HURRY UP LIMITED SEAT~ BOOK YOUR SEAT FOR ENROLLMENT~CALL/WHATSApp 7044871915/ 8420594969
CLASSES ARE AVAILABLE ON WEEKDAYS / WEEKENDS ALSO.
This is a weekend batch. Classes will be held on every SUNDAYS for 6 consecutive SUNDAYS.
Duration: 1&1/2 months - 6 SUNDAYS
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
The COURSE OUTLINE delivered during the class is as follows -
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
Exercises
We also conduct Advanced Excel Macros & PowerPoint courses on Weekdays and Weekdays.
Our Advantage:
1 Excellent faculty who conducts trainings on
Weekdays/Weekends.✓
2. Fabulous feedback from previous participants✓
3. Complete hands-on workshop✓
4. Materials and certificate after completion✓
5. Placement assistance✓
6. Small Batch size.✓
7. Flexible schedule✓
8. Convenient locations✓
9. Online classes also available✓
FOR CORPORATE TRAINING CALL@ 8274830691 or 8420594969 OR MAIL US AT [email protected] or [email protected]
VISIT OUR WEBSITE: www.paliumskills.com
Event Venue
Palium Skills, 1/22 Poddar Nagar, Kolkata, India
INR 6000.00