Advanced Excel 365 Course​ | SkillsFuture Course Singapore

WSQ ADVANCED EXCEL COURSE

ALL THE POWERTOOLS YOU NEED TO BECOME A POWER EXCEL 365 USER

critical core skills of the future

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

REVIEWS

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
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