Microsoft Excel - Advanced
|Presentation Style:||Tutor-led Classroom Training Course|
|Course Time:||09:30 - 16:30hrs|
|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
|Click a date to book:||No upcoming courses|
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
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.
- 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