Create Video Tutorials for Microsoft Excel - A Comprehensive Series
₹12500-37500 INR
Paguhet në dorëzim
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
ID Projekti: #17667761
Rreth projektit
13 profesionistë freelancer dërguan një ofertë mesatare prej ₹36217 për këtë punë
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/ Më shumë
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 Më shumë
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 Më shumë
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 Më shumë
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 Më shumë
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.