Notice : You are now accessing LOOP UAT SERVER. This is not meant for public access. For the actual LOOP Website please visit www.LOOP.sg instead


Understand Data Analytics with Microsoft Excel


Understand Data Analytics with Microsoft Excel, Singapore elarning online course

Course Description

In today's world, we must navigate through a sea of data and simplify it into decisions for growth, problem solving, and success. By learning the data-analysis techniques and features of Microsoft excel we can master the fast growing world of Analytics. Microsoft Excel is the most common analysis software on the market today, but few users are aware of its full powers. In this advanced course, users will master the tasks necessary in order to handle today's complex data sets, including data validation, data analysis, charting, and design. * Learn how to use Excel and your data to support decision making * Master functions and calculations that streamline your analysis * Simplify statistics through the use of Excels analysis features * Learn to automate repetitive tasks and quickly spot patterns * Translate your analysis into meaningful charts and graphs.

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


Course Objectives

1. Understand the concept of Decision Making using Analytics 
2. Understand the basics of Microsoft Excel 
3. Know the different analytics functions in Excel 
4. Able to prep data and how to input for analysis 
5. Know how to visualise charts, graphs and lines using results

 


Related Courses

  • Avid Pro Tools 10: Know how to work with audio

    Avid Pro Tools 10: Know how to work with audio

    SGD $49.00

    Course Description

    VTC's Avid Pro Tools 10 course introduces the new features in this latest release of the audio recording and music production powerhouse. From clip gain and disk caching to new plug-ins and workflows, this version of ProTools is both powerful and exciting. Sam McGuire covers these new features and also explores many of the traditional features using real world examples and practical demonstrations. Whether you are a novice or a seasoned professional, you will find this course both insightful and entertaining.Learn how to work with audio files using Avid Pro Tools. - Know how Avid Pro Tools handles audio - Learn how to edit your own audio files with Avid Pro Tools- Discover the potential of Avid Pro Tools with your audio files- Master audio editing with all the right tools and techniques in Avid Pro ToolsThis course is SkillsFuture Credit Eligible.

    Read more...

  • Discover the Benefits of VMWare Workstation 8

    Discover the Benefits of VMWare Workstation 8

    SGD $45.00

    Course Description

    Virtual computing is one of the most exciting and in-demand aspects of Information Technology. From the user's laptop to the back office server, virtual computing is changing the way we think about and utilize our physical machines. VMWare is the industry leader in virtualization technology and product innovation. Workstation 8 is the latest version of the most popular desktop virtualization software available. It provides a mature, stable, and innovative environment for creating and managing virtual machines. It is also the place to begin to introduce yourself to the world of virtual computing and the place to begin your quest to become certified on VMWare's extensive product line. In this VTC course, author Mark Long will introduce you to Workstation 8 and guide you through the process of using Workstation to create, manage, and utilize virtualization on your computer, whether you are using a laptop or a multi-processor server. VMWare is the industry leader in virtualization technology and product innovation.- Know more about the functions of VMWare- Learn about the benefits of using VMWare - Discover how VMWare can provide a smoother working experince - Learn more about the comcpet of using VMWare This course is SkillsFuture Credit Eligible.

    Read more...

  • Google Apps for Business

    Google Apps for Business

    SGD $45.00

    Course Description

    Whether you are a business owner, personal google apps user, or google apps administrator, this VTC Google Apps for Business course has been designed to take you from a beginner to an advanced user in no time at all. It will cover each Google App in detail including lots of great functionality that will impress your friends, family, and co-workers. You can easily jump to sections of the course that are relevant to you, including Google Apps Setup, Gmail, Contacts, Tasks, Calendar, Groups, and Drive. Drive is really where cloud computing comes to life; Documents, Spreadsheets, Presentations, and Forms each get their own chapter because their functionality is so rich. This phenomenal course is packed to brim with goodness and draws upon Andrew Martin's many years of experience working with and teaching Google Apps. Get ready to transform your way of working while you bring collaboration and efficiency to your project or company. TKnow all about Google's Apps with this course!- Learn about the different applications in Google - Understand how the different applications function- Learn about the features and functions of Google Apps - Know how to make full use out of the features 

    Read more...


Content

Introduction

Preview Available

+

Welcome

Work Files

Analytics for Decision Making

Preview Available

+

Analysis and Decisions

Introduction to Fundtions

SumIf and Countif

IF Statement

Multiple Conditions

IF Examples

Vlookup

Nested Statement with Vlookup

Excel Tools

+

Filters

Understanding Subtotals

Creating Subtotals

Conditional Formats

Using Formulas with Conditional Formats

Data Validation

+

Introduction to Validation

Constraining Data Input

Circling Invalid Data

Creating Static Lists

Dynamic Lists with Tables and Names

Charts and Graphs

+

Changes in Excel 2013

Creating Charts

Single Point Chart and Dialog Boxes

Titles that Work

Help with Chart Types

Sparklines

Trend lines

+

Forecasting with Autofill

Inserting Trend lines

Understanding the Types

The R Squared Value

Tables and Ranges

+

Named Ranges

Named Ranges continued

Excel Tables

Vlookup and Named Ranges

Merging and Spliting Cells

Upper and Lower Case

Understanding Plugins and Add Ins

+

Installing an Add In

Collections of Add Ins

Excel BackStage

Data Analysis Tools

+

Introduction to the Tools

Descriptive Statistics

Descriptive Statistics continued

Histogram

Histogram continued

What if Analysis

+

Overview of the Tools

Goal Seek

Goal Seek continued

Scenario

Scenario continued

Scenario Manager

Solver

Named Ranges and Solver

Data Tables

+

Understanding Data Tables

Single Criteria

Double Criteria

Criteria with Conditional Formatting

Pivot Tables

+

Intro to Pivots

Tables and Pivots

The Foundation

Working with the Slicer

Pivot Charts

Calculated Fields

Conditional statements

+

Highlighting Significant Data

Icon Sets

Formulas - Coloring Columns

Formulas - Rows

Customizing Icons and Highlights

Dashboards

+

What is a Dashboard?

Creating a Dashboard

Creating a Dashboard Part II

Creating a Dashboard Part III

Automation

+

Developer Toolbar

Creating a Macro

Creating a Macro continued

Absolute vs Relative

Editing a Macro

Autocorrect

Report Writing

+

Starting with a Menu Page

Buttons rather than Hyperlinks

Key Points or Instructions

Interactive Spreadsheets

Scroll Bars

Radio Buttons

The Formulas

Presenting Data

+

Utilizing Shapes

Working with SmartArt

Link Paste and Paste Special

Edit Links

Select Visible Cells

Pasting into PowerPoint

Motion in PowerPoint

Motion continued

Comments and Review

+

A Twist on Comments

Comments with Data Validation

Protecting your Work

Protection continued

Review

+

What we Have Covered

Where to Next

About the Author

+

Wrap Up

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.