Business Analytics Certification Training with Excel

Business Analytics Certification Course Overview

This Business Analytics certification course teaches you the basic concepts of data analysis and statistics to help 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.

What you'll learn

100% Money Back Guarantee
No questions asked refund*

At It Nuggets Online, we value the trust of our patrons immensely. But, if you feel that a course does not meet your expectations, we offer a 7-day money-back guarantee. Just send us a refund request via email within 7 days of purchase and we will refund 100% of your payment, no questions asked!
  • Learn Research
  • Collect Usefull Data
  • Requirement Analysis Phase
  • Market competent Skills
  • Problem Solving Skills
  • Model Implementation Skills
  • Building or Developing Phase
  • Presenting and Testing Skills

    Course Includes:

  • 7+ hours on-demand video
  • 7+ articles
  • 20+ downloadable resources
  • Full access
  • Access on mobile and TV
  • Certificate of completion


Whether you work for a small company, a large corporate or from home, a computer will be one of the first pieces of office equipment you’re going to need. And they comes in different forms, such as laptops and desktops. Computer skills are a valuable addition to any employee’s personal portfolio. Upskilling and polishing your computer literacy can greatly increase your desirability to employers. This is the perfect opportunity to take on roles you might not have previously considered. As an employer, motivating your employees to become computer literate will increase productivity and also stave off problems that can cost time and significant amounts of money. Many companies have started to depend upon computerised technology to get work done. Which is why computer skills have become increasingly important. Having the necessary and basic computer course knowledge will put you a step ahead of others. You’ll have a big advantage over those who aren’t computer literate. It’s for this specific reason that many schools and tertiary institutions encourage students to complete basic computer studies. Here are three reasons why being computer literate is beneficial in the workplace.

Helping professionals thrive, not just survive

Learning — Blended to Perfection

Learning — Blended to Perfection

Learning — Blended to Perfection

Course Inquiry


Annual Salary

Hiring Companies

Training Options


Enroll Now
  • Lifetime access to high-quality self-paced eLearning content curated by industry experts
  • 4 hands-on projects to perfect the skills learnt
  • 2 simulation test papers for self-assessment
  • 24x7 learner assistance and support


Enroll Now
  • Everything in Self-Paced Learning, plus
  • 90 days of flexible access to online classes
  • Live, online classroom training by top instructors and practitioners
  • 24x7 learner assistance and support


  • Blended learning delivery model (self-paced e-learning and/or instructor-led options)
  • Flexible pricing options
  • Enterprise grade Learning Management System (LMS)
  • Enterprise dashboards for individuals and teams
  • 24x7 learner assistance and support
  • 24x7 learner assistance and support

Business Analytics Course Curriculum


Business Analytics with Excel is a great course for both beginners and experienced professionals who are inexperienced or have recently entered the analytics field. This Business Analytics online course is beneficial for IT developers and testers, data analysts, junior data scientists, analytics professionals, BI and reporting professionals, project managers, students, and professionals working with data in any industry.


There are no prerequisites for this Business Analytics certification training other than an analytical mindset. However, we do expect the participants to have a basic knowledge of working with Microsoft Excel.

Course Content

Lesson 00 - Introduction
0.001 Course Introduction
Lesson 01 - Introduction to Business Analytics
1.001 Introduction
1.002 What Is in It for Me
1.003 Types of Analytics
1.004 Areas of Analytics
Knowledge Check
1.006 Key Takeaways
1.007 Conclusion
Lesson 02 - Formatting Conditional Formatting and Important Fuctions
2.001 Introduction
2.002 What Is in It for Me
2.003 Custom Formatting Introduction
2.004 Custom Formatting Example
2.005 Conditional Formatting Introduction
2.006 Conditional Formatting Example1
2.007 Conditional Formatting Example2
2.008 Conditional Formatting Example3
2.009 Logical Functions
2.010 Lookup and Reference Functions
2.011 VLOOKUP Function
2.012 HLOOKUP Function
2.013 MATCH Function
2.014 INDEX and OFFSET Function
2.015 Statistical Function
2.016 SUMIFS Function
2.017 COUNTIFS Function
2.019 STDEV, MEDIAN and RANK Function
2.020 Exercise Intro
2.21 Exercise
Knowledge Check
2.023 Key Takeaways
2.024 Conclusion
Lesson 03 - Analyzing Data with Pivot Tables
3.001 Introduction
3.002 What Is in It for Me
3.003 Pivot Table Introduction
3.004 Concept Video of Creating a Pivot Table
3.005 Grouping in Pivot Table Introduction
3.006 Grouping in Pivot Table Example 1
3.007 Grouping in Pivot Table Example 2
3.008 Custom Calculation
3.009 Calculated Field and Calculated Item
3.010 Calculated Field Example
3.011 Calculated Item Example
3.012 Slicer Intro
3.013 Creating a Slicer
3.014 Exercise Intro
3.15 Exercise
Knowledge Check
3.017 Key Takeaways
3.018 Conclusion
Lesson 04 - Dashboarding
4.001 Introduction
4.002 What Is in It for Me
4.003 What is a Dashboard
4.004 Principles of Great Dashboard Design
4.005 How to Create Chart in Excel
4.006 Chart Formatting
4.007 Thermometer Chart
4.008 Pareto Chart
4.009 Form Controls in Excel
4.010 Interactive Dashboard with Form Controls
4.011 Chart with Checkbox
4.012 Interactive Chart
4.013 Exercise Intro
4.14 Exercise1
4.15 Exercise2
Knowledge Check
4.017 Key Takeaways
4.018 Conclusion
Lesson 05 - Business Analytics With Excel
5.001 Introduction
5.002 What Is in It for Me
5.003 Concept Video Histogram
5.004 Concept Video Solver Addin
5.005 Concept Video Goal Seek
5.006 Concept Video Scenario Manager
5.007 Concept Video Data Table
5.008 Concept Video Descriptive Statistics
5.009 Exercise Intro
5.10 Exercise
Knowledge Check
5.012 Key Takeaways
5.013 Conclusion
Lesson 06 - Data Analysis Using Statistics
6.001 Introduction
6.002 What Is in It for Me
6.003 Moving Average
6.004 Hypothesis Testing
6.005 ANOVA
6.006 Covariance
6.007 Correlation
6.008 Regression
6.009 Normal Distribution
6.010 Exercise1 Intro
6.11 Exercise 1
6.012 Exercise2 Intro
6.13 Exercise 2
6.014 Exercise3 Intro
6.15 Exercise 3
Knowledge Check
6.017 Key Takeaways
6.018 Conclusion
Lesson 07 - Power BI
7.001 Introduction
7.002 What Is in It for Me
7.003 Power Pivot
7.004 Power View
7.005 Power Query
7.006 Power Map
Knowledge Check
7.008 Key Takeaways
7.009 Conclusion

Course Training Session FAQ'S

IT Nuggets Online is a progressive IT company engaged in creating eye-grabbing computer-based content in English, for the benefit of students. we offer learning process that blends texts, visuals, animation, video clips, and sound to give a complete learning experience to students.
Everyone Take an Online Classes in Your Flexible Times.
Yes, You Can Enroll More Than Courses.
After Meeting the Certification Criteria Explained By Instructor which will be contain some quiz and hands on exercise then definitely you will get certification.