top of page

Microsoft Excel Intermediate

Course Overview
FREE Course Guide Download
Overview
​

This course has been developed for people wanting to utilise Excel to perform calculations using a variety of common worksheet functions, filter, sort and summarise database lists, format and modify charts, and conditionally format cells.


Target Student

​

This course is for individuals whose job responsibilities include creating more advanced functions, creating charts and analysing data using Pivot tables.


Prerequisites

​

Previous experience using Microsoft Excel at a basic level is an essential prerequisite for this course.

 

Duration

​

1 day

​

​

Course Outline​
​

1. Working With Functions

  • Topic A: Work with Ranges

  • Topic B: Use Specialized Functions

  • Topic C: Work with Logical Functions

  • Topic D: Work with Date and Time Functions

  • Topic E: Work with Text Functions

​

2. Working With Lists

  • Topic A: Sort Data

  • Topic B: Filter Data

  • Topic C: Query Data with Database Functions

  • Topic D: Outline and Subtotal Data

​

3. Analyzing Data

  • Topic A: Create and Modify Tables

  • Topic B: Apply Intermediate Conditional Formatting

  • Topic C: Apply Advanced Conditional Formatting

​

4. Visualizing Data With Charts

  • Topic A: Create Charts

  • Topic B: Modify and Format Charts

  • Topic C: Use Advanced Chart Features

Training Centre

Sydney: 95-99 York Street Sydney, 2000

Melbourne: Level 9, 120 Spencer Street, Melbourne, 3000

Head Office:

Ground Floor, 465 Victoria Avenue, Chatswood NSW 2067
info@illuminatecoachingandtraining.com 


 

  • LinkedIn
  • Twitter
  • Instagram
  • YouTube
  • Facebook

© 2022 by Illuminate Coaching and Training.

bottom of page