Microsoft Excel

Dive deeper into Excel's robust functionalities with our Intermediate Excel course. This course is designed for users who are already familiar with basic Excel operations and want to expand their skills to enhance data management, analysis, and presentation.
Advanced Formulas and Functions: Explore more complex formulas including VLOOKUP, HLOOKUP, and nested functions to streamline data analysis and enhance efficiency. Learn to use advanced logical functions, such as IFS and dynamic named ranges.
PivotTables and PivotCharts: Gain proficiency in creating and customizing PivotTables and PivotCharts to summarize and analyze large datasets quickly.
Data Visualization: Master advanced chart types, images and graphic art to create visually compelling and informative reports.
Collaborative Tools: Understand how to work with Excel’s collaborative features including sharing workbooks, tracking changes, and protecting data.
This course includes a combination of instructor-led sessions, hands-on exercises, and real-world scenarios to ensure practical application of concepts.

Please make sure you have MicroSoft Office Excel 2013 or later version.