| 1. Data Cleaning.mp4 | 148.4 MB | ||
| 1. MIS Executive Role & Skill Requirements.mp4 | 43.4 MB | ||
| 1. SUM Function.mp4 | 13.6 MB | ||
| 1. Use Case 1 Calculate Count of the letter in Excel.mp4 | 24.1 MB | ||
| 10. HLOOKUP Function.mp4 | 25.4 MB | ||
| 10. Use Case 10 Modify Phone Numbers using Custom Formatting.mp4 | 20.1 MB | ||
| 11. XLOOKUP Function.mp4 | 27.9 MB | ||
| 12. Quiz 2.html | 102.4 B | ||
| 13. IF Function.mp4 | 37.2 MB | ||
| 14. IFS Function.mp4 | 30.6 MB | ||
| 15. AND Function.mp4 | 29.2 MB | ||
| 16. OR Function.mp4 | 53.5 MB | ||
| 17. CONDITIONAL FORMATTING.mp4 | 42.6 MB | ||
| 18. Quiz 3.html | 102.4 B | ||
| 2. Excel Overview.mp4 | 31.6 MB | ||
| 2. Pivot Tables & Charts.mp4 | 74.9 MB | ||
| 2. SUMIF Function.mp4 | 21.5 MB | ||
| 2. Use Case 2 Calculate Total marks based on Students First and Last Name.mp4 | 32.8 MB | ||
| 2.1 Excel Basics Overview.pdf | 2.7 MB | ||
| 2.2 Excel Shortcuts Cheat Sheet.pdf | 94.5 KB | ||
| 3. Quiz 4.html | 102.4 B | ||
| 3. SUMIFS Function.mp4 | 22.8 MB | ||
| 3. Use Case 3 Calculate PassFail column based based on multiple condition.mp4 | 34.2 MB | ||
| 4. SUMPRODUCT Function.mp4 | 17.2 MB | ||
| 4. Use Case 4 Calculate Commission as per Commission table.mp4 | 26.2 MB | ||
| 5. Quiz 1.html | 102.4 B | ||
| 5. Use Case 5 Calculate Employee Attendance.mp4 | 22 MB | ||
| 6. COUNT Function.mp4 | 11.9 MB | ||
| 6. Use Case 6 Calculate Age of an Employee using VLOOKUP.mp4 | 22 MB | ||
| 7. COUNTIF Function.mp4 | 19.5 MB | ||
| 7. Use Case 7 Calculate Full name using VLOOKUP & XLOOKUP function.mp4 | 37.6 MB | ||
| 8. COUNTIFS Function.mp4 | 25.4 MB | ||
| 8. Use Case 8 Calculate Number of working days for months.mp4 | 17.8 MB | ||
| 9. Use Case 9 Create Pivot table and calculate different KPIs.mp4 | 48.6 MB | ||
| 9. VLOOKUP Function.mp4 | 58.8 MB | ||
| Bonus Resources.txt | 409.6 B | ||
| Get Bonus Crypto Downloads Here.url | 204.8 B | ||
| ▲ 37 total files | |||
MIS Basic to Advance Excel Course
https://FreeCryptoLearn.com
Published 9/2023
Created by Monica Jain
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 29 Lectures ( 1h 48m ) | Size: 1 GB
Mastering Excel for Management Reporting and Data Analysis
What you'll learn
Gain the skills to efficiently organize, clean, and manage large volumes of data using Excel, making it ready for analysis and reporting
Learn to create complex formulas and functions, enabling you to perform intricate calculations and automate repetitive tasks.
Discover time-saving tips and tricks that will boost your productivity and allow you to tackle complex tasks with ease.
Achieve Excel certification and gain a competitive edge in the job market, opening doors to new career opportunities and advancement.
Requirements
Basic Computer Knowledge is must
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
| 7.5 GB | SunRiseZone | 7 years | 0 | 0 |
All Comments