IT Computer Training Courses Edinburgh, Glasgow, Scotland: Microsoft Excel Level 2 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 2

Suitable for versions 365 / 2019 / 2016

Whether you are a new 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 those who have a good understanding of Excel at a Foundation level.

Course goals

Delegates will learn how to:

Improve existing spreadsheet knowledge with linking worksheets and files
Learn all about working with Data Tables and Dynamic Referencing
Create professional looking charts and visualise data
Boost existing formula knowledge with super handy functions
Delegates will also learn shortcuts and tips about how to use Excel in the most efficient way

Topics

Linking worksheets

Multiple sheets
Selection techniques
Copying data between sheets
Filling across multiple sheets
Group mode
Consolidating data across worksheets

Understanding Databases and Datasets

A masterclass in Excel Data Tables
Database parameters
Understanding Dynamic Named Ranges
Managing multiple tables
Formatting and styling tables
Using Slicers to filter
Exporting data from other sources in tables
Creating calculated fields
Using Dynamic References
Introduction to PIVOT TABLES

Very Useful Functions

COUNTIFS, SUMIFS, AVERAGEIFS
Using Wild cards and Comparison operators to extend your functions
Efficient formula tips, tricks and expert advice

Protection

Protecting worksheets
Protecting cells
Protecting files
Permissions
Multi-user access
Passwords

Data lists

Using the Fill handle to create lists
Understanding data series
Flash Fill

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
Format Painter

Excel's secrets & expert advice

Creating a proper database
Navigating a worksheet
Hidden views

File linking

Linking spreadsheets
Linking workbooks
Linking Microsoft 365 Cloud Files (OneDrive, SharePoint and Teams)
Controlling links
Breaking links
Updating
Editing

Charts

Creating professional looking charts
Advanced properties
Advanced chart types
Multiple charts
Linking
Exporting
Visualising data

Microsoft 365 Cloud Features

What's new
Cloud storage, SharePoint, Teams and OneDrive
Versions
Co-Authoring
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 £ 269 n/a

2 places £ 538 n/a

3 places £ 807 £ 799

4 places £ 1076 £ 1054

5 places £ 1345 £ 1305

6 places £ 1614 £ 1549

7 places £ 1883 £ 1789

8 places £ 2152 £ 2023

		Group discount
1 place	£ 269	n/a
2 places	£ 538	n/a
3 places	£ 807	£ 799
4 places	£ 1076	£ 1054
5 places	£ 1345	£ 1305
6 places	£ 1614	£ 1549
7 places	£ 1883	£ 1789
8 places	£ 2152	£ 2023