Microsoft Excel Training Courses

“Spreadsheet:  a kind of program that lets you sit at your desk and ask all kinds of neat "what if?" questions and generate thousands of numbers instead of actually working.”  Dave Barry

Level 1

Download course details

Request a quote for this course

 

What this course will do for you:
To be able to use a spreadsheet confidently has now become part of most people’s work.  However, it’s also where many people flounder because of lack of confidence and the necessary skills.  This course will give you the confidence and skills to use an Excel spreadsheet to enter, change and analyse information necessary to do your job . You will learn how to start working with Excel’s formulas and functions to manipulate both numbers and text and you’ll also find out how to create charts so you can communicate information effortlessly to your clients and colleagues. By completing structured exercises, using data relevant to your work, this course will show you how easy it is to use Excel and get the skills to become more efficient and productive in your work. It also prepares you for moving on to the Microsoft Excel Level 2 Course.

To get the most out of this course:
You don’t need any previous experience of using spreadsheets but you should be reasonably confident in general computer use and want to learn how to use the everyday features of Excel.

Duration: 1 Day

Course Topics:

Introduction to the Excel Environment	How to use Autofill
Basic Spreadsheet Skills	How to Enter Formulas and Functions
Moving and Copying Data	Printing Sheets
Formatting Cells	Using Simple Charts

 

Level 2

Download course details

Request a quote for this course

 

What this course will do for you:
A large percentage of your organisation’s data is held in spreadsheets but at the moment, you’re struggling to extract the information you need. This course will give you the skills to get Excel to do most of the analysis work for you.  You will learn how to use the IF function, conditional formatting, filtering and sorting and many more data analysis features to help you in your work.  By completing structured exercises, using data relevant to your work, this course will increase your competence in day-to-day data analysis making you more efficient and productive. This course also prepares you for moving on to the Microsoft Excel Level 3 Course.

To get the most out of this course:
You will have attended the Burningsuit Microsoft Excel Level 1 Course. Or, you feel reasonably competent in using worksheets to enter your data and basic formatting of cells and you now want to concentrate on the analysis of your data.

Duration: 1 Day

Course Topics:

Review the Entry of Formulas	Introduction to Pivot Tables
Use Absolute References	How to Use Data Consolidation
Naming Cells and Ranges	How to Use Conditional Formatting
How to Use the IF Function	Work with Paste Special
Work with Datalists

 

Back to Top

Level 3

Download course details

Request a quote for this course

 

What this course will do for you:
Although you’re a competent user of Excel, you’re still finding some aspects challenging. You have specific targets to meet and you feel frustrated because your existing knowledge keeps letting you down. By its focus on working with nested functions, this course will give the skills to tackle the most complex data analysis and with the use of more advanced Pivot Tables, you will have the necessary skills to extract any information from datalists or consolidated ranges of data.  By completing structured exercises, using data relevant to your work, this course will increase your competence in advanced data analysis helping you meet those targets more efficiently. This course also prepares you for moving on to the Microsoft Excel VBA Course.

To get the most out of this course:
You will have attended the Burningsuit Microsoft Excel Level 2 Course. Or, you have been using Excel for a reasonable length of time and you are competent in basic spreadsheet analysis work and have used formulae and functions.  You now need to know how to use more complex functions and data analysis.

Duration: 1 Day

Course Topics:

Review of the IF Function	Working with Advanced Pivot Tables
How to Nest Functions	How to Use Data Validation
Using Advanced Conditional Functions	How to Use Select Special
How to Use the VLOOKUP Function.	What-If Analysis
Using Concatenation

Back to Top