Course Details

Course Description

Course Overview

Mastering Microsoft Excel: From Beginners to Advanced Level is an all-encompassing course designed to take learners from the basics of Excel to advanced data analysis and automation techniques. Taught by industry experts, this course provides a deep dive into Excel’s powerful features, enabling students to efficiently manage, analyze, and visualize data.

The course is delivered online, offering the convenience of learning at your own pace. It’s perfect for beginners new to Excel as well as those looking to enhance their existing skills. Through practical exercises, real-world assignments, and case studies, students gain hands-on experience in performing complex calculations, creating dynamic charts, using pivot tables, and automating tasks with macros.

Students receive continuous mentorship from experienced professionals throughout the course, ensuring they fully grasp the material and can apply their knowledge in practical situations. This mentorship is key to helping learners transition from novices to advanced Excel users, capable of leveraging Excel for sophisticated data analysis and business decision-making.

Course Outline

1. Overview of MS Excel
2. Getting Started with MS Excel
3. Data Entry in MS Excel
4. Relative & Absolute Referencing in MS Excel
5. Moving Data Across Sheets
6. Basic Shortcuts in MS Excel
7. Autofill in MS Excel
8. Displaying formula in MS Excel status bar
9. Conditional Formatting in MS Excel
10. Table Styles
11. Cell Styles
12. Inserting Smart Art
13. Goal Seek
14. Scenarios
15. Data Table & Sensitivity Analysis
16. Forecasting in MS Excel
17. Tracing Precedents & Dependents
18. Comments in MS Excel
19. Inserting Charts in MS Excel
20. Pivot Table
21. Text to Column & Concatenation
22. Flashfill in MS Excel
23. Checking & Removing Duplicates
24. Data Consolidation
25. Tables in MS Excel
26. Grouping Data in MS Excel
27. SUMIF,SUMIFS,COUNTIF,COUNTIFS
28. Data Validation & Dropdown List
29. VLOOKUP & HLOOKUP
30. IFERROR
31. MS Excel IF
32. Named Ranges
33. Understanding MS Excel Errors
34. MS Excel Form
35. marking a Workbook as Final
36. Protecting MS Excel Workbook
37. 37.   Module Conclusion & Reflections
38. 38.   MS Excel Quiz & Assignments