Business Analytics using Excel

Schedule

Sun Jul 24 2022 at 11:00 pm to Mon Jul 25 2022 at 12:00 am

Location

Palium Skills Professional Training Institute in Kolkata | Kolkata, WB

HURRY UP LIMITED SEAT~ BOOK YOUR SEAT FOR ENROLLMENT~CALL/WHATS UP ABHIJIT BASU ~ +917003926799

CLASSES 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


Power BI


Introduction


What is it and how to use it – different types


Power Pivot


Power View


Power Query


Power Map


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@ 9051092035 or 8420594969 OR MAIL US AT [email protected] or [email protected]

VISIT OUR WEBSITE: www.paliumskills.com

Where is it happening?

Palium Skills Professional Training Institute in Kolkata, 1/22 Poddar Nagar, 1st Floor, 'Sheeba Bhavan' (Near South City Mall), Katju Nagar, Jadavpur, Kolkata, West Bengal 700068, India
Tickets

INR 7500.00

Palium Skills

Host or Publisher Palium Skills

It's more fun with friends. Share with friends