Excel Intermediate
Delivered Face to Face or Virtually
Who should attend?
Are you looking to become more confident in Excel within a short period of time? Our Excel Intermediate Express course could be perfect for you. If you currently use Microsoft Excel for basic formulas and functions such as Auto sum then this one day express course could help streamline the way you work. Designed and delivered by industry leading trainers, this course will teach you features such as XLOOKUP, pivot tables and how to work with large data.
Prerequisites
Delegates will need to have a good working knowledge of creating/formatting simple spreadsheets, basic formulas and functions for example AutoSum. You will be self taught or would of attended our Excel Foundation course.
Course Objectives
Upon completion, all delegates will receive a certificate of attendance, an extensive manual and a range of tips to save you time and improve the way you work.
This course can be customised to incorporate other features of Office 365.
To find out more about our training options or to find out whether this course is right for you, please speak to our team today.
Course Duration
1 Day Classroom Training or Online.
Our course timings are 09:30 - 16:30, however timings can be customised to meet your needs.
Overview of shortcuts
Recap of Shortcuts and Tips
Customising the Ribbon to include useful shortcuts
Refresh on everyday Formulae
Recap of Absolute Cell Referencing
Range Names
Create Range Names
Navigate using Range Names
Print Range Name Areas
Create Formulae using Range Names
Advanced Functions
IF Statements
VLOOKUP, HLOOKUP, XLOOKUP
COUNTIF
Conditional Formatting
Apply Shading, Icon Sets and DataFills to cells based on criteria
Format Painter
Working with Large Data
Split your Worksheet
Freeze Panes
AutoFilter
AutoFilter Formatting and tricks
Sort and Custom Sort
Removing Duplicates
Text Functions
Use the Trim, Proper, Left and Right Functions
Concatenate Text
Text to Columns
Removing Duplicates
Flash Fill
Date Functions
Entering data Formulae
Now and Today Functions
Customising Data Formats
Tables
Creating Tables
Formatting Tables
Pivot Tables
Preparing data for a Pivot Table
Create Pivot Tables
Format Data
Group Data in Pivot Tables
Refresh Data
Slicers
Charting
Creating Charts Using a Function Key
Creating Pivot Charts
Changing the Chart Type
Formatting Charts
Adding Titles and Customising
Sparklines
