Course Details close

Course Details

Price:
(inc GST)
$ 385
Sale Price:
(inc GST)
$ 250
Application:Excel
Level:Advanced
Version:2010
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 2010 Course

   (4.80 out of 5)
1253 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 2010 Course

Course Overview

The Excel Advanced course assumes students are confident in working with Excel and the spreadsheet environment. Students will want to learn more functions available to them other than the standard sum function. Typically in their workplace they are required to use Excel a great deal to evaluate, extract and analyse results and desire techniques to automate tasks. They may also have an interest in gaining a basic knowledge of VBA code to understand macros more fully.

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

Course Prerequisites

Microsoft Excel Intermediate 2010 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

CREATING A PIVOTTABLE IN EXCEL

Creating Excel PivotTables

  • Creating A PivotTable

Updating An Excel PivotTable

  • Update A PivotTable
  • Adding Multiple Fields To The Row / Column Area
  • Rearrange PivotTable Fields
  • Removing A PivotTable Field
  • Filter A PivotTable Field
  • Remove A Filter
  • Filter The PivotTable Using The Filters Field
  • Clearing A Filter
  • Setting The Field Calculation
  • Format Calculations In A PivotTable
  • Managing Subtotals and Grand Totals

More Features In PivotTables

  • Filter Records Using Slicers
  • Setting Multiple Filter Criteria
  • Clearing Filters In The Slicer
  • Remove A PivotTable Slicer

ADVANCED FEATURES OF PIVOTTABLES

Working With Calculated Fields In A PivotTable

  • Insert A Calculated Field Into A PivotTable
  • Moving The Values Field
  • Remove A Calculated Field
  • Set PivotTable Options
  • Show Report Filter Pages For A Field
  • Show Detailed Information From A PivotTable Result

PivotCharts

  • Create A PivotChart From A PivotTable

DATA VALIDATION, DATA PROTECTION & WORKING WITH TEMPLATES

Setup Data Validation

  • Validate Data Entry
  • Create A Data Validation Input Message
  • Compose An Error Alert Message
  • Circle Cells With Invalid Data

Working With Template

  • Create A New Workbook Based On A Workbook Template
  • Create A New Excel Template
  • Create A New Workbook From Your Own Template
  • Edit Your Own Template

Protecting Worksheets

  • Protecting Data On A Single Worksheet
  • Unprotecting A Worksheet For Editing
  • Unlock Cells For Editing
  • Hide Formulas In A Cell
  • Add A Password To Edit A Specific Ranges

Protecting The Workbook Structure

  • Protect And Unprotect The Workbook Structure

Password Protect The Workbook

  • Setting A Password To Open A Spreadsheet
  • Remove A Password From A Spreadsheet
  • Setting A Password To Modify A Spreadsheet

FORMULA AUDITING IN EXCEL

Auditing Formulas And Tracing Cell References

  • Tracing Precedents
  • Tracing Dependents
  • Tracing Precedents / Dependents Across Worksheets
  • Error Checking
  • Trace An Error In A Worksheet
  • Setting Error Checking Options
  • The Watch Window
  • Showing / Hiding Formulas In A Worksheet
  • Evaluate Formula Steps

ADVANCED FUNCTIONS

The Payment Function

  • PMT Function (Payment)
  • Using The ABS Function (Absolute)

Working With Logical Functions

  • Introducing A Logical Test
  • Setup An IF Function To Return Text
  • Setup An IF Function To Return Value
  • Nesting IF Functions In A Formula
  • Using The OR Function
  • Using The AND Function
  • Count Cells With Specific Criteria Using The COUNTIF Function

WHAT IF ANALYSIS AND ANALYSING DATA

Goal Seek Tool

  • Use The Goal Seek Tool

Data Tables

  • Create A One Variable Data Table
  • Create A Two Variables Data Table

Scenarios

  • Create Scenarios
  • Apply A Scenario

Solver Tool

  • Load The Solver Add-In
  • Setting Up The Solver Tool
  • Solver Features

RECORDING MACROS

Recording Macros

Understanding The Two Types of Macros

  • Recording A New Macro
  • Run A Recorded Macro
  • Add A Button To The Quick Access Toolbar
  • Showing The Developer Tab
  • Embed A Command Button Into A Worksheet
  • Editing The Command Button

Editing A Recorded Macro

  • Unhide the Personal Macro Workbook
  • Edit The VBA Code In A Macro
  • Rename A Recorded Macro
  • Delete A Recorded Macro
  • Hide the Personal Macro Workbook

Relative Reference Macros

  • Record A Macro With Relative Cell References
  • Run The Relative Reference Macro
  • Saving A Workbook With Macros
  • Open A Workbook With Macros

INTEGRATING DATA WITH OTHER APPLICATIONS

Importing And Exporting Data

  • Using The Text Import Wizard

Import Data From A Database

  • Introducing Microsoft Query

Importing Data From Another Source

  • Import Information From Other External Sources

Student Comments

  • Excel Advanced training course
    I love doing these courses with you guys!
    - Teneale
  • Excel Advanced training course
    Course was great, would like to stay up to date with other courses
    - Jimmy
  • Excel Advanced Formulas training course
    Excellent! Tom not only taught what was in the guide but expanded providing useful insights, hints and tips.
    - Michael
  • Excel Advanced training course

    - Shobna
  • Excel Advanced Training Course
    I found the course extremely effective and have a much greater understanding of the use of excel.
    - Luke
  • Excel Training Course Sydney - Advanced
    I should have done this course 10 years ago!
    - Margaret
  • Excel Advanced Training Course
    Good course. Everyone using excel should take this course
    - Manuraj
  • Excel Advanced Training Course
    Sean was fantastic, amazingly knowledgeable, and very friendly.
    - Declan
  • Excel Advanced training course
    Craig was excellent! The content was interesting, useful and easy to follow. Would highly recommend!
    - Christina
  • Excel Advanced Formulas training course
    Excellent course well presented definitely recommend to other employees and friends.
    - Chris
  • Excel Advanced Training Course
    Yes, the instructor was very helpful and professional. May I say he would of been the best instructor I have ever had for any course. I would recommend this course to anyone provided that Sean Misso was the instructor.
    - Geoff
  • Excel Advanced Training Course
    I understand it is hard to avoid the 'too short, too quick' issue, without adding an extra day and hence extra price. Thanks a heap, it was awesome
    - JP
  • Excel Advanced training course
    Love the small and personalised classroom style.
    - Erin
  • Excel Advanced Training Course
    Whilst the course was probably too advanced for me the instructor was excellent. He remembered my name from the previous week, explained everything very well and was an excellent presenter making difficult topics a bit easier to understand
    - Shayne
  • Excel Advanced training course
    Great Course!
    - Darren
  • Excel Advanced Training Course
    Excellent
    - Michael
  • Excel Advanced Training Course
    Excellent!
    - Oliver
  • Excel Advanced training course
    Excellent course. Addressed many queries and issues I experience in the workplace.
    - Ross
  • Excel Advanced training course
    Well structured and enjoyable. Very interesting content.
    - Adriana
  • Excel Advanced Training Course
    Excel is such a powerful spreadsheet with so many functions to remember and if you don`t practise you will soon forget.
    - Tommy
  • Excel Training Course - Advanced
    I found the course very informative and friendly atmosphere.
    - Niven
  • Excel Advanced training course
    Just right. Thanks Craig :)
    - Maria
  • Excel Advanced Training Course
    Sean the trainer was fantastic was able to hold and keep the course interesting
    - Linda
  • Excel Advanced Training Course
    Excellent presenter, very patient
    - Becky
  • 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
    very interesting and useful!
    - Daniel
  • Excel Advanced Formulas training course
    Very helpful! I am much more confident with formulas now.
    - Imogen
  • Excel Advanced Training Course
    Excellent
    - Ken
  • Excel Advanced Training Course
    The instructor was first class. I had some reservations about doing the course after the intermediate excel I took a couple of weeks ago but the instructor quickly showed there was nothing to worry about. I would be more than happy to participate in
    - William
  • Excel Advanced Formulas training course
    Great... had good fun learning :)
    - Valerie

Need Assistance

  • Send Email
Raising the Bar
Warning Icon Information Icon

OK
1300 937 782 Contact us