WSQ Microsoft Excel Essentials
TGS-2023041089
Course Overview
Being the most widely used spreadsheet tool, Microsoft Excel is an essential application for working with data – whether for data analytics, business, or research. Designed to impart you with essential working skills of Excel and how to use it managing data.
This course lays the foundation in applying business statistics, analytical and quantitative skills in Excel. Throughout this course, you’ll gain valuable experience working with data sets and spreadsheets. You will learn how to use formulas and functions, create charts and graphs, and use conditional formatting to visually represent your data.
With strong focus on practice and applied learning in this course, you’ll have the opportunity to manipulate data and gain hands-on experience using Excel. By the end of this course, you’ll have a solid foundation in using Excel and will have the skills and knowledge needed to effectively use Excel.
Course Duration
2 days
Total Training Duration (Hour)
16 hours, 15 hours training and 1 hour assessment
Course Outline
Introduction to Business Statistics & Application Fundamentals
- Navigating a Worksheet
- Entering Labels & Values
- Editing Cell Contents
- Selecting Cells & Ranges
- Entering Content Automatically using AutoFill
- Importing Data
Editing a Worksheet
- Copying & Moving Cells
- Checking Spelling
- Insert Cells, Rows, & Columns
- Delete Cells, Rows, & Columns
- Hiding & Unhiding Rows & Columns
- Using Undo & Redo
- Finding & Replacing Content
- Cell Comments
Managing Worksheets
- Using Workbook Views
- Selecting & Switching Between Worksheets
- Inserting, Renaming & Deleting Worksheets
- Moving & Copying Worksheets
- Changing Worksheet Tab Colour
- Splitting & Freezing a Window
- Working with Multiple Workbook Windows
- Hiding & Unhiding Worksheets
Working with Data Ranges
- Sorting by One Column
- Sorting by Multiple Columns
- Filtering Data
Introduction to Formulas & Functions
- Overview of Formulas & Cell References
- Entering Formulas
- Absolute & Relative References
- Formulas with Multiple Operators
- Using Essential Statistical Function
- Referencing External Data
Formatting a Worksheet
- Formatting Text & Values
- Adjusting Column Width & Row Height
- Working with Cell Alignment
- Adding Cell Borders & Background Colours
- Copying Formatting
- Working with Cell Styles & Document Themes
- Applying Conditional Formatting
Managing Page Setup & Printing
- Previewing & Printing a Worksheet
- Setting the Print Area
- Adjusting Page Margins & Orientation
- Adjusting Paper Size & Print Scale
- Adding Print Titles, Gridlines & Headings
- Creating Headers & Footers
- Printing a Selection, Multiple Worksheets & Workbooks
Introduction to Charts
- Choosing & Selecting the Source Data
- Choosing the Right Chart
- Inserting, Moving, Resizing & Deleting Charts
- Changing Chart Layouts & Styles
- Changing Chart Type
- Working with Chart Labels
Course Objectives
At the end of the course, you will be able to:
- Identify the various types of business statistics, including descriptive statistics in Excel workbooks.
- Create and edit imported data from external sources in Excel.
- Create formulas and functions to calculate business statistics.
- Edit worksheet data and cells.
- Format cells and worksheets in Excel, and utilise conditional formatting to emphasise
- Manage multiple worksheets and windows.
- Prepare and format worksheets for printing.
- Sort and filter data range.
- Create charts using existing data
Pre-requisites
- (≥ 16 years old); or
- 1 year working experience
Course Pre-Requisites
Price
| Course Fee Payable | ||
|---|---|---|
| Original Fee | Before GST | With GST (9%) |
| Course Fee | $450.00 | $490.50 |
| Individual Pricing (Fee payable to Training Provider) | Before GST | With GST (9%) |
| PMET SkillsFuture >= 21 years old | $225.00 | $265.50 |
| PMET Skillsfuture >= 40 years old | $135.00 | $175.50 |
| Corporate Pricing (Fee payable to Training Provider) | ||
| Non-SME | Before GST | With GST (9%) |
| PMET SC and PR | $225.00 | $265.50 |
| Non-SME PMET Funding >= 40 years old | $135.00 | $175.50 |
| SME | Before GST | With GST (9%) |
| PMET funding >= 21 years old | $135.00 | $175.50 |
| PMET funding >= 40 years old | $135.00 | $175.50 |
Please note that prices are subjected to change.
