ESF Intermediate Course on Excel - Get SET Academy

ESF Intermediate Course on Excel

This one-day course provides delegates with a brief review of Excel basics and introduces them to more features, functions, and data handling techniques within Excel 2016. It is designed for those computer users who use spreadsheets on a regular day to day basis.

Pre-requisites

Delegates should have either attended the Excel Introduction course or have similar experience gained in the workplace.

Course outline

This course provides delegates with a brief review of Excel basics and introduces them to more features, functions, and data handling techniques within Excel 2016. It is designed for those computer users who use spreadsheets on a regular day to day basis.
These course objectives familiarise delegates with the topics to be covered and provide a means for them to evaluate their learning. Upon successful completion of this course delegates will be able to: –

Finding Your Way Around the Excel 2016 Interface
Use relative, mixed & absolute cell references
Manage & navigate worksheets in a workbook
Sort & filter information held in tables
Create & use custom cell formats
Use conditional formatting to highlight results
Use logical, mathematical, statistical, date/time & text functions
Use Named cell ranges in formulas
Customise charts & control chart options

Contents

Backstage View & the Office 2016 Ribbon
Using Absolute & Relative Addresses
Managing Worksheets
Using Custom Cell Formats

Using Miscellaneous Tools

Using the Format Painter
Using Conditional Formatting
Add Data Bars, Colour Scales & Icon Sets to cells
Using Sparklines to add minicharts
Hiding/Unhiding Rows & Columns
Clearing Cell Contents and Formats
Jumping to a Cell

Working with Excel Data Tables

Sorting Data
Filtering Information
Format cells as Excel 2016 Tables
Finding and Replacing Data
Linking Worksheets & Workbooks

Working with Functions

Defining Names for Ranges
What are Functions?
Using Math and Trigonometric Functions
Using Statistical Functions
Using Logical Functions
Using Date and Time Functions
Using Text Functions

Charts & Graphs

Customising a Chart
Modifying Chart Options
Adding New Data
Changing Chart Type
Changing Chart Location
Adding Trendlines
Working with more than one Axis

Controlling the View

Freeze headings when scrolling a Worksheet
Using Comments

Keyboard shortcuts

Keyboard shortcuts and error codes

Duration:

9.30am to 4.30pm (plus 1 day self learning)

Location:

Delivered online via Zoom/MS Teams

Already completed this workshop?

Microsoft Word Introduction

Dates Available:

To be confirmed

Book on workshop!

Head Office

Central Buildings
Richmond Terrace

Blackburn, BB1 7AP

Telephone

01254 679998

Email

info@getsetacademy.co.uk

Training Academy

Innovation Centre
69 Preston New Road

Blackburn, BB2 6AY

Greater Manchester Office

Marlborough Resource Centre
Marlborough Street
Glodwick, Oldham, OL4 1EG

Policies and Procedures

© Copyright 2022 Get SET Academy | All Rights Reserved.