The Advanced Excel course equips delegates with the skills to analyse, report and automate data at a professional level. Participants will explore advanced formulas, lookup functions, pivot tables, goal seek, solver and scenario manager. They will also learn how to create and run simple macros to streamline tasks. By the end of the course, delegates will be able to customise Excel for complex problem-solving and efficient reporting.
Content
• Using advanced text and conditional functions (SUMIF(S), COUNTIF(S), AVERAGEIF(S))
• Lookup functions: LOOKUP, VLOOKUP, HLOOKUP
• Creating, formatting, and modifying PivotTables and drilldown reports
• Grouping and ungrouping PivotTable data; showing/hiding data
• Using Goal Seek for problem-solving
• Applying Solver with constraints for advanced analysis
• Scenario Manager for comparing data models and generating reports
• Custom Views for managing display and print settings
• Introduction to Macros: recording, assigning, editing, and running macros
Aimed at
Those who have completed Excel Intermediate or who already have substantial working knowledge of Excel and want to progress to advanced data management and automation.
