Overview
This course covers Excel from beginner to advanced level in under 6 hours. The learning outcomes include mastering Excel formulas, data cleaning, pivot tables, dynamic array functions, advanced formulas, and VBA macros. The course teaches essential Excel skills such as VLOOKUP, COUNT, SUM, IF, INDEX, MATCH, SUMPRODUCT, SUMIFS, COUNTIFS, and more. The teaching method includes video tutorials with practical examples and exercises. This course is intended for beginners looking to become proficient in Excel, including professionals, students, and anyone interested in enhancing their spreadsheet skills.
Syllabus
- Excel Formulas for Beginners
- Cleaning Data in Excel
- Pivot Tables Excel Tutorial
- Dynamic Array Functions
- Advanced Formulas in Excel
- Macros and Basic VBA in Excel
Taught by
Simon Sez IT