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.

    Read more...

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

    Read more...

  • 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

    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.