Business Analytics with Excel

COURSE INTRODUCTION

Business Analytics with Excel training has been designed to help initiate you to the world of analytics, by using the most commonly used analytics tool (Microsoft Excel). This business analytics training will equip you with all the concepts and hard skills required for a strong analytics career basis. If you already have some experience in the IT or any core industry, this business analytics course will quickly teach you how to understand data and make data-driven decisions using Microsoft Excel.

For those that are new to the analytics field, this course provides an excellent foundation of required concepts and skills. This business analytics training also delves into the statistical concepts that are important in deriving insights from available data in order to present findings using executive level dashboards. Finally, you will be introduced to Power BI, which is currently the latest and best tool provided by Microsoft for analytics and data visualization.

KEY FEATURES

12 hours of self-paced video
Two hands-on industry-based projects on healthcare and e-commerce
Includes training on business intelligence using Power BI
Eight practical exercises
Lifetime access to self-paced learning

COURSE OBJECTIVES

After completing this course, students will have knowledge and skills 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

AUDIENCE