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.
At the end of this course, you should be able to:
You will be learning the following:
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 (Nested IF, AND, OR)
Using Conditional Count, Sum and Average Functions (COUNTIF, SUMIF, AVERAGEIF)
Using Database Functions (DSUM, DCOUNT, DAVERAGE)
Splitting and Freezing a Window
Working with Multiple Workbook Windows
Protecting a Workbook Structure
Protecting Worksheets and Worksheet Elements
Creating Custom Number Format
Sorting by One Column
Sorting by Multiple Columns
Sorting by Custom List
Creating Custom AutoFilter
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
Changing Chart Layout, Style and Colours
Working with Chart Labels
Changing Chart Gridlines
Changing the Scale
Changing Chart Type
$200 ($216 Inc. 8% GST) per participant
No SDF grant
Any of the 2 fast track – 10% offer
$360 ($388.80 Inc. 8% GST)
Any of the 3 fast track – 20% offer
$480 ($518.40 Inc. 8% GST)
No SDF grant.
Absentees will be charged the full course fee.
|Microsoft Excel Intermediate - Fast Track||ASKELF||JTC Summit||08|
|ASKELF||Home Based Learning||15||13||29||21||19||23||28|
|ASKELF||JTC Summit (Weekend)||03||08||05||23||07||11||16|
For Organisations on HRMS Learning Hub, you are strongly encouraged to use this platform for registration.