Software Training

Cost & Time Effective | Career Advancement

Melbourne - Perth - Sydney

Have Questions?

 1300 723 056

Enquire Online

Excel 2013 – 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 advanced features of Excel 2013. This workshop is designed to provide an in-depth understanding of Excel 2013. You will be shown a practical way of learning with a hands-on and customizable approach. You will get a chance to experience some of the new features that are offered in Excel 2013. 

Excel 2013 is the world’s premier spreadsheet software. You can use Excel to analyze numbers, keep track of data, and graphically represent your information. With Office 2013 you are provided a new landing screen which makes launching and creating documents easier than previous versions of Excel. Excel 2013 also has an improved user interface with an array of powerful tools to help you manage your data through Skydrive – 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 Evaluating Formulas

  • 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 and Pivot Charts

  • Inserting a PivotTable using Excel Recommendations
  • Choosing Fields and Grouping Data
  • Overview of the Pivot Table Tools Tabs
  • Changing the Data Displayed and Refreshing the PivotTable
  • Applying a Style to Your Pivot Table
  • Creating a Pivot Chart from a Pivot Table or Data
  • Some Real-life Examples

Module Six: Macros

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

Module Seven: Solving Formula Errors

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

Module Eight: Using What If Analysis

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

Module Nine: 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 Ten: Grouping and Outlining Data

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

Module Eleven: Protection

  • Protection your Worksheets
  • Unlocking Cells
  • Protecting your Workbooks
  • To protect your Workbook

Module Twelve: 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