DMW logo
tel 01732 833085
tonbridge · kent · UK

Advanced Excel 2013, 2016 snd 2019 Training Courses

DMW’s Advanced Microsoft Excel courses focus on using Excel efficiently in creating, maintaining and enhancing complex spreadsheets.

There is much in Excel to engage power users and their ingenuity. Tap our experience in developing spreadsheet-based systems for business since 1988 to extend your expertise through the focus of DMW bespoke on-site courses.

If you are an intermediate-level user of Excel 2003 (or an earlier version than that) and intend an advanced course to coincide with your move to Excel 2007, 2010, 2013 or 2016, then we can use a little time to go over the ribbon interface.

Course Duration

This course takes one day on-site, normally between 9:30am and 4:30pm.

Course Prerequisites

Completion of our Intermediate Microsoft Excel course or sound practical experience of applying the skills covered by that course.

Course Content

For clients preferring topics from the Intermediate course to be included for revision purposes, we will adjust the Advanced course syllabus accordingly.

Functions Examination of a selection of functions appropriate to your calculations, chosen from the maths, look-up and reference, database, finance, engineering, statistics, date and time, text, logic and information ones built in to Excel.

Advanced formulae Constructing and checking complex formulae; embedding functions in formulae.

Look-ups How to make Excel look-up entries in lists and tables.

Auditing Checking spreadsheets for missing and incorrect formulae.

Scenarios Feeding spreadsheets with sets of differing values to compare outcomes.

Custom views Keeping a variety of interchangeable formats and layouts for the same spreadsheet.

Report Manager Add-in Combining views and scenarios to produce different 'reports' from the same spreadsheet.

Databases Setting up a database; sorting; querying; outputting filtered subsets.

Pivot tables Powerful technique for taking different perspectives on a complex sets of data.

Recording macros How to capture sequences of keystrokes and mouse actions for repetitive use.

Editing macros A look at your recorded VBA (Visual Basic for Applications) macro code. The ground we cover on VBA is limited by the time left available by the other topics. If you want to cover VBA in any depth, consider our Excel VBA course.

“I wish I’d known about sumproduct before now 😂”

Author unknown