Curriculum
- 13 Sections
- 50 Lessons
- Lifetime
Expand all sectionsCollapse all sections
- Quick Tour of Microsoft Excel3
- Formatting in Excel4
- Working with Mathematical Operations2
- Excel Function for Calculation and Analysis - Case Study I4
- Conditional Formatting1
- Working with Tables4
- Introducing Pivot Tables - Case Study II3
- Introducing Graphs in Excel5
- Common Errors in Excel2
- Functions Collection6
- Advanced Excel Tools - Case Study 38
- VBAs and Macros - Multiple Projects8
- 12.1Protocols in Creating Macros7 Minutes
- 12.2Creating My First Macro4 Minutes
- 12.3VBA Environment – Project Explorer10 Minutes
- 12.4VBA Environment – Properties6 Minutes
- 12.5Run – Design – Build a Calculator24 Minutes
- 12.6If Condition – Create an Age Category Checker26 Minutes
- 12.7Data List – Sector Data Presenter35 Minutes
- 12.8Chart – Create & Manipulate Chart14 Minutes
- Final Quiz1
Excel Startup Screen – Ribbon – Cells – Worksheet – Saving
Next