Embedded Files
Overview
Overview
This Business Analytics course teaches you the basic concepts of data analysis and statistics to help promote data-driven decision making. This training introduces you to Power BI and delves into the statistical concepts that will help you devise insights from available data in order to present your findings using executive-level dashboards.
Objectives
Objectives
- Need for Business Analytics
- Definition of Business Analytics
- How Business Analytics Facilitate Processes Automation
- Using MS Excel as Statistical Analysis Tool
- MS Excel Power Business Features
- MS Excel as Business Intelligence Tool of Choice
Content
Content
- MS Cell Formatting Definition and Importance
- Custom Formatting
- Conditional Formatting
- MS Excel Functions Types Definition
- Logical IF, AND, OR, NOT Functions
- Look up and Reference Functions (VLOOKUP, HLOOKUP, MATCH, INDEX, OFFSET)
- Statistical Functions (SUMIFS, COUNTIFS, PERCENTILE, QUARTILE, STDEV, MEDIAN)
Duration: 1 H 00 M
Duration: 1 H 00 M
Target: Analyst
Page updated
Google Sites
Report abuse