Our Advanced Excel course enhances the knowledge of experienced by delving deeper into Excel’s powerful formula auditing, data modelling and what-if analysis tools. The course also covers the creation of macros and custom functions.
Auditing Worksheets, Finding errors in formulas, Evaluating Formulas, Tracing cell precedents and dependents, Using the Watch Window, Creating User-Defined Functions
Using Data Analysis Tools
Performing “What If” Analyses, Working with Scenarios, Single Input Data Tables, Double Input Data Tables, Using GoalSeek, Using the Solver
Creating a pivot table, Formatting pivot tables, Grouping data in pivot tables, Creating pivot charts, Creating Slicers, Creating Timelines, Creating Dashboards
Importing and Exporting Files, Create Web Queries, Importing XML data, Exporting XML
Macros and Customisation
Recording a macro, Editing macros in the Visual Basic Editor, Assigning a macro to a button, Customizing the Ribbon, Creating your own Ribbon Tab, Assigning commands and macros