Courses in Accounting and Bookkeeping | Applied Education

Microsoft Excel Intermediate Course

Classroom or Online Learning

Trustpilot

Enhance your day-to-day use of Excel

Use detailed functions and complex formulas to enhance your spreadsheets with our hands-on classroom course or online Excel Intermediate course.

Designed for users familiar with Excel basics who want to improve their productivity and get more out of their spreadsheets.

View Full Course Outline

Training manual and comprehensive resources included with Microsoft Excel course

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 Intermediate 2016 course manual
- Handy Tips guide (key tips and tricks for using Excel 2016)
- Quick Reference Guide
- Exercise Files to practise with

Study Options

Online Learning

Start any time and study at your own pace

$99

Affordable and convenient

Log in at any time to access the course material, so you can study the course at a time that fits in with your lifestyle or other commitments.

Instructor-demonstrated video tutorials.

Electronic manual included, plus 12 months unlimited access to course material.

Follow along with the sample exercises provided.

6 CPD hours per course

Classroom Workshop (Perth)

Hands-on classroom training in the Perth CBD

$339

Hands-on classroom environment led by an expert trainer

Full-day workshop with refreshments and lunch included

All resources and computers provided

Talk to the course trainer, ask questions and receive handy tips to aid with your use of Excel.

12 months access to electronic materials after completion of the class

6 CPD hours per course

Get the Course Guide

Excel Intermediate - Online 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:

134-part course

Microsoft Excel 2016 Intermediate Online Training is a convenient, effective and affordable way to learn. You can complete the online training at your own pace and 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.

Learning Outcomes Chapters 1 to 7 - Click to View

Chapter 1

  • Chapter 1-1 Filling Data
  • Chapter 1-2 Filling A Growth Series
  • Chapter 1-3 Filling A Series Backwards
  • Chapter 1-4 Filling Using Options
  • Chapter 1-5 Creating A Custom Fill List
  • Chapter 1-6 Modifying A Custom Fill List
  • Chapter 1-7 Deleting A Custom Fill List
  • Chapter 1-8 Extracting With Flash Fill
  • Chapter 1-9 More Complex Flash Fill Extractions
  • Chapter 1-10 Extracting Dates And Numbers

Chapter 2

  • Chapter 2-1 Using IF With Text
  • Chapter 2-2 Using IF With Numbers
  • Chapter 2-3 Nesting IF Functions
  • Chapter 2-4 The CHOOSE Function
  • Chapter 2-5 The LOOKUP Function
  • Chapter 2-6 Using Counting Functions
  • Chapter 2-7 The Round Function
  • Chapter 2-8 Rounding Up And Rounding Down
  • Chapter 2-9 Manipulative Functions
  • Chapter 2-10 The MOD Function
  • Chapter 2-11 The TODAY Function
  • Chapter 2-12 The NOW Function
  • Chapter 2-13 The DATE Function
  • Chapter 2-14 The PMT Function

Chapter 3

  • Chapter 3-1 Scoping A Formula
  •  Chapter 3-2 Preparing For Complex Formulas
  •  Chapter 3-3 Creating The Base Formula
  •  Chapter 3-4 Adding More Operations
  •  Chapter 3-5 Editing A Complex Formula
  •  Chapter 3-6 Adding More Complexity
  •  Chapter 3-7 Copying Nested Functions
  •  Chapter 3-8 Switching To Manual Recalculation
  •  Chapter 3-9 Pasting Values From Formulas
  •  Chapter 3-10 Documenting Formulas

Chapter 4

  • Chapter 4-1 Understanding Defined Names
  •  Chapter 4-2 Defining Names From Worksheet Labels
  •  Chapter 4-3 Using Names in Typed Formulas
  •  Chapter 4-4 Applying Names To Existing Formulas
  •  Chapter 4-5 Creating Names Using The Name Box
  •  Chapter 4-6 Using Names To Select Ranges
  •  Chapter 4-7 Pasting Defined Names Into Formulas
  •  Chapter 4-8 Defining Names For Constant Values
  •  Chapter 4-9 Creating Names From A Selection
  •  Chapter 4-10 Scoping Names To A Worksheet
  •  Chapter 4-11 Using The Name Manager
  •  Chapter 4-12 Documenting Defined Names

Chapter 5

  • Chapter 5-1 Using Goal Seek

Chapter 6

  • Chapter 6-1 Inserting And Deleting Worksheets
  • Chapter 6-2 Copying A Worksheet
  • Chapter 6-3 Renaming A Worksheet
  • Chapter 6-4 Moving A Worksheet
  • Chapter 6-5 Hiding And Unhiding A Worksheet
  • Chapter 6-7 Changing Worksheet Tab Colours
  • Chapter 6-8 Grouping Worksheets
  • Chapter 6-9 Hiding and Unhiding Rows And Columns
  • Chapter 6-10 Freezing Rows And Columns
  • Chapter 6-11 Splitting Windows

Chapter 7

  • Chapter 7-1 Using Margins
  • Chapter 7-2 Centring
  • Chapter 7-3 Changing Orientation
  • Chapter 7-4 Specifying The Paper Size
  • Chapter 7-5 Setting The Print Area
  • Chapter 7-6 Inserting Page Breaks
  • Chapter 7-7 Setting And Clearing The Background
  • Chapter 7-8 Setting Rows As Repeating Print Titles
  • Chapter 7-9 Printing Gridlines and Headings
  • Chapter 7-10 Scaling To A Percentage
Learning Outcomes Chapters 8 to 14 - Click to View

Chapter 8

  • Chapter 8-1 Applying A Border To A Cell
  • Chapter 8-2 Applying A Border To A Range
  • Chapter 8-3 Applying A Bottom and Top And Bottom Border
  • Chapter 8-4 Removing Borders
  • Chapter 8-5 The More Borders Command
  • Chapter 8-7 Erasing Borders
  • Chapter 8-8 Formatting The Drawing Pencil

Chapter 9

  • Chapter 9-1 Applying Alternate Currencies
  • Chapter 9-2 Applying Alternate Date Formats
  • Chapter 9-3 Formatting Clock Time
  • Chapter 9-4 Formatting Calculated Time
  • Chapter 9-5 Creating Descriptive Custom Formats
  • Chapter 9-6 Custom Formatting Large Numbers
  • Chapter 9-7 Custom Formatting For Fractions
  • Chapter 9-8 Padding numbers Using Custom Formatting
  • Chapter 9-9 Aligning Numbers Using Custom Format
  • Chapter 9-10 Customising The Display Of Negative Values

Chapter 10

  • Chapter 10-1 Formatting Cells Containing Values
  • Chapter 10-2 Clearing Conditional Formatting
  • Chapter 10-3 More Cell Formatting Options
  • Chapter 10-4 Top Ten Items
  • Chapter 10-5 More Top And Bottom Formatting Options
  • Chapter 10-6 Working With Data Bars
  • Chapter 10-7 Working With Colour Scales
  • Chapter 10-8 Working With Icon Sets
  • Chapter 10-9 Creating Sparklines
  • Chapter 10-10 Editing Sparklines

Chapter 11

  • Chapter 11-1 Quick Formatting
  •  Chapter 11-2 Quick Charting
  •  Chapter 11-3 Quick Totals
  •  Chapter 11-4 Quick Sparklines
  •  Chapter 11-5 Quick Tables

Chapter 12

  • Chapter 12-1 Creating A Table From Scratch
  • Chapter 12-2 Working With Table Styles
  • Chapter 12-3 Inserting And Deleting Table Columns
  • Chapter 12-4 Converting A Table To A Range
  • Chapter 12-5 Creating A Table From Data
  • Chapter 12-6 Inserting Or Deleting Table Records
  • Chapter 12-7 Removing Duplicates
  • Chapter 12-8 Sorting Tables
  • Chapter 12-9 Filtering Tables
  • Chapter 12-10 Renaming A Table
  • Chapter 12-11 Splitting A Table
  • Chapter 12-12 Deleting A Table

Chapter 13

  • Chapter 13-1 Adding A Chart Title
  • Chapter 13-2 Adding Axes Titles
  • Chapter 13-3 Repositioning The Legend
  • Chapter 13-4 Showing Data Labels
  • Chapter 13-5 Showing Gridlines
  • Chapter 13-6 Formatting The Chart Area
  • Chapter 13-7 Adding A Trendline
  • Chapter 13-8 Adding Error Bars
  • Chapter 13-9 Adding A Data Table
  • Chapter 13-9 Adding A Data Table

Chapter 14

  • Chapter 14-1 Selecting Chart Objects
  • Chapter 14-2 Using Shape Styles
  • Chapter 14-4 Changing The Colour Of A Series
  • Chapter 14-5 Changing Line Chart Colours
  • Chapter 14-6 Using Shape Effects
  • Chapter 14-7 Colouring The Chart Background
  • Chapter 14-8 Using The Format Pane
  • Chapter 14-9 Exploding Pie Slices
  • Chapter 14-11 Formatting Text
  • Chapter 14-12 Formatting With WordArt
  • Chapter 14-13 Changing WordArt Fill
  • Chapter 14-14 Changing WordArt Effects

Instant Access to Online Learning -
Sign Up & Start Now

$99

Enrol & Start Now

Complete Online Course Bundle
All 10 Courses $495 - RRP $1090

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

Read More

Excel Intermediate - Classroom Workshop

Hands-on classroom training in the Perth CBD

The Microsoft Excel Intermediate course in Perth is designed to give basic Excel users the skills to get the most out of their spreadsheets.

Learn the tools of Excel in a hands-on environment where you can interact in real time with the course instructor. Ask questions, receive handy tips and see real examples to enhance your day-to-day use of the software.

Classroom students are given access to reference the electronic course materials for 12 months after attending the class.

1-day intensive workshop

Location: Level 1, 524 Hay St, Perth WA 6000

Duration: 9am-4pm (1 day)

$339

View Dates & Enrol

Customised Group Training - Perth

Custom Group Training is available in Perth for Microsoft Excel 2010, 2013 or 2016.

  • Customised 1-day group session for 5 or more attendees
  • Complete a pre-course questionnaire and needs analysis for us to ascertain your group's specific training requirements
  • We can come to you, onsite with up to 12 laptops and projector
  • Alternatively use our computer training room venue in the Perth CBD
  • Group booking minimum 5 attendees up to a maximum of 12 students
  • Electronic manual and resources included for each attendee (hard copies additional)

Please email us for comprehensive details and a proposal on how we can make your next corporate training event a success.

Get the Course Guide
Trustpilot