BlackFriday-Left

Extended Black Friday Sale

Pay Upfront and Save with
Coupon Code: BLACKFRIDAY15

Ends 7 December 2022

Day
Hour
Minute
Second
BlackFriday-Right

Microsoft Excel Intermediate

Online Course for Excel Users

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

Enhance your day-to-day use of Excel

Our Microsoft Excel Intermediate training course is designed for users familiar with Excel basics and who want to really improve their productivity and get more out of their spreadsheets.

Use detailed functions, complex formulas and tools like Goal Seek to quickly adjust your results in Excel.

Excel laptop
  • Online Learning

  • 6 CPD hours per course

  • Certificate of completion

  • Instant access, start NOW!

Excel Intermediate Online Learning

148-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 Intermediate Course Details

The skills and knowledge acquired in Microsoft Excel 365 - Level 2 (with Challenge Exercises) enable users to expand their knowledge and learn how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.

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

  • use the fill operations available to fill a data series
  • use a range of techniques to work with worksheets
  • apply a variety of page setup techniques
  • apply borders to cells and ranges in a worksheet
  • use common worksheet functions
  • create more complex formulas and functions
  • create and use defined names in a workbook
  • apply a range of number formatting techniques to worksheet cells
  • apply conditional formatting to ranges in a worksheet
  • use goal seeking to determine the values required to reach a desired result
  • understand and use Excel's Quick Analysis tools
  • create and work with tables
  • use a range of elements and features to enhance charts
  • select and change the format of objects in a chart

Microsoft Excel 365 - Level 2 (with Challenge Exercises) assumes the learner has the knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and copying is also important.

Filling Data

  • Understanding Filling
  • Filling a Series
  • Filling a Growth Series
  • Filling a Series Backwards
  • Filling Using Options
  • Creating a Custom Fill List
  • Modifying a Custom Fill List
  • Deleting a Custom Fill List
  • Extracting With Flash Fill
  • More Complex Flash Fill Extractions
  • Extracting Dates and Numbers
  • Challenge Exercise
  • Challenge Exercise Data

Worksheet Techniques

  • Inserting and Deleting Worksheets
  • Copying a Worksheet
  • Renaming a Worksheet
  • Moving a Worksheet
  • Hiding a Worksheet
  • Unhiding a Worksheet
  • Copying a Sheet to Another Workbook
  • Changing Worksheet Tab Colours
  • Grouping Worksheets
  • Hiding Rows and Columns
  • Unhiding Rows and Columns
  • Freezing Rows and Columns
  • Splitting Windows
  • Challenge Exercise
  • Challenge Exercise Sample

Page Setup

  • Strategies for Printing Worksheets
  • Understanding Page Layout
  • Using Built in Margins
  • Setting Custom Margins
  • Changing Margins by Dragging
  • Centring on a Page
  • Changing Orientation
  • Specifying the Paper Size
  • Setting the Print Area
  • Clearing the Print Area
  • Inserting Page Breaks
  • Using Page Break Preview
  • Removing Page Breaks
  • Setting a Background
  • Clearing the Background
  • Settings Rows as Repeating Print Titles
  • Clearing Print Titles
  • Printing Gridlines
  • Printing Headings
  • Scaling to a Percentage
  • Fit to a Specific Number of Pages
  • Challenge Exercise
  • Challenge Exercise Sample

Applying Borders

  • Understanding Borders
  • Applying a Border to a Cell
  • Applying a Border to a Range
  • Applying a Bottom Border
  • Applying Top and Bottom Borders
  • Removing Borders
  • The More Borders Command
  • Using the More Borders Command
  • Drawing Borders
  • Drawing a Border Grid
  • Erasing Borders
  • Formatting the Drawing Pencil
  • Challenge Exercise
  • Challenge Exercise Sample

Essential Functions

  • Key Worksheet Functions
  • Using IF With Text
  • Using IF With Numbers
  • Nesting IF Functions
  • The CHOOSE Function
  • The LOOKUP Function
  • Using Counting Functions
  • The ROUND Function
  • Rounding Up and Rounding Down
  • Manipulative Functions
  • The MOD Function
  • The TODAY Function
  • The NOW Function
  • The DATE Function
  • The PMT Function
  • Challenge Exercise
  • Challenge Exercise Sample

Complex Formulas

  • Scoping a Formula
  • Long-Hand Formulas
  • Preparing for Complex Formulas
  • Creating the Base Formula
  • Adding More Operations
  • Editing a Complex Formula
  • Adding More Complexity
  • Copying Nested Functions
  • Switching to Manual Recalculation
  • Pasting Values From Formulas
  • Documenting Formulas
  • Challenge Exercise
  • Challenge Exercise Sample

Defined Names

  • Understanding Defined Names
  • Defining Names From Worksheet Labels
  • Using Names in Typed Formulas
  • Applying Names to Existing Formulas
  • Creating Names Using the Name Box
  • Using Names to Select Ranges
  • Pasting Defined Names Into Formulas
  • Defining Names for Constant Values
  • Creating Names From a Selection
  • Scoping Names to a Worksheet
  • Using the Name Manager
  • Documenting Defined Names
  • Challenge Exercise
  • Challenge Exercise Sample

Number Formatting Techniques

  • Applying Alternate Currencies
  • Applying Alternate Date Formats
  • Formatting Clock Time
  • Formatting Calculated Time
  • Understanding Number Formatting
  • Understanding Format Codes
  • Creating Descriptive Custom Formats
  • Custom Formatting Large Numbers
  • Custom Formatting for Fractions
  • Padding Numbers Using Custom Formatting
  • Aligning Numbers Using Custom Formats
  • Customising the Display of Negative Values
  • Challenge Exercise
  • Challenge Exercise Sample

Conditional Formatting

  • Understanding Conditional Formatting
  • Formatting Cells Containing Values
  • Clearing Conditional Formatting
  • More Cell Formatting Options
  • Top Ten Items
  • More Top and Bottom Formatting Options
  • Working With Data Bars
  • Working With Colour Scales
  • Working With Icon Sets
  • Understanding Sparklines
  • Creating Sparklines
  • Editing Sparklines
  • Challenge Exercise
  • Challenge Exercise Sample

Goal Seeking

  • Understanding Goal Seeking
  • Using Goal Seek
  • Challenge Exercise
  • Challenge Exercise Sample

The Quick Analysis Tools

  • Understanding Quick Analysis
  • Quick Formatting
  • Quick Charting
  • Quick Totals
  • Quick Sparklines
  • Quick Tables
  • Challenge Exercise
  • Challenge Exercise Sample

Worksheet Tables

  • Understanding Tables
  • Creating a Table From Scratch
  • Working With Table Styles
  • Inserting Table Columns
  • Removing Table Columns
  • Converting a Table to a Range
  • Creating a Table From Data
  • Inserting or Deleting Table Records
  • Removing Duplicates
  • Sorting Tables
  • Filtering Tables
  • Renaming a Table
  • Splitting a Table
  • Deleting a Table
  • Challenge Exercise
  • Challenge Exercise Workspace

Chart Elements

  • Understanding Chart Elements
  • Adding a Chart Title
  • Adding Axes Titles
  • Repositioning the Legend
  • Showing Data Labels
  • Showing Gridlines
  • Formatting the Chart Area
  • Adding a Trendline
  • Adding Error Bars
  • Adding a Data Table
  • Challenge Exercise
  • Challenge Exercise Sample

Chart Object Formatting

  • Understanding Chart Formatting
  • Selecting Chart Objects
  • Using Shape Styles
  • Changing Column Colour Schemes
  • Changing the Colour of a Series
  • Changing Line Chart Colours
  • Using Shape Effects
  • Colouring the Chart Background
  • Understanding the Format Pane
  • Using the Format Pane
  • Exploding Pie Slices
  • Changing Individual Bar Colours
  • Formatting Text
  • Formatting With WordArt
  • Changing WordArt Fill
  • Changing WordArt Effects
  • Challenge Exercise

Challenge Exercise Sample

  • 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