• Make full use of Excel for data analysis and modelling
• Experience hands-on, practical learning
• Boost efficiency by learning how to handle and manipulate data from many sources
• Design data related solutions with guided support
• Flexible delivery options, either join in person or online

If you've attended our Excel Intermediate course and/or Excel Advanced Level 1 course and need more knowledge on the techniques and functions required to manipulate and summarise data, then this is the course for you.

This Excel Advanced Level 2 course is ideal for:

• Professionals who are responsible for analysing data to guide business decisions
• Team members who are preparing data for analysis or cross-checking data sources to ensure consistency
• Anyone who needs to analyse data logs from production machines or report on data exported from other systems
• Individuals preparing for new jobs or roles that require data analysis skills such as finance managers, project managers and administrators and data analysts

• Turn data into meaningful business insights - enable your team to confidently analyse large datasets using Pivot Tables and advanced filtering and lookup functions
• Reduce guesswork in decision making - your team will be able to evaluate possible outcomes with What If analysis and scenario planning
• Streamline complex data management - gain the ability to query and combine data from multiple sources to extract key information
• Deliver high impact reporting - visualise the summarised data using KPIs and complex charts using multiple axes, combining chart types and adding trend lines

• What If - Allows storing best, worst and expected values for your spreadsheet. It will even do your calculations in reverse if you know what you want the answer to be!
• Custom Views - Same data, different columns, filters and print setups are a click away
• Consolidation - Pull data from different sheets or workbooks, even if the layouts don't match exactly
• Manipulate Text - Import from database exports, find and extract relevant information
• Tables - Makes working with a block of data easier and allows fast publishing to SharePoint
• Conditional Formatting - Beyond the basic rules by using custom logic similar to IF
• Functions for Lists - many  functions such as FILTER, XLOOKUP and SUMIFS are made for lists and tables
• Pivot Tables - Probably the fastest way to summarise and gain insight from large blocks of data
• Ch​arts - Secondary axis plus trend lines and all saved as a template for consistency

Goal Seek

• Changing a single cell
• Applying a global change

Scenarios

• Creating scenarios
• Editing scenarios
• Showing scenarios
• Summarising scenarios
• Data Table

Custom Views

• Creating custom views
• Using custom views
• User specific sheet views

Consolidating Data

• Working with multiple sheets
• Linking files with formulas
• Paste special
• Data consolidation

Working with Text Files

• Importing text files
• Text to columns
• Text functions (inc. split/combine)

Working with Tables

• Defining and formatting a table
• Table features
• Switch between table and cell referencing
• As a data source for Power Query and pivot tables
• Removing duplicates
• Converting to a range

Conditional Formatting

• Applying and editing predefined rules
• Using icon sets and data bars
• Creating new rules using custom logic
• Managing rules

Data Manipulation

• Custom sort orders
• Multi-level subtotals
• Advanced filter
• Filter function (building dynamic array logic)
• Power Query (filter, combine and load data)

Pivot Tables

• Creating a pivot table
• Editing the pivot table
• Drilling down in a pivot table
• Slicers for clear filtering
• Show values as calculations

Advanced Calculations

• Lookup functions (X and V Lookup)
• Dynamic array functions
• Conditional calculations (SUMIF/SUMIFS family)

Advanced Charting

• Creating combination charts
• Plotting on a secondary axis
• Adding & removing data
• Adding trend lines
• Forecasting forward
• Chart templates

This course does not lead to a formal qualification or accreditation, but upon successful completion, you will receive a Certificate of Attendance from Jarrold Training.

This certificate demonstrates your commitment to professional development and confirms that you have completed an advanced level course in Microsoft Excel - a valuable asset for your CV and workplace skillset.

By the end of this course, you’ll be able to:

• Implement What If analysis to cover all eventualities
• Summarise data stored dissimilar data layouts
• Import and manipulate data from other systems
• Summarise data using formulas and pivot tables
• Visualise the summary data for efficient reporting and decision making

The course runs from 9:30am through to 4:30pm.

You will learn in a relaxed environment with a small group of people. A specialist tutor will guide and encourage you through all the learning necessary to develop your skills and questions are always welcome.

Included with your course
We provide the following with online and training centre delivered courses.

• Course notes
• Certificate of attendance
• 90 days post course support

Online Delivery
A link to the online training platform will be sent before the course, simply click the link and follow the instructions.

• See Virtual / Remote training information for more details
• Contact us if you'd like to test the platform before the morning of the course
• You can be located anywhere in the world with an internet connection and your computer

Our Training Centres
For training courses run at one of our training centres we include.

• Free onsite parking
• Lunch and refreshments
• Notepad, pen and Polos

Our Norwich on-site parking (NR3 1UB) is free and situated 5 minutes walk along the river to our training centre at St James Mill. If you arrive by train it is about 20 minutes on the Riverside walk or a short taxi ride to get to us. View full directions for Norwich and all our other venues.

We aim to provide you with an effective, high-quality learning experience to help you build confidence and practical skills in Excel.

Your trainer will guide and support you throughout the training day, so please feel free to ask questions at any time - they’re always happy to help. Our friendly team is also on hand to ensure your learning experience is smooth and enjoyable from start to finish.

While there is no formal exam, the course includes plenty of hands-on exercises and revision opportunities to reinforce what you’ve learned. Additional support is available after the course, with 90 days of post-course help should you need it. Please contact us if you have any questions.
 

Do I need to have taken the Excel Advanced Level 1 course first?

Not necessarily, although it is an advantage. If you plan to do both of our advanced courses it will be easier to do them in order. You do need to have attended at least our Excel Intermediate course and be confident with that content before attending this course. If you're not sure - contact us and we can help guide you.

Do I need to bring a laptop?

For in-person courses, all equipment is provided. For online delivery, you’ll need a computer with internet access and Excel installed.

Who is this Excel Advanced Level 2 course suitable for?

If you're a regular and confident user of Excel and now need to handle larger or more varied datasets, then this course is ideal for you. 

Is this course suitable for Mac users?

Yes, although Excel looks slightly different on Mac, most functions covered in the course are the same. Please let us know in advance if you’re using a Mac so we can tailor support where needed.