Create Video Tutorials for Microsoft Excel - A Comprehensive Series

Closed Posted 5 years ago Paid on delivery
Closed Paid on delivery

About Us:

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.

About the Videos:

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)

10) Track Changes & Comments

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:

[login to view URL]

Software:

Microsoft Excel 2016

Data Entry Data Processing Excel Statistics

Project ID: #17667761

About the project

13 proposals Remote project Active 5 years ago

13 freelancers are bidding on average ₹36217 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
(63 Reviews)
6.7
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
₹27777 INR in 10 days
(0 Reviews)
0.0
MousaDiyyeh

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
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
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
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