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

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 designed for new or existing basic users of Microsoft Excel.

Course goals

Delegates will learn:

How to create spreadsheets
Understand formulas and functions
Format spreadsheets
Work with data lists, sorting, filtering
Delegates will also learn shortcuts and tips about how to use Excel in the most efficient way

Topics

Editing Spreadsheet

Enter different data types
Change existing formulae
Re-size columns, auto-fitting, text wrapping
Copy and Pasting inc. paste special

Creating Basic Formulae

How to create a formula
Understanding Functions
Autosum and all aggregate functions

Creating a Basic Spreadsheet

Create a table with titles
Use text, numbers and formulae
Copy formulae
Total columns
Format the cells
Hide gridlines

Presentation

Resizing columns / text wrapping
Formatting numbers
Formatting cells
Applying borders, cell colour, etc.
Using the Format Painter to copy formatting

Lists

Creating number series
Creating customised text lists
Creating date lists
Creating sequential number / date lists

Dates

Understanding dates in Excel
Formatting dates inc. custom format
Using dates in formulae
Using the TODAY functions

File Procedures

Save Vs Save as
Saving as older versions
Compatibility Mode

Printing

Print Preview
Scaling to print on 1 page
Define Print Area
Using Page Break Preview
Printing multiple worksheets / selected cells
Printing to PDF

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

Managing Formulae

Using brackets (BODMAS)
Relative and Absolute references (Using the $ signs in references)
Changing formulae to values

Page Setup

Orientation / scaling
Margins
Headers / footers

Functions

Min/Max
Average/Count
Sum
The IF function
Comparison Operators

Spreadsheet Efficiency

Cell Notes
Sorting
Page Breaks
Freeze Titles / Print Titles

Charts

Creating a simple chart
Changing chart type

Basic Filtering

Applying a filter
Creating a custom filter
Sorting
Remove Filter
Instant Data Analysis
Flash Fill

Integration with Microsoft 365

Cloud storage and OneDrive, Teams & SharePoint
365 Cloud File Benefits- Co-Authoring, Version control, Sharing, access file from multiple devices
Microsoft 365 Cloud Apps
Signing-in to Microsoft 365
Using Microsoft 365 on multiple devices
Easier file sharing

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