-
Mode of Delivery
Face to face delivery on campus -
Computers and Software Provided
Fast and reliable PCs to learn on
-
Course Duration
24 hours (3 day) -
Convenient Campus
Walking distance from MRT
-
Practical Components
Hands-on learning -
Accredited by
SkillsFuture Singapore (SSG)
CRITICAL SKILLS FOR DIGITAL WORKPLACES
In 2021 and beyond, our lives will be dictated by COVID-19 and how we live with it’s variants. In a cosmopolitan city like Singapore, the biggest change is in the nature of work. Most jobs will have a remote work or work-from-home component to reduce the chances of sicknesses being spread at work.
Now, more than ever, everyone who is looking to land and keep a well-paying office job, must be comfortable working with Microsoft Office or Google Workspace, operate securely from a remote laptop or device, and should understand the basics of working with data.
If you need to work for at least another 5 years or longer, then these skills are essential to your career.
They are so essential that you won’t even find them stated in job requirements – they are critical skills and they are expected of everyone.
COURSE DESCRIPTION
The Advanced Spreadsheets module covers the advanced skills needed to use the versatile features of spreadsheets to produce reports, provide statistical or mathematical analysis, and manage data more effectively and productively.
The benefits of data-based decision-making are widely recognised. All types of organisation need workers who are able to use spreadsheets effectively – not just for storing tabular data, but for the sophisticated way that spreadsheets can be used to validate, interpret, and present information.
As data becomes easier to source and share, inputting, extracting, and displaying data (either internally or externally) is now a common task for workers in all types of role and every sector
WHO IS THIS COURSE FOR
For regular users of Microsoft Excel / Spreadsheets who want to tap on advanced data processing tools and techniques.
Extensive prior experience is highly recommended.
COURSE OUTLINE
This course is grouped into 9 main sections. Click on each one to see the content that is covered in the section.
- Considerations in Designing a Spreadsheet
- Working with Cell Styles & Document Themes
- Apply, Create & Manage Conditional Formatting
- Creating a Custom Number Format
- Create a Table & working with the Total Row
- Sorting & Filtering a Table
- Formatting the Table
- Converting to a Range
- Formulas with Multiple Operators
- Using and Managing Defined Names
- Using Mixed Cell Referencing
- Date and Time Function
- Using Logical Functions (IF, AND and OR)
- Using Lookup Functions
- Mathematical and Statistical Functions
- Using Financial, Text & Database Functions
- Using 3D Reference within SUM Function
- Using Data Validation
Auditing Tools - Displaying and Tracing Formulas
- Understanding Formula Errors
- Editing, Adding, and Removing Chart Data
- Changing Chart Data
- Change Scales and Display Unit of the Axis
- Add Secondary Axis & Change Series
- Chart Type
- Changing and Aligning Data
- Labels and Chart Legend
- Sorting by a Custom List
- Creating a Custom AutoFilter
- Using Advanced Filters
- Creating a PivotTable
- Specifying PivotTable Data
- Changing a PivotTable’s Calculation
- Filtering and Sorting a PivotTable
- Working with PivotTable Layout
- Grouping PivotTable Items
- Updating & Formatting a PivotTable
- Creating a PivotChart
- Using Slicers between PivotTables
- Creating Scenarios
- Working with Data Tables
- Using Goal Seek
- Using Text to Columns
- Grouping and Outlining Data
- Using Subtotals
- Consolidating Data by Position or Category
- Recording a Macro
- Playing and Deleting a Macro
- Adding a Macro to the Quick Access Toolbar
TRAINERS
Maymond Batchelor
An IT Professional with more than 20 years of IT experience with extensive hands-on and broad technical knowledge. Involved in Local, Regional IT technical support and managerial roles in MNC such as SKF, IBM, Seagate, BD before taking on an Educator role in 2016. Validated technical competencies by attaining various certifications from Cisco, Google, Microsoft, ICS2, ISACA, Checkpoint, Fortinet, ITIL etc. Achieved Advanced Certificate in Training and Assessment (ACTA) in Feb 2017. A Microsoft Certified Trainer (MCT) specialised in Microsoft Azure Cloud Computing, Data Analytics with Power BI and Microsoft Excel
An IT Professional with more than 20 years of IT experience with extensive hands-on and broad technical knowledge. Involved in Local, Regional IT technical support and managerial roles in MNC such as SKF, IBM, Seagate, BD before taking on an Educator role in 2016. Validated technical competencies by attaining various certifications from Cisco, Google, Microsoft, ICS2, ISACA, Checkpoint, Fortinet, ITIL etc. Achieved Advanced Certificate in Training and Assessment (ACTA) in Feb 2017. A Microsoft Certified Trainer (MCT) specialised in Microsoft Azure Cloud Computing, Data Analytics with Power BI and Microsoft Excel
Muhammad Syahrizal Bin Isnin
Muhammad Syahrizal is an Associate Trainer and has been in the training and education industry for 5 years. He has trained and facilitated in various areas such as Information Technology (IT), Corporate & Personal Development. As a certified Microsoft Office Specialist (MOS), he has trained adults in Basic and Advanced Microsoft Office applications. He also trains in other IT areas such as digital marketing, Google Apps, cloud computing and others. Besides IT, as for Corporate & Personal Development, he has conducted various skillsets in Interpersonal, Leadership, Public Speaking, Team Building, Coaching, Managing People Successfully, Delivering Effective Customer Service, Service with a Smile, Persuasive and Influencing and others.
Muhammad Syahrizal is an Associate Trainer and has been in the training and education industry for 5 years. He has trained and facilitated in various areas such as Information Technology (IT), Corporate & Personal Development. As a certified Microsoft Office Specialist (MOS), he has trained adults in Basic and Advanced Microsoft Office applications. He also trains in other IT areas such as digital marketing, Google Apps, cloud computing and others. Besides IT, as for Corporate & Personal Development, he has conducted various skillsets in Interpersonal, Leadership, Public Speaking, Team Building, Coaching, Managing People Successfully, Delivering Effective Customer Service, Service with a Smile, Persuasive and Influencing and others.
Cecil Lum
A certified trainer and marketing leader with over 15 years of experience in both traditional and digital marketing, specifically in search engine optimization (SEO), search engine marketing (SEM), content management, e-commerce and social media marketing. Cecil holds a certification in WSQ Advanced Certificate in Training and Assessment (ACTA) and is MOE certified.
A certified trainer and marketing leader with over 15 years of experience in both traditional and digital marketing, specifically in search engine optimization (SEO), search engine marketing (SEM), content management, e-commerce and social media marketing. Cecil holds a certification in WSQ Advanced Certificate in Training and Assessment (ACTA) and is MOE certified.
Candy Sim
ACTA certified trainer with 8 years of training experience. ICDL certified in Digital Marketing and Spreadsheets. Been conducting WSQ ICT courses including Digital Marketing, Social Media Marketing, Search Engine Optimization (SEO), Microsoft Office applications, Innovate Customer Experience etc.
ACTA certified trainer with 8 years of training experience. ICDL certified in Digital Marketing and Spreadsheets. Been conducting WSQ ICT courses including Digital Marketing, Social Media Marketing, Search Engine Optimization (SEO), Microsoft Office applications, Innovate Customer Experience etc.
Edmund Tan
There is a saying, “Never stop Learning because Life never stops Teaching”. Edmund is an Advanced Certificate in Learning and Performance (ACLP) certified Trainer. He has conducted many ICT related courses for public and corporate learners, such as Microsoft Office (Excel, Word, PowerPoint), ICDL certification programs like Computer Essentials, Online Essentials, Online Collaboration, Data Analytics and also various WSQ training courses. He is an ICDL Accredited Tester and also an MOE registered instructor conducting enrichments classes/workshops for Primary, Secondary and Polytechnic students.
There is a saying, “Never stop Learning because Life never stops Teaching”. Edmund is an Advanced Certificate in Learning and Performance (ACLP) certified Trainer. He has conducted many ICT related courses for public and corporate learners, such as Microsoft Office (Excel, Word, PowerPoint), ICDL certification programs like Computer Essentials, Online Essentials, Online Collaboration, Data Analytics and also various WSQ training courses. He is an ICDL Accredited Tester and also an MOE registered instructor conducting enrichments classes/workshops for Primary, Secondary and Polytechnic students.
Velarie Quek
Velarie has been teaching since 2016 in soft skills and computer skills. She has experienced in teaching computer essential, tablet essential, Words, PPT, Excel, Online Collaboration to WSQ soft skills program such as Workplace Communication, Service Excellence, Work in a Team, SkillFuture Digital Workplace, Mobile Device Productivity, Lets Go Shopping and Selling. She is ACTA certified trainers and recently, she is taking a course in Advanced Certificate in PDPA Operational Excellence to enhance her knowledge in teaching.
Velarie has been teaching since 2016 in soft skills and computer skills. She has experienced in teaching computer essential, tablet essential, Words, PPT, Excel, Online Collaboration to WSQ soft skills program such as Workplace Communication, Service Excellence, Work in a Team, SkillFuture Digital Workplace, Mobile Device Productivity, Lets Go Shopping and Selling. She is ACTA certified trainers and recently, she is taking a course in Advanced Certificate in PDPA Operational Excellence to enhance her knowledge in teaching.
Previous
Next
Maymond Batchelor
An IT Professional with more than 20 years of IT experience with extensive hands-on and broad technical knowledge. Involved in Local, Regional IT technical support and managerial roles in MNC such as SKF, IBM, Seagate, BD before taking on an Educator role in 2016. Validated technical competencies by attaining various certifications from Cisco, Google, Microsoft, ICS2, ISACA, Checkpoint, Fortinet, ITIL etc. Achieved Advanced Certificate in Training and Assessment (ACTA) in Feb 2017. A Microsoft Certified Trainer (MCT) specialised in Microsoft Azure Cloud Computing, Data Analytics with Power BI and Microsoft Excel
An IT Professional with more than 20 years of IT experience with extensive hands-on and broad technical knowledge. Involved in Local, Regional IT technical support and managerial roles in MNC such as SKF, IBM, Seagate, BD before taking on an Educator role in 2016. Validated technical competencies by attaining various certifications from Cisco, Google, Microsoft, ICS2, ISACA, Checkpoint, Fortinet, ITIL etc. Achieved Advanced Certificate in Training and Assessment (ACTA) in Feb 2017. A Microsoft Certified Trainer (MCT) specialised in Microsoft Azure Cloud Computing, Data Analytics with Power BI and Microsoft Excel
Muhammad Syahrizal Bin Isnin
Muhammad Syahrizal is an Associate Trainer and has been in the training and education industry for 5 years. He has trained and facilitated in various areas such as Information Technology (IT), Corporate & Personal Development. As a certified Microsoft Office Specialist (MOS), he has trained adults in Basic and Advanced Microsoft Office applications. He also trains in other IT areas such as digital marketing, Google Apps, cloud computing and others. Besides IT, as for Corporate & Personal Development, he has conducted various skillsets in Interpersonal, Leadership, Public Speaking, Team Building, Coaching, Managing People Successfully, Delivering Effective Customer Service, Service with a Smile, Persuasive and Influencing and others.
Muhammad Syahrizal is an Associate Trainer and has been in the training and education industry for 5 years. He has trained and facilitated in various areas such as Information Technology (IT), Corporate & Personal Development. As a certified Microsoft Office Specialist (MOS), he has trained adults in Basic and Advanced Microsoft Office applications. He also trains in other IT areas such as digital marketing, Google Apps, cloud computing and others. Besides IT, as for Corporate & Personal Development, he has conducted various skillsets in Interpersonal, Leadership, Public Speaking, Team Building, Coaching, Managing People Successfully, Delivering Effective Customer Service, Service with a Smile, Persuasive and Influencing and others.
Edmund Tan
There is a saying, “Never stop Learning because Life never stops Teaching”. Edmund is an Advanced Certificate in Learning and Performance (ACLP) certified Trainer. He has conducted many ICT related courses for public and corporate learners, such as Microsoft Office (Excel, Word, PowerPoint), ICDL certification programs like Computer Essentials, Online Essentials, Online Collaboration, Data Analytics and also various WSQ training courses. He is an ICDL Accredited Tester and also an MOE registered instructor conducting enrichments classes/workshops for Primary, Secondary and Polytechnic students.
There is a saying, “Never stop Learning because Life never stops Teaching”. Edmund is an Advanced Certificate in Learning and Performance (ACLP) certified Trainer. He has conducted many ICT related courses for public and corporate learners, such as Microsoft Office (Excel, Word, PowerPoint), ICDL certification programs like Computer Essentials, Online Essentials, Online Collaboration, Data Analytics and also various WSQ training courses. He is an ICDL Accredited Tester and also an MOE registered instructor conducting enrichments classes/workshops for Primary, Secondary and Polytechnic students.
Cecil Lum
A certified trainer and marketing leader with over 15 years of experience in both traditional and digital marketing, specifically in search engine optimization (SEO), search engine marketing (SEM), content management, e-commerce and social media marketing. Cecil holds a certification in WSQ Advanced Certificate in Training and Assessment (ACTA) and is MOE certified.
A certified trainer and marketing leader with over 15 years of experience in both traditional and digital marketing, specifically in search engine optimization (SEO), search engine marketing (SEM), content management, e-commerce and social media marketing. Cecil holds a certification in WSQ Advanced Certificate in Training and Assessment (ACTA) and is MOE certified.
Candy Sim
ACTA certified trainer with 8 years of training experience. ICDL certified in Digital Marketing and Spreadsheets. Been conducting WSQ ICT courses including Digital Marketing, Social Media Marketing, Search Engine Optimization (SEO), Microsoft Office applications, Innovate Customer Experience etc.
ACTA certified trainer with 8 years of training experience. ICDL certified in Digital Marketing and Spreadsheets. Been conducting WSQ ICT courses including Digital Marketing, Social Media Marketing, Search Engine Optimization (SEO), Microsoft Office applications, Innovate Customer Experience etc.
Velarie Quek
Velarie has been teaching since 2016 in soft skills and computer skills. She has experienced in teaching computer essential, tablet essential, Words, PPT, Excel, Online Collaboration to WSQ soft skills program such as Workplace Communication, Service Excellence, Work in a Team, SkillFuture Digital Workplace, Mobile Device Productivity, Lets Go Shopping and Selling. She is ACTA certified trainers and recently, she is taking a course in Advanced Certificate in PDPA Operational Excellence to enhance her knowledge in teaching.
Velarie has been teaching since 2016 in soft skills and computer skills. She has experienced in teaching computer essential, tablet essential, Words, PPT, Excel, Online Collaboration to WSQ soft skills program such as Workplace Communication, Service Excellence, Work in a Team, SkillFuture Digital Workplace, Mobile Device Productivity, Lets Go Shopping and Selling. She is ACTA certified trainers and recently, she is taking a course in Advanced Certificate in PDPA Operational Excellence to enhance her knowledge in teaching.
Previous
Next
REVIEWS
Previous
Next
COURSE FEES AND FUNDINGS
Full Fee:
$450
Course Fees after 90% SSG Subsidy*:
$135
Course Fees after GST:
$166.50
Find out more about your eligibility for subsidies and grants here
From
S$166.50
S$166.50
After 70% subsidy (if eligible). Full Fees: $450 before GST
WSQ ADVANCED EXCEL
PERFORM ADVANCED SPREADSHEET FUNCTIONS 2016
Click the button above to sign up for the course
From S$166.50
after 70% subsidy
