fbpx

Microsoft Excel Intermediate

Course Description

Microsoft Excel 2016 Intermediate is part of a 3-level study program. This course aims to expand participant’s knowledge and demonstrate how to create more productive workbooks. It covers formulas and function techniques, advanced formatting and charting features and data manipulation tools like goal seeking.

Learning Outcomes

At the completion of Microsoft Excel Intermediate you should be able to:

Prerequisites

Microsoft Excel Intermediate assumes the participant has the knowledge required to create, edit, print and chart simple worksheets. Understanding ranges and copying is also important.

Course Duration

The Microsoft Excel Intermediate course is run over one-day but can be customised to suit your needs.

Course Overview

  • Fill a series or growth series
  • Creating a custom fill list
  • Modify and delete a custom fill list
  • Extract with Flash Fill
  • Extracting Dates and Numbers
  • Inserting and Deleting Worksheets
  • Copy and Rename Worksheets
  • Move and Hide Worksheets
  • Hide and Unhide Worksheets
  • Freezing Rows and Columns
  • Using Built-in Margins
  • Set Custom Margins
  • Customising Page Layout
  • Set a Print Area
  • Using Page Break Preview
  • Apply borders to a cell or range
  • Remove borders
  • Drawing borders
  • Using IF with Text and Numbers
  • Nesting IF Functions
  • The CHOOSE and LOOKUP Function
  • Using Counting Functions
  • The TODAY, NOW, and DATE Function
  • Scoping a Formula
  • Creating the Base Formula
  • Adding More Operators
  • Copying Nested Functions
  • Understanding Defined Names
  • Defining Names from Worksheet Labels
  • Apply Names to Existing Formulas
  • Create Names using the Name Box
  • Using the Name Manager
  • Applying Alternate Currencies
  • Formatting Clock Time
  • Formatting Calculated Time
  • Understanding Number Formatting
  • Understanding Format Codes
  • Creating Descriptive Custom Formats
  • Formatting Cells containing Values
  • Top Ten Items
  • More Top and Bottom Formatting
  • Working with Data Bars
  • Working with Colour Scales
  • Working with Icon Sets
  • Create and Edit Sparklines
  • Understanding Goal Seek
  • Using Goal Seek
  • Quick Formatting
  • Quick Charting
  • Quick Totals
  • Quick Sparklines
  • Quick Tables
  • Creating a Table from scratch
  • Working with Table Styles
  • Insert and remove table columns
  • Converting a table to a range
  • Creating a Table from Data
  • Insert and delete Table Records
  • Remove Duplicates
  • Sort and Filter Tables
  • Rename, split and delete a table
  • Select Chart Objects
  • Use Shape Styles
  • Change Colour schemes
  • Use Shape Effects
  • Explode Pie Slices
  • Format Text and WordArt

Course Includes

Skills Analysis

Certificate

We come to you

Hands-on training

Email Support

Real-world examples

Course Pricing

Pricing as of 1st July 2019. All prices are exempt of GST. All prices are PER SESSION, not per person.

Number of participants Investment (per day)
1-on-1 Training $500.00
2-3 participants $650.00
4-6 participants $800.00
7-8 participants $950.00
9-10 participants $1,200.00

Above costs are for training conducted within the Sydney region and is subject to travel fees dependent on location. Pricing provides a guide only and will be confirmed at time of booking enquiry.

View other course outlines

Microsoft Excel Courses

Excel Introduction

- 1 day course duration

Microsoft Excel Courses

Excel Advanced

- 1 day course duration

Call Now Button