Business Analytics Certification Training with Excel

Overview

Business Analytics with excel training has been designed to help initiate you to the world of analytics. For this we use the most commonly used analytics tool i.e. Microsoft Excel. The training will equip you with all the concepts and hard skills required to kick start your analytics career. If you already have some experience in the IT or any core industry, this course will quickly teach you how to understand data and take data driven decisions relative to your domain using Microsoft excel. For a new-comer to the analytics field, this course provides the best required foundation. The training also delves into statistical concepts which are important to derive the best insights from available data and to present the same using executive level dashboards. Finally we introduce Power BI, which is the latest and the best tool provided by Microsoft for analytics and data visualization.

Price (*ask for discount) 400 USD
Access period 180 days

Prerequisite list

  • There are no prerequisites for this course other than an analytical bent of mind. We do expect the participants to have a basic knowledge of working with Microsoft Excel.

Audience list

  • IT developers and testers
  • Data analysts
  • Junior Data scientists
  • Analytics Professionals
  • BI and reporting professionals
  • Project managers
  • Students
  • Professionals working with data in any industry

What is included

  • 12 hours of self-paced video
  • 2 hands-on industry-based project on healthcare and ecommerce domains
  • Includes training on business intelligence using Power BI
  • 8 practical exercises
  • Downloadable e-book

Certification Info

  • How To Earn?  Complete 85% of the course. Complete 1 project. Complete and submit the evaluation project. On successful evaluation, the participant will receive the certification.
  • How To Maintain?  N/A

Certification Exam Format

  • No Exam

Retake policy

  • N/A.

Enrollment Policy

  • You should pay the online course fee then the online course access will be granted to you within 1 week after receiving payment.
  • Course fee payment is not refundable.

Frequently Asked Questions

Course Outline

Introduction to Business Analytics
  • Introduction
  • What Is in It for Me
  • Types of Analytics
  • Areas of Analytics
  • Quiz
  • Key Takeaways
  • Conclusion
Formatting Conditional Formatting and Important Fuctions
  • Introduction
  • What Is in It for Me
  • Custom Formatting Introduction
  • Custom Formatting Example
  • Conditional Formatting Introduction
  • Conditional Formatting Example1
  • Conditional Formatting Example2
  • Conditional Formatting Example3
  • 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
  • Quiz
  • Key Takeaways
  • Conclusion
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 Example
  • Grouping in Pivot Table Example
  • Custom Calculation
  • Calculated Field and Calculated Item
  • Calculated Field Example
  • Calculated Item Example
  • Slicer Intro
  • Creating a Slicer
  • Exercise Intro
  • Exercise
  • Quiz
  • Key Takeaways
  • Conclusion
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
  • Quiz
  • Key Takeaways
  • Conclusion
Business Analytics With Excel
  • Introduction
  • What Is in It for Me
  • Concept Video Histogram
  • Concept Video Solver Addin
  • Concept Video Goal Seek
  • Concept Video Scenario Manager
  • Concept Video Data Table
  • Concept Video Descriptive Statistics
  • Exercise Intro
  • Exercise
  • Quiz
  • Key Takeaways
  • Conclusion
Data Analysis Using Statistics
  • Introduction
  • What Is in It for Me
  • Moving Average
  • Hypothesis Testing
  • ANOVA
  • Covariance
  • Correlation
  • Regression
  • Normal Distribution
  • Exercise1 Intro
  • Exercise 1
  • Exercise2 Intro
  • Exercise 2
  • Exercise3 Intro
  • Exercise 3
  • Quiz
  • Key Takeaways
  • Conclusion
Power BI
  • Introduction
  • What Is in It for Me
  • Power Pivot
  • Power View
  • Power Query
  • Power Map
  • Quiz
  • Key Takeaways
  • Conclusion