WSQ INTERMEDIATE EXCEL COURSE

PERFORM SPREADSHEET FUNCTIONS 2016​

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

Most jobs that you go into these days will need you to manage some form of data. Data such as customer purchases, payments, receipts, customer data, inventory, survey results, appointments, etc.

This data is managed most often using the famous software Microsoft Excel. But if you’re going into a digital working environment for the first time, where do you learn these skills?

Most companies are going to expect you to know how to use the software on your first day.

Join our 1-day course that covers everything you need to know about Excel such as:
✔ Why do we collect data
✔ Types of data processing that are required
✔ Typical data formats
✔ Introduction to what Microsoft Excel looks like
✔ What types of work can be done on Microsoft Excel
✔ Entering and storing data with Microsoft Excel
✔ Formatting data for easy statistical analysis
✔ A quick overview of data analytics and use of statistical tools

WHO IS THIS COURSE FOR

For first time users of Microsoft Excel / Spreadsheets.

No prior experience required.

COURSE OUTLINE

This course is grouped into 7 main sections. Click on each one to see the content that is covered in the section.

  • Editing Cell Contents
  • Copy and Moving Cells & Clipboard
  • Checking Spelling
  • Insert & Delete Cells, Rows & Columns
  • Using Undo and Redo
  • Finding and Replacing Content
  • Adding Comments to Cells
  • Overview of Formulas and Cell References
  • Entering Formulas
  • Formulas with Multiple Operators
  • Inserting and Editing a Function
  • Using Logical Functions
  • Displaying and Printing Formulas
  • Understanding Formula Errors
  • Formatting Text & Values
  • Adjusting Row Height and Column Width
  • Working with Cell Alignment
  • Adding Cell Borders & Background Colours
  • Copying Formatting
  • Sort by One & Multiple Columns
  • Filtering Data
  • Using Workbook Views
  • Select, Switch, Insert, Delete, Rename, Move & Copy Worksheets
  • Splitting and Freezing a Window
  • Creating Headers and Footers
  • Hide Rows, Columns, Worksheets & Windows
  • Setting the Print Area
  • Adjusting Page Margins and Orientation
  • Adding Print Titles, Gridlines, Row & Column Headings
  • Adjusting Paper Size & Print Scale
  • Printing Worksheets and Workbooks
  • Choosing and Selecting the Source Data
  • Choosing the Right Chart & Elements
  • Inserting, Moving and Resizing a Chart
  • Editing, Adding, and Removing Chart Data
  • Change Chart Data, Layout, Style & Labels
  • Changing the Chart Gridlines
  • Emphasizing Data
  • Applying Different Chart Type
  • Modifying Chart Background
  • Formatting Chart Elements
  • Customizing the Ribbon
  • Quick Access Toolbar
  • Excel’s Default Options

TRAINERS

REVIEWS

COURSE FEES AND FUNDINGS

Full Fee:
$395

Course Fees after 70% SSG Subsidy*:
$118.15

Course Fees after GST:
$146.15

Find out more about your eligibility for subsidies and grants here

From
S$146.15
After 70% subsidy (if eligible). Full Fees: $395 before GST

WSQ Intermediate Excel

PERFORM SPREADSHEET FUNCTIONS 2016​​
Click the button above to sign up for the course

From S$146.15

after 70% subsidy