Business Analytics Certification Training With Excel

Business Analytics Certification Training With Excel – Course Agenda

Lesson 1: Introduction to Business Analytics

• What is Analytics?
• Overview of different – 2 Analytic Areas
• Customer Analytics
• Industry-focused Analytics
• Financial Analytics
• Performance Analytics
• Risk Analytics

Lesson 2: Formatting, Conditional Formatting, and Important Functions

• Formatting
• Conditional Formatting
• Logical Functions
• And, If, Not, Or, True, False
• Vlookup/Hlookup, Index, Match, Offset
• Statistical and Mathematical Functions
• Rank, Quartile, Decile, Percentile
• Standard Deviation, Correlation, Mean, Median, Sum, Count, Sumifs, Countifs

Lesson 3: Analyzing Data with Pivot Tables

• Pivot Table Creation
• Grouping for different – 2 data types
• Show and Summarize Values
• Calculated Field and Calculated Items
• Slicer

Lesson 4: Dashboarding

• What is Dashboards and Excel Dashboard.
• Overview of Chart types, Chart Formatting
• Active X Form Controls
• Principle of great dashboard design
• Selecting Correct Chart to display data
• Interactive Charts with Form Controls
• Combo box, Check Box, Scroll Bar and Radio Button
• Interactive Dashboard with Form Controls

Lesson 5: Analytics with Excel

• Histogram
• Solver Add-In
• Goal Seek
• Scenario Manager

• Data Table
• Descriptive Statistics

Lesson 6: Data Analysis Using Statistics

• Descriptive Statistics
• ANOVA
• Moving Average
• Testing Hypothesis
• Measuring Covariance and Correlation
• Distribution
• Regression

Lesson 7: Power BI

• Power Pivot
• Power View
• Power Query
• Power Map