# Basic Excel

Learn basic Microsoft Excel in just four hours.

This online course contains four hours of basic Excel training split across-22 modules. If you’re new to Excel or have limited knowledge of Excel, this course is for you.

## Highlights

Upon completion of this course, you will have covered:
• Data entry
• Text and number formats
• Basic mathematical functions
• Editing skills, including flash fill
• Sorting and filtering

## Preview

Course Content

Course Content

Course Content

Syllabus Explorer

User Dashboard

Course Certificate

## Syllabus

### Section 1: Basic Skills

directright

#### Unit 1.1 - Excel Introduction

A description of the purpose and application of Excel – what it can do, why it’s useful.

directright

#### Unit 1.2 - The Excel Interface

Understanding and working with the Excel interface – getting to know your way around the application, how to access functionality and how to customize it.

directright

#### Unit 1.3 - Accessing and Saving Files

How to create, save and open Workbooks. Under Save As, a brief explanation of backwards compatibility and other formats (e.g. PDF) save options. Skydrive, alternative online storage, and ‘local’ saving. Basic printing.

directright

#### Unit 1.4 - Read and Enter Data

Entering information into cells, types of data (text, numbers, dates). Basic formatting. Working with multiple Worksheets.

### Section 2: Efficiency of Use

directright

directright

#### Unit 2.2 - Editing

Copying, pasting, inserting and deleting cells, ranges of cells, rows, columns and Worksheets. ‘Special’ pasting – for example to copy just formulas, or just values. Common problems with pasting. The differences between copying and ‘cutting’.  Excel aids to copying – Fill Handle and Flash Fill.

### Section 3: Data Analysis

directright

#### Unit 3.1 - Basic Arithmetic

Perform basic maths calculations in Excel using cell references and arithmetic operators.

directright

#### Unit 3.2 - Sorting and Filtering

Techniques for sorting and filtering data, including controlling the order of precedence in a sort, advanced filters, and an introduction to PivotTables.  Using sorting and filtering to check and ‘clean’ data.

### Section 4: Presentation

directright

#### Unit 4.1 - Setup and Printing

Displaying spreadsheets as pages. Page layout view, page breaks, print area. Printing from multiple Worksheets (and that default will be to print only from active Worksheet). Headers and footers. Adjusting page setup. Printing very large sheets of data.

## Pricing

Pricing is for 12 months access.

*The AUD price shown above is an estimate. Actual charges are based on the current exchange rate from GBP

## Requirements

Software:

• Required: Microsoft Excel
• Suggested: None

Completion Time: 4 hours (average)