ESF An Introduction To Excel

This one-day course introduces delegates to basic commands, functions, and capabilities of Excel 2016. It is designed for computer users who are new to spreadsheets and are going to use Excel occasionally.

Target Audience

New or intending users of Excel who want to gain a good understanding of the software in a short space of time.

Pre-requisites

Requirements include a basic understanding of PCs, a familiarity of the layout of a PC-style keyboard, and using a mouse and/or touchpad. This can be gained either through previous experience or attendance on a “Windows Fundamentals” course.

Course outline

This course introduces the delegate to the basic commands, functions, and capabilities of Microsoft Excel 2016. It is designed for those computer users who are new to spreadsheets or are only going to use Excel occasionally.
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: –

Use Excel 2016 to create, save & open spreadsheets
Enter & edit information in worksheets
Use formulas & functions to add, subtract, multiply & divide numbers
Enhance worksheets with fonts and borders
Format numbers & resize cells
Preview & print spreadsheets
Create, save & format a Chart
Work with Graphics

Introduction

Introducing Backstage View
Finding commands on Excel’s Ribbon
Customising the Quick Access Toolbar
The Excel Screen layout
Cell References
Opening & Saving Files
Entering Data in the Worksheet
Changing Data

Using the Worksheet

Selecting Cells
Adjusting Columns or Rows
Inserting & Deleting Rows and Columns
Using AutoFill
Moving Data

Formulas & Functions

Creating Simple Formulas
Using Simple Functions
Using the Spell Checker

Formatting Worksheets

Formatting Data in Cells
Aligning Cells
Merging cells
Using Cell Styles

Printing Worksheets

Displaying spreadsheets in Page Layout view
Previewing the Worksheet before printing
Using Headers & Footers
Using Page Break View
Controlling Printouts
Printing the Worksheet

Working with Charts

Understanding Charts
Creating Charts
Selecting Chart Types
Showing Data Values in a Chart
Changing the Chart Scale

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?

Try the next level.

Microsoft Excel Intermediate

Dates Available:

To be confirmed

UNEMPLOYED

CAREER BUILDERS

ENTREPRENEURS

EMPLOYERS