Level Up Your Excel Skills ( Advanced )
COURSE SYNOPSIS
This course sets out advanced skills that can be used to perform complex mathematical and statistical calculations, to produce high quality management information and to use the advance features in a spreadsheet application to improve productivity
COURSE OBJECTIVES
By the end of this course, learners will be able to:
Import and organise data sources
Prepare worksheets for data entry and calculations
Manage data and navigate cells effectively
Perform efficient analyse of data
Perform advanced calculations with Excel functions
Collaborate and review workbooks
TARGET AUDIENCE (OPERATIONAL, SUPERVISORY & MANAGERIAL)
The job role(s)/occupations that this unit would be relevant for learners who are required to prepare data and analyse data using Microsoft Excel at an advanced level. The competencies covered in this course would be relevant to all industries and to organisations of all sizes.
ASSUMED SKILLS
Workforce Skills Qualifications (“ES WSQ”) Workplace Literacy (“WPL”) level 5
Be able to read and write English at a proficiency level equivalent to ES WSQ WPL level 5
Be able to manipulate numbers at a proficiency level equivalent to ES WSQ Workplace Numeracy (“WPN”) level 5
Learners to have minimum GCE ‘O’ level or ITE certificate education
Learner should have at least 1 year’s working experience in any industry
Learners must be able to operate a personal computer, use keyboard and mouse
Learners are expected to have basic knowledge of Microsoft Excel
COURSE CONTENT
LEARNING UNIT 1 – GATHER DATA
Import data
Data consolidation
Linking to cells, range, between applications, break links
LEARNING UNIT 2 – FORMAT & MANAGE WORKSHEETS
Custom number formats
Data validation
Worksheet grouping
Paste special options
LEARNING UNIT 3 – ADVANCED DATA HANDLING
Range name
Go To special
LEARNING UNIT 4 – DATA ANALYSIS
Using Quick Analysis
Conditional formatting
Advanced sorting
Advanced filters
PivotTabel and PivotChart
LEARNING UNIT 5 – ADVANCED EXCEL FUNCTIONS
Cell referencing
Logical functions
Nested functions
Mathematical functions
Date functions
Text functions
Lookup & reference functions
Database functions
Formula auditing
LEARNING UNIT 6 – COLLABORATIVE EDITING
Track changes
Share workbook
Compare & merge
Funding
Additional Info
Course Code : TGS-2022017320
Course Funding Period : 02 Dec 2022 To 01 Dec 2024
Course Duration : 17 hours