← All coursesMKCL KLiC CourseAbout this course What you'll learn Major topics Eligibility
Accounting
KLiC Advanced Excel
A data-focused Excel 365 course covering advanced spreadsheet analysis, reporting and automation. Learners progress from functions and formatting to PivotTables, dashboards, Power Query, Power Pivot, VBA and introductory business intelligence.
- Track
- Data Science
- Duration
- 120 hours
- Level
- Master
- Language(s)
- English, Marathi, Hindi
- Learning mode
- Learn at ALC or Learn Online
- Stream
- Any stream
- Use advanced formulas, functions and conditional formatting
- Perform scenario and What-If analysis
- Create PivotTables, charts and dashboards
- Clean and model data with Power Query and Power Pivot
- Automate repeated work with macros and VBA
- Build introductory Power BI and Looker Studio reports
- Microsoft 365 and Excel 365
- Functions and advanced charts
- PivotTables and dashboards
- Macros, VBA and UserForms
- Power Query, Power Pivot and DAX
- Power BI and Looker Studio
- Preferably Standard 10 passed, though this is not compulsory.
- Prior completion of MS-CIT is desirable, though not compulsory.
Course information is summarized from the official MKCL KLiC course description. View official MKCL course details