Precautionary measures for Covid-19
Loading Events

« All Events

  • This event has passed.

Master Advanced Data Analytics with Microsoft Excel

Live Virtual Lesson / Classroom


Course Objective
Master data analytics skills using Microsoft excel in our 2 days accredited programme. Microsoft excel is one of the top tools used in data analysis.
In this course, you will learn many popular features to perform data analysis to make better decisions for your business.

Intermediate knowledge of Microsoft Excel.

Who Should Attend?
Anyone who’s keen to perform data analytics using Microsoft Excel to improve business decision making.

Learning Outcomes
Attendees will acquire knowledge on the following areas:

  • Understanding Data mining
  • Analytics techniques with Statistical and Financial Functions
  • Data summarisation techniques Pivot Tables and PivotChart
  • What is Sampling and how to use it for data analysis
  • Types of Business Intelligence tools
  • How to use and manage multiple Data parameters
  • Data quality standards
  • Sources of data

Course Outline

  1. Databases
  2. Data Mining
    • What is Data Mining?
    • Understand Your Data
    • Sources of Data
    • Import External Data into Worksheet Using the Text Import Wizard
    • Organizing Data
    • Data Extraction using LOOKUP Functions
    • Power Query
  1. Analysis Techniques
    • Work with Math and Statistical Functions by using SUMIFS, AVERAGEIFS, and COUNTIFS
    • Work with Financial Functions by using NPV, IRR and PMT
    • Perform What-if analysis by using Goal Seek
    • Perform What-if analysis by using Scenario Manager
    • Solver
    • Data Summarisation Techniques Using PivotTable and PivotChart
    • Data Visualisation Techniques using Charts
      • Common types of Data Visualizations
      • Create, Format and Edit a Chart
      • Create Advanced Charts
      • Create a Dashboard from Excel Templates
  1. Sampling Techniques
    • What is sampling?
    • Using Data Analysis Tool to Perform Sampling
    • Limitations of Sampling Tool
  2. Business Intelligence (BI) Tools
    • An Overview of BI Tools
    • Different types of BI Tools
    • Data Analysis in Excel versus Business Intelligence Tools
    • Microsoft Power BI
  1. Data Parameters
    • Using Data Parameters
    • Managing Multiple Parameters
    • Parameters in Power BI
  1. Data Quality Standards
    • Data Validation Tool
    • Use Error-Checking Rules to Validate Formulas
    • Using Formula Auditing
    • Removing Duplicate Data


27 Feb 2021 @ 9:00 am
28 Feb 2021 @ 5:00 pm
Event Category:


+65 6931 2828


Laures Academy


The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Advanced Data Analytics with Microsoft Excel
13 - 14 March 2021 (Face-to-Face)
$ 75.00
Advanced Data Analytics with Microsoft Excel
13 - 14 March 2021 (Online)
$ 75.00
Advanced Data Analytics with Microsoft Excel
18 - 19 March 2021
$ 75.00
Advanced Data Analytics with Microsoft Excel
27 - 28 March (Online) Sat/Sun
$ 75.00

Register Your Interest