Intermediate Excel 2013, 2016 and 2019 Training Courses
DMW’s Intermediate Microsoft Excel courses are for spreadsheet users who want to expand their skills in creating and checking formula, and to develop skills for managing multiple spreadsheets, for chart or graph making and for working with substantial sets of data.
A major objective of the training is to set you up to use spreadsheets in your work. With this in mind hands-on exercises are based wherever possible on worksheets like those you meet day-to-day in the office.
One great advantage of receiving training at your offices is that you are not distracted by the concerns of people from other businesses, as you might be if you attend public courses.
Questions are welcome and encouraged throughout the day. Often these lead to discussions of topics and techniques that might otherwise be overlooked.
On satisfactory completion of the course you are provided with a Certificate of Attendance.
If there are topics in the Basic Introduction course that you want included, let DMW know ahead of your Intermediate and we will take a little time out for a refresher.
Charts/Graphs Creating; formatting; customising.
Formatting Creating custom formats for numbers and dates; conditional formatting
Functions Important Excel functions for incorporation in formulae, including IF, ROUND, SUMIF, COUNTIF and VLOOKUP.
Interpreting formulae Techniques for understanding complicated formulae—useful if you are using spreadsheets created by other people, particularly by your office Excel geek.
Range names Their significance; creation; incorporation in formulae.
Verifying input Techniques for checking content of cells; input validation.
Spreadsheet auditing Techniques for checking formulae.
Multiple spreadsheets Viewing; arranging; organising.
Linking spreadsheets Why link; linking worksheets; linking workbooks.
Workspaces Collections of workbooks for easy filing.
Data consolidation Combining results from more than one set of data.
Outlining Applying structure to rows and columns.
Sorting Sorting lists.
Filtering Showing items in lists that match chosen criteria.
Sub-totals Creating automatic sub-totals.
Course Duration and Prerequisites
This course takes one day on-site, normally between 9:30am and 4:30pm.
If you haven’t completed DMW’s Basic Introduction course, then have a look at the topics it covers to find out if you already posssess the necessary background.