Course Details close

Course Details

Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
* Selected Courses ONLY
$ 350*
Application:Excel
Level:Intermediate
Version:365
Duration:1 day
Location:
Online via
Microsoft Teams
Participants:Max 10
Length:9:00 to 16:30
Break Times:
(approx)
10:30 (15mins)
12:30 (1hr)
14:45 (15mins)
Course Dates: View
Course Outline: View

Excel Intermediate Course

   (4.80 out of 5)
3146 Excel intermediate student evaluations
Location: Level 2
80 Mount St
North Sydney
NSW 2060
Break Times:
(approx)
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)
$ 350

Quick links

Excel Intermediate Course

Course Overview

This is a one-day training course tailored to teach current Excel users the intermediate features of Microsoft Excel. Lead by dedicated instructors who know the ins and outs of the Microsoft Office package, you’ll build upon your existing skills and learn valuable techniques to help you create more professional and productive spreadsheets. We’ll teach you how to manage data in multiple workbooks, use 3D formulas, apply range names, create tables and charts, use data outlining, review formulas and work with advanced formatting, style and themes. You’ll learn streamlined methods to develop reports and analyse and manipulate data quicker than you ever thought possible.

Raising the Bar training courses are delivered face-to-face by certified experts using clear, easy to follow instructions. We keep our class sizes small so that all students achieve the best possible learning outcomes and supply all equipment so there’s no need to bring anything. You’ll learn through clear demonstrations and hands-on activities and leave with brand new skills to produce more professional and effective spreadsheets than ever before.

Upon completion of the Excel Intermediate course, you’ll receive a certificate of completion, a comprehensive course manual to work through at your leisure and the proficiency required to proceed to one of our more advanced Excel courses.

Who Should Attend This Course

The Excel Intermediate training course is designed especially for students who want to enhance their existing Excel skills to go beyond creating basic spreadsheets. This course is perfect for those wanting to gain confidence before moving onto expert level tasks and for companies looking to improve efficiency through more advanced spreadsheet management.

Typically, students who attend this course are already familiar with the fundamentals of Excel and know how to create basic spreadsheets and are ready to take these skills to the next level.

This course is right for you if you want to learn how to manage large datasets, summarise data, create and edit complex formulas, apply more intricate formatting, create and present professional looking charts and work more effectively with existing worksheets and workbooks.

Raising the Bar’s public training courses are available throughout the year in our Sydney CBD training centre, or via closed group training sessions for companies and organisations in Sydney, Melbourne, Adelaide, Canberra, Brisbane and Perth.

Course Prerequisites

Our Intermediate course is designed for current Microsoft Excel users, so prior knowledge of Excel is required. Students should have completed our Excel Beginners course or have equivalent skills entering data, creating basic formulas, formatting and printing spreadsheets. You will also need general computer skills using the Windows operating system.

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.

Course Manual

With each course we provide you with a comprehensive online course manual for you to practice post course.

Course Certificate

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

Virtual Classroom Dates (via Microsoft Teams)

Course Date Price Add Course Qty Status
29-Jul-25 (Tue)$350.00 0
ON SALE
20-Aug-25 (Wed)$385.00 0
28-Aug-25 (Thu)$385.00 0
09-Sep-25 (Tue)$385.00 0
24-Sep-25 (Wed)$385.00 0
08-Oct-25 (Wed)$385.00 0
16-Oct-25 (Thu)$385.00 0
28-Oct-25 (Tue)$385.00 0
Training courses on sale now

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

Course Outline

WORKING WITH MULTIPLE WORKSHEETS

Managing Data in Multiple Worksheets

  • Renaming Worksheets
  • Select Adjacent Worksheets
  • Selecting Non-Adjacent Worksheets
  • Enter Data Into Multiple Worksheets
  • Preparing the Summary Sheet

Using A 3-D Formula Across Worksheets

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

NAMED RANGES

Using Range Names

  • Define Names Quickly
  • Define Multiple Name Ranges
  • Insert A Name In A Formula
  • Enter a Named Range From a List
  • Using ‘Paste Name’ in Formulas

WORKING WITH TABLES

General Table Rules

Creating Tables

  • Create A Table
  • Change The Style Of A Table
  • Create A New Table Style
  • Show Or Hide Table Elements
  • Create A Calculation In A Table
  • Insert And Delete A Table Row
  • Resize A Table

Sorting Data

  • Perform A Simple Sort (quick sort)
  • Perform A Multi-Level Sort (more than one column)
  • Customise The Sort Order

Filtering Data

  • Enable / Disable The AutoFilter
  • Apply / Remove The Filter
  • Customise The Filter
  • Using A Search To Create A Filter
  • Convert A Table To A Range

THE VLOOKUP FUNCTION

Using The VLOOKUP Function

  • Range Names
  • Creating The Vlookup Formula
  • Using the Insert Function Wizard to enter the VLOOKUP
  • Using Vlookup Functions To Assist with Data Entry
  • Use The Closest Match For The Lookup Value

OUTLINING DATA

Using Data Outlining

  • Create An Outline Automatically
  • Remove An Outline
  • Auto Outlining on Large Worksheets
  • Create An Outline Manually
  • Copy an Outline Using Visible Cells Only
  • Use A Subtotal To Create An Outline
  • Show / Hide Details Using Outline Symbols
  • Remove a Subtotal

WORKING WITH ADVANCED FORMATTING, STYLES AND THEMES

Customising The Appearance Of Data With Advanced Formatting

  • Use The Built-In Number Formats
  • Custom Number Format Examples
  • Customise The Number Format
  • Customise The Date Format

Using Conditional Formatting

  • Use The Conditional Formatting To Highlight Cells
  • Use The Data Bars
  • Use The Colour Scales
  • Use The Icon Sets
  • Create New Rules
  • Edit Rules
  • Change The Precedence Of The Rules
  • Stop A Rule
  • Clear The Rules

Maintaining Format Consistency With Styles And Themes

  • Apply A Built-in Cell Style
  • Create A Custom Cell Style
  • Apply A Custom Cell Style
  • Modify / Delete A Cell Style
  • Apply A Theme

WORKING WITH CHARTS

Creating A Chart

  • Insert A Chart
  • Move An Embedded Chart
  • Resize An Embedded Chart
  • Change The Chart Type
  • Add, Edit or Remove A Chart Data Source
  • Swap Labels In The Legend With The Horizontal Axis
  • Change The Order Of A Data Series
  • Move An Existing Chart To A New Worksheet

Modifying A Chart

New Features For Modifying A Chart In 2016/2013

  • Change A Chart Layout And Style (2010)
  • Change The Chart Title
  • Change The Axis Titles
  • Change The Legend
  • Insert Data Labels
  • Add A Data Table
  • Adding and Removing Gridlines
  • Insert A New Chart Element
  • Delete A Chart

Formatting A Chart

  • Select A Chart Element
  • Format The Chart Elements
  • Format Text In A Chart Using WordArt
  • Create A Picture Chart
  • Create A Combination Of Chart Types
  • Create A Pie Chart
  • Set The 3D Rotation
  • Explode A Wedge In A Pie Chart
  • Inserting Sparklines
  • Enhancing Sparklines

Student Comments

  • Excel Intermediate training course
    Enjoyed the course. The explanation and pace of the course was really good. Looking forward to attend the advanced course for additional topics including pivot tables.
    - Chiyo
  • Excel Intermediate Training Course
    Great presenter who knew her subject and carried on professionally whilst suffering personal sickness
    - Sue
  • Excel Intermediate training course
    The course covered relevant content and the presenter had a wealth of knowledge. I appreciated his ability to cater the course to our specific needs so that it became practical skills we could literally walk away with and apply to our roles.
    - Bernadette
  • Excel Intermediate training course
    All the staff are immensely friendly and helpful. A great day and learning environment. The computers are great and the course manual is FANTASTIC, it will remain a brilliant reference guide in the future. I`ve already recommended your company on social m
    - Kaila
  • Excel Intermediate training course
    Very thankful for today's class
    - Rose
  • Excel Intermediate training course
    Sean is an excellent Teacher!
    - Fiona
  • Excel Intermediate training course
    Craig is a very good facilitator. He was good at explaining the concept and process of activities.
    - Gabby
  • Excel Intermediate training course
    Great course, really enjoyed it. Thanks!
    - Freya
  • Excel Intermediate training course
    I didn't think i would enjoy this but Craig made it fun and so helpful
    - Rani
  • Excel Intermediate training course
    Very happy that we went with RTB - very professional + efficient. Comms leading up to the course was fantastic. Would definitely utilise you next year. I really liked how Craig would give detail into every click he was making. I also liked that without needing to ask, he would also say things twice (incase you missed it the first time) so first he would go through the steps and then slowly do it all together. This provided ease of learning.
    - Renee
  • Excel Intermediate training course
    Craig presented the content really well and at a very good pace. There was a good balance of presenting and practicing. He was helpful if we were having issues. I really enjoyed the session overall and will come back for the advanced one.
    - Emma
  • Excel Intermediate Training Course
    Fantastic really enjoyed
    - Kate
  • Excel Intermediate training course
    Craig is a great teacher and makes it very simple and easy to understand
    - Sophia
  • Excel Intermediate training course
    Great course and really helpful. Thanks.
    - Scott
  • Excel Intermediate training course
    Thank you so much Craig for the session today. I now know great tricks and am able to work time efficiently
    - Faith
  • Excel Intermediate training course
    Intermediate excel was great. Craig presented very well and was very clear when teaching a certain task. I learned mainly the vlookup and just some of the basic tasks to simplify every day use. I would highly recommend craig, he was patient but also did not drag too long for every task taught.
    - Dyana
  • Excel Intermediate training course
    Craig is an excellent teacher with great patience when working with a number of clients who have a range of abilities. This course has met many of my needs as I was not sure if I was to be in the intermediate or beginners course. Definitely recommend this
    - Caroline
  • Excel Intermediate training course
    Great course, I really enjoyed it.
    - Suzi
  • Excel Intermediate Training Course
    Was presented very professionally and thorough. Course presenter was very clear and concise and very knowledgeable.
    - Houda
  • Excel Intermediate training course
    Very impressed and would like to get next level training.
    - Aman
  • Excel Intermediate training course
    Craig is great! Was far more informative than another Excel training course I had attended. I feel well versed to give Vlookups a go in my spreadsheets now.
    - Lachlan
  • Excel Intermediate training course
    Have provided me with a lot of knowledge that I can apply to my job so for that I am extremely pleased that I attended the course.
    - Nicole
  • Excel Intermediate Training Course
    Fabulous course and excellent presenter
    - Amanda
  • Excel Intermediate training course
    Craig was a great trainer and super helpful and responsive to any questions. He explained everything very clearly and it was easy to follow.
    - Sarina
  • Excel Intermediate training course
    Facilitator was great and has a vast knowledge.
    - Adrian
  • Excel Intermediate training course
    Very well presented. Great facilitator
    - Jordan
  • Excel Intermediate training course
    The course materials have the right amount of relevant contents.
    - Thanh
  • Excel Intermediate training course
    Great course!
    - Heidi
  • 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
    Had a great day, didn't drag on and was thoroughly enjoyable and simple to follow. Insight was fantastic and though some was only refreshing what I knew, it was good to learn more about how the shortcuts work!
    - Timothy

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us