 |
 |
 |
|||
|
Info, Blogs, Contact & Login ▼
|
Courses ▼
|
Tests ▼
|
|||
|
|
|
|
|||
|
Info, Blogs, Contact & Login ▼
|
Courses ▼
|
Tests ▼
|
|||
Options for your Shopping Cart
Microsoft Excel 365 (2021) Advanced
Interactive course with workbook
SPRING SALE pricing (RRP $ 59.00)
Click on your choice [ it can be removed or edited in the cart ]
Order Qty |
Total cost | Unit cost |
|
1 |
$ 17.68 | $ 17.68 |
|
5 |
$ 83.95 | $ 16.79 |
|
10 |
$ 162.60 | $ 16.26 |
|
50 |
$ 795.50 | $ 15.91 |
|
100 |
$ 1,502.00 | $ 15.02 |
Options for your Shopping Cart
Microsoft Excel 365 (2021) Advanced
+
Microsoft Excel 365 (2021) Intermediate
SPRING SALE pricing
Click on your choice [ it can be removed or edited in the cart ]
Order Qty |
Total cost | Unit cost |
|
1 |
$ 40.68 | $ 40.68 |
|
5 |
$ 193.95 | $ 38.79 |
|
10 |
$ 382.60 | $ 38.26 |
|
50 |
$ 1,845.50 | $ 36.91 |
|
100 |
$ 3,502.00 | $ 35.02 |
Options for your Shopping Cart
Interactive course with workbook
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 |
$ 17.68 | $ 17.68 |
|
5 |
$ 83.95 | $ 16.79 |
|
10 |
$ 162.60 | $ 16.26 |
|
50 |
$ 795.50 | $ 15.91 |
|
100 |
$ 1,502.00 | $ 15.02 |
Course Introduction
Dynamic Arrays
Advanced Lookup and Reference Functions
Statistical Functions
Math Functions
New Functions - LET and LAMBDA
Advanced PivotTables and Pivot Charts
Form Controls
Working with Power Query
Forecasting
Macros and VBA
Practical Excel - Advanced Formulas You 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.
This course is designed for people who have intermediate-level knowledge of Excel and are looking to build on those skills.
It's also great for anyone who's moving up from an older version of Excel.
It will also enable you to tackle problem-solving differently and combine Excel's many functions to complete practical tasks more quickly and effecively.
This Advanced Microsoft Excel 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 completely interactive 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 advanced Microsoft Excel skills?
The course takes advantage of the latest updates from Microsoft including the game-changing LET and LAMBDA functions. These exciting functions allow students to create their own variables and even their own Excel functions.
You'll be introduced to six brand-new dynamic array functions, learn how to build advanced Excel formulas, analyse data with advanced PivotTable skills, create macros to automate tasks, import and clean data with Power Query, forecast data, and so much more!
Watch the modules, revisit them time and again ... and have fun with improving your skills!
How about fulfilling your maximum potential?
Choose the Development course option and get your own great, results-focused downloadable workbook.
[ Click for details of the course options available ]
The workbook features:
Microsoft Access