Understand Data Analytics with Microsoft Excel


  • Understand Data Analytics with Microsoft Excel, Singapore elarning online course
  • Understand Data Analytics with Microsoft Excel, Singapore elarning online course
  • Understand Data Analytics with Microsoft Excel, Singapore elarning online course
  • Understand Data Analytics with Microsoft Excel, Singapore elarning online course
  • Understand Data Analytics with Microsoft Excel, Singapore elarning online course
  • 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

  • Learn about Digital Audio with Steinberg Cubase 6

    Learn about Digital Audio with Steinberg Cubase 6

    SGD $49.00

    Course Description

    Steinberg's Cubase 6 is the latest update to the extremely popular professional digital audio workstation music software. In this course, author Mark Struthers will demonstrate how to make initial input and output connections to the program from the soundcard before examining routing in more detail. Additionally, insert and group effects are explored to help show how to enhance recorded audio tracks. Mark will walk you through the many-featured project window before showing you how to create and save your own project. Within the Cubase workflow, important terms such as clips, events, and parts are explained along with the distinction between lanes and tracks. Mark also covers insert and send effects, quantization, time stretch, and the Media Bay. Cubase comes equipped with VST instruments and, in particular, Groove Agent One and Halion Sonic SE are explored before working through the concepts behind a final mix and export to a finished audio track. Be able to produce music recording, arranging and editing with Steinberg. - Learn how to work with audio files using Steinberg- Know how Steinberg works as an audio editing software- Enable yourself to be able to produce your own music with Steinberg - Learn about the different techniques used in Steinberg to achieve quality audioThis 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...

  • FileMaker Pro 13: Beginner

    FileMaker Pro 13: Beginner

    SGD $76.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 beginner level and uses a single invoicing example to demonstrate all the features in FileMaker Pro 12 and 13. Feature that include: field creation, finding, sorting, layout mode, container fields, auto entry, validation, printing, scripts, calculations, importing, exporting, interface design as well as new FileMaker Pro 13 features: charting, snapshot links and the inspector. 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...


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.