Microsoft Excel

Category
Duration Time
1 day
VERSIONS PROVIDED:
2010 / 2013 / 2016 / Online

Do you want to master Excel and really understand how to work best with spreadsheets? Our Excel training courses will get you started with the basics of calculations, formatting, linking and working with lists or enable to you to use advanced features, such as PivotTables, advanced functions and macros. On all sessions you’ll learn useful tips to work smarter and quicker, enabling you to become confident in updating or creating spreadsheets, whatever level you work to.

 

Essentials Overview

The first in our series of Excel courses is to get beginners up and running. We cover just the essential topics you need to create basic but effective spreadsheets, by looking at how to use basic formulas and functions, perform formatting, create basic charts and manage printing. By the end of the course, you will have everything you need to master the essentials of Excel.

Download the full course outlines
ESSENTIAL COURSE OUTLINE
Spreadsheet terminology explained
Navigating the Excel environment
Create a spreadsheet
Enter, edit and delete text and values
Enter formulae
Calculate totals
Use common functions (SUM, AVERAGE, MAX, MIN)
Insert worksheets
Move, copy, rename and delete worksheets
Copy and move data
Use AutoFill
Sort and filter data
Format data
Change text formatting
Merge cells
Wrap text
Apply cell styles
View and print spreadsheets
Use Page Layout view
Insert headers and footers
Set print titles
Create a chart

Intermediate Overview

The second of our Excel courses takes those with basic skills and some experience of working with spreadsheets and takes them to the next level. You will learn more detail around formulas, so learn about Absolute Cell References, other functions and linking. You will go into depth on database features and learn how to perform advanced filters and use database functions. By the end of the course, you will really start to become an Excel expert.

Download the full course outlines
INTERMEDIATE COURSE OUTLINE
Review of essential Excel skills
Write formulae
Calculate totals
Understand absolute and relative cell references
Use named ranges
Use AVERAGE, MAX, MIN and COUNT functions
Use the IF function
Use SUMIF and COUNTIF
Advanced formatting
Apply conditional formatting
Link worksheets and workbooks
Use Data Consolidation
Understand data list design
Work with Flash Fill
Sorting and filtering data
Apply an advanced filter
Use table slicers
Work with advanced charts
Add Trend Lines and Error Bars
Use stack and scale formatting options
Create and use custom chart types

Advanced Overview

Our advanced Excel course is for those that want to become Excel power users. You will learn those expert features such as PivotTables, macros, advanced functions such as VLOOKUP and formula auditing tools. By the end of the course you will be ready to become an Excel master.

Download the full course outlines
ADVANCED COURSE OUTLINE
Review of essential Excel skills
Write formulae
Calculate totals
Understand absolute and relative cell references
Use named ranges in calculations
Use AVERAGE, MAX, MIN and COUNT functions
VLOOKUP function
Use TEXT functions (AND, OR, CONCATENATE)
Add comments to cells
Using formula auditing
Using error checking
Using the watch window
The formula evaluator
Work with goal seek
Create and use templates
Use data validation
Sheet and workbook protection
Use form controls
Create PivotTables and PivotCharts
Understand report, column, row labels and data options
Modify and insert calculations
Insert PivotTable slicers and timelines
Apply PivotTable formatting

Visual Basic for Applications Overview

The final course in our series of Excel courses is just for those professionals who need to go beyond the standard Excel features to create customised processes, forms and calculations. You will learn the essentials of coding, how to create functions, check for errors and build forms.

Download the full course outlines
VISUAL BASIC FOR APPLICATIONS OUTLINE
The concept of a macro
Absolute and relative recording
Macro storage
Assign a macro to a button or keyboard shortcut
The Visual Basic window
Switching between Excel and the VB editor screens
Understanding code
Objects, properties, methods and events
Code storage and scope
The structure of routines
Common commands
Understand variables and declaration
Understand constants
Create message boxes
Manage input boxes
Use advanced functions
Check for errors
Use Debugging and Step mode
Create user forms
Create custom Excel functions
Protecting/locking code
Digital signatures

Find out more about our Evergreen service   Learn more