Jun 2020

Business Analysis With Excel(LIVE Stream)

Course Information

Start Date30 Jun 2020, Tuesday
End Date30 Jun 2020, Tuesday
Time09:00 am to 05:00 pm
Fee$350 (Excluding GST), Inclusive of e-certificate, e-materials
Contact6720 3333 (Ms Rina) training.aventis@gmail.com
Register Now
Get Group Quote
LIVE Stream

In Partnership with Simplilearn

This is an ONLINE course. Participants are able to access to the online course upon completion of registration.

Once activated, the licenses will be valid for ONE YEAR from the date of activation.

Course Overview

This Business Analytics course teaches you the basic concepts of data analysis and statistics to help promote data-driven decision making. This training introduces you to Power BI and delves into the statistical concepts that will help you devise insights from available data in order to present your findings using executive-level dashboards.


Business Analytics with Excel is a great course for both beginners and experienced professionals who are inexperienced or have recently entered the analytics field. This course is beneficial for IT developers and testers, data analysts, junior data scientists, analytics professionals, BI and reporting professionals, project managers, students, and professionals working with data in any industry.


There are no prerequisites for this business analytics certification other than an analytical mindset. However, we do expect the participants to have a basic knowledge of working with Microsoft Excel.

Course Content


  • Lesson 00 – Introduction

  • Lesson 01 – Introduction to Business Analytics

  • Lesson 02 – Formatting Conditional Formatting and Important Fuctions

  • Lesson 03 – Analyzing Data with Pivot Tables

  • Lesson 04 – Dashboarding

  • Lesson 05 – Business Analytics With Excel

  • Lesson 06 – Data Analysis Using Statistics

  • Lesson 07 – Power BI

Communication Guru – Ronald van Loon

Ronald van Loon

Ronald van Loon

Top 10 Big Data and Data Science Influencer, Director – Adversitement

Named by Onalytica as one of the three most influential people in Big Data, Ronald is also an author of a number of leading Big Data and Data Science websites, including Datafloq, Data Science Central, and The Guardian. He also regularly speaks at renowned events.

The trainer was highly skilled and took the time to answer every single question, and explained how to think of the BA framework from the right perspective. The sessions were very interactive and focused on content and explained each knowledge area in detail.

Caleb Navarro