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 Advanced Training Course?

By the end of this Excel course delegates will have gained skills; giving them a solid understanding of advanced tools and concepts in order to increase their knowledge and productivity

Course Content

Module One – Paste Special Options

Using Paste Special to Add, Subtract, Multiply & Divide, Using Paste Special ‘Values’, Transpose.

Module Two – Functions and Formulas

Nested Functions, Consolidating Data Using a 3-D Reference Sum Function, Mixed References within Formulas.

Module Three – Mathematical and Statistical Functions

Round, Rounddown, Roundup, Sumif, Counta, Countif, Rank.

Module Four – Database Functions

Dsum, Dmin, Dmax, Dcount, Daverage.

Module Five – Pivot Tables

Creating and Using a Pivot Table, Filtering and Sorting Data, Automatically Grouping Data, Manually Grouping Data.

Module Six – Validating

Whole Number, Decimal Number, List, Date, Time, Text Length, Input Messages, Error Alerts, Removing Data Validation.

Who should take this course?

This Excel course is designed for delegates with Knowledge of Microsoft Excel to a level equivalent to having completed the Microsoft Excel Intermediate course and who wish to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, create pivot tables and pivot charts and incorporate multiple data sources.

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