Microsoft Excel Advanced
Work with Excel’s advanced features, including PivotTables and Data Consolidation. You will also create templates and work with Macros.
About this Event
Take your skills to the next level to get more out of Excel’s advanced features, including PivotTables and Data Consolidation. You will also build on your existing knowledge by exploring worksheet and workbook protection. Work on spreadsheet automation by recording macros, then edit your macros for even greater functionality and flexibility.
This course is designed for participants who are already building more complex spreadsheets and wish to perform more detailed analysis as well as adding automation to their workbook tasks.
This is an advanced level course.
What you get
- Class size kept to a maximum of 10 participants.
- Average class is 4-6 people.
- Qualified, experienced and approachable facilitators.
- Training materials and take away practice files.
- Lifetime post course support.
We encourage you to bring along your own laptop so you are familiar with its layout and functionality. If you do not have a laptop, we can supply one on the training day.
Microsoft Excel Advanced Workshop Course Content
- Linking to Source Data
- Consolidate by Position
- Consolidate by Category
- Building a PivotTable Shell
- Adding Fields
- Grouping Items
- Drilling Down
- Changing Layouts
- Using Slicers
Advanced PivotTable Features
- Creating Calculated Fields
- GetPivotData Function
- Show Report Filter Pages
- Preparing Excel for Recording
- Recording Macros
- Storing Macros
- Adding Comments
- Testing Macros
Absolute vs Relative Macros
- Absolute and Relative Recording
- Testing types of Recording
- Viewing and Editing Macros
- Types of Protection
- Protecting Worksheets
- Protecting Workbooks
- Protecting Files
- Using Existing Templates
- Creating Templates
- Modifying Templates
If you need to book a course after the ticket sales have closed, please get in touch and we'll do our best to accommodate you.
See here for terms and conditions.
Due to COVID-19 some events may be operating differently than planned.
Please contact the event organiser directly to confirm.
Please contact the event organiser directly for accessibility information.