Excel Courses - 4 Levels

Introduction - Level 1

Who is the Course for?

This course is ideal for both new and long term users who have had no formal training (often self-taught) and would like to make sure they are prepared for further levels. A general understanding of the personal computer and Windows would be useful. There are lots of useful time-saving tips.

Content

Introduction to Spreadsheets
Data Entry
The Ribbon Bar
Formatting
Basic Maths
Resizing
Basic Calculations
Sum
Copy & Fill
Absolute & Relative Referencing
Percentage
Sorting Data
Filter Data
Find Data
Selecting Data
Selecting Multiple Ranges
Insert New Columns and Rows
Date and Time Entries & Functions
Comments
Working with Multiple Worksheets
Printing
Page Setup
Show Formulas
Freeze Panes
Average, Maximum, Minimum
Conditional Formatting
Basic Charts
Embedded Chart
Handy Shortcuts

Intermediate - Level 2

Who is the Course for?

This course is designed for users who wish to increase their skills and knowledge of spreadsheets and Microsoft Excel. This level will help the delegate to produce more productive spreadsheets using formulas and function techniques.

Content

Logic Functions
TRUE – FALSE
SumIF

SumIFs
AverageIF

AverageIFs

CountIF

CountIFs
IF
Nested IF
IFERROR
AND

NOT
Naming Cells & Ranges
Managing Names
Using Names
Lookup Functions
Import CSV or Txt
Custom Fill
Static Dates and Times
Custom Date Formats
Custom Time Formats
Dynamic Dates and Times
Basic Date Calculations
Date Functions
Times
Handy Shortcuts

Advanced - Level 3

Who is the Course for?

This course is designed for users who have a good knowledge and understanding of spreadsheets and wish to use more advanced features of the programme.

Content
Excel Forms
Scenario Manager
Goal Seek
Installing Solver
Solver
Subtotals
Grouping & Outlining
Pivot Tables
Pivot Charts
Slicers
Tables
Cleansing Data
Excel Macros
Macro Security
Saving a Macro Workbook
Recording & Running a Macro
Relative Cell References (Macros)
Viewing & Editing a Macro
Assigning Macros
Global Macros
Object to run Macros
VBA Code

Power Pivot - Level 4

Who is the Course for?

This course is ideal for experienced users who are responsible for analysing data from many sources and have a good understanding of Excel functions and formulas.

Content
Introduction to Excel Power Business Intelligence
Enable Power Pivot
Power Query
Power Query Editor
Query Editor Tools
Loading Data
Pivoting and Unpivoting
Merging Queries
Appending Queries
Data Model Views
Database Normalisation
Data and Lookup Tables
Power Pivot
DAX Measures
Data Analysis Expressions (DAX)
Basic Measures
SWITCH and SWITCH(TRUE) Functions
Date and Time Functions (Basic)