Course Details close

Course Details

Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
* Selected Courses ONLY
$ 250*
Application:Excel
Level:Intermediate
Version:2013
Duration:1 day
Location:
ITIC Live
Level 3
321 Pitt St
Sydney NSW 2000
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 2013 Course

   (4.79 out of 5)
2872 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)
$ 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

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

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.

Public Course Dates

Course Date Price Add Course Qty Status
25-Aug-22 (Thu)$250.00 0
ON SALE
07-Sep-22 (Wed)$385.00 0
20-Sep-22 (Tue)$385.00 0
11-Oct-22 (Tue)$385.00 0
26-Oct-22 (Wed)$385.00 0

Virtual Course Dates (via Zoom)

Course Date Price Add Course Qty Status

There are currently no virtual course dates scheduled for this course.

Call us today to discuss - 1300 937 782.

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

Course Outline

MANAGING MULTIPLE WORKSHEETS AND WORKBOOKS

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

NAMED RANGES

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

WORKING WITH EXCEL TABLES

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

THE VLOOKUP FUNCTION

  • 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

OUTLINING DATA

  • 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

ADVANCED FORMATTING, STYLES AND THEMES

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

CHARTS

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

REVIEWING FORMULAS - Appendix

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
    The formatting of charts section went a bit long. Our trainer was absolutely excellent - energetic, encouraging, clear and concise - one of the best I’ve come across. A real asset to the organisation. I'll be recommending people based a lot on her
    - Caitlin
  • Excel Intermediate training course
    Course content and trainer Sean was very helpful.
    - Jason
  • Excel Intermediate training course
    the instructor is well-prepared. I love his attitude and willing-to-help.
    - Ronald
  • Excel Intermediate training course
    Best on line course I've done using applications. Found the book valuable for the future
    - Henk
  • Excel Intermediate training course
    Craig was great, very easy to understand
    - Indiarna
  • Excel Intermediate training course
    Great course. I highly recommend
    - Melinda
  • Excel Intermediate training course
    Craig is an incredibly knowledgeable instructor. I have had people try to explain excel to me before but clearly did not have the expert level of knowledge that Craig has. Craig has an ability to explain excel concepts in a clear and easy to understand way which a real expert would be able to do. I like the use of concepts-chunks - it is a proven way for memory retention and creates new schemas in people who are learning something for the first time or building on existing knowledge. I like the fact that he explains mechanically how excel actually works as a database which made it a lot easier for me to visualise and conceptualise. I want to practice and eventually attend the advanced course. I also like that there was no exam which took away any stress associated with learning the content.
    - Casey
  • Excel Intermediate training course
    The day was very enjoyable!
    - Catherine
  • Excel Intermediate Training Course
    Great course, great trainer and I learnt a lot more about excel and have a better understanding. Thoroughly enjoying every topics.
    - Maria
  • Excel Intermediate Training Course
    I thought the course was a good refresher for the advanced course
    - Scott
  • Excel Intermediate training course
    Thanks Mark and Raising the Bar, really enjoyable training session.
    - Jasmine
  • Excel Intermediate training course
    Awesome training very thorough and easy to follow.
    - Filip
  • Excel Intermediate training course
    All the course was relevant and practical. Very useful my day-to-day excel use. Great course - thanks Craig!
    - Daniel
  • Excel Intermediate Training Course
    Craig was organised, easy to understand and knew how to answer every question that he got. Thanks Craig.
    - Eileen
  • Excel Intermediate training course
    omg! this is gold!
    - James
  • Excel Intermediate training course
    It was well presented, useful and something that I can take into my career. Loved it.
    - Sarah
  • Excel Intermediate Training Course
    Fantastic really enjoyed
    - Kate
  • Excel Intermediate training course
    Very Useful and easy to understand. The course was properly designed and in a correct flow and manner. Strongly recommended
    - Pradeep
  • Excel Intermediate training course
    This was a great course, will definitely recommend to anyone in my work place that needs a excel course.
    - Hong
  • Excel Intermediate training course
    Very enjoyable, glad I did it.
    - Simon
  • Excel Intermediate training course
    Love the course very useful
    - Michelle
  • Excel Intermediate training course
    Presenter was friendly and interactive
    - Emma
  • Excel Intermediate training course
    The course was extremely useful and very clearly run. Was great to learn about multiple excel functions in depth, and also learn great tips along the way.
    - Lewis
  • Excel Intermediate training course
    Very well run and learning friendly
    - Fong
  • Excel Intermediate training course
    Craig was very helpful and knowledgeable good course lots of practise opportunities thank you
    - Merrilyn
  • Excel Intermediate training course
    Facilitator was awesome very engaging and clear. Super easy to deal with whole RTB team and would definitely use again for future training courses.
    - Lou
  • Excel Intermediate training course
    really useful refresher & more efficient ways of performing excel functions
    - Jennifer
  • Excel Intermediate training course
    Craig is fantastic teacher, patient, efficient, easy to understand, explains everything in simple steps
    - Gillian
  • 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 useful information. Very enjoyable
    - Lyn

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us