Discover More of Your Data with Microsoft Excel

  • Discover More of Your Data with Microsoft Excel , Singapore SKillsFuture elarning online course
  • Discover More of Your Data with Microsoft Excel , Singapore SKillsFuture elarning online course
  • Discover More of Your Data with Microsoft Excel , Singapore SKillsFuture elarning online course
  • Discover More of Your Data with Microsoft Excel , Singapore SKillsFuture elarning online course
  • Discover More of Your Data with Microsoft Excel , Singapore SKillsFuture elarning online course
  • Discover More of Your Data with Microsoft Excel , Singapore SKillsFuture elarning online course

Course Description

Microsoft Excel is one of the most popular programs to use for analyzing, extracting, and cleaning the tremendous amounts of data that we have collected. Learn how Microsoft Excel can manage and summarize your data with PowerPivot and Pivot Tables, automation and coding, along with the standard features of Arrays, functions such as MATCH and INDEX, and the Data Analysis Tools. Understand speed and file size limitations while appreciating the art of data cleaning and manipulation. Explore how the What If Analysis tools can help with plans and forecasts and consolidate and link data for interactive reports. This course will allow you to unleash the power of Excel to make accurate decisions based on your data and Excel's power.

Realise the full potential of your data with Microsoft Excel.

- Learn about the functions in Excel that can help your understand data better
- Know the different ways of vizualising your data with Excel
- Pick up the knowledge of utilizing Excel for better understanding your data
- Learn how you can stretch your data for optimum analysis

This course is SkillsFuture Credit Eligible.

Course Objectives

1. Understand the concept of Big Data 
2. Understand the basics of Microsoft Excel 
3. Understand the introduction to PowerPivot 
4. Able to prep data and how to input into PowerPivot 
5. Know how to vizualise charts and graphs with results
6. Able to apply functions, custom functions, analysis tools, data cleaning 

Related Courses

  • Explore iOS 6

    Explore iOS 6

    SGD $40.00

    Course Description

    iOS 6 is the world's most advanced mobile operating system. Version 6 brings tighter integration with social media, new maps, refinements with Siri, and so much more. This VTC course explores the new features of iOS 6 along with the basics of operation. VTC author Sam McGuire demonstrates how to set-up your device and get the most from its day to day use. Topics include: app usage, interfacing with iCloud, social media, and a host of other practical applications. This course covers everything you need to get the most from your mobile devices.Keep yourself updated with the new changes in iOS. - Learn about the changes in the latest version of iOS - Undersatand about the operating system - Discover the newly-added features in each new version - Go through an in-depth view of the features of each iOS 


  • Access 2010 and Beyond

    Access 2010 and Beyond

    SGD $99.00

    Course Description

    Microsoft Access is a DBMS (also known as Database Management System) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. Microsoft® Access® 2010 is an easy-to-use database software that helps you track and report information with ease. This training series will teach you how to use the results-oriented user interface that's context-sensitive and optimized for efficiency and flexibility. Become comfortable with the new look and feel and the many great features of Access 2010 in this online tutorial series.Maximize your skills in Microsoft Access 2010 and beyond now!- Use the results-oriented user interface and the many great features of Access 2010 to 2013- Maximize your database with Microsoft Access- Take your working knowledge of tables, queries, reports and forms to dress up your forms and reports- Know how to build your own database with personalized tables and queries This course is SkillsFuture Credit Eligible.


  • Microsoft Office for Mac 2011

    Microsoft Office for Mac 2011

    SGD $45.00

    Course Description

    Office for Mac 2011 is a powerful update of the widely used productivity suite. Mac users now have access to a slew of updated features which are designed to simplify workflow while still maintaining the incredible strength of inter-application collaboration. This VTC course explores the 2011 update through a detail driven approach and with the help of practical examples. All of the major applications in Office are covered, along with several of the lesser profile utilities. Office may be constantly changing, but that doesn't mean you need to be left behind! Jump on board with Sam McGuire and get the very most out of the tools you use on a daily basis. Find out more about Microsoft's productivity tools!- Learn and understand the purpose of Microsoft's tools- Know more about the functionality and features of each application- Learn about functions that you never knew existed in Microsoft's tools- Be fluent and an efficient user in Microsoft tools by the end of this course This course is SkillsFuture Credit Eligible.




Preview Available



Work Files

What is Big Data?

Preview Available


Working with Large files

Connecting to the Web

Databases and Text Files

The Connections Dialog Box

File Size Connections

Reviewing the Basics



Filters and Sort

Filtering Tables with Slicers

Subtotal Troubleshooting

Subtotal Tricks

Patterns and Sparklines

Pivot Tables


Data Extraction and Creation

Calculations and Summarization


Slicers and Filters

Pivot Charts and Menu Formats



Introduction to PowerPivot


Adding Data

PowerPivot KPI

Installing PowerPivot

Option Add Ins

Working with PowerPivot DAX


DAX Overview

Basic Syntax

Dax in the Pivot Table

Dynamic Charting


Review of Charting Features

Dialog Boxes

Intro to Dynamic Charts

Using the Offset Command

Dynamic Chart Continued

Interpreting and Summarizing Data


Conditional Formatting and IF

Use IF and Formulas

The AND operator and IF

Using a List with a VLOOKUP


VLOOKUP with Approximate


Matching Functions


Create a Table of Contents

Finding Duplicates



MATCH and INDEX together

Functions for Manipulating Text


String Extractions

Case Functions and CONCATENATE


Data Cleaning


Cleaning Empty Cells

Cleaning continued

Text to Column

ISERROR Function



About Arrays


Including IF Statements

Array Exercises from the Help Menu



Getting Started with Macros

Enhancing Usage and Automation

Absolute vs Relative

Viewing the Macro in VBA

Invoking macros with Form controls

Forms continued

Option Buttons


R1C1 Reference



The VBA Window

Simple Code and WorkFiles

Creating a Form

Creating a Form Continued

Adding Code

Fine tuning the Spreadsheet Form

Custom Functions


Understanding Custom Functions

Creating a Function


Adding Descriptions

Auditing and Other Features


Tools for Formulas

Tracing calculations

Tracing calculations continued

Watches and Formula Bar

Analysis Tools



Goal seek


Add Ons

Remembering the User



The Power of Scenarios

Using Named Ranges

Creating a Scenario

Scenario Summary



Power of the Dashboard


Creating Dashboards

Business Intelligence

About the Author

Resource Files

Wrap Up

SkillsFuture Credit Eligible
SGD $40.00
(Price excludes GST)
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.