Course Details close

Course Details

Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
$ 250
Application:Excel
Level:Advanced
Version:2013
Duration:1 day
Location:
Level 2
80 Mount St
North Sydney
NSW 2060
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 Advanced 2013 Course

   (4.80 out of 5)
1479 Excel advanced 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 Advanced 2013 Course

Course Overview

The Excel Advanced course assumes that students are confidently working within the Excel environment and wish to delve into the more technical and intricate aspects of using Excel’s available tool set. This course will expose students to a deeper level of understanding when constructing and building formulas. Students wishing to attend this course will typically use Excel on a day to day basis to evaluate, extract and analyse results and may also desire techniques to streamline tasks within their current workflows. They may also have an interest in gaining a basic knowledge of recording macros to automate tasks within Excel and a basic insight to VBA code to gain a greater understanding of macros.

As a result of this course students will be able to use a variety of lookup, logical, financial and statistical functions. Analytical features such as Goal Seek, Scenario Manager will also be demonstrated, and students will gain exposure to Macros including an introduction to VBA code.

Course Prerequisites

Microsoft Excel Intermediate 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
03-May-19 (Fri)$385.00 0
10-May-19 (Fri)$250.00 0
ON SALE
15-May-19 (Wed)$385.00 0
23-May-19 (Thu)$250.00 0
ON SALE
31-May-19 (Fri)$385.00 0
05-Jun-19 (Wed)$385.00 0
13-Jun-19 (Thu)$385.00 0
19-Jun-19 (Wed)$385.00 0
28-Jun-19 (Fri)$385.00 0
03-Jul-19 (Wed)$385.00 0
12-Jul-19 (Fri)$385.00 0
19-Jul-19 (Fri)$385.00 0
25-Jul-19 (Thu)$385.00 0
31-Jul-19 (Wed)$385.00 0
09-Aug-19 (Fri)$385.00 0
14-Aug-19 (Wed)$385.00 0
22-Aug-19 (Thu)$385.00 0
30-Aug-19 (Fri)$385.00 0
05-Sep-19 (Thu)$385.00 0
13-Sep-19 (Fri)$385.00 0
18-Sep-19 (Wed)$385.00 0
25-Sep-19 (Wed)$385.00 0
03-Oct-19 (Thu)$385.00 0
11-Oct-19 (Fri)$385.00 0
Training courses on sale now

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

Course Outline

CREATE A PIVOTTABLE

Creating A PivotTable To Analyse Data

  • Create A PivotTable

Updating PivotTables

  • Updating PivotTable Data
  • Adding Multiple Fields - The Row Area
  • Adding Multiple Fields - The Column Area
  • Rearranging PivotTable Data
  • Removing A Field From A PivotTable
  • Filtering A PivotTable Rows And Columns
  • Removing A Filter From A PivotTable
  • The Report Filters Field
  • Clearing the Report Filter
  • Changing A Field Calculation
  • Formatting Calculated Data
  • Managing PivotTable Subtotals And Grand totals

PivotTable Features

  • Recommended PivotTable Layouts
  • Using Slicers To Filter Records
  • Select Multiple Filter Criteria
  • Clear Slicer Filters
  • Removing A Slicer

ADVANCED PIVOTTABLE FEATURES

Working With Calculated Fields In A PivotTable

  • Inserting A PivotTable Calculated Field
  • Multiple Calculations And The Values Field
  • Remove Calculated Fields
  • Setting PivotTable Options
  • Show Report Filter Pages Across Worksheets
  • Drilling Down Into PivotTable Results

Creating A PivotChart

  • Create A PivotChart

DATA VALIDATION AND PROTECTING DATA

Using Data Validation To Manage Data Entry

  • Validating Data Input
  • Composing An Input Message
  • Creating A Custom Error Message
  • Circling Invalid Data In A Worksheet

Protecting Worksheet Data

  • Protect A Worksheet
  • Unprotecting Worksheets
  • Unlock Cells In A Protected Worksheet
  • Hiding Formulas
  • Setting A Password To Edit A Specific Range

Protecting Workbooks

  • Protect And Unprotect Workbooks

Protecting Your Workbook From Unauthorised Users

  • Setting A Password To Open A Workbook
  • Removing A Password From A Workbook
  • Setting A Password To Modify A Workbook

WORKING WITH TEMPLATES

Create New Workbooks Based On A Template

  • Create A New Workbook Based On A Template
  • Creating And Saving Your Own Template
  • Create A New Workbook From Your Own Template
  • Editing An Existing Template

AUDITING FORMULAS

Tracing Cell References

  • Trace Precedent Cells
  • Trace Dependent Cells
  • Trace Cells Across Worksheets Or Workbooks
  • Checking For Errors
  • Tracing An Error
  • Error Checking Options
  • Using The Watch Window
  • Show / Hide Formulas
  • Evaluating A Formula

ADVANCED FUNCTIONS

Using A Financial Function

  • The PMT Function
  • The ABS Function

Logical Functions In Excel

  • Creating A Logical Test
  • Use An IF Function To Return A Text Message
  • Use An IF Function To Return A Calculated Result
  • Nesting Functions
  • The OR Function
  • The AND Function
  • The COUNTIF Function

ANALYSING DATA – WHAT IF ANALYSIS

Using The Goal Seek Tool

  • Using Goal Seek

Exploring What-If Tables

  • Creating A One Variable Data Table
  • Creating A Two Variable Data Table

Using Scenarios

  • Creating A Worksheet Scenario
  • Applying A Worksheet Scenario

The Solver Tool

  • Loading The Solver Add-In
  • Using The Solver Tool
  • Solver Features In Excel

AUTOMATING ROUTINE TASKS WITH MACROS

Understanding Macros

Types of Macros

  • Recording A Macro In Excel
  • Running A Macro In Excel
  • Add A Macro Button To The Quick Access Toolbar
  • Showing The Developer Tab In The Ribbon
  • Embed A Macro Command Button Into A Worksheet
  • Editing A Command Button

Edit A Macro

  • Showing the Personal Macro Workbook
  • Editing Macro VBA Coding
  • Renaming A Macro
  • Deleting A Macro
  • Hiding the Personal Macro Workbook

Recording A Relative Reference Macro

  • Record A Relative Reference Macro
  • Running A Relative Reference Macro
  • Saving A Macro Enabled Workbook
  • Opening A Macro Enabled Workbook

Student Comments

  • Excel Advanced Formulas training course
    Delivered in easy to understand language, very professional and knowledgable. Has improved my confidence with formulas & functions.
    - Monique
  • Excel Advanced training course
    Excellent course. Addressed many queries and issues I experience in the workplace.
    - Ross
  • Excel Advanced Training Course
    Course trainer adapted the course to meet our current level of knowledge and taught at a level to make everyone comfortable. Trainer’s technique was excellent.
    - Brendan
  • Excel Advanced Training Course
    Mandy was an excellent teacher. She took time to make us understand what she was doing
    - Anita
  • Excel Advanced Training Course
    Excellent presenter always makes the difference. Well done Craig
    - John
  • Excel Advanced Training Course
    You don't just learn about excel, but shortcuts within windows that you can apply to other programs to make it user friendly and time saving. The course is well presented in a friendly environment.
    - Troy
  • Excel Advanced Formulas training course
    great course!
    - Guy
  • Excel Advanced Training Course
    Excellent and well worth the time
    - Yolanda
  • Excel Advanced Formulas training course
    Great course!
    - Aimee
  • Excel Advanced Training Course
    Great course, would be happy to come back here for future training in other courses
    - Scott
  • Excel Advanced Training Course
    Excellent
    - Michael
  • Excel Advanced Training Course
    Can't wait for the next instalment
    - Susan
  • Excel Advanced Training Course
    Craig was a very patient and helpful teacher. I would definitely recommend Raising the Bar to anyone wishing to undertake an IT course.
    - Sarah
  • Excel Advanced training course
    Course was great, would like to stay up to date with other courses
    - Jimmy
  • Excel Advanced Formulas training course
    Very helpful! I am much more confident with formulas now.
    - Imogen
  • Excel Advanced Training Course
    Thank you to Sean he was excellent in the way he ran the course, really enjoyed it.
    - Mark
  • Excel Advanced Training Course
    Great course, would be happy to come back here for future training in other courses
    - Scott
  • Excel Advanced Training Course
    Sean once again very friendly, helpful and professional.
    - Luke
  • Excel Advanced Training Course
    Mandy is an amazing presenter, she knows everything inside out and is very professional in her approach.
    - My
  • Excel Advanced Training Course
    Tom is very funny and a tangential thinker he was hysterical and made excel fun.
    - Kathleen
  • Excel Advanced Training Course
    Further applications of excel, or further applications of formulas would be quite useful
    - Rosalie
  • Excel Advanced Training Course
    Sean the trainer was fantastic was able to hold and keep the course interesting
    - Linda
  • Excel Advanced Formulas training course
    Alot was learnt over the period of the course. Very instructive & very informative, as well as easy to follow. It helps alot, too when you have an instructor that is well versed in the topic. I would commend Sean for his efforts.
    - Ben
  • Excel Advanced training course
    Trainer well organised and loved templates, pivot tables, data tables, protection and auditing.
    - Gene
  • Excel Advanced Training Course
    I thought the course was great and Sean was a fantastic trainer I got a lot out of the course today
    - Ryllana
  • Excel Advanced Training Course
    very interesting and useful!
    - Daniel
  • Excel Advanced Training Course
    Good course. Everyone using excel should take this course
    - Manuraj
  • Excel Advanced Training Course
    I had in mind we might cover even more advanced excel topics than we did in the end
    - Stephen
  • Excel Advanced Training Course
    Mandy was fantastic. Thanks
    - Palana
  • Excel Training Course Sydney - Advanced
    Wish I knew how to do some of these things years ago - it would have made my job so much easier. Great course.
    - Leanne

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us