Options for your Shopping Cart
Microsoft Excel 2013/2016 Advanced
Interactive course with workbook & certificate
SPRING SALE pricing (RRP $ 69.00)
Click on your choice [ it can be removed or edited in the cart ]
Order Qty |
Total cost | Unit cost |
|
1 |
$ 10.76 | $ 10.76 |
|
5 |
$ 48.40 | $ 9.68 |
|
10 |
$ 86.00 | $ 8.60 |
|
50 |
$ 360.00 | $ 7.20 |
|
100 |
$ 538.00 | $ 5.38 |
Options for your Shopping Cart
Microsoft Excel 2013/2016 Advanced
+
Microsoft Excel 2013/2016 Professional
SPRING SALE pricing
Click on your choice [ it can be removed or edited in the cart ]
Order Qty |
Total cost | Unit cost |
|
1 |
$ 24.76 | $ 24.76 |
|
5 |
$ 113.40 | $ 22.68 |
|
10 |
$ 206.00 | $ 20.60 |
|
50 |
$ 860.00 | $ 17.20 |
|
100 |
$ 1,238.00 | $ 12.38 |
Options for your Shopping Cart
Interactive course with workbook & certificate
SPRING SALE pricing (RRP $ 0.00)
Click on your choice [ it can be removed or edited in the cart ]
Order Qty |
Total cost | Unit cost |
|
1 |
$ 10.76 | $ 10.76 |
|
5 |
$ 48.40 | $ 9.68 |
|
10 |
$ 86.00 | $ 8.60 |
|
50 |
$ 360.00 | $ 7.20 |
|
100 |
$ 538.00 | $ 5.38 |
Grouping & Outlining and Subtotals
What-If Analysis
PivotTables
Charting Pivoted Data
Advanced Excel Tasks
Creating HLOOKUP and VLOOKUP Functions
Introduction to Macros in ExcelYou should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
This course has been designed for users with a good understanding of Microsoft Excel who want to expand on their capabilities in a short space of time.
Please select your course:
Enter your details as follows:
Your First Name:If you have a solid understanding of the basics, and working with functions, formulas and the like, this course will take you into the world of data analysis.
You learn how to retrieve and analyze large data sets, and how to automate processes with simple macros
Everything is clearly explained, but you should be very familiar with the subjects in the Introduction and Intermediate courses.
This Microsoft Excel Data Analysis skills training course, like all our courses, has been developed over many years of classroom and online delivery. Content has been thoroughly researched and is constantly updated so it's always leading edge. It's delivered by professional presenters and is full of practical knowledge and solutions.
Still wondering whether to do the course?
Just think about this: how much would you benefit if you had better Microsoft Excel data analysis skills?
Are you ready to take your work from good to downright impressive?
You learn about Grouping, Outlining and Subtotals, and how to use What-If Analysis, Pivot Tables and Pivot Charts.
Then we introduce you to HLOOKUPS and VLOOKUPS, and finish with an introduction to Macros which will make your spreadsheets FLY!
You will now be able to produce spreadsheets that not only display your data, but analyse and play tricks with it too...
Watch the modules, revisit them time and again ... and have fun with improving your skills!
The CPD certificate you get with the Diploma and Professional course options will be your proof of where you are.
How about fulfilling your maximum potential?
Choose the Development or Professional course options and get your own great, results-focused downloadable workbook.
[ Click for details of the course options available ]
The workbook features:
POWER pack: Microsoft Excel Beginner to Professional (Four courses)
You do not require any experience of using Microsoft Excel, but you do need to be familiar with using a PC with Microsoft Windows.
Microsoft Access