Business Analytics with Excel - eLearning

Business Analytics with Excel eLearning

Learn to understand data and make data-driven decisions

COURSE OVERVIEW

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

The Business Analytics with Excel course will boost your analytical career with new powerful Excel skills. You will learn the basic theory of data analysis and statistics, but the course will also delve into the statistical concepts essential to derive insights from available data to present results with executive-level dashboards.

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

WHAT'S INCLUDED?

• One-year access to the platform
• Duration approx. 12 hours
• Practical industry-based projects
• Downloadable PDF documents with detailed content (images, explanations) for each lesson
• Access around the clock

AIMS OF THE COURSE You will learn:

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

• Understand the meaning of business analysis and its importance in the industry
• Find out the basics of Excel analysis functions and conditional formatting
• Learn how to use pivot tables and segments to analyze complex data sets
• Solve theoretical and analytical problems using tools such as scenario managers, solvers, and goal search
• Apply statistical tools and concepts such as moving average, hypothesis testing, ANOVA and regression to datasets using Excel
• Represent your results using charts and dashboards

Prerequisites

There are no prerequisites for this business analysis course apart from an analytical mindset. However, it is expected to have a basic knowledge of working with Microsoft Excel.

Course content

The course has the following modules:

• Lesson 1 - Introduction to Business Analysis
• Lesson 2 - Conditional formatting and key features
• Lesson 3 - Analyzing data with pivot tables
• Lesson 4 - Dashboarding
• Lesson 5 - Business analytics with Excel
• Lesson 6 - Data analysis with statistics
• Lesson 7 - Power BI

There are two projects included in this course:

Project 1 (submission and evaluation) - E-commerce

The analytics team of an online e-commerce company wants to design a sales dashboard to analyze sales by different product categories. The main interest of the company is to add user control for product category, so they can select a category and then see the trend by month and product. The analytics team also wants to create a histogram to analyze the number of delivery days.

Project 2 (Practice) - Medicines and Healthcare.

The analytics team of a pharmaceutical company wants to design a dashboard to analyze the sales of products in different regions and brands. They need a chart with user control functionality so that users can easily see the total sales and commissions paid to external agents categorized by brands and region.