Microsoft Excel Intro

What Will I Learn?

•  Create a spreadsheet from scratch

•  Format text & numbers

•  Learn shortcuts to work efficiently

•  Perform basic calculations

•  Present data visually using charts

•  Free digital course assets

•  Free post-course helpdesk support

Getting to Grips with the Basics

• The Excel Interface

• Using Backstage View

• Understanding the Ribbon

• Using & customising the Quick Access toolbar

Effectively Organise Your Workbooks

• Creating, saving & opening a new Workbook

• Entering numbers, text & dates in a Workbook

• Deleting Cell Contents

• Quickly sorting data

• Adding, deleting & naming sheets

Controlling the Layout of Spreadsheets Effortlessly

• Inserting Columns & Rows

• Deleting Columns & Rows

• AutoFill

• Using Cut, Copy & Paste

• Using Undo & Redo

Uncomplicate Tasks by Defining & Creating Calculations

• Writing a basic formula

• Understanding the order of BODMAS

• The Sum function & AutoSum

• Creating statistical functions (Average, Max and Min)

• Working with Relative References when Copying Formulas

Beautifully Presenting Your Data

• Font formatting

• Borders & 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

Visual Representations of Your Data

• Creating a chart

• Changing the Chart Type

• Basic Formatting of Charts