Presentation Style:  Tutor-led Classroom Training Course
Duration: 1 Day
Course Time: 09:30 - 16:30hrs
Course Location: Northampton
Cost: Public Courses: £175 +VAT per delegate, £150 each + VAT for two delegates on the same day (call for group discounts)
Closed Courses: please enquire

What will you learn on this Microsoft Excel Intermediate Training Course?

By the end of this Excel course delegates will have gained skills in how to work with ranges, work with large spread sheets, entering formulas, working with databases, advanced charting and setting up spread sheets.

Course Content

Module One
Naming ranges, Hide/unhide columns and rows, conditional formatting, format painter and hyperlinks
Module Two
Creating and working with outlines, freezing panes
Module Three
Calculating with dates, VLOOKUP, linking worksheets and workbooks, using the IF formula
Module Four

Setting up lists, sorting and auto filtering, creating subtotals

Module Five

Creating a secondary axis, combined chart types, custom format charts

Module Six

Passwords to open and modify, protect sheets and cells, changing default options and using auto correct

Who should take this course?

This course is designed for delegates with working knowledge of Microsoft Excel to a level equivalent to having completed the Microsoft Excel Introduction course and who wish to gain further knowledge of the more advanced features such as data handling tools, charting options and how to use more in-depth function of Microsoft Excel.

Additional Information

  • Buffet lunch included and free parking (only for courses held at Paradise Training Centre, Northampton)
  • Joining instructions will be sent prior to attending the course