Introduction to Business Analytics with MS Excel (E-Learning)

Business Analytics with Excel

You will learn some important tools and techniques to proceed with Business Analytics of your own without getting yourself into complex mathematical and statistical modelling. You will become familiar with the processes needed to develop, report, and analyze business data.

You will learn how to use PivotTable to quickly summarize large amounts of data into a meaningful report, analyse and visualise data in various ways that can provide deep insights.

You will learn how to use Power Query to consolidate several files with the same format, clean & transform your data that you download from your company’s database system and display it in a report for Excel to work with.

You will learn how to use Power Pivot to analyse databases of several million lines by extracting aggregated information according to the rules set by your business and it allows users to create data models from tables previously cleaned by Power Query.

If you are a manager and you want to differentiate yourself or create a competitive advantage for you, Introduction to Business Analytics with Excel is right course for you.

This is a 4-Hour self-paced E learning course consisting of 5 modules with 1 month account validity to finish the course. Upon successful completion the course, you will receive a course completion certificate from  Aventis Learning Group that will be able to enhance your portfolio.

By the end of this self-paced e learning course, learners will be equipped to: 

• Use important analytic functions to analyze data
• Apply Conditional Formatting rules to visualize data in a more efficient way
• Use Excel Table and chart to create a dynamic spreadsheet report
• Create a dynamic dashboard with PivotCharts
• Use Power Query to Import multiple files, merge multiple tables, clean and transform the data
• Use Power Pivot to import multiple tables and create relationships between tables
• Use Power Pivot to create calculated columns with DAX functions, create measure and KPI
• Use Power Pivot to create an interactive Dashboard

This course is suitable for both beginners and working professionals who are keen to deepen their understanding in the field of Business Analytics through the use of Microsoft Excel. 

Module 1: Analytic Functions

1.1 Cell References and Defined Names

1.2 Logical and Statistical Functions

1.3 Database Functions

1.4 Lookup Functions

Module 2: Data Visualisation

2.1 Creating Custom Formats

2.2 Applying Conditional Formatting

2.3 Inserting Sparklines

2.4 Interactive Spreadsheet Reporting

Module 3: data Analysis with Pivot Table

3.1 Using Pivot Table to Analyse Data

3.2 Performing Calculations in Pivot Table

3.3 Creating Data Model in Pivot Table

Module 4: Dynamic Dashboard Reporting

4.1 Dashboard Introduction

4.2 Creating a Slicer-driven Dashboard

4.3 Creating Dashboard with Form Controls

Module 5: Power Query and Power Pivot

5.1 Working with Power Query

5.2 Transforming Data with Power Query

5.3 Working with Power Pivot

5.4 Creating Power Pivot Dashboard