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 

    Read more...

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

    Read more...

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

    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.