Microsoft Excel is essentially the most widely used strategy, reporting, and analytics software. This course on business analytics with excel will equip the participants with information analytical capabilities using Excel's characteristics. The individuals will be trained some statistical ideas on how you can get insights from information and take data-driven choices using Excel.

The participant will even develop abilities in Excel pivots as well as the use of theirs to summarize information in adaptable ways, enabling fast exploration of information and creating essential insights from the accumulated information. The program will additionally include Power BI, and that is the latest and the very best tool offered by Microsoft for analytics as well as information visualization.

Who Can Attend

Business Analysis with Excel program is highly recommended for experts that are want to construct the capacity of theirs in the area of analytics. The program is best suited for individuals who presently use Excel at the office and will gain from enhanced Excel abilities for reporting, analysis, and presentation.

Course Objectives

By the conclusion of the course you are going to be ready to:

• Understand value of company analytics in business

• Understand basics of succeed analytics functions and conditional formatting

• Analyze with advanced datasets utilizing pivot tables and slicers

• Solve analytical problems with tools as scenario manager, goal and solver seek

• Apply statistical concepts and tools like moving average, theory assessment, regression and ANOVA to data sets utilizing Excel

• Represent your findings with dashboards and charts

• Use Microsoft Power BI

Program Outline

Introduction to Business Analytics

• What is Business Analytics?

• Analysis vs Analytics

• Types of Analytics

• Areas of Analytics

Conditional Formatting using Excel

• Custom Formatting

• Conditional Formatting

Functions

• Logical Functions

• Look up and also Reference Functions

• VLOOKUP Function

• HLOOKUP Function

• MATCH Function

• INDEX and also OFFSET Function

• Statistical Function

• SUMIFS Function

• COUNTIFS Function

Analysis Data using PIVOT Tables

• Pivot Table Introduction

• Grouping within Pivot Table Introduction

• Custom Calculation

• Calculated Field and also Calculated Item

• Creating a Slicer

Dashboard within Excel

• What is a Dashboard?

• Dashboard Design

• Chart Formatting

• Interactive Dashboard with Form Controls

• Interactive Chart

Business Analytics using Excel

• Histogram

• Solver Addin

• Goal Seek

• Scenario Manager

• Data Table

• Descriptive Statistics

Statistical Analysis using Excel

• Hypothesis Testing

• ANOVA

• Covariance

• Correlation

• Regression

VBA

• MsgBox

• VBA variables

• Events

• Array

• VBA functions

• Application Object

BI

• Power Pivot

• Power View

• Power Query

• Power Map