Microsoft Excel Intermediate – Fast Track
Nett Course Fee
$218
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.
Prerequisites
To enrol in this course, you should possess the following:
- (≥ 16 years old); or
- 1 year working experience
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 Name | Course Code | Venue | November 2024 | December 2024 |
|---|---|---|---|---|
| Microsoft Excel Intermediate - Fast Track | ASKELF | JTC Summit | - | - |
| ASKELF | Mountbatten Square | - | 17 |