Software Training

Cost & Time Effective | Career Advancement

Melbourne - Perth - Sydney

Have Questions?

 1300 723 056

Enquire Online

Excel 2013 - Boot Camp


Our Microsoft Office Excel Boot Camp courses are intense one day courses that give you all the essential knowledge you need for most job positions.  They are ideal for people starting TAFE or University, upskilling, starting new jobs or re-entering the workforce.

You will learn how to use the basic features of Excel 2013. This workshop is designed to provide a basic understanding of Excel 2013. You will be shown a practical way of learning with a hands-on and customizable approach. You will also 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

Module One: Getting Started

  • Workshop Objectives

Module Two: Opening Excel

  • Opening Excel
  • Using the Recent List
  • Opening Files
  • Creating a Blank Workbook
  • Creating a Workbook from a Template

Module Three: Working with the Interface

  • Understanding the Interface
  • About Your Account and Feedback
  • Using Backstage View
  • Understanding Worksheets
  • Saving Files
  • Closing Files vs. Closing Excel

Module Four: Your First Worksheet

  • Entering Data
  • Entering Dates
  • Entering Numbers
  • Entering Text
  • Using Auto Fill
  • Editing Data
  • Checking Your Spelling
  • Adding Rows and Columns
  • Using Flash Fill

Module Five: Viewing Excel Data

  • An Overview of Excel’s Views
  • Switching Views
  • Using Zoom
  • Creating Custom Views
  • Switching Between Open Files

Module Six: Building Formulas

  • The Math Basics of Excel
  • Building a Formula
  • Editing a Formula
  • Copying a Formula
  • Using the Status Bar to Perform Calculations

Module Seven: Using Excel Functions

  • Formulas vs. Functions
  • Using the SUM Function
  • Using AutoComplete
  • Using Other Basic Excel Functions
  • Understanding the Formulas Tab
  • Understanding Function Compatibility

Module Eight: Using Cut, Copy and Paste

  • Using Copy
  • Using Paste Special

Module Nine: Using Quick Analysis

  • Formatting Data
  • Creating Quick Analysis Charts
  • Calculating Totals
  • Creating Quick Analysis Tables
  • Sorting and Filtering Your Data
  • Using Sparklines

Module Ten: Formatting Your Data

  • Changing the Appearance of Text
  • Using Merge
  • Changing the Appearance of Numbers
  • Adding Borders and Fill Color
  • Removing Formatting
  • Working with Alignment Options
  • Adding Rows and Columns
  • Hide and Unhide Rows and Columns
  • Renaming Sheets

Module Eleven: Using Styles, Themes, and Effects

  • Using Table Styles and Cell Styles
  • Using Conditional Formatting
  • Changing the Theme, Colors, and Fonts

Module Twelve: Printing and Sharing Your Workbook

  • An Overview of the Page Layout Tab
  • Setting up Your Page
  • Previewing and Printing Your Workbook
  • Inviting People
  • E-Mailing Your Workbook

Module Thirteen: Creating Charts

  • Using Recommended Charts
  • Inserting a Chart
  • Using Chart Styles and Colors
  • Overview of the Chart Tools Tabs
  • Understanding Chart Elements
  • Resizing and Moving the Chart

Module Fourteen

  • Applying Advanced Chart Features
  • About Trend Lines
  • Add a Trend Line
  • Using Secondary Axes
  • Using Chart Templates

Module Fifteen Wrapping Up

  • Words from the Wise

Resources

A printed training manual is provided.

Prior Knowledge

No prior 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