Microsoft Excel Intermediate 2
Building on the skills developed in Excel Intermediate 1, this course introduces more advanced formulas, workbook techniques and data analysis tools. Delegates will learn to use logical and lookup functions, work with named ranges and linked workbooks, apply advanced filtering techniques, enhance charts and gain an introduction to PivotTables.
Complete Course Syllabus
Advanced Formulas and Functions
- Using the IF function in practical examples
- Using IF to check whether a cell is blank
- Creating nested IF statements
- Using VLOOKUP and HLOOKUP
- Working with text functions
- Working with date functions
Using Named Ranges
- Creating and managing named ranges
- Using named ranges in formulas
- Using named ranges to navigate through workbooks
Linking Worksheets and Workbooks
- Creating references to other worksheets
- Creating references to other workbooks
- Editing workbook links
- Troubleshooting links
Advanced Data Analysis
- Using the Quick Analysis tool
- Applying advanced filters
- Sorting and filtering data using conditional formats
Advanced Charting Techniques
- Analysing trends using Sparklines
- Exploring different chart types
- Applying chart styles and formatting chart elements
- Filtering charts by series or categories
- Adding trendlines to charts
- Creating chart templates
Protecting Worksheets and Workbooks
- Protecting individual cells
- Protecting worksheet structure
- Protecting workbooks with passwords
Introduction to PivotTables
- Understanding the purpose and structure of PivotTables
- Creating a basic PivotTable
- Summarising and rearranging data
- Using recommended PivotTables to analyse data
- Understanding how PivotTables can support data analysis and reporting
More Excel Courses
Microsoft Excel Introduction
Master workbook navigation, efficient data handling, and essential formulas. Create professional-looking spreadsheets, design clear charts, and produce polished print-ready reports.
Microsoft Excel Intermediate 1
Develop practical Excel skills, enabling users to work more efficiently with spreadsheets, organise and analyse data, and present information clearly. Delegates will learn to use Excel Tables, conditional formatting, sorting and filtering, formulas and charts.
Microsoft Excel Advanced
The goal of this course is to provide you with the knowledge required to use advanced functions and formulas, analyse complex data using PivotTables and PivotCharts, perform What-If Analysis, audit and troubleshoot formulas, validate and consolidate data, import and transform external data using Power Query, and automate repetitive tasks using macros.