ASK Training

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 will be guided to learn more popular features such as conditional formatting, sorting, filtering and data validation. Besides that, you learn formulas like IF(), AND() and OR(), conditional and database formulas. Most importantly, you will learn to work with Charts confidently.

 

Course Objectives

At the end of this course, you should be able to:

Use advanced functions such as Financial Logical Lookup and Text functions

Working with Functions and Formulas

Create and manage conditional formatting rules

Managing Workbooks and Protections

Use the data validation function to control data being accepted for selected cells in your worksheet

Working with Data Ranges

Create scenarios and use the Goal Seek and Solver functions to achieve desired results in formulated cells

Creating and Working with Charts

Use advanced functions such as Financial Logical Lookup and Text functions

Working with Functions and Formulas

Create and manage conditional formatting rules

Managing Workbooks and Protections

Use the data validation function to control data being accepted for selected cells in your worksheet

Working with Data Ranges

Create scenarios and use the Goal Seek and Solver functions to achieve desired results in formulated cells

Creating and Working with Charts

Course Outline

You will be learning the following:

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
  • Overview of Formulas and Cell References (Absolute & Relative)
  • Cell and Range Names
  • Using and Managing Defined Names
  • Understanding Formula Errors
  • Using Logical Functions (NestedIF.AND,OR)
  • Using Conditional Count,Sum and Average Functions (COUNT IF, SUMIF,AVERAGE, IF)
  • Using Database Functions (DSUM, DCOUNT, DAVERAGE)
  • Splitting and Freezing a Window
  • Working with Multiple Workbook Windows
  • Protecting Workbooks
  • Protecting a Workbook Structure
  • Protecting Worksheets and Worksheet Elements
  • Sorting by One Column
  • Sorting by Multiple Columns
  • Sorting by Multiple Columns and Custom List
  • Using Subtotals
  • Creating a Custom Number Format
  • Filtering Data
  • Using Data Validation
  • 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 w ith Chart Labels
  • Changing Chart Gridlines
  • Changing the Scale
  • Emphasizing Data
  • Changing Chart Type
  • Using Sparklines

Course Fees And Grants

$200 ($216 Inc. 8% GST) per participant
No SDF grant
If you sign up for
Any of the 2 fast track – 10% off
Any of the 3 fast track – 20% off

Absentees will be charged the full course fee.

Course Schedule

CourseCodeVenueDec-22Jan-23Feb-23Mar-23Apr-23May-23Jun-23
Microsoft Excel Intermediate - Fast TrackASKELFJTC Summit10
30
07
22
02
15
11
26
09
25
08
27
ASKELFMountbatten Square1702
15
09
22
05
10
04
17
06
26
ASKELFHome Based Learning2728203015

Registration

For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.

Our Corporate Partners

What Our Students Say

COURSE FEES AND GRANTS

$200 ($216 Inc. 8% GST) per participant
No SDF grant
If you sign up for
Any of the 2 fast track – 10% off
Any of the 3 fast track – 20% off

Absentees will be charged the full course fee.

REGISTRATION

For Organisations on HRP Portal, you are strongly encouraged to use this platform for registration.

Browse Courses

Learning Paths

Master Microsoft Office

Master Microsoft Office

Become a Web Designer

Become a Web Designer

Become a Digital Marketer

Become a Digital Marketer

Become a Video Producer

Become a Video Producer