Microsoft Excel Proficient User

Course description

This advanced CPD accredited course builds on your existing Microsoft Excel skills and knowledge. Learn how to use the tools, formulas and techniques that are used in the workplace by proficient users. The course consists of the following modules: - use grouping tools - use formula auditing tools - use Excel tables - use named cells and ranges - use an advanced filter - use data validation - use What-if analysis - use the IF Function - use the AND Function - use the OR Function - use functions to lookup data - use conditional formatting - use an array formula - use tools to identify blank cells - use tools to find duplicates - use PivotTables. You'll receive 10 hours of 1-to-1 training from an EC-PC Tutor. During the training sessions we'll cover core topics from the course, or we can customise the sessions to cover what you need to know. The training sessions can be delivered in 2 days or over a period of time, eg 1 hour a week for 10 weeks. Training is delivered remotely using Microsoft Teams. If you live in the Aberdeen area the course can be delivered face-to-face at our Aberdeen Training Centre.