IT Computer Training Courses Edinburgh, Glasgow, Scotland: Microsoft Excel Level 3 Computer Training: iTrain Scotland: Microsoft Office 2016 Training, Adobe Training, Windows 10 training, Office 2013 training, Computer Courses, Computer training room equipment hire

Classroom with tutor
or
Live virtual classroom

1 Day

Training Options:

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Classroom with tutor
or
Live virtual classroom

1 Day

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Microsoft Excel Level 3

Suitable for versions 365 / 2019 / 2016 / 2013

Whether you are an occasional user or have been using Excel for years, this course will vastly increase your understanding of Excel. Existing users will learn how to get the most out of Excel, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Excel trainers.

Course content

Prerequisites

This course is aimed at intermediate users of Excel who wish to exploit the full capabilities of their spreadsheet software. A complete understanding of the topics in the level 1 course is suggested.

Course goals

Delegates will learn about Pivot Tables, Databases, Macros, XLOOKUPS, Arrays, and many other Excel advanced features. The course also covers a vast array of advanced formulas and functions including Lookups and nested IFs. Delegates will also learn shortcuts and tips about how to use Excel in the most efficient way.

Topics

Databases

Excel tables
Slicers
Dynamic named ranges
Extending a table
Styles
Removing duplicates

Pivot Tables

Creating
Updating / refreshing
Connecting to a data source
Data models
Adding Fields
Field Options
Manipulating
Consolidation
Pivot Charts
Dashboards
Slicers and timelines

Arrays

Arrays explained
Dynamic array functions
Spilling
Unique, Sort array functions

Advanced Functions

XLOOKUP
VLOOKUP / HLOOKUP
MATCH & INDEX
Logical IF, AND, OR
Nested IFs
Mathematical
Date/Time
Text
Information
Statistical
Database Functions
Financial
General Nesting
Function hints and tips

Scenario Manager

Adding
Updating
Merge
Summary
Printing

Tips & tricks

Using Excel efficiently using shortcuts
Previewing all formulas on a worksheet
Auto calculations
Autofill
Keyboard shortcuts
Mouse shortcuts
Autoresize
Keyboard selection techniques
Mouse selection techniques

Excel's secrets & expert advice

Creating a proper database
Navigating a worksheet
Hidden views

General Advanced Features

Custom Formatting Numbers
Conditional Formatting Rules
Goal Seek
Text Joining
Styles
Custom Lists
Auditing
Mixed References

Advanced Charts

Adding 2nd Y Axis
Custom Charts
Trend Lines

Introduction to Macros

Recording Macros
Assign to Keyboard
Assign to Ribbon
Save in Personal
Save in Workbook

Office 365 features

What's new
Cloud storage and OneDrive
Office 365
Signing-in to Office 365
Using Office 365 on multiple devices
Easier file sharing
Instant Data Analysis
Flash Fill
Chart Recommendations
Animations in Charts

Prices

Prices below are for scheduled courses held in our Edinburgh Training Centre or Live Virtual Classroom. Major discounts available for onsite or private courses: click General Enquiry button below to enquire about private courses.

Group discount

1 place £ 205 n/a

2 places £ 410 n/a

3 places £ 615 £ 570

4 places £ 820 £ 760

5 places £ 1025 £ 950

6 places £ 1230 £ 1140

7 places £ 1435 £ 1330

8 places £ 1640 £ 1520

		Group discount
1 place	£ 205	n/a
2 places	£ 410	n/a
3 places	£ 615	£ 570
4 places	£ 820	£ 760
5 places	£ 1025	£ 950
6 places	£ 1230	£ 1140
7 places	£ 1435	£ 1330
8 places	£ 1640	£ 1520