Create Video Tutorials for Microsoft Excel - A Comprehensive Series
₹12500-37500 INR
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
Project ID: #17667761
About the project
13 freelancers are bidding on average ₹36217 for this job
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
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
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
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
I'm Excel Expert and Excel trainer for my past company. I could explain well the topics request in video.
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
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.