The best solution for Advanced Excel Training CoursesA hands-on one-day course with free e-learning revision after your training and pre-course online skills testing. Free bespoke course design is also available for private classes if the content needs to be adjusted
Note: this Excel Advanced course is CPD certified.
It is available as either a classroom course with online revision, or an online course.
This means that not only has it been rigorously assessed in terms of content and quality, but it comes with a FREE CPD Certification certificate, as well as an Activia diploma of completion.
We are a corporate member of the CPD: the highest level of association available.
Full details of modules and topics covered in this one-day course
This course covers 2010, 2013 and 2016 versions
Note: Free e-learning revision is available with this course: 12 months of access for each delegate on scheduled public (open) classes and standard on-site/private classes (not available for bespoke courses) .
This is a one-day training course structured into 7 modules
This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of advanced Excel 2007, 2010, 2013 or 2016 tools and concepts in order to increase their knowledge and productivity.
Users with a good understanding of Microsoft Excel 2007, 2010, 2013 or 2016 who want to expand on their capabilities in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction and Intermediate courses.
- Outlining and Grouping Data
- Using the Subtotals Tool
- Exploring Scenarios
- Goal Seek and Data Tables
- Using Solver
- Getting Started with PivotTables
- Displaying Data in a PivotTable
- Formatting a PivotTable
- Using the Classic PivotTable Layout
- Getting Started with PivotCharts
- Using the PivotChart Tools Tabs
- Formatting a PivotChart
- Excel and Hyperlinks
- Using Custom AutoFill Lists
- Sharing Workbooks
- Using the VLOOKUP Function
- Using the LOOKUP Function
- Recording and Playing Macros
- Copying and Deleting Macros
- Visual Basic and Macros
Don't see a date you want?
[Duration: one day]
- Introduction to Dashboards
- Inserting Graphics for a Dashboard
- Specialist Functions and Formulas
- Dashboard Navigation
- Preparing your Workbook's Layout and Structure
- Using Excel Objects for Specialist Dashboard Views
- Using Macros and VBA with Dashboards
[Duration: one day]
- Working with Functions and Formulas
- Outlining, Grouping and Sub Totals
- Protecting Your Spreadsheet
- Presenting Data with Charts
- Formatting Financial Data
- Data Tools: Managing Your Data
- Formula Auditing
- LOOKUP Functions
AVERAGE REVIEW: 4.2 out of 5 BASED ON 21 REVIEWS
With our latest Microsoft Excel courses, you get free e-learning revision for a full 12 months after your class so you can reinforce the knowledge you have gained.
Access is simple: go to www.activia.co.uk/login/ and log in using your email address. This will give you free access to our e-learning revision modules.
Note: These have been developed and written exclusively by Activia to maximise effectiveness, by matching the e-learning exactly to what you cover in class. We hope you have fun, on the day of the course and with honing your knowledge afterwards!
All Activia advanced excel training courses have been created, reviewed and developed to ensure up to date provision and constantly improving standards of content. Our Microsoft Excel training is interactive and classroom-based which maximises learning through the ability to ask questions and discuss specific issues.
Maximum class size for Microsoft Excel courses is 8 delegates, which ensures that attendees get adequate time for personal attention from the instructor. At some of our centres, the maximum class size is 6 delegates.
Note that we never cancel our scheduled classes -- even if there are only one or two delegates -- so once you have booked, your place is assured.
On our Public courses, you will always benefit from our small maximum class sizes of 8 delegates. In fact, the actual class size is often less.
However, if you want training for larger groups at your offices, we can deliver exactly the same content (though with a little less interactivity) for classes of up to 18 delegates, provided they have their own PCs or laptops. You will still have the exercises to download, and the same access to free e-learning revision, after the course.
These "large class" courses are a great choice if you need to get a lot of people trained in a short space of time, and the cost per delegate allows you to get more people upskilled within a limited budget.
[Note: Bespoke options are not available for these courses.]
If you would like to find out more, please get in touch to discuss.
Note: With non-credit card bookings you must sign and return a Booking Form before we can confirm your training.
Also note: If you are a private individual you must pay by credit card at the time of booking.
Note: Please allow 1 - 2 working days for your confirmation and invoice.
If you are coming to our centre, dress code is smart casual. Refreshments in the form of tea/coffee will be provided for morning and afternoon breaks, but please note that we do not provide lunch. The timetable is as follows:
Note: break times can vary according to the needs of the training, and course duration for smaller class sizes are usually shorter because fewer delegates have fewer questions !
For training at your offices, this itinerary can be varied by prior arrangement.
With every Microsoft Excel training course with Activia, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge. With all courses, you are also given 12 months access to free e-learning revision which will further help you to reinforce the lessons you have learned.
Every delegate on a Microsoft Excel course also gets an Activia Training Attendance Certificate.