custom code gtranslate code

Business Analytics with Excel

In this course you will learn business analytics basics, business analytics fundamentals like data analysis and statistics to enhance your data-driven decision-making skills.

Course Outlines

Module 1 – Introduction to Business Analytics
Introduction
Types of Analytics
Areas of Analytics

Module 2 – Formatting Conditional Formatting and Important Functions
Introduction
Custom Formatting Introduction
Custom Formatting Example
Conditional Formatting
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

Module 3 – Analyzing Data with Pivot Tables
Introduction
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

Module 4 – Dashboarding
Introduction
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

Module 5 – Data Analysis Using Statistics
Introduction
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

What you'll learn

  • Excel analytics functions
  • Excel conditional formatting
  • Pivot tables and slicers
  • Scenario manager tool
  • Solver tool
  • Goal seek tool
  • ANOVA
  • Hypothesis testing
  • Power BI

Course Content

  • Excel analytics functions
  • Excel conditional formatting
  • Pivot tables and slicers
  • Scenario manager tool
  • Solver tool
  • Goal seek tool
  • ANOVA
  • Hypothesis testing
  • Power BI

Customize a Course

We will be happy to assist you for inquiries about a customized scheduled or program:
Rachael McPherson, Director of Sales
☎(250)882-9549 📧rachael@qacademy.tech
Caroline Santos, Corporate and Custom Sales Manager- Eastern Canada
☎(514)771-3206 📧caroline.santos@qacademy.tech

Student Ratings & Reviews

Course Info

Prerequisites
No prerequisites
Duration
20 Hours

Enroll Now

For Group Class Options

Enroll Now

For Corporate and Funding Agencies
popup and lms tutor hidden code
X
Customize A Course
We will be happy to assist you for inquiries about a customized scheduled or program:
Tanvir Qureshi
Caroline Santos
Corporate and Custom Sales Manager
(Eastern Canada)
Phone Number
0(0)

Business Analytics with Excel

  • Course level: Beginner

Description

In this course you will learn business analytics basics, business analytics fundamentals like data analysis and statistics to enhance your data-driven decision-making skills.

About the instructor

0 (0 ratings)

81 Courses

0 students

Send your feedback

Phone Number

Request for Instructor Info

Phone Number

Become A Program Partner

Q Academy works with the most innovative, sustainable industries and we continue to review all the major skills gaps across the globe. We’re looking for industry leaders and academic partners to help us create courses for upgrading skills within growing sectors across globe. We’d love to work with you to build something great!

Phone Number

Become A Hiring Partner!

Phone Number

With so many companies looking for great talent why not look take your needs directly to Q Academy and ensure your candidates have all the most update skills they need. Hire Great Talent without the high costs of some job search platforms or services.

Become a Training Partner!

Q Academy works with thosands of business across the globe and we have become several business go to training partners for the past 5 years.

Phone Number

Inquire Now

Phone Number

Log in
Login / Signup