Microsoft Excel Training Courses

Microsoft Excel Introduction Course

This one day course provides a new user or user with basic experience of Microsoft Excel, the confidence to use a wide range of features.

Understand and write formulae, build common functions, apply formatting, sorting, filtering and generate charts in Excel spreadsheets. You will also learn valuable shortcuts enabling you to work efficiently.

Read More

Microsoft Excel Introduction training course outline

Basics and Formatting
Tour the Microsoft Excel Environment
Customise the Quick Access Toolbar
Enter and edit data
Adjust Column widths
Move and copy data
Use AutoFill
Format a worksheet
Copy and clear formatting
Prepare a worksheet for printing
Save a workshseet as a PDF
Learn keyboard shortcuts

Formulas and Functions
Understand and write Formulae
Learn the construction of a Function
Use the SUM function
Use AutoFill to copy a formula

Further Functions
Use Functions AVERAGE, MIN, MAX and COUNT
Calculate percentages
Learn how to use relative and absolute cell referencing

Work with Data Lists
Use Freeze Panes
Sort data
Filter Information

Charts and Graphs
Create bar, column, line and pie charts
Explore and change chart properties

Training Dates

5th July 2017

4th August 2017

11th September 2017

12th October 2017

Price

£155

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Excel Intermediate Course

You've mastered the basics - you can write formulae and apply a function and you're ready to find out more about what Excel can do.

A full day which provides a delegate who has a good basic knowledge of Excel the confidence to use some of the more advanced functions, use Excel as a database (data lists) and summarise data over multiple sheets.

Read More

Microsoft Excel Intermediate training course outline

Calculations and Named Ranges
Brief review of common functions and formulae
Calculate and format dates
Create Named Ranges
Use Named Ranges with Functions

Work with Data Lists
Sort multiple columns
Filter Information
Apply Validation Rules
Create Subtotals
Insert and work with Pivot Tables
Apply conditional Formatting

Work with More Advanced Functions
Work with the IF Function
Use the SUMIF Function
Apply the COUNTIF Function
Look up data with the VLOOKUP Function

Multiple Sheets and Protection
Enter data and use Formulas across sheets
Group sheets for Input and formatting
Consolidate data on a summary sheet
Protect a worksheet
Protect cells within a worksheet
Password protect a workbook

Training Dates

13th July 2017

11th August 2017

18th September 2017

18th October 2017

Price

£165

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Excel Advanced Course

This one day Microsoft Excel Advanced training course is for those with a sound working knowledge of Microsoft Excel. For those delegates who wish to progress to use the most complicated functions and features. At the end of this course you will investigated some of the higher functions of Microsoft Excel.

Read More

Microsoft Excel Advanced training course outline

Work with and Nest Functions
Create your own Custom Lists
Nest Functions, IF, AND and OR
Apply DATE Functions
Use and nest TEXT Functions
Understand and manage Errors

Auditing, Linking and Advanced Formatting
Apply Conditional Formatting across rows
Work with Track Changes and Comments
Link and Paste data
Use the Watch Window
Apply Table Formats

Excel Analysis Tools
Use Goal Seek
Apply solutions using Solver
Create Scenarios with Scenario Manager

Macros and Excel Forms
Record a Macro
Assign a Macro to the Quick Access Toolbar
Assign a Macro to a Button
Edit Visual Basic Code
Create Excel Forms

Training Dates

11th July 2017

2nd August 2017

20th September 2017

23rd October 2017

Price

£175

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Excel Data Lists

For those who work with columns of data in lists within Excel, perhaps exported from another application or entered directly into Excel. This course explores the many useful database functions, pivot tables and other useful features to make the most of analysing your data.

Read More

Microsoft Excel Data Lists course outline

Setting up and Entering Data
Rules to follow
Using the Data Form
Setting up Data Validation
Freeze Panes

Useful Functions
The IF, AND and OR Functions
Database Functions
VLOOKUP Function
Excel Tables
Flash Fill

Reporting Tools
Sorts and Filters
Conditional Formatting
SubTotals
Sparklines
Pivot Tables
Pivot Charts

Training Dates

Please contact us for dates

Price

£195

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course

Microsoft Excel PowerPivot

This one day training course is for users who have little or no knowledge of PowerPivot in Excel. This course provides you with a working understanding of the basic features. At the end of the course you will have a good working knowledge of PowerPivot basics. You will feel more confident using PowerPivot and be able to create your own tables and charts from scratch.

Read More

Microsoft Excel PowerPivot course outline

Introduction
PowerPivot Overview
Where do I get PowerPivot from
Connecting to a Data Source
Pasting Data into PowerPivot

Data Models
Introduction to the Data Model
Combining Data from Two data tables
Combining Data from more than one source
Using the Diagram View
Managing relationships between tables

Analysing Data
Creating a Pivot Table
Creating a Pivot Chart
Combining Pivot Tables and Charts into one View
Creating Slicers
Creating a Calculated Column
Introducing DAX
Basic DAX Expressions

NOTE: We also offer Advanced PowerPivot training on request.

Training Dates

Please contact us for dates

Price

£295

Venue

Minstead Lodge, New Forest Venue Information

Download Course Details

Book this course