Microsoft Excel Intro

Introduction to Microsoft Excel

The Excel Interface

Opening a worksheet

Amending data in a worksheet

Getting to grips with the basics

Using Backstage View

Understanding the Ribbon

Using & customising the Quick Access toolbar

Effectively organising your workbooks

Creating, saving and opening a new workbook

Entering numbers, text and dates in a workbook

Deleting cell contents

Quickly sorting data

Adding, deleting and naming sheets

Controlling the layout of spreadsheets effortlessly

Inserting columns and rows

Deleting columns and rows

Using AutoFill

Using Cut, Copy and Paste

Using Undo and Redo

Uncomplicate tasks by defining and creating calculations

Writing a basic formula

Understanding the order of BODMAS

The Sum function and AutoSum function

Creating statistical functions (Average, Max and Min)

Working with Relative References when copying formulas

Beautifully presenting your data

Font formatting

Borders and shading

Number formatting (currency etc)

Alignment options

Clearing formats

Fine-tuning your page layout before printing worksheets

Setting page margins & page orientation

Creating a Header & Footer

Printing all or part of a worksheet

Setting print titles for large worksheets

Creating different visual representations of your data

Creating a chart

Changing the chart type

Basic formatting of charts

Questions and answers