New Logo
White mail

Microsoft Excel

Fundamentals

This course is for new and existing users of Excel who wish to acquire the basic skills required to create, edit, format and print spreadsheets effectively.

Objectives

Introduction

Using the ribbon, Quick Access Toolbar & keyboard shortcuts

Creating a new workbook

Entering, editing & deleting data

Autofilling data

Using Flash Fill

Working with SmartTags

Saving and closing a workbook

Opening a workbook

Using zoom

Data navigation and selection

 

Formulas

Creating and editing basic formulas

Using AutoSum

Copying formulas

Creating basic statistical functions

Using Absolute Cell Addresses

AutoCalculate

 

Formatting

Inserting & deleting cells, columns and rows

Changing the size of columns & rows

Aligning data

Changing text and number formats

Copying formats using the Format Painter

Merging & splitting cells

Applying borders and shading

 

Editing

Undo & redo

Checking spelling

Finding and replacing cell contents

Moving and copying data

Using the Clipboard

 

Printing

Using Print Preview

Changing worksheet orientation

Setting headers and footers

Additional Page Setup features

Printing

 

Charts

Quick Analysis charts

Recommended charts

Creating a basic chart

Changing the chart type

Formatting chart elements

Printing the chart

No previous knowledge of Excel is required however delegates should be able to use a computer.

Prerequisities

Content

© PrimeraTraining 2020

aIkYTrpHRRG58ENlqEQrRF0h5WI
Green_PolicyBee_Badge

Professionally insured through PolicyBee

We are GDPR compliant. For information on how we handle personal data, and your associated rights, please view our Privacy & Data Protection Notice.