Business Analytics Certification Training with Excel - Simplilearn | IT Training & Certification | Info Trek
Respect Your Dreams
Follow through on your goals with courses

Business Analytics Certification Training with Excel - Simplilearn

Location

Format What’s this?
Starting From
RM 1715.77
  1. 12 Hours
  1. HRDF SBL Claimable
  2. Certificate of Attendance available
  3. 180 days of access from date of purchase
  1. 0 Days
  1. All of our private classes are customized to your organization's needs.
  2. Click on the button below to send us your details and you will be contacted shortly.
Request more information

Inquiry for: Myself    My Company

By providing your contact details, you agree to our Privacy Policy

 

 

 

Thank You

Our learning consultant will get back to you in 1 business day

Business Analytics Certification Training with Excel - Simplilearn

WHAT YOU WILL LEARN

Business Analytics with Excel training has been designed to help initiate you to the world of analytics, by using the most commonly used analytics tool (Microsoft Excel). This business analytics training will equip you with all the concepts and hard skills required for a strong analytics career basis. If you already have some experience in the IT or any core industry, this business analytics course will quickly teach you how to understand data and make data-driven decisions using Microsoft Excel. For those that are new to the analytics field, this course provides an excellent foundation of required concepts and skills. This business analytics training also delves into the statistical concepts that are important in deriving insights from available data in order to present findings using executive level dashboards. Finally, you will be introduced to Power BI, which is currently the latest and best tool provided by Microsoft for analytics and data visualization.

AUDIENCE

Business Analytics with Excel is a great course for both beginners and experienced professionals who are inexperienced or have recently stepped into the field of analytics. This course is beneficial for:

• IT developers and testers

• Data analysts

• Junior data scientists

• Analytics professionals

• BI and reporting professionals

• Project managers

• Students

• Professionals working with data in any industry


PREREQUISITES

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

COURSE OBJECTIVES

With Simplilearn’s training on business analytics with Excel, you will be able to:

• Understand the meaning of business analytics and its importance in the industry

• Grasp fundamentals of excel analytics functions and conditional formatting

• Learn how to analyze with complex datasets using pivot tables and slicers

• Solve stochastic and deterministic analytical problems using tools like scenario manager, solver and goal seek

• Apply statistical tools and concepts like moving average, hypothesis testing, ANOVA and regression to data sets using Excel

• Represent your findings using charts and dashboards

• Get introduced to the latest Microsoft analytic and visualization tools i.e. Power BI


Expand All

Modules

Module 1 – Introduction
• Course Introduction
Module 2 – Introduction to Business Analytics

• Introduction

• What is in it for Me

• Types of Analytics

• Areas of Analytics

• Quiz

• Key Takeaways

• Conclusion


Module 3 – Formatting Conditional Formatting and Important Fuctions

• Introduction

• What is in it for Me

• Custom Formatting Introduction

• Custom Formatting Example

• Conditional Formatting Introduction

• Conditional Formatting Example1

• Conditional Formatting Example2

• Conditional Formatting Example3

• Logical Functions

• Lookup and Reference Functions

• VLOOKUP Function

• HLOOKUP Function

• MATCH Function

• INDEX and OFFSET Function

• Statistical Function

• SUMIFS Function

• COUNTIFS Function

• PERCENTILE and QUARTILE

• STDEV, MEDIAN and RANK Function

• Exercise Intro

• Exercise

• Quiz

• Key Takeaways

• Conclusion


Module 4 – Analyzing Data with Pivot Tables Discovering The Testing Cycle

• Introduction

• What is in it for Me

• Pivot Table Introduction

• Concept Video of Creating a Pivot Table

• Grouping in Pivot Table Introduction

• Grouping in Pivot Table Example 1

• Grouping in Pivot Table Example 2

• Custom Calculation

• Calculated Field and Calculated Item

• Calculated Field Example

• Calculated Item Example

• Slicer Intro

• Creating a Slicer

• Exercise Intro

• Exercise

• Quiz

• Key Takeaways

• Conclusion


Module 5 – Dashboarding

• Introduction

• What is in it for Me

• What is a Dashboard

• Principles of Great Dashboard Design

• How to Create Chart in Excel

• Chart Formatting

• Thermometer Chart

• Pareto Chart

• Form Controls in Excel

• Interactive Dashboard with Form Controls

• Chart with Checkbox

• Interactive Chart

• Exercise Intro

• Exercise1

• Exercise2

• Quiz

• Key Takeaways

• Conclusion


Module 6 - Business Analytics With Excel

• Introduction

• What is in it for Me

• Concept Video Histogram

• Concept Video Solver Addin

• Concept Video Goal Seek

• Concept Video Scenario Manager

• Concept Video Data Table

• Concept Video Descriptive Statistics

• Exercise Intro

• Exercise

• Quiz

• Key Takeaways

• Conclusion


Module 7 - Data Analysis Using Statistics

• Introduction

• What is in it for Me

• Moving Average

• Hypothesis Testing

• ANOVA

• Covariance

• Correlation

• Regression

• Normal Distribution

• Exercise1 Intro

• Exercise1

• Exercise2 Intro

• Exercise2

• Exercise3 Intro

• Exercise3

• Quiz

• Key Takeaways

• Conclusion


Module 8 – Power BI

• Introduction

• What is in it for Me

• Power Pivot

• Power View

• Power Query

• Power Map

• Quiz

• Key Takeaways

• Conclusion


To Be Confirm

To Be Confirm

Read More

Course Reviews

No Remarks

0

0 Ratings