Software Training

Cost & Time Effective | Career Advancement

Melbourne - Perth - Sydney

Have Questions?

 1300 723 056

Enquire Online

Excel 2010 – Expert


Our Microsoft Office Excel Expert courses are intense one day courses meant for people that use Excel every day in their workplace.  They follow on from the learning in the Boot Camp course.  If you are not using Excel in your current workplace we suggest that you will need to do the Boot Camp before you do this course.

You will learn how to use the more in-depth features of Excel 2010. This workshop is designed to for the advanced users of Excel 2010. This workshop incorporates a hands-on approach to learning. You will get a chance to practice some of the advanced features right on a computer. 

Excel is the world's premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Excel 2010, you can manage more data than ever, with increased worksheet and workbook sizes. Excel also makes your job easier by providing an easy to use interface, and an array of powerful tools to help you turn your data into usable information - and better information leads to better decision making!

Cost $350 (includes GST)

Package Deal: Buy 2 Microsoft courses get one free.

 

Course Covers

We will cover such topics as:

Module One :Getting Started

  • Workshop Objectives

Module Two: Relative vs Absolute References

  • Relative vs. Absolute References

Module Three: Auditing and Solving Formula Errors

  • Tracing Precedent Cells
  • Tracing the Dependents of a Cell
  • Displaying Formulas Within the Sheet
  • Adding, Displaying, Editing, and Removing Comments
  • Evaluating Formulas

Module Four: Performing Advanced Formula and Function Tasks

  • VLookup Function
  • Logical Functions
  • IF
  • CountIF
  • SumIF
  • Using the IFERROR Function to Evaluate Formulas
  • Using the Watch Window

Module Five: Creating Pivot Tables

  • Inserting a PivotTable
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs

Module Six: Working with PivotTables and PivotCharts

  • Changing the Data Displayed and Refreshing the PivotTable
  • Applying a Style to Your Pivot Table
  • Creating a Pivot Chart from a Pivot Table
  • Creating a Pivot Chart from Data
  • Some Real-life Examples

Module Seven: Macros

  • Displaying the Developer Tab
  • Recording and Running Macros
  • Changing the Security Level
  • Customizing and Changing the Quick Access Toolbar

Module Eight: Solving Formula Errors

  • Using Named Ranges
  • Understanding Formula Errors
  • Using Error Checking
  • Evaluating Formulas
  • Using the Trace Errors Commands

Module Nine: Using What If Analysis

  • Using Goal Seek
  • Using the Scenario Manager
  • Using a One Input Data Table
  • Using a Two Input Data Table

Module Ten: Managing Your Data

  • Transposing Data from Rows to Columns
  • Using the Text to Columns Feature
  • Checking for Duplicates
  • Creating Data Validation Rules
  • Consolidating Data

Module Eleven: Grouping and Outlining Data

  • Grouping Data
  • Adding Subtotals
  • Outlining Data
  • Viewing Grouped and Outlined Data

Module Twelve: Protection

  • Protecting your Worksheets
  • Protecting your Workbooks

Module Thirteen: Wrapping Up

  • Words from the Wise       

Resources

A printed training manual is provided.  

Prior Knowledge

An advanced knowledge of Excel is required.  Basic computer and keyboard skills are required.

Course Times

Our classes run from 9am to 5pm.  We run classes every week of the year.

Where do I go to attend the course?

CBD training rooms in Sydney are located in the heart of the city across the road from the Apple store on George St.  If traveling on train, get off at Town Hall and walk down towards Circular Quay on George St for 2 blocks.  Exact address:  Suite 1, Level 10, The Dymocks Building, 428 George St, Sydney.

Cancellation policy

We are unable to refund monies for students who do not turn up for classes or decide at a later date after booking that that they do not want to attend. Changes to class times are allowed, but not within 48 hours of the class commencing.

 

Quick Enquiry Form

Please complete the form below to submit your enquiry:

Why Choose CBD College

  • CBD Location
  • Courses Every Week
  • Highly Experienced Trainers
  • Face-to-Face Teaching
  • Nationally Recognised Training

Win an iPad

Book securely online 24/7 with CBA security. Credit card bookings prior to the day of your first aid course are essential as class sizes are strictly limited.

View Winners

Our Clients

Just a few of our satisfied customers. View all clients.

Our Clients


Our Guarantee

Our Guarantee