-
Mode of Delivery
Face to face delivery on campus -
Computers and Software Provided
Fast and reliable PCs to learn on
-
Course Duration
16 hours (2 days) -
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
This is the ideal course for users who work on excel everyday to break through their traditional workflows and use Excel 365 for the incredible abilities that come standard… but nobody ever uses.
This short 2 day course focuses on some of the most commonly sought after excel tools in a hands on and interactive environment.
At the end of the 2 day course, learners will be able to perform incredibly advanced excel functions and accelerate their work tasks through to completion.
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
- Vlookup Hlookup Xlookups
- Creating and Modifying Pivot Tables
- Absolute vs Relative References
- Sorting, Filtering, AutoFills
- Insert/ Delete/ Modify Columns
- Wrapping / Merging / Centering
- Freezing and Unfreezing Views
- Format Dataset as Tables with Styles
- Tools for Data Cleansing (text to columns, upper/lower case, trims, left, query)
- Format cells for standardised formats
- Troubleshooting values and formula errors
- Advanced filter functions
- Handling Missing Data
- Find and Replace
- Conditional formatting for data interpretation
- Cell Referencing Methods
- Nested functions (if, if-or, if-and, countif, sumif, and logicals)
- Filtering by conditions
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:
$620
Course Fees after 70% SSG Subsidy*:
$186
Course Fees after GST:
$235.60
Find out more about your eligibility for subsidies and grants here
From
S$235.60
S$235.60
After 70% subsidy (if eligible). Full Fees: $620 before GST
WSQ EXCEL 365 ADVANCED
DATA AND STATISTICAL ANALYSIS 2
Click the button above to sign up for the course
From S$229.40
after 70% subsidy
