Business Analytics with Excel Training

Business Analytics with Excel Training Course

Click on the buttons inside the tabbed menu:

Course Description

The Business Analytics with Excel program is designed to lead the participant to understand the Business Analytics domain and to successfully work in this domain.
There are multiple courses available to fit the requirement of students and working Professionals. 1. Business Analytics with Excel suitable for those who want to get started on the growing Data Science domain. 2. A more intense Business Analytics with Python or R-programming for those intending to pursue a more indepth career in this domain  
What skills will the student gain?
After the completion of this course, the student will be able to:

  • Understand the what services are offered in Business Analytics
  • ·   Learn about Data Science and its usage
  • ·   Learn about the Excel features relevant to Data Analytics
  • ·  
  • ·  
  • ·  

Mode of Training

The Business Analytics with Excel training is delivered in the following modes - Regular Classroom, Fast-track and Online live trainer


The training is offered in locations like Chennai, Bangalore, Kolkata, Mumbai and NCR.

To know more about the schedules in those cities click here -->

Schedule for Kolkata

Outside the country it is delivered in Dhaka, Thimpu, Singapore, Kuala Lumpur, Middle East, Africa and Australia.

The course outline delivered during the class is as follows -

Introduction to Business Analytics


Types of Analytics

Areas of Analytics

Formatting Conditional Formatting and Important Functions


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




Exercises Analyzing Data with Pivot Tables


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




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


Business Analytics With Excel


Concept Video Histogram

Concept Video Solver Addin

Concept Video Goal Seek

Concept Video Scenario Manager

Concept Video Data Table

Concept Video Descriptive Statistics


Data Analysis Using Statistics


What Is in It for Me

Moving Average

Hypothesis Testing





Normal Distribution


Power BI


What is it and how to use it – different types

Power Pivot

Power View

Power Query

Power Map



If you are located outside Kolkata or would like to attend our session during your visit to Kolkata then please feel free to write us at for any queries related to program,
upcoming schedule and fee. Call: +91-9051092035 or WhatsApp: +91-9051092035

Schedule for Business Analytics with Excel Training in 2018 is as follows:
Month Dates No of Hours
January Completed
February Completed
March Completed
April Completed
May Completed
June Completed
July Completed
August 26th Aug (Fast-track) 30
September 4th - weekday, 23rd - fast-track 30
October TBA 30
November 4th - fast-track,6th - weekday 30
December 2nd - fast-track, 4th - weekday 30

Study Mode & Fees

Certification Name Delivery Mode Fees Special Offers
Business Analytics with Excel Classroom Rs. 8,000+ 18% GST Discount for 5+ enrollments
Business Analytics with Excel Certification Classroom Rs. 11,000 + 18% GST Discount for 3+ enrollments and Deep Discount for 5+ enrollments


The commonly asked questions pertaining to Business Analytics with Excel training are -

Q: What are the pre-requisites for taking the Business Analytics with Excel course?

A: Basic computer knowledge is the only pre-requisite

Q: Will this be theoretical or hands-on?

A: This is a complete hands-on training where the trainer will demonstrate each feature and participants will follow and do the same on the system.

Q: Will I get access to the system?

A: Yes, trainer will demonstrate how to register for the instance. You will need to use your card to authenticate yourself and access the system

Q: Will I incur any charges for accessing the application?

A: The standard features are available for free. There are some premium services for which charges maybe imposed by Microsoft.

Q: What if I have doubts after completing the class?

A: You can gather your doubts and come by prior appointment to get your doubts cleared.

Q: What help will I get for clearing the Certification Exam?

A: Our trainer is a Certified person and will provide guidance and tips for clearing the exam. Besides, you will get access to dumps for clearing the exam

Q: Will I receive a certificate for the course?

A: Yes, participants receive a certificate after completing the course provided they have attended 90% of the class.

Get help now
CONTACT US +91-9051092035 (24×7)
WhatsApp +91-9051092035 (24×7)
Enquire Now

A Few Things You’ll Love!

  • Accredited Training Partner
  • Certified & Industry Experts Trainers
  • Multiple Training Delivery Models
  • Customized Course
  • 24/7 e-Learning Access
  • Assessments and Mock Tests
  • Placement Assistance

Palium Skills