Price Free!

Course Features
language
Language: English
access_time
40 hours
spellcheck
Study Level: Intermediate
terrain
Certificate of Completion

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

chat_bubble_outlineReviews

Average Rating

0
No Votes 0 Votes
Free!
0 Ratings

Detailed Rating

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

There are no reviews yet.

Be the first to review “Data analyst with EXCEL”

Your email address will not be published. Required fields are marked *