Excel Courses Milton Keynes

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
OR
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)

Ready for Action?

Are you ready to check dates and book? Then take action now and click below.
Check Dates

Harben House Hotel
Tickford Street
Newport Pagnell
MK16 9EY

Tel: 01908 92 50 58
        0330 32 100 58
(Calls may be recorded for quality purposes) 

linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close