Calc Training Courses

“Because people will try it and see they can get everyday work done without giving more money to Microsoft, they'll see -- in a low-risk way -- that open source software can work for them and be an even better solution."  Miguel de Icaza.

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 Calc spreadsheet to enter, change and analyse information necessary to do your job . You will learn how to start working with Calc’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 Calc and get the skills to become more efficient and productive in your work. It also prepares you for moving on to the Calc 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 Calc.

Duration: 1 Day

Course Topics:

Introduction to the Calc 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 Calc Level 3 Course.

To get the most out of this course:
You will have attended the Burningsuit Microsoft Calc 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 Data Pilot
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 Calc, 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.

To get the most out of this course:
You will have attended the Burningsuit Calc Level 2 Course. Or, you have been using Calc 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 Data Pilot
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