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

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


  • FileMaker Pro 12: Intermediate

    FileMaker Pro 12: Intermediate

    SGD $80.00

    Course Description

    FileMaker Pro is powerful enough to handle most database jobs yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from intermediate level and uses a single invoicing example to demonstrate FileMaker Pro 7, 8, 8.5, 9, 10, 11 and 12 features and techniques including: interface design, relational database design, relationship operators, multiple predicates, table occurrences, portal filters, security, scripts, calculations, FileMaker Pro Advanced, multi-user solutions, record locking, multi-keys, deleting duplicate records and new FileMaker Pro 11 features. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning. Discover how data can be managed efficiently. - Find out how you can manage your database- Learn ways to fully utilize your data's potential - Know how queries can be implemented to run the data better - Understand an effective solution to optimize your database's productivity This course is SkillsFuture Credit Eligible.


  • Math & Statistics: Training Tutorials for SPSS and Graphic Calculators

    Math & Statistics: Training Tutorials for SPSS and Graphic Calculators

    SGD $99.00

    Course Description

    SPSS Statistics is a software package used for statistical analysis. Long produced by SPSS Inc., it was acquired by IBM in 2009. The current versions (2015) are officially named IBM SPSS Statistics. Master Math & Statistics with this bundled course that includes training tutorials on BA II PLUS PROFESSIONAL, SPSS, TI-30XS MultiView calculator, IBM SPSS Statistics, TI-Nspire handheld, TI-Nspire CX handheld and TI-84 Plus C Silver Edition. Atomic Learning has teamed up with Texas Instruments to create tutorials that answer common questions students and teachers may have when learning how to use TI-Nspire™ and TI-Nspire™ CAS math and science learning technology. Be able to understand and utilize your analysis with SPSS. - Improve your business using SPSS analytic functions- Using SPSS, examine and solve a research problem, from hypothesis testing to the power analysis- Using BA II PLUS PROFESSIONAL to take advantage of all the same time-saving financial functions- Learn about TI-Nspire handheld, TI-Nspire CX handheld and TI-84 Plus C Silver Edition graphing calculator




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.