Business Analytics Certification Training with Excel - Simplilearn

Business Analytics with Excel is a great course for both beginners and experienced professionals who are inexperienced or have recently stepped into the field of analytics. This course is beneficial for:

• IT developers and testers

• Data analysts

• Junior data scientists

• Analytics professionals

• BI and reporting professionals

• Project managers

• Students

• Professionals working with data in any industry

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

With Simplilearn’s training on business analytics with Excel, you will be able to:

• Understand the meaning of business analytics and its importance in the industry

• Grasp fundamentals of excel analytics functions and conditional formatting

• Learn how to analyze with complex datasets using pivot tables and slicers

• Solve stochastic and deterministic analytical problems using tools like scenario manager, solver and goal seek

• Apply statistical tools and concepts like moving average, hypothesis testing, ANOVA and regression to data sets using Excel

• Represent your findings using charts and dashboards

• Get introduced to the latest Microsoft analytic and visualization tools i.e. Power BI

• Introduction

• What is in it for Me

• Types of Analytics

• Areas of Analytics

• Quiz

• Key Takeaways

• Conclusion

• Introduction

• What is in it for Me

• 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

• Exercise Intro

• Exercise

• Quiz

• Key Takeaways

• Conclusion

• 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 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

• Exercise Intro

• Exercise

• Quiz

• Key Takeaways

• Conclusion

• 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

• Quiz

• Key Takeaways

• Conclusion

• Introduction

• What is in it for Me

• Concept Video Histogram

• Concept Video Solver Addin

• Concept Video Goal Seek

• Concept Video Scenario Manager

• Concept Video Data Table

• Concept Video Descriptive Statistics

• Exercise Intro

• Exercise

• Quiz

• Key Takeaways

• Conclusion

• Introduction

• What is in it for Me

• Moving Average

• Hypothesis Testing

• ANOVA

• Covariance

• Correlation

• Regression

• Normal Distribution

• Exercise1 Intro

• Exercise1

• Exercise2 Intro

• Exercise2

• Exercise3 Intro

• Exercise3

• Quiz

• Key Takeaways

• Conclusion

• Introduction

• What is in it for Me

• Power Pivot

• Power View

• Power Query

• Power Map

• Quiz

• Key Takeaways

• Conclusion