Microsoft Excel Level 3 – Advanced Excel
Course Duration: 1 Day
About: This Advanced Excel course is designed for experienced users looking to leverage Excel's powerful features to streamline their work and enhance their data analysis capabilities. The course delves into topics such as PivotTables, advanced functions, auditing workbooks, and data tools. Students will also explore importing and consolidating data, What-If analysis, recording and using macros, and collaborating with others. Through hands-on exercises and real-world examples, students will master advanced Excel techniques, equipping them with the skills needed to tackle complex data analysis tasks efficiently.
Audience profile
Students who have intermediate skills with Microsoft Excel who want to learn more advanced skills.
Prerequisites: Intermediate level of Excel.
Group Data
- Group Data
- Automatically create groups
- Ungroup
- Subtotals
Advanced Functions and Formulas
- Using Absolute and Mixed Reference in Formulas
- XLOOKUP Function
- The LET Function
Using PivotTables
- How PivotTables Work
- Timeline Filters
- Inserting Slicers
- Grouping Data
- Calculated Fields
- PivotCharts
Data Tools
- Importing Data from online source
- Converting Text to Columns
- Importing Files
- Linking to External Data
- Controlling Calculation Options
- Data Validation
- Consolidating Data
- What-If Analysis
Recording and Using Macros
- Recording Absolute and Relative Reference Macros
- Running Macros
- Editing Macros
- Adding Macros to the Quick Access Toolbar
Protecting and Sharing Workbooks
- Comments and Notes
- Protecting Worksheets and Workbooks
- Marking a Workbook as Final
- Sharing the Workbook