Presentation Style:  Tutor-led Training Course: Face-to-Face or Online
Duration: 1 Day
Course Time: 09:30 - 16:30hrs
Course Location: Face-to-Face in Althorp, Northampton or Online from any location
Cost:

Public Courses: £225 + VAT per delegate, £200 each + VAT for two delegates on the same day (call for group discounts)
Closed Courses: £850 + VAT for up to 12 delegates
Click a date to book:

What will you learn on this Microsoft Excel Intermediate Training Course? Delivered in our Northampton Training Suite or at Your Premises.

By the end of this course delegates will have gained skills in how to manage and extract data from database lists, use logical functions, link sheets and workbooks together and modify charts.

Excel Intermediate 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 Intermediate Excel course?

This Excel 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