Take Your Excel Skills to the Next Level
- Are you wasting time trying to manually analyse endless rows of data?
- Do advanced spreadsheet functions give you a headache?
- Does organizing messy data feel impossible?
- Are you unable to identify key data insights and trends?
- Do you struggle to present Excel findings clearly and professionally?
- Can you create interactive visualizations beyond basic graphs?
- Are you unable to forecast future outcomes based on current data?
- Does consolidating data from multiple sources feel like a nightmare?
- Are inefficiencies in Excel analysis delaying your team’s decision making?
- Is your current Excel skillset limiting your strategic contributions overall?
If so, then the Excel Level 2: Intermediate course will help you.
AT A GLANCE
Audience
This course is for users who want to build upon their foundational knowledge and master more advanced spreadsheet capabilities for robust data analysis and reporting. This includes learning pivot tables, lookup functions, database tools, chart creation, and other analytical features to extract deeper insights.
Format
- 1 x 1-day, instructor-led online sessions
- Public workshops are available for all our Excel courses.
What’s Included
- Comprehensive Learning Guide and Resource Manual
- Subscription to our monthly LearningLink e-newsletter
Think Bigger, Do More with Data
Learn how to harness the power of Excel for making an impact with data.
This course will help you:
FULL OUTLINEMake an enquiry
- Use the new features in MS Excel
- Identify new charts to communicate the key message
- Use a variety of functions to analyse business data
- Sort and Filter Data in predefined Tables
- Use data validation to control data entry
- Use the key functions of Pivot tables.
What You Will Learn
Complex Formulas
Use advanced functions, array formulas, date logic, and range names to construct complex calculations and analyses.
Powerful Insights
Harness pivot tables, lookups, data validation, and other dynamic tools to organize, filter, summarize and extract deep insights
Compelling Visuals
Make raw data impactful for any audience by creating sleek interactive dashboards, charts, graphs and pivot visualizations.
Predictive Modelling
Project future outcomes and make data-driven decisions leveraging Excel’s What-If analysis and forecasting capabilities.
Detailed Synopsis
This Microsoft Excel course focuses on the need to produce real time reports using Charts and Pivot Tables and introduces new functions and data tools to help participants be more productive. Areas covered include If Statements, VLookup, data analysis functions, sorting and filtering data in tables, data validation and cleaning data . This is our most popular Microsoft Excel course and is a very comprehensive day for Excel users to really get to grips with the key functions they need.
Unit 1 New features in Excel
- Flash fill, Quick Analysis & Tell me About.
Unit 2 Working with Charts
- Creating charts
- Selecting charts from the Add-ins Store
- Identifying and using the correct chart for your data
- Creating Sparklines
- Insert 3D map.
Unit 3 Working with Functions and Formulas
- Using Functions in Excel: IF Statements, VLookup and XLookup, CountIf, SumIf
- Working with Names and Ranges
- Using names to simplify formulas
Unit 4 New functions in Excel
- Ifs, Switch, TextJoin, ConCat.
Unit 5 Advanced Formatting
- AutoFormat (Table Format)
- Visualising Data using Conditional Formatting
- Data Validation
- Using Multiple Worksheets & Workbooks
Unit 6 Pivot Tables
- Introduction to Pivot Tables
- Manipulating data in the Pivot Table
- Creating Pivot Charts
- Using Slicers.
Unit 7 Get and Transform Data:
- Introduction to Power Query.
