Intermediate Excel: Data Modeling, Analysis, and Dashboards

只需 199 美元（原价 399 美元）即可通过 Coursera Plus 学习更高水平的技能。立即节省

Intermediate Excel: Data Modeling, Analysis, and Dashboards

本课程是 Excel to Power BI: Data Analysis & Business Intelligence 专项课程的一部分

位教师：Keith Gibson

包含在中

了解更多

6个模块

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

中级等级

推荐体验

2 小时完成

灵活的计划

自行安排学习进度

6个模块

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

中级等级

推荐体验

2 小时完成

灵活的计划

自行安排学习进度

您将学到什么

Essential skills to import, clean and format data (plus an introduction to using power query to automatically maintain data in Excel)
Understand and build confidence creating pivot tables, pivot charts, slicers, filters, dashboards for use in Excel
Manage and protect Excel workbook data to maintain data security and learn to keep data integrity intact

您将获得的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

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

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

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

积累特定领域的专业知识

本课程是 Excel to Power BI: Data Analysis & Business Intelligence 专项课程专项课程的一部分

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

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

该课程共有6个模块

Unlock Excel’s full potential and transform your data into insights.

- This intermediate-level course empowers learners to go beyond basic spreadsheets and move toward mastering Excel’s powerful data modeling and dashboarding capabilities—skills that are in high demand across industries. - Excel is used by over 750 million people worldwide. Yet, most users only scratch the surface. This course helps you unlock Excel’s advanced features — Power Query, PivotTables, Power Pivot, and dynamic dashboards — used by analysts, consultants, and business professionals globally. How will this course impact you? - Excel skills are listed in over 60% of data analyst job postings. - Intermediate Excel proficiency can boost productivity by 40% and reduce reporting time by up to 50%. - Mastering dashboards and data models is a key differentiator for roles in analytics, business intelligence, finance, and operations. What you will learn? - Import and clean data using Power Query - Build and manage data models with Power Pivot - Create dynamic dashboards with PivotCharts and slicers - Protect and share workbooks securely - Use advanced lookup functions (VLOOKUP, XLOOKUP, INDEX/MATCH) What Makes This Course Unique? ✔ Hands-on assignments with real-world datasets ✔ Step-by-step video walkthroughs for each Excel feature ✔ Practice quizzes and dashboard-building exercises ✔ Designed for fast completion—under 4 hours total ✔ No need for external tools—everything is done in Excel Who Should Take This Course? - Business professionals looking to level up their Excel skills - University students preparing for internships or analyst roles - Job seekers wanting to add practical Excel skills to their resume - Consultants and freelancers who build client reports - Anyone who’s used Excel and wants to go deeper Whether you're preparing for a promotion, pivoting into data analytics, or simply want to work smarter—not harder—this course will help you unlock Excel’s hidden power. Enroll now and start building dashboards that drive decisions. Please note that this course requires an Excel license or qualifying Microsoft 365 subscription to complete.

Streamline your workflow and take control of your data! Discover how to import, explore, and prepare information effortlessly using powerful Excel tools. Through quick videos and interactive activities, you’ll learn to automate repetitive tasks and eliminate manual work so you can spend more time uncovering insights that drive smarter decisions.

涵盖的内容

10个视频3个作业

10个视频总计16分钟

Intro: Import and Navigate Data1分钟
Use Power Query to Import Data1分钟
Transform and Clean Data in Excel 3分钟
Use the VLOOKUP Function1分钟
Use the XLOOKUP Function1分钟
Use the INDEX and MATCH Functions Together2分钟
Use the TRIM Function0分钟
Use the TEXTSPLIT Function0分钟
Use the TEXTJOIN Function1分钟
Use the IF and ISERROR Function1分钟

3个作业总计43分钟

Give It a Try: Import and Clean Data with Power Query10分钟
Give It a Try: Prepare Text for Analysis30分钟
Check-In: Review Lookup and Reference Functions in Excel3分钟

Quickly summarize and analyze large datasets with PivotTables without using complicated formulas. Watch short videos and complete interactive activities to group, aggregate, and refresh data dynamically, so you can uncover trends and make smarter decisions in minutes.

涵盖的内容

4个视频2个作业

Combine data from multiple sources and create relationships between tables to build powerful data models in Excel. Through short videos and interactive activities, you’ll learn to use Power Pivot to organize complex data and generate dynamic insights.

涵盖的内容

5个视频2个作业

5个视频总计8分钟

Intro: Build Data Models with Power Pivot1分钟
Enable the Power Pivot Add-In for Excel1分钟
Use Power Pivot to Add Tables to a Data Model2分钟
Create Relationships Between Tables in Power Pivot2分钟
Create a PivotTable from a Data Model1分钟

2个作业总计14分钟

Check-In: Review Building Data Models with Power Pivot4分钟
Give it a Try: Link Tables with a Data Model10分钟

Turn your PivotTables into interactive charts that make data easier to understand and explore. Through short videos and hands-on activities, you’ll learn to create PivotCharts and apply filters for dynamic, visual analysis.

涵盖的内容

5个视频2个作业

5个视频总计6分钟

Intro: Create Dynamic Visualizations Using PivotCharts1分钟
Create a PivotChart from a PivotTable1分钟
Create a PivotChart from a Data Range or Standard Table1分钟
Refresh Data in PivotTables and PivotCharts1分钟
Filter Data in a PivotChart1分钟

2个作业总计9分钟

Check-In: Review Creating Visualizations Using PivotCharts4分钟
Give it a Try: Create a PivotChart5分钟

Bring your data to life with interactive dashboards, right inside Excel. Combine PivotTables, PivotCharts, slicers, and timelines into a single, dynamic dashboard. Through short videos and a hands-on activity, you’ll discover how to arrange, format, and control multiple elements for a polished, Power BI–style experience.

涵盖的内容

5个视频2个作业

5个视频总计10分钟

Intro: Create Dashboards in Your Workbooks1分钟
Create Multiple PivotTables and PivotCharts from One Dataset2分钟
Control Multiple PivotTables and PivotCharts with Slicers1分钟
Create a PivotTable Timeline to Filter Dates2分钟
Arrange, Align, and Format Elements to Build a Dashboard2分钟

2个作业总计12分钟

Check-In: Creating Dashboards in Your Workbooks4分钟
Give it a Try: Build a Dashboard8分钟

Keep your data secure and maintain control over edits in Excel. Learn how to protect entire workbooks or specific cells, manage permissions, and review recent changes. Through short videos and a hands-on activity, you’ll gain the skills to safeguard your work while collaborating effectively.

涵盖的内容

4个视频2个作业

获得职业证书

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

位教师

Keith Gibson

Knowledge Accelerators

22 门课程395,728 名学生

提供方

Knowledge Accelerators

从 Data Analysis 浏览更多内容

Knowledge Accelerators
Excel Basics for Beginners: Workbooks, Formatting, Charts and Core Skills
课程
Knowledge Accelerators
From Excel to Power BI
课程
Knowledge Accelerators
Dive Deeper into Data-Driven Decisions with Power BI
课程

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

Felipe M.

自 2018开始学习的学生

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

Jennifer J.

自 2020开始学习的学生

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

Larry W.

自 2021开始学习的学生

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

Chaitanya A.

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

通过 Coursera Plus 开启新生涯

无限制访问 10,000+ 世界一流的课程、实践项目和就业就绪证书课程 - 所有这些都包含在您的订阅中

了解更多

通过在线学位推动您的职业生涯

获取世界一流大学的学位 - 100% 在线

探索学位

加入超过 3400 家选择 Coursera for Business 的全球公司

提升员工的技能，使其在数字经济中脱颖而出

了解更多

常见问题

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.