Advanced Excel

About this programme

Advanced Excel is a practical, hands-on course designed to equip learners with advanced skills for analysing, managing, interpreting, and presenting data using Microsoft Excel. The course goes beyond basic spreadsheet operations and focuses on powerful Excel tools and techniques used in business, finance, administration, accounting, research, data analysis, and decision-making. Learners will develop proficiency in advanced formulas and functions, data validation, conditional formatting, lookup and reference functions, PivotTables, PivotCharts, dashboards, data visualization, and data analysis tools. The course also introduces automation using macros and VBA, enabling learners to streamline repetitive tasks and improve productivity. By the end of the course, learners should be able to: - Apply advanced Excel formulas and functions to solve complex problems. - Use XLOOKUP, INDEX, MATCH, SUMIFS, COUNTIFS, IF, IFS and other advanced functions. - Clean, organize, filter, sort, and transform large datasets. - Create and analyse data using PivotTables and PivotCharts. - Develop professional and interactive Excel dashboards. - Apply advanced data visualization techniques. - Use What-If Analysis, Goal Seek, Scenario Manager, and Solver for decision-making. - Import, transform, and combine data using Power Query. - Use Excel tables, named ranges, and structured references effectively. - Automate repetitive tasks using Macros and VBA. - Protect worksheets, workbooks, and sensitive data. - Produce professional reports for management and decision-making. Key Topics 1. Advanced Excel Formulas and Functions 2. Lookup and Reference Functions 3. Logical, Statistical and Financial Functions 4. Data Cleaning and Transformation 5. Advanced Sorting and Filtering 6. Data Validation and Conditional Formatting 7. Excel Tables and Named Ranges 8. PivotTables and PivotCharts 9. Advanced Charts and Data Visualization 10. Interactive Excel Dashboards 11. What-If Analysis and Forecasting 12. Goal Seek, Scenarios and Solver 13. Power Query for Data Preparation 14. Introduction to Macros and VBA 15. Workbook and Worksheet Protection 16. Practical Data Analysis Projects The course is suitable for students, accountants, business professionals, administrators, managers, entrepreneurs, researchers, data analysts, teachers, and anyone who wants to move from intermediate Excel skills to advanced data analysis and reporting.

Entry requirements

• Open