Tickets

Course Fees

Sales close in about 1 year

Rs 6000.00 × = Rs 0


Rs 0

All tickets are priced in INR.


We-accept

Event Details

About

 

Business Analytics using Excel

 

Our Business Analytics with Excel course is designed to help you get introduced to the world of analytics. This training will provide you with the concepts, knowledge and hard skills required for building a strong analytics career. For a person with knowledge and experience in the IT or any core industry, this course will equip you to understand data and make data-driven decisions us.

 

For those new to the analytics field, this course provides an excellent foundation of required concepts and skills. This business analytics training also goes 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 learn Power BI, which is currently the latest and best tool provided by Microsoft for analytics and data visualization.

 

Duration: 24 hours

 

Course Outline:

 

 

Introduction to Business Analytics

 

Ø  Introduction

 

Ø  Types of Analytics

 

Ø  Areas of Analytics

 

 

 

Formatting Conditional Formatting and Important Functions

 

Ø  Introduction

 

Ø  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

 

Ø  Exercises

 

 

 

 

 

 

 

 

 

Analyzing Data with Pivot Tables

 

Ø  Introduction

 

Ø  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

 

Ø  Exercises

 

 

 

Dashboarding

 

Ø  Introduction

 

Ø  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

 

 

 

 

 

Business Analytics With Excel

 

Ø  Introduction

 

Ø  Concept Video Histogram

 

Ø  Concept Video Solver Addin

 

Ø  Concept Video Goal Seek

 

Ø  Concept Video Scenario Manager

 

Ø  Concept Video Data Table

 

Ø  Concept Video Descriptive Statistics

 

Ø  Exercises

 

 

 

Data Analysis Using Statistics

 

Ø  Introduction

 

Ø  What Is in It for Me

 

Ø  Moving Average

 

Ø  Hypothesis Testing

 

Ø  ANOVA

 

Ø  Covariance

 

Ø  Correlation

 

Ø  Regression

 

Ø  Normal Distribution

 

Ø  Exercises

 

 

 

Power BI

 

Ø  Introduction

 

Ø  What is it and how to use it – different types

 

Ø  Power Pivot

 

Ø  Power View

 

Ø  Power Query

 

Ø  Power Map

 

Ø  Exercises

    

Map

Contact

Barin @ 9051092035
Shrabana @ 8420594969