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

  • Joomla! 3: An Essential Management System

    Joomla! 3: An Essential Management System

    SGD $40.00

    Course Description

    Joomla is a popular and highly functional content management system. Joomla is a mobile ready, responsive system that will adapt to user platforms and is extremely user friendly for both site users and site managers. In this VTC course, author Melanie Hedgespeth will show you how to install Joomla and work with the site from an administrative standpoint. From the administration side of Joomla you will learn how to handle users and permissions, increase Joomla functionality with extensions, change templates and most importantly how to keep your site secure and backed up.Keep your back covered with Joomla!- Learn how you can keep your page secure and backed up with Joomla- Know how Joomla can play a constructive part in maintaining your page - Learn how Joomla can prevent malicious acts on your page ​- Understand how Joomla's key functions can fend off attacks on your pagesThis course is SkillsFuture Credit Eligible.

    Read more...

  • Corel Painter 12 Advanced: Create Digital Art Pieces

    Corel Painter 12 Advanced: Create Digital Art Pieces

    SGD $45.00

    Course Description

    Corel Painter 12 is a completely revolutionary update for the popular natural media emulator. Awesome new features, massive computing power improvements, and a completely redesigned user interface make this version a must have for anybody serious about producing artwork on a computer. Taught by longtime illustrator and fine artist Jason Maranto, this Corel Painter 12 Advanced course is designed to quickly take your understanding of this powerful application to a higher level. Focusing heavily on the highly customizable nature of Painter while using an in-depth but easy-to-follow style, this VTC course will help you to master Painter and create with confidence like never before.Dive into Corel Painter and unleash your artistic flare!- Learn about the tools and techniques available in Corel Painter - Know about the different types of tools and techniques used in Corel Painter - Discover the capability of Corel Painter to create dynamic creative content - Be able to produce content that can rival physical painting This course is SkillsFuture Credit Eligible.

    Read more...

  • Creating Dynamic Presentations

    Creating Dynamic Presentations

    SGD $40.00

    Course Description

    Creating meaningful presentations is easier than ever using powerful tools that incorporate mobile technology, touch interfaces, and interactive media. This course explores the most common presentation software available and showcases workflows that are useful in creating dynamic presentations. University professor Sam McGuire helps viewers explore ways to get past the tools and focus on the storytelling involved with your presentations.Wow your audience with your next presentation!- Know how to make use of the resources that you have - Learn how to use different types of media in your presentation- Learn how to present an effective presentation - Learn various presentation tips at the end of this course

    Read more...


Content

Introduction

Preview Available

+

Welcome

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

+

Tables

Filters and Sort

Filtering Tables with Slicers

Subtotal Troubleshooting

Subtotal Tricks

Patterns and Sparklines

Pivot Tables

+

Data Extraction and Creation

Calculations and Summarization

Formulas

Slicers and Filters

Pivot Charts and Menu Formats

PowerPivot

+

Introduction to PowerPivot

Relationships

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

VLOOKUP with Approximate

VLOOKUP with IF

Matching Functions

+

Create a Table of Contents

Finding Duplicates

MATCH

INDEX

MATCH and INDEX together

Functions for Manipulating Text

+

String Extractions

Case Functions and CONCATENATE

REPLACE and SUBSTITUTE

Data Cleaning

+

Cleaning Empty Cells

Cleaning continued

Text to Column

ISERROR Function

Arrays

+

About Arrays

Creating

Including IF Statements

Array Exercises from the Help Menu

Macros

+

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

Security

R1C1 Reference

VBA

+

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

Properties

Adding Descriptions

Auditing and Other Features

+

Tools for Formulas

Tracing calculations

Tracing calculations continued

Watches and Formula Bar

Analysis Tools

+

Toolpak

Goal seek

Solver

Add Ons

Remembering the User

Scenarios

+

The Power of Scenarios

Using Named Ranges

Creating a Scenario

Scenario Summary

Dashboards

+

Power of the Dashboard

Templates

Creating Dashboards

Business Intelligence

About the Author

+
Resource Files

Wrap Up

SkillsFuture Credit Eligible
SGD $40.00
(Price excludes GST)
GET ACCESS NOW
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.