Welcome to our Advanced Excel Course
A comprehensive program designed for professionals seeking to leverage Excel's powerful features in their daily work. This course will equip you with an in-depth understanding of advanced Excel applications, enabling you to automate tasks, manipulate data, create macros, and gain an introduction to Excel dashboards.
Key Topics Covered
HLOOKUP, INDEX, MATCH, Nested IF, IFERROR, LEN, TRIM, SUBSTITUTE, Tracing Precedents and Dependents, Error Checking, Scenario Manager, Understanding Protection, PivotTable, PivotChart, Filters, Macros, Developer Tab, and Viewing and Editing the VBA Code.
Course Design
This course is designed for those who already have a basic working knowledge of Excel. As we delve into the more advanced aspects of Excel, you'll discover how to add a drop-down list, compose text with "&", transpose your values, create your own shortcuts, and apply restrictions on your input using Data Validation.
Quotes
"Whatever you think of the spreadsheet, don't dismiss it as trivial." - Mike James
"Excel is one of the most powerful and important software applications of all time." - James Kwak
Join Us
Join us on this journey to become an Excel Pro!