Course Description
This expert MS Excel course is aimed at learners who want to get the most out of MS Excel and who have a very good practical knowledge of using MS Excel.
By the end of this course you will be able to create dynamic ranges, use ISERR, ISBLANK and ISNA functions and DSUM and DCOUNT. You will also take macros to another level by exploring the Visual Basic Editor and turning off screen flashing. Lastly you will explore further features with pivot tables such as filtering fields and calculated items.
Topics Covered
Advanced Features
More on Pivot Tables
Working with Macros
Excel Integration
Information Functions
Database Functions
Can't see what you need?
All Microsoft Office Online Courses are based on a typical one day training course at a specific skill level and are included in our full online library. If you require a more tailored course to meet a particular learning need, get in touch.
All Personal Development Online Courses are 15 minute modules that complement our Bite Size methodology and work well together to create a great training plan.
Great deals for Corporate licences – give us a call.

