Advanced Excel
Description:
This course moves beyond simple data entry and basic arithmetic to focus on automation, complex logic, and professional visualization. You will learn to transform raw, messy data into interactive dashboards and streamlined workflows. We cover high-level functions like XLOOKUP and INDEX/MATCH, the magic of Power Query for data cleaning, and the basics of Macros to make the computer do your repetitive work for you. By the end of this course, you’ll be building spreadsheets that don’t just store data—they tell a story.
Course Duration: 1 Month
Prerequisites for Advanced Excel:
- Certificate in IT
- SSCE
- Basic computer skills`
- Basic English reading skills