# Create Video Tutorials for Microsoft Excel - A Comprehensive Series

We are an Online Video Streaming Platform, and we create a huge array of content for our YouTube Channel. We are looking for professional content creators to join us for our endeavour.

i) Topics to cover:

1) Basics of Excel Interface: e.g. Quick Access Toolbar, Ribbon, Tell Me Box

2) Basic of Cells and Sheets e.g. Insert, delete, drag & drop cells or Fill, cut, copy, and paste functions.

3) Modify & Format Rows, Columns, Cells & Numbers

4) Working with Multiple worksheets

5) Creating simple and complex formulas (including nested functions)

6) Cell referencing: Relative & Absolute

7) Crash Course on Functions & Arguments with Examples

- Basics (e.g. SUM, AVERAGE, VLOOKUP, MATCH, INDEX, TODAY, MONTH, LEN, CONCATENATE, IF, AND, CELL, ISNUMBER)

- Advanced from all categories ie.

- Financial

- Date & Time

- Math & Trig

- Statistical

- Lookup & Reference

- Database

- Text

- Logical

- Information

- Engineering

- Cube

8) Working with Excel Data

- Sorting Data

- Filtering Data (Basic & Advanced)

- Summarizing Data

- Creating Tables & Visualizations

- Conditional Formatting

- Subtotals

- Data Validation

- Error Checking & Data Monitoring

- Freezing Rows & Columns

9) View Options (including Freeze Pane)

11) Inspecting & Protecting Workbooks

12) Pivot Tables (Basic & Advanced)

13) What if Analysis?

ii) Length of individual videos: Not more than 15 minutes

iii) Format: Screen-recording with Text & Voice-over

iv) Language: English

v) Please ensure audio is both clear and audible. Please minimize background noise & echo.

vi) Please ensure text doesn't merge into the background. Also, please choose a legible font.

vii) With regards to number of videos, give us an estimate of how many videos you think it would take to cover the topics mentioned comprehensively.

Reference Video:

Software:

Microsoft Excel 2016

Skills: Data Entry, Data Processing, Excel, Statistics

( 0 reviews ) India

Project ID: #17667761

## 14 freelancers are bidding on average ₹34543 for this job

shivampanchal

I have a good hands on working with Advanced R and Python and BI tools and technologies, AI, Big Data. I have quite a good knowledge of DL/ML Algorithm , have also developed Dashboards and Web Applications using flask/ More

₹30000 INR in 10 days
(55 Reviews)
6.4
Ashraf5426

Hello, I am a finance and investment professional with over 14+years of experience in the industry and using excel. For the last 7+ years, I have been training on Basic, Intermediate, and Advanced Level of Excel al More

₹111111 INR in 15 days
(2 Reviews)
3.4
₹41666 INR in 7 days
(3 Reviews)
1.4
₹27777 INR in 10 days
(0 Reviews)
0.0

i will do it More

₹27777 INR in 10 days
(0 Reviews)
0.0
SANDEEPTA05

I'm an expert web developer with over 5+ years of programming experience in Shopify, HTML, Javascript, CSS, Photoshop, Wordpress, PHP, MYSQL, and SQL Server. I'll be an invaluable asset to your team. I'm highly motivat More

₹27777 INR in 10 days
(0 Reviews)
0.0
Hasanonurinal

I have been used excell for 10 years where i worked and became an excell expert. so i may be best option for this job. if you say more clear what you want about videos step by step i will be very glad of this job. in t More

₹41111 INR in 10 days
(0 Reviews)
0.0
nky789

Hi, I’m an experienced data analyst working in one of the Big4 firm in Ireland. Excel is used for formatting, report generation and visualizations. I can provide you a sample recorded video for you. Relevant Skills a More

₹12777 INR in 10 days
(0 Reviews)
0.0
melena89

I'm Excel Expert and Excel trainer for my past company. I could explain well the topics request in video.

₹31111 INR in 15 days
(0 Reviews)
0.0
drexleraustria

Philippine- licensed Mechanical Engineer, with excellent knowledge in mechanical engineering laws and principles in automotive, HVAC, refrigeration, machine design and general mathematics and statistics, determined to More

₹25555 INR in 14 days
(0 Reviews)
0.0
₹12500 INR in 10 days
(0 Reviews)
0.0
sirichandanayt

My daily work is n excel only. So I have lot of experience in that. And I make youtube videos also, so have both the experience to do. I guess I am the best person to do this.

₹27777 INR in 15 days
(0 Reviews)
0.0
₹38888 INR in 15 days
(0 Reviews)
0.0
swrachh

I have worked with excel for 5 years of my career and taken several trainings in the process. I also have clear voice and teaching techniques and hence ensure the best possible videos for the purpose. Relevant Skills More

₹27777 INR in 12 days
(0 Reviews)
0.0