150px Floral-02

SPRING SALE

Pay Upfront and Save 15% - Use Coupon Code: SPRING22

Ends 30 September 2022

Day
Hour
Minute
Second
150px Floral-01

Microsoft Excel Introductory

Online Course for Excel Beginners

Duration 12 Months Access
Start Date Anytime - Instant Access
Delivery Online Course
Version 365 or 2016

Understanding Excel from the basics

Our Microsoft Excel Introductory course is designed to give the new spreadsheet user the skills to start using Excel in the workplace. From using simple formulas such as the SUM function to formatting data and the basics of spreadsheets.

The course covers topics such as creating a workbook, functions, filtering data, charting and more.

Excel laptop
  • Online Learning

  • 6 CPD hours per course

  • Certificate of completion

  • Instant access, start NOW!

Excel Introductory Online Learning

135-part
course

Microsoft 365 or 2016 Version

Pdf manual and resources

Follow along with the sample exercises provided

Instant Access to Course

$99

Complete Excel 3 Course Bundle

Excel Introductory, Intermediate and Advanced

3 Course Bundle - Get both 365 & 2016 versions

Pdf manual and resources

18 CPD hours

Instant access to course

$195

Complete Microsoft 10 Course Bundle

The Ultimate Microsoft Office Course Bundle

55% Saving off RRP of $1090

Over 50 hours on-demand tutorials

Detailed training manuals e-book

Excel, Word, PowerPoint, Project, Access & Outlook

$495

Excel Introductory Course Details

This is a beginner’s course and aims to give the new spreadsheet user a thorough grounding in the basics of creating and working with spreadsheets using Microsoft Excel. Particular emphasis is placed on developing accurate and well-designed spreadsheets employing sound design and documentation principles.

At the completion of this course you should be able to:

  • navigate your way around Microsoft Excel 365
  • create and work with a new workbook
  • open and navigate within workbooks and worksheets
  • make changes to data in a workbook
  • understand and work with ranges in a worksheet
  • copy and paste data in Excel
  • use the fill operations available to fill a data series
  • move the contents of cells and ranges within and between workbooks
  • understand, create and work with formulas and functions
  • understand and use formula cell referencing
  • use font formatting techniques
  • align the contents of cells in a number of ways
  • understand and use the number formatting features in Excel
  • format rows and columns in a worksheet
  • work with elements that make up the structure of a worksheet
  • sort data in a list in a worksheet
  • filter data in a table
  • print your workbook data
  • create effective charts in Microsoft Excel
  • obtain help for Excel whenever you need it

This course assumes little or no knowledge of spreadsheets or Microsoft Excel. However, it would be beneficial to have a general understanding of personal computers and the operating system environment, especially in regard to working with files and folders.

Getting to Know Excel 365

  • Starting Excel From the Desktop
  • Understanding the Excel Start Screen
  • The Excel Workbook Screen
  • How Excel 365 Works
  • Using the Ribbon
  • Showing and Collapsing the Ribbon
  • Understanding the Backstage View
  • Accessing the Backstage View
  • Using Shortcut Menus
  • Understanding Dialog Boxes
  • Launching Dialog Boxes
  • Understanding the Quick Access Toolbar
  • Adding Commands to the QAT
  • Understanding the Status Bar
  • Exiting Safely From Excel

Creating a New Workbook

  • Understanding Workbooks
  • Using the Blank Workbook Template
  • Typing Text
  • Typing Numbers
  • Typing Dates
  • Typing Formulas
  • Easy Formulas
  • Saving a New Workbook on Your Computer
  • Checking the Spelling
  • Making Basic Changes
  • Safely Closing a Workbook
  • Challenge Exercise
  • Challenge Exercise Sample

Working With Workbooks

  • Opening an Existing Workbook
  • Navigating a Workbook
  • Navigating Using the Keyboard
  • Using Go To
  • Recent Files and Folders
  • Challenge Exercise
  • Challenge Exercise Sample

Editing in a Workbook

  • Understanding Data Editing
  • Overwriting Cell Contents
  • Editing Longer Cells
  • Editing Formulas
  • Clearing Cells
  • Deleting Data
  • Using Undo and Redo
  • Challenge Exercise
  • Challenge Exercise Sample

Selecting Ranges

  • Understanding Cells and Ranges
  • Selecting Contiguous Ranges
  • Selecting Non Contiguous Ranges
  • Selecting Larger Ranges
  • Selecting Rows
  • Selecting Columns
  • Challenge Exercise
  • Challenge Exercise Sample

Copying Data

  • Understanding Copying in Excel
  • Using Fill for Quick Copying
  • Copying From One Cell to Another
  • Copying From One Cell to a Range
  • Copying From One Range to Another
  • Challenge Exercise
  • Challenge Exercise Sample

Filling Data

  • Understanding Filling
  • Filling a Series
  • Filling a Growth Series
  • Extracting With Flash Fill
  • Challenge Exercise
  • Challenge Exercise Data

Moving Data

  • Understanding Moving in Excel
  • Moving Cells and Ranges
  • Moving by Dragging
  • Challenge Exercise
  • Challenge Exercise Sample

Formulas and Functions

  • Understanding Formulas
  • Creating Formulas That Add
  • Creating Formulas That Subtract
  • Formulas That Multiply and Divide
  • Understanding Functions
  • Using the SUM Function to Add
  • Summing Non-Contiguous Ranges
  • Calculating an Average
  • Finding a Maximum Value
  • Finding a Minimum Value
  • Creating More Complex Formulas
  • What if Formulas
  • Common Error Messages
  • Challenge Exercise
  • Challenge Exercise Sample

Formula Referencing

  • Absolute Versus Relative Referencing
  • Relative Formulas
  • Problems With Relative Formulas
  • Creating Absolute References
  • Creating Mixed References
  • Challenge Exercise
  • Challenge Exercise Sample

Font Formatting

  • Understanding Font Formatting
  • Working With Live Preview
  • Changing Fonts
  • Changing Font Size
  • Growing and Shrinking Fonts
  • Making Cells Bold
  • Italicising Text
  • Underlining Text
  • Changing Font Colours
  • Changing Background Colours
  • Using the Format Painter
  • Challenge Exercise
  • Challenge Exercise Sample

Cell Alignment

  • Understanding Cell Alignment
  • Horizontal Cell Alignment
  • Vertical Cell Alignment
  • Indenting Cells
  • Challenge Exercise
  • Challenge Exercise Sample

Number Formatting

  • Understanding Number Formatting
  • Applying General Formatting
  • Formatting for Money
  • Formatting Percentages
  • Formatting as Fractions
  • Formatting as Dates
  • Using the Thousands Separator
  • Increasing and Decreasing Decimals
  • Challenge Exercise
  • Challenge Exercise Sample

Row and Column Formatting

  • Approximating Column Widths
  • Setting Precise Columns Widths
  • Setting the Default Column Width
  • Approximating Row Height
  • Setting Precise Row Heights
  • Challenge Exercise
  • Challenge Exercise Sample

Working With a Worksheet

  • Understanding Worksheets
  • Changing the Worksheet View
  • Worksheet Zooming
  • Viewing the Formula Bar
  • Viewing Worksheet Gridlines
  • Inserting Cells Into a Worksheet
  • Deleting Cells From a Worksheet
  • Inserting Columns Into a Worksheet
  • Inserting Rows Into a Worksheet
  • Deleting Rows and Columns
  • Working With Multiple Worksheets
  • Worksheet Wisdom
  • Challenge Exercise
  • Challenge Exercise Sample

Sorting Data

  • Understanding Lists
  • Performing an Alphabetical Sort
  • Performing a Numerical Sort
  • Sorting on More Than One Column
  • Challenge Exercise
  • Challenge Exercise Sample

Filtering Data

  • Understanding Filtering
  • Applying and Using a Filter
  • Clearing a Filter
  • Creating Compound Filters
  • Multiple Value Filters
  • Creating Custom Filters
  • Using Wildcards
  • Challenge Exercise
  • Challenge Exercise Sample

Printing

  • Understanding Printing
  • Previewing Before You Print
  • Selecting a Printer
  • Printing a Range
  • Printing an Entire Workbook
  • Specifying the Number of Copies
  • The Print Options
  • Challenge Exercise
  • Challenge Exercise Sample

Creating Charts

  • Understanding the Charting Process
  • Choosing the Right Chart
  • Using a Recommended Chart
  • Creating a New Chart From Scratch
  • Working With an Embedded Chart
  • Resizing a Chart
  • Repositioning a Chart
  • Printing an Embedded Chart
  • Creating a Chart Sheet
  • Changing the Chart Type
  • Changing the Chart Layout
  • Changing the Chart Style
  • Printing a Chart Sheet
  • Embedding a Chart Into a Worksheet
  • Deleting a Chart
  • Challenge Exercise
  • Challenge Exercise Sample

Getting Help

  • Understanding How Help Works
  • Using Tell Me
  • Accessing the Help Window
  • Navigating the Help Window
  • Using Google to Get Help
  • Printing a Help Topic
  • Other Sources of Assistance
  • Challenge Exercise

Challenge Exercise Workspace

  • Digital Certificate of Completion
  • 6 Hours CPD
  • Short online assessment to test your knowledge is included on the Student Learning platform.
  • Certificate of Completion is available after the online quiz as a printable PDF and includes a QR code to verify authenticity.

Applied-Education-Digital-Certificate
Certificate shown are for illustration purpose only.

Most students complete the online course in around 6 hours. You will have 12 months access to the tutorials. Study online at a pace that suits your personal situation.

  • Online access to learning tutorials
  • Course presentation videos
  • Electronic pdf learner guide
  • Activity sheets and calculation templates

The course content is accessed via our online student portal with additional learning materials also available. Please note due to copyright the digital training manuals cannot be printed. Hard copies can be ordered when enrolling in your course.

Instructor-demonstrated video tutorials

Pause, rewind and re-watch as many times as you need to assist in understanding the course material. Here's some sample videos:

Training manual and comprehensive resources included with Microsoft Excel course

Microsoft Excel 365 Introductory Online Training is a convenient, effective and affordable way to learn. You can complete the Microsoft Excel Introductory Online Training at your own pace and at your own leisure. Whether you’re a beginner, an experienced user, or somewhere in between, you’ll find valuable knowledge that can be accessed again and again at a time and pace that suits you.

The course includes online learning materials that can be accessed again and again. Packed full of high-quality content, step-by-step instructions with plenty of visuals and practice exercises, the course materials offer exceptional value to the participant, including:

  • Microsoft Excel Advanced course manual
  • Handy Tips guide (key tips and tricks for using Excel)
  • Quick Reference Guide
  • Exercise Files to practise with

Complete Microsoft Online Course Bundle - 10 Courses

55% Saving off RRP of $1090
Over 50 hours on-demand tutorials
Detailed training manuals e-book
Access anytime
Certificates of completion

All our Microsoft Online Learning - Excel, Word, PowerPoint, Project, Access & Outlook

Scroll to Top