Business Intelligence & Data Visualization in Excel

Coursera PlusMonthly 3 个月课程4 折优惠 ，让你轻松掌握闪耀技能。立即节省

Business Intelligence & Data Visualization in Excel

本课程是 Business Intelligence & Reporting Tools 专项课程的一部分

位教师：EDUCBA

包含在中

了解更多

5个模块

深入了解一个主题并学习基础知识。

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

5个模块

深入了解一个主题并学习基础知识。

1 周完成

在 10 小时一周

灵活的计划

自行安排学习进度

您将学到什么

Analyze datasets using sorting, filtering, and conditional formatting.
Build Pivot Tables and charts for business insights.
Apply what-if analysis to support data-driven decisions.

您将获得的技能

您将学习的工具

要了解的详细信息

可分享的证书

添加到您的领英档案

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累特定领域的专业知识

本课程是 Business Intelligence & Reporting Tools 专项课程专项课程的一部分

在注册此课程时，您还会同时注册此专项课程。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
获得可共享的职业证书

该课程共有5个模块

Master Excel Business Intelligence tools to analyze data, create visual insights, and support better business decisions. Learn how to transform raw data into meaningful reports and dashboards.

This course provides a structured, hands-on approach to data analysis and visualization using Microsoft Excel. You will learn how to organize datasets, apply advanced sorting and filtering, and use conditional formatting to highlight key insights. Through practical modules, you will build professional charts, create dynamic Pivot Tables, and perform multi-level data analysis for business reporting. The course also covers what-if analysis techniques using data tables, enabling you to evaluate different scenarios and support strategic decision-making. By the end of the course, you will be able to analyze complex datasets, design visually compelling reports, and generate actionable insights using Excel BI tools. Ideal for students and professionals, this course equips you with job-ready skills in data analysis, reporting, and business intelligence using Excel.

This module introduces the core principles of Business Intelligence in Microsoft Excel, focusing on organizing, sorting, filtering, and visually enhancing datasets. Learners build foundational data control skills and apply conditional formatting techniques to transform raw data into structured and decision-ready information.

涵盖的内容

9个视频4个作业

9个视频总计86分钟

Introduction to Business Intelligence12分钟
Sorting in Business Intelligence10分钟
Filtering Data in BI10分钟
Example of Filtering the Data10分钟
Advance Filtering Data8分钟
Advance Filtering Data Continues8分钟
Conditional Formatting in Excel11分钟
Edit Conditional Formatting Rules11分钟
New Formatting Rules and Format Cells7分钟

4个作业总计60分钟

Foundations of Data Organization & Smart Formatting30分钟
BI Fundamentals & Data Control10分钟
Advanced Filtering Techniques10分钟
Conditional Formatting Essentials10分钟

This module enhances data presentation capabilities by exploring advanced formatting logic, resolving rule conflicts, integrating interactive controls, and preparing structured datasets for visualization. Learners strengthen their ability to build professional and interactive Excel BI reports.

涵盖的内容

7个视频4个作业

7个视频总计56分钟

Duplicates and Triplicates Formatting9分钟
How to Create Alternate Row in Excel7分钟
Conflicting Rules In Excel6分钟
Checklist Demonstration using Developer8分钟
Checklist Demonstration using Developer Continues9分钟
Data Charts In Excels8分钟
More on Data Chart9分钟

4个作业总计60分钟

Advanced Formatting & Visualisation Readiness30分钟
Advanced Formatting Mastery10分钟
Interactive Excel Tools10分钟
Introduction to Data Charts10分钟

This module focuses on transforming structured data into meaningful visual insights using Excel charting tools. Learners explore core chart types, advanced visualization techniques, and analytical enhancements such as trend lines and error bars to improve decision-making impact.

涵盖的内容

6个视频4个作业

6个视频总计59分钟

Bar Chart and Line Chart9分钟
Pie Chart Nd Its Difference8分钟
Advance Data Charts12分钟
Advance Data Charts Continues12分钟
Chart Sheet in Data Chart7分钟
Trend Lines and Error Bars In Data Chart10分钟

4个作业总计60分钟

Data Visualization & Chart Intelligence30分钟
Core Chart Types10分钟
Advanced Charting Techniques10分钟
Enhancing Chart Insights10分钟

This module develops advanced analytical capabilities through Pivot Tables in Excel. Learners organize, group, summarize, and compute dynamic business reports using multi-level analysis, frequency distribution, calculated fields, and calculated items for professional reporting.

涵盖的内容

7个视频4个作业

7个视频总计58分钟

Inserting Pivot Table8分钟
Darg Fileds7分钟
Grouping Using Pivot Table6分钟
Grouping Using Pivot Table Continues7分钟
Multi Level Pivot Table9分钟
Frequency Distribution10分钟
Calculated Fields10分钟

4个作业总计60分钟

Pivot Tables & Analytical Reporting30分钟
Pivot Table Fundamentals10分钟
Grouping & Multi-Level Analysis10分钟
Statistical Analysis in Pivot10分钟

This module introduces advanced analytical modeling techniques in Excel, including structured tables, calculated intelligence within Pivot Tables, and scenario-based what-if analysis using one-variable and two-variable data tables. Learners develop strategic decision-support capabilities using Excel BI tools.

涵盖的内容

6个视频4个作业

6个视频总计47分钟

Calculated Items9分钟
Calculated Items Continues6分钟
Insert A Table6分钟
Sorting and Changing Style6分钟
One Variable Data Table12分钟
Two Variable Data Table8分钟

4个作业总计60分钟

Advanced Analysis & What-If Modeling30分钟
Advanced Pivot Intelligence10分钟
Structuring Data & Styling10分钟
What-If Analysis Using Data Tables10分钟

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

EDUCBA

1,360 门课程301,081 名学生

提供方

EDUCBA

从 Data Analysis 浏览更多内容

Macquarie University
Excel Skills for Data Analytics and Visualization
专项课程
Simplilearn
Business Analytics using Excel
课程
Logical Operations
Excel: Data Analysis and Visualization Fundamentals
课程
EDUCBA
Master Microsoft Excel: Apply, Analyze & Visualize Data
课程

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生

''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'

Jennifer J.

自 2020开始学习的学生

''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'

常见问题

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.