Microsoft Excel Intermediate – Fast Track

Nett Course Fee

Course Description

Do you often work with data at work or frequently extract data to create reports to update your leaders?

Microsoft Excel is a powerful spreadsheet program that allows you to make quick and accurate numerical calculations.

You will be more confident when you present formulated spreadsheets to highlight your key data narratives.

This 1 day workshop course is suitable for you, if you are looking beyond using basic features of Excel. You will be explored with more features of Excel to increase your productivity while working with data.

You’ll learn the popular features such as conditional formatting, sorting, filtering and data validation. Besides that, you will learn formulas like IF(), AND() and OR(), conditional and database formulas. Most importantly, you will learn to work with Charts confidently.

Course Outline

Essential Excel Fundamental
  • Customizing the Quick Access Toolbar
  • Entering Content Automatically (AutoFill & Flash Fill)
  • Using Paste Options and Paste Special Commands
  • Applying Conditional Formatting
  • Creating and Managing Conditional Formatting Rules
Working with Functions and Formulas
  • Overview of Formulas and Cell References (Absolute & Relative)
  • Cell and Range Names
  • Using and Managing Defined Names
  • Understanding Formula Errors
  • Using Logical Functions (Nested IF, AND, OR)
  • Using Conditional Count, Sum and Average Functions (COUNTIF, SUMIF, AVERAGEIF)
  • Using Database Functions (DSUM, DCOUNT, DAVERAGE)
Managing Workbooks and Protections
  • Splitting and Freezing a Window
  • Working with Multiple Workbook Windows
  • Protecting Workbooks
  • Protecting a Workbook Structure
  • Protecting Worksheets and Worksheet Elements
Formatting a Worksheet
  • Formatting Text & Values
  • Adjusting Row Height & Column Width, Cell Alignment, Borders & Colors
  • Copying Formatting
Managing Workbooks
  • Using Workbooks View
  • Selecting and Switching between Worksheets
  • Inserting, Renaming and Deleting Worksheets
  • Moving and Copying Worksheets
  • Changing Worksheet Tab Colour
  • Freezing a Window
  • Working with Multiple Workbook Windows
  • Hiding and Unhiding Rows, Columns and Worksheets
Working with Data Ranges
  • Creating Custom Number Format
  • Sorting by One Column
  • Sorting by Multiple Columns
  • Sorting by Custom List
  • Filtering Data
  • Creating Custom AutoFilter
  • Using Data Validation
  • Using Subtotal
Creating and Working with Charts
  • Choosing and Selecting the Source Data
  • Using Quick Analysis
  • Choosing the Right Chart
  • Inserting, Moving, Resizing and Deleting Chart
  • Elements of a Chart
  • Modifying and Changing Chart Data
  • Filtering Chart
  • Changing Chart Layout, Style and Colours
  • Working with Chart Labels
  • Changing Chart Gridlines
  • Changing the Scale
  • Emphasizing Data
  • Changing Chart Type
  • Using Sparklines

Related Courses

Microsoft Excel Basic – Fast Track

This 1 day workshop, participants will acquire fundamental skills in formatting cells, values, worksheets, and workbooks, gain confidence in using basic formulas for calculations, and receive guidance on setting up pages for printing in this essential learning module.

Course Duration:
1 Day (9.00am – 5.00pm)

View course details here

Microsoft Excel Advanced – Fast Track

In this 1 day workshop, you will be guided to use Lookup Formulas, Match and Index Formulas, Text & Date Formulas and Financial Formulas. Besides that, you will learn to analyse data and appreciate the powerful feature in using Pivot Tables. You will have the opportunity to learn simple Macros

Course Duration:
1 Day (9.00am – 5.00pm)

View course details here

Microsoft Excel Intermediate – Fast Track

Course Duration:

1 Day (9.00am – 5.00pm)

Course Fee Details:

1 Fast Track Course: $218.00 (incl. of 9% GST)

2 Fast Track Courses: $392.40 (incl. of 9% GST)

3 Fast Track Courses: $523.20 (incl. of 9% GST)

This course is not eligible for SDF Grant.

Course Schedule

Course NameCourse CodeVenueJuly 2024August 2024September 2024October 2024November 2024December 2024
Microsoft Excel Intermediate - Fast TrackASKELFJTC Summit30-26-05-
ASKELFMountbatten Square-27-29-17