Currently Empty: $0.00
Explore
MS Excel Zero to Hero – Complete Excel Mastery for Beginners to Advanced
Learn MS Excel from basics to advanced using real business examples, formulas, dashboards, automation & productivity shortcuts.
Perfect course for students, employees & accountants.
Course Overview
This course will take you from Zero to Hero in Excel, even if you are a complete beginner.
With practical office tasks, dashboards, formulas & automation, you will become job-ready and confident in Excel.
What you’ll learn
- Excel basic to professional level
- Data cleaning, formatting & validation.
- Formulas – VLOOKUP, XLOOKUP, IF, SUMIFS, COUNTIFS
- Pivot Tables & Charts
- Dashboard creation step-by-step
- Automation, productivity hacks & templates
- Real business case studies
- You will be able to apply correctly with all excel formulas.
- Downloadable exercise files
- Build Excel dashboard from beginning to end.
- Learn to design advance macros.
- All the tips used by office professionals
- You will be able to apply correctly with all excel formulas.
Requirements
- You will need a laptop with Ms Office Installed
- No previous working experience is needed.
- No previous Excel skills are needed.
Curriculum
- 1 Section
- 0 Lessons
- 15 Days
Expand all sectionsCollapse all sections
- LessonsTopic 1: Introduction to Excel What is Excel & interface explanation (Video) Workbook vs Worksheet Cells, Rows, Columns Shortcut Keys PDF Topic 2: Basic Excel Tools Formatting Tools Number Formatting Freeze Pane / Wrap text Assignment – Basic Sheet Topic 3: Formulas & Functions SUM, AVERAGE, MIN, MAX IF, Nested IF VLOOKUP vs XLOOKUP SUMIFS, COUNTIFS + Exercises Topic 4: Charts & Visualization Column, Pie, Donut Chart Project – Sales Dashboard Topic 5: Pivot Tables Creating Pivot Tables Pivot Filtering Live Example Assignment Topic 6: Automation & Productivity Data Validation Conditional Formatting Excel Productivity Hacks Excel Project File0
Instructor
admin
At vero eos et accusamus et iusto odio dignissimos ducimus qui blanditiis praesentium voluptatum deleniti atque corrupti quos dolores et quas molestias excepturi sint.
admin
Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et.
admin
Ridiculus eu convallis eu mattis iaculis et, in dolor. Sem libero, tortor suspendisse et, purus euismod posuere sit. Risus dui ut viverra venenatis ipsum tincidunt non, proin.