Business Intelligence with Excel Skills you will learn

  • Business analytics
  • Excel analytics functions
  • Data infrastructure
  • Power Query

Who should learn this free Business Intelligence course?

  • IT professionals
  • Project managers
  • DevOps professionals
  • Developers

What you will learn in this free Business Intelligence course?

  • Business Intelligence using Excel Basics Tutorial

    • Introduction

      01:36
      • 0.0 Introduction
        01:36

    • Lesson 1: What is Excel? Part-1

      36:40
      • 1.01 What is Excel? Part-1
        36:40

    • Lesson 2: What is Excel? Part-2

      31:39
      • 2.01 What is Excel? Part-1
        31:39

    • Lesson 3: Functions and Formulas

      29:04
      • 3.01 Functions and Formulas
        29:04

    • Lesson 4: Conditional Formatting

      29:27
      • 4.01 Conditional Formatting
        29:27

    • Lesson 5: Pivot Charts and Tables

      30:02
      • 5.01 Pivot Charts and Tables
        30:02

    • Lesson 6: Excel Power Query

      33:45
      • 6.01 Excel Power Query
        33:45

    • Lesson 7: Statistics in Power Query

      24:08
      • 7.01 Statistics in Power Query
        24:08

Get a Completion Certificate

Share your certificate with prospective employers and your professional network on LinkedIn.

Why you should learn Business Intelligence with Excel?

US$33.77 billion in 2023

The Business Intelligence Market size

$93067 a year

The avg salary for a Business Intelligence professional

About The Course

In this business intelligence Excel course, you will learn the basics of MS Excel, comprehensively understanding its core concepts. Additionally, you will delve into Power Query in Excel, understanding its data transformation and analysis capabilities. 

Throughout the training, you will use hands-on exercises and practical examples to reinforce your learning. By the end of this free business intelligence Excel course, you'll hav

Read More

Get your team a digital skilling library

with unlimited access to live classes
Know More
digital skilling library

FAQs

  • What is business intelligence in Excel?

    Business intelligence in Excel refers to using Excel's features and tools to analyze and interpret data, derive insights, and make informed business decisions.

  • What fundamental business intelligence concepts will I learn in this Excel course?

    In this business intelligence Excel course, you'll learn fundamental concepts such as data analysis, data visualization, and data manipulation techniques using Excel's powerful tools, such as PivotTables, Power Query, and charts.

  • How will this course teach me to handle data effectively?

    This business intelligence Excel course will provide you with hands-on experience and practical examples to effectively handle and analyze data in Excel. You'll learn various techniques to import, clean, transform, and visualize data to derive meaningful insights.

  • Who should take this free Business Intelligence Excel Course?

    This business intelligence Excel course is ideal for anyone interested in using Excel for business intelligence purposes, including analysts, managers, students, and professionals looking to enhance their data analysis skills.

  • What outcomes can I expect after completing the course?

    After completing the business intelligence Excel course, you'll have a solid understanding of business intelligence concepts in Excel and be proficient in using Excel's features to analyze and visualize data effectively for informed decision-making.

  • How long is the training program and what is the format?

    This business intelligence Excel course consists of 4 hours of self-paced video lessons, allowing you to learn at your own pace and convenience.

  • How long will I have access to the course materials?

    You'll have access to the business intelligence Excel course material for 90 days, giving you sufficient time to review the content and reinforce your learning.

  • Is certification provided after course completion?

    Upon completing the business intelligence Excel course, you'll receive a course completion certificate, validating your proficiency in business intelligence concepts in Excel.

Related Courses

  • Acknowledgement
  • PMP, PMI, PMBOK, CAPM, PgMP, PfMP, ACP, PBA, RMP, SP, OPM3 and the PMI ATP seal are the registered marks of the Project Management Institute, Inc.