Business Analytics with Excel Certification - eLearning

450,00 EUR

8 hours

eLearning

Get a boost in your business analytics career by mastering the full functionality of Microsoft Excel. This Business Analytics certification course teaches you the basic concepts of data analysis and statistics to help data-driven decision making. This training introduces you to Power BI and delves into the statistical concepts that will help you derive insights from data and present your findings through intuitive and executive-level dashboards.

Course timeline

Introduction to Business Analytics
Lesson 01
- Introduction
- What Is in It for Me
- Types of Analytics
- Areas of Analytics
- Key Takeaways
- Conclusion
Formatting: Conditional Formatting and Important Functions
Lesson 02
- Introduction
- What Is in It for Me
- Custom Formatting
- Introduction
- Custom Formatting Example
- Conditional Formatting Introduction
- Conditional Formatting Examples
- 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
- Exercise Intro
- Exercise
- Key Takeaways
- Conclusion
Analyzing Data with Pivot Tables
Lesson 03
- Introduction
- What Is in It for Me
- Pivot Table Introduction
- Concept Video of Creating a Pivot Table
- Grouping in Pivot Table Introduction
- Grouping in Pivot Table Examples
- Custom Calculation
- Calculated Field and Calculated Item
- Calculated Field Example
- Calculated Item Example
- Slicer Intro
- Creating a Slicer
- Exercise Intro
- Exercise
- Key Takeaways
- Conclusion
Dashboarding
Lesson 04
- Introduction
- What Is in It for Me
- 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 Intro
- Exercise1
- Exercise2
- Key Takeaways
- Conclusion
Business Analytics with Excel
Lesson 05
- Introduction
- What is in it for Me
- Concept video histogram
- Concept video Sovler Addin
- Concept video Goal Seek
- Concept video Scenario Manager
- Concept video Data Table
- Concept video Descriptive Statistics
- Excercise
- Takeaways
- Conclusion
Data Analysis Using Statistics
Lesson 06
- Introduction
- What Is in It for Me
- 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
- Exercises
- Key Takeaways
- Conclusion
Power BI
Lesson 07
- Introduction
- Power Pivot
- Power View
- Power Query
- Power Map
- Key Takeaways
- Conclusion

Learning Outcomes

At the end of this course, you will be able to:

Concepts

Understand the basic concepts of business analytics

Pivot Tables

Analyze data with pivot tables

Dashboarding

Understand the principles of dashboard design and how to create charts in Excel

Data Analysis

Learn data analysis using statistics

Formatting

Understand conditional formatting and logical functions

Who Should Enroll in this Program?

Prerequisites:

There are no prerequisites for this Business Analytics certification training other than an analytical mindset. However, we do expect the participants to have a basic knowledge of working with Microsoft Excel.

Beginners in the business analytics field

Professionals looking to dive deeper into analytics

Data Analysts

Junior Data Scientists

BI and Reporting Professionals

Project Managers

Students in UG/ PG programs

Start course now

Need corporate solutions or LMS integration?

Didn't find the course or program which would work for your business? Need LMS integration? Write us, we will solve everything!

;