Business Analytics with Excel - eLearning

Business Analytics with Excel - eLearning

Learn how to understand data and make data-driven decisions

The Business Analytics with Excel training course has been designed to introduce you to the world of analytics by using the most commonly used analytics tool - Microsoft® Excel. It provides an excellent foundation of concepts and skills needed in the analytics field by teaching you how to understand data and make data-driven decisions.

ABOUT THE COURSE

The Business Analytics with Excel training course will boost your analytics career with powerful new Excel skills. You'll learn the basic theory of data analysis and statistics but the course will also delve into the statistical concepts that are important in acquiring insights from available data in order to present findings using executive level dashboards.

You will also become trained in Power BI, currently the best tool provided by Microsoft for data analytics and visualisation, so you can better represent and present your data analysis findings. Your new knowledge of these two commonly used tools combined with official business analytics certification is guaranteed to boost your career.

LEARNING OBJECTIVES

By the end of the course 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 use pivot tables and slices for analysing complex datasets
• Resolve theoretical and 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

WHAT'S INCLUDED

• Course and material are in English
• Beginner friendly
• 1 year access to the self-paced study eLearning platform 24/7
• 3,5 hours of video content
• 8 hours study time recommended
• Practical industry-based projectsDownloadable PDF documents with detailed content (pictures, explanations) for each lesson
• Quizzes, 2 End-project, Cheat sheet
• No exam for the course but student will get certification of training completion

Who Should Enroll in this Program?

• 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

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.

WHAT'S COVERED?

The course has the following modules:

Lesson 1 - Introduction to business analytics

- Introduction
- What Is in It for Me
- Types of Analytics
- Areas of Analytics
- Key Takeaways
- Conclusion

Lesson 2 - Data Cleaning and Preparation

Lesson 3 - Formatting: Conditional Formatting and Important Functions

- 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

Lesson 4 - Analyzing Data with Pivot Tables

- 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

Lesson 5 - Dashboarding

- 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

Lesson 6 - Business Analytics with Excel

- 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

Lesson 7 - Data Analysis Using Statistics

- 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

Lesson 8 - Macros For Analytics