ADVANCED EXCEL COURSE

A COURSE ON PERFORMING ADVANCED SPREADSHEET FUNCTIONS 2016

EXCEL IS A CRITICAL SKILL FOR EMPLOYMENT IN 2022

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.

Advanced Formatting

Considerations in Designing a Spreadsheet
Working with Cell Styles & Document Themes
Apply, Create & Manage Conditional Formatting
Creating a Custom Number Format

Working With Tables

Create a Table & working with the Total Row
Sorting & Filtering a Table
Formatting the Table
Converting to a Range

Advanced Functions and Formulas

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

Validating Data and Auditing Worksheets

Using Data Validation
Auditing Tools
Displaying and Tracing Formulas
Understanding Formula Errors

Managing Charts

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

Working with Data Ranges

Sorting by a Custom List
Creating a Custom AutoFilter
Using Advanced Filters

Working with PivotTables

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

Analyzing Data

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

Working with Macros

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

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.

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.

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.

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.

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.

Shiraz S/O Kaderuppan

A corporate IT trainer for over 7 years, Shiraz has trained numerous professionals in the effective use and assimilation of the Microsoft Office suite of applications (including Microsoft Excel, Word, PowerPoint, Access and Project) to increase overall team productivity and efficiency. Being ACTA-certified and possessing a Microsoft Office Specialist Expert certification in Excel, Shiraz also provides customized consulting services for the use of the Microsoft Office applications on a personalized basis.

Latchmana Murlly

A tech enthusiast with more than 7 years of experience across various technologies and domains mostly in Microsft Office user specialist, Microsoft server 2016 and Cybersecurity. Keen interest in transforming others to the world of digital technologies.

REVIEWS

The trainer is very dedicated and imparts his knowledge very well. He answers all questions and attended to every student.

Course notes were written clearly and easy to follow. Trainer was extremely understanding and patient in helping his students grasp difficult concepts. Kudos to him!

I enjoyed all the learning and will definitely apply it to my job. Thank you to our very helpful trainer!

Sent my staff for training. My staff gave feedback that the trainer was committed and they enjoyed the course. They look forward to more courses!

Our trainer is knowledgeable and willing to go the extra mile to help us learn.

Trainer is friendly. Taught us slow and clear. In between questions trainer is very patient to explain. I am a pioneer.

Truly enjoyed the lessons and the networking session too for this course. The Auston staff were very friendly and supportive too. Excellent services provided and very positive experience attending lessons here. Keep it up!

Very good, thank you for the class, it was awesome!

Intensive but useful course!

Would like to compliment trainer for his professionalism and go straight to the point during the course. Am looking forward to other courses conducted by him.

The best trainer I’ve ever come across! The teaching is clear and patient in making me understand. Thank you so much.

The trainer’s expertise and patience are commendable! Very professional and helpful to all regardless of background and knowledge of individual learners.

The trainer is patient, helpful, clear and concise in his presentation.

Trainer was very patient and endeavor to answer our queries and concerns.

Thank you for the class that has been conducted in very professionally and very interesting and I got to really learn and have better understanding from it

Trainer is helpful & patience in answering our questions. Will recommend your learning centre to those who are interested in taking up those s courses that your centre conducted

Nice and I definitely learned about the application of Excel ...Thank you and trainer was good and created interest in learning

Good trainer. His teaching method is very interesting n not boring. He make you want to continue learning n want to know more.

I had enjoyed learning in this class, the teacher is very helpful in my learning process.

Thank you so much for being very generous and patient with slow learner like myself.

A very patient and knowledgable instructor. I really enjoy his lesson. He not only teach us what is in the textbook, he also give us real life situation. Thus, it give us a in-depth understanding of our learning.

The trainer is very competent in this subject and gave attention to every student and answers every question promptly.

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

OUR HAPPY CUSTOMERS

OUR CAMPUSES

READY TO SIGN UP?

Course dates, registration and many other queries can be answered on the next page when you signup.

We look forward to see you at our class!

From
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