Advanced Excel Training is planned to build upon an intermediate level knowledge and experience with Microsoft Excel. You will develop a range of advanced skills to manage more complex and unusual tasks to elevate your overall confidence in using and exploring Excel on a deeper level.
Interested? Look below to see what topics we can cover!
Every session is designed to mould to the level of experience of those attending each session.
Here are the topics we can cover in this course:
Enter and Organise Data
- Insert, copy, delete and hide tabs
- Change tab colour
- Cell styles
- Linking Worksheets and Workbooks
- Cell Protection and restricting data entry
- Protecting Worksheets
- Protecting Workbooks
- Named Ranges
- Naming Tables
- Page Setup and Repeating rows and columns
Managing Data
- Data Validation
- Group and Ungroup
- Sub-totals
- What if – Goal seek
- Sparklines
Functions and Formulas
- IF and nested IF statements
- SWITCH
- SUMIFS
- COUNTIFS
- COUNTA and COUNTBLANK
- RANK
Charts, Pivot Tables and Pivot Charts
- Managing Charts
- Creating Pivot Tables and Pivot Charts
- Managing Fields
- Filtering and sorting
- Drill Down
- Slicers
This 1-day course is delivered onsite from 9.30am – 4:00pm.
You must meet at least 1 of the 2 Entry Requirement points below;
- Have already attended our Intermediate Excel Training
- And/or have used all of the below:
• Basic formulas and functions
• IF and SUMIF
• Relative and absolute cell references
• Created simple charts tables
• Filtered & sorted data.
(Please note that this point is a self-assessment and therefore we will take this at face value upon receipt of your application).
This course is funded via the UK Government’s Multiply project so you will be requested to sign a declaration upon attendance.