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
  • Printing spreadsheets

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

Unit 2.1 - Keyboard Shortcuts

Selection and navigation. Moving around a spreadsheet efficiently. 

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)