Course Details close

Course Details

(inc GST)
$ 385
Sale Price:
(inc GST)
$ 250
Duration:1 day
Level 2
80 Mount St
North Sydney
NSW 2060
Participants:Max 10
Length:9:00 to 16:30
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Excel Intermediate 2013 Course

   (4.79 out of 5)
2854 Excel intermediate student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Duration: 1 day Participants: Max 10
Course Length: 9:00 to 16:30 Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
$ 250

Quick links

Excel Intermediate 2013 Course

Course Overview

The Excel Intermediate course is suited to students who have either attended an Excel Basic course or those who are experienced in working with Excel spreadsheets and have a fairly good understanding of the features and tools of Excel. Students attending this course are generally working with large amounts of data and are required to summarise and manipulate the information quickly. They are looking for tools and/or techniques to speed up their processes to manage and manipulate their work related data utilised within their current workflows. These students are familiar with creating basic formulas and want to implement them more effectively.

As a result of this course students will be able to manage multiple worksheets and workbooks including construction of formulas across worksheets. They will learn how to utilise Excel’s advanced formatting features, manage large amounts of data, sort data, filter data, outline and subtotal their spreadsheets. Competency will also be gained in advanced charting, auditing techniques and greater understanding of constructing formulas.

Course Prerequisites

Microsoft Excel Beginner 2013 or equivalent

Course Inclusions

FREE Course Re-sit

8 months

When you book a public course at Raisng the Bar we offer you a FREE course re-sit for up to 8 months from the scheduled course date.

FREE Email Support

12 months

Free email support for up to 12 months from the scheduled course date.

Small Class Sizes

10 students

All of our courses are capped at a maximum of 10 students to maximise your learning experience.

Classroom Training

All of our courses are face to face, hands on, classroom based training delievered by .

Course Manual

Every student will receive a printed course manual with step by step instructions to use as a reference guide.

Computer Lab

No need to bring your own laptop. Our training courses are conducted in fully equipped computer labs with free Wi-Fi.

Course Certificate

Every student receives a certificate of completion at the end of course to recognise your new skills.

Course Dates

Course Date Price Add Course Qty Status
30-Oct-19 (Wed)$250.00 0
14-Nov-19 (Thu)$385.00 0
21-Nov-19 (Thu)$385.00 0
26-Nov-19 (Tue)$385.00 0
05-Dec-19 (Thu)$385.00 0
10-Dec-19 (Tue)$385.00 0
17-Dec-19 (Tue)$385.00 0
15-Jan-20 (Wed)$385.00 0
21-Jan-20 (Tue)$385.00 0
29-Jan-20 (Wed)$385.00 0
04-Feb-20 (Tue)$385.00 0
13-Feb-20 (Thu)$385.00 0
19-Feb-20 (Wed)$385.00 0
25-Feb-20 (Tue)$385.00 0
03-Mar-20 (Tue)$385.00 0
11-Mar-20 (Wed)$385.00 0
19-Mar-20 (Thu)$385.00 0
24-Mar-20 (Tue)$385.00 0
31-Mar-20 (Tue)$385.00 0
08-Apr-20 (Wed)$385.00 0
16-Apr-20 (Thu)$385.00 0
Training courses on sale now

Courses start
from $250 (inc GST).
Limited seats.
Book today!

Course Outline


Managing Data Across Multiple Worksheets

  • Renaming Worksheets In A Workbook
  • Selecting Adjacent Worksheets
  • Selecting Non-Adjacent Worksheets
  • Simultaneously Enter Data Into Multiple Worksheets
  • Creating And Preparing A Summary Sheet

Creating 3-D Formulas

  • Entering A 3-D Formula Across Worksheets
  • Enter A 3-D Formula Using A Sum Function

Combining Data From Different Worksheets Or Workbooks

  • Consolidating Data In a Worksheet
  • Consolidating Data Across Multiple Workbooks
  • Manage Linked Workbooks
  • Move / Copy Worksheets To Another Workbook


Using Range Names

  • Define A Named Range Quickly
  • Define Multiple Named Ranges Using The Ribbon
  • Pasting A Named Range In A Formula
  • Selecting a Named Range From A List
  • Using The ‘Paste Name’ Dialogue Box


Introducing General Table Rules

Applying The Table Tool

  • Creating A Table
  • Changing The Style Applied To A Table
  • Create Your Own Table Style
  • Showing Or Hiding Table Features
  • Adding The Total Row To A Table
  • Inserting Table Rows
  • Deleting Table Rows
  • Resizing The Table
  • Performing A Simple Sort
  • Sorting By More Than One Column
  • Customising The Default Sort Order
  • Enable And Disable The AutoFilter In A Table
  • Applying A Filter
  • Clearing A Filter
  • Custom Number And Date Filters
  • Use A Search To Filter A Table
  • Removing The Table Tool


  • Setting Up Named Ranges
  • Entering A VLOOKUP Function
  • Using the Insert Function Wizard To Enter A VLOOKUP
  • Use A VLOOKUP Function To Automate Data Entry
  • Use A VLOOKUP Function To Find The Closest Match


  • Creating An Outline Automatically
  • Removing An Outline
  • Outlining Large Worksheets
  • Manually Creating An Outline
  • Copying Outlined Results Using Visible Cells Only
  • Subtotalling A Table And Outlining The Results
  • Managing The Outline Using Outline Levels
  • Removing A Subtotal


Customise The Appearance Of Dates And Numbers Using Advanced Formatting

  • Formatting Numbers Overview
  • Custom Number Format Syntax And Examples
  • Customise The Number Format Using Format Cells
  • Customise The Date Format Using Format Cells

Conditional Formatting

  • Using Conditional Formatting To Highlight Cells
  • Adding Data Bars To A Range
  • Using Colour Scales
  • Rank Data Using Icon Sets
  • Creating A New Rule
  • Edit An Existing Rule
  • Setting The Precedence Of The Rules
  • Stopping A Rule
  • Clearing A Rule

Maintaining Consistency With Styles Or Themes

  • Apply An In-Built Cell Style
  • Create Your Own Cell Style
  • Applying A Custom Cell Style
  • Modifying A Cell Style
  • Deleting A Cell Style
  • Applying A Theme To A Workbook


Creating A Chart

  • Inserting A Chart
  • Changing The Existing Chart Type
  • Manipulating The Chart Data Source
  • Swap Rows/Columns
  • Change The Data Series Order
  • Moving A Chart

Modify A Chart

  • Change A Chart Layout
  • Change The Existing Chart Style
  • Adding And Editing The Chart Title
  • Adding Axis Titles
  • Moving The Legend
  • Adding Data Labels
  • Showing A Data Table
  • Add / Remove Gridlines
  • Inserting A New Chart Element
  • Delete An Existing Chart

Format The Chart

  • Selecting Chart Elements
  • Formatting Chart Elements
  • Using WordArt In A Chart
  • Using Pictures In A Chart
  • Create A Combination Chart
  • Creating A Pie Chart
  • Rotating A 3D Chart Type
  • Exploding A Wedge In A Pie Chart
  • Sparklines in Excel
  • Changing Sparkline Options


Simple Formulas In Excel

  • Entering Formulas Using The Keyboard
  • Manually Entering Formulas
  • Working With Relative References
  • Working With Absolute References
  • Applying Absolute Cell Reference

Using Simple Functions In Excel

  • Entering A Function To Perform A Calculation
  • Using AutoSum To Calculate Row/Column Totals
  • Using the Insert Function Wizard

Student Comments

  • Excel Intermediate Training Course
    Professional training and comprehensive.
    - Dimitra
  • Excel Intermediate training course
    Craig was very informative, our team will benefit from the session. It will bring efficiency to our processes. We would love to book another session in the future.
    - Sharmend
  • Excel Intermediate training course
    All parts are EXTREMELY useful! Great presentation, just to the CORE.
    - Nadiya
  • Excel Intermediate Training Course
    Excellent. Improved understanding, gaps closed, exposed to new areas e.g. Text function.
    - Malachy
  • Excel Intermediate Training Course
    Very very good :-) excellent trainer. Made us laugh on a very dry subject!
    - Helena
  • Excel Intermediate Training Course
    Craig is a fabulous trainer and his knowledge of excel is second to none!
    - Greg
  • Excel Intermediate training course
    Craig was an excellent and professional facilitator who is obviously an expert in this subject. Would love to continue my knowledge with him in the Advanced course.
    - Aaron
  • Excel Intermediate Training Course
    Thank you so much Craig for adapting the day to our skill level.
    - Lindsey
  • Excel Intermediate Training Course
    Excellent course, definitely recommend it.
    - Teena
  • Excel Intermediate Training Course
    Eager to attend the excel advanced 2007 - 2010 re: pivot tables
    - Vicki
  • Excel Intermediate Training Course
    Sean was amazing! He was so passionate about excel and was very personable. He really demonstrated to me how if you do what you love, it really does shine through! Thank you so much :)
    - Rachel
  • Excel Intermediate Training Course
    Libby was an excellent communicator
    - Jackie
  • Excel Intermediate Training Course
    Have had a fantastic two days in training with Nicole
    - Deanna
  • Excel Intermediate Training Course
    Sean was fantastic. Made what could've been a very dry day fun.
    - Yvette
  • Excel Intermediate Training Course
    Excellent facilities and trainer.
    - Denise
  • Excel Intermediate Training Course
    The trainer Libby was very professional. Libby was very easy to understand, clear and easy to approach with questions and help. I would recommend ‘raising the bar’ to any one that requires training
    - Yvette
  • Excel Intermediate training course
    Great content, well delivered. Very interesting.
    - Zak
  • Excel Intermediate Training Course
    I was very impressed and my expectations were exceeded. Sean is a great instructor - the best computing one I have encountered. Thanks for instilling enthusiasm into Excel - I never thought it would be possible!
    - Sophia
  • Excel Intermediate Training Course
    Good level of detail. I feel like an expert is excel now.
    - Felippe
  • Excel Intermediate training course
    Excellent course!
    - Kiri
  • Excel Intermediate Training Course
    I learnt a great deal more about excel from this course and look forward to doing the next stage so I can learn about pivot tables.
    - Sharon
  • Excel Intermediate training course
    Great presenter! Made something I would normally find not so fun, actually fun!
    - Kathryn
  • Excel Intermediate training course
    the course was very helpful and I really enjoyed it
    - Stephanie
  • Excel Intermediate training course
    This was a very useful course that assisted me greatly with my computer skills and I have learnt a great deal that will help me in the future. I feel very prepared now in using excel.
    - Andrew
  • Excel Intermediate Training Course
    Libby was an excellent trainer and I hope to come back soon and attend the advanced course.
    - Montana
  • Excel Intermediate training course
    It was a good course. I feel like it will be useful for professionals and students alike.
    - Kevin
  • Excel Intermediate Training Course
    Very professional and very well presented.
    - Troy
  • Excel Intermediate training course
    I liked the way if I asked a question that wasn`t covered the instructor still went over it and explained it for me, Even if it was in the basic course and I should have already known it.
    - Megan
  • Excel Intermediate training course
    great cousre and great presenter
    - Steve
  • Excel Intermediate training course
    Great, easy to follow, practical & educational.
    - Jeremy

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

1300 937 782 Contact us