Intermediate Excel: Data Modeling, Analysis, and Dashboards

Instructor: Keith Gibson

Included with 糖心vlog官网观看 Plus

Learn more

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 hours to complete

Flexible schedule

Learn at your own pace

6 modules

Gain insight into a topic and learn the fundamentals.

Intermediate level

Recommended experience

2 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

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

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about 糖心vlog官网观看 for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 6 modules in this course

Unlock Excel鈥檚 full potential and transform your data into insights.

- This intermediate-level course empowers learners to go beyond basic spreadsheets and move toward mastering Excel鈥檚 powerful data modeling and dashboarding capabilities鈥攕kills 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鈥檚 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鈥攗nder 4 hours total 鉁� No need for external tools鈥攅verything 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鈥檚 used Excel and wants to go deeper Whether you're preparing for a promotion, pivoting into data analytics, or simply want to work smarter鈥攏ot harder鈥攖his course will help you unlock Excel鈥檚 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.

What's included

6 videos2 assignments1 plugin

6 videosTotal 12 minutes

Intro: Import and Navigate Data1 minute
Use Power Query to Import Data1 minute
Transform and Clean Data in Excel 3 minutes
Use the VLOOKUP Function1 minute
Use the XLOOKUP Function1 minute
Use the INDEX and MATCH Functions Together2 minutes

2 assignmentsTotal 13 minutes

Give It a Try: Import & Clean Data with Power Query10 minutes
Check-In: Navigating Data with Functions3 minutes

1 pluginTotal 10 minutes

Let's Talk Power Query10 minutes

What's included

6 videos2 assignments

6 videosTotal 9 minutes

Intro: Explore Data with PivotTables1 minute
Create a PivotTable from Cell Data2 minutes
Group Numeric Values into Ranges in a PivotTable1 minute
Group Specific Rows in a PivotTable 1 minute
Add a Calculated Field to a PivotTable1 minute
Refresh Queries and Workbook Data0 minutes

2 assignmentsTotal 9 minutes

Check-In: Exploring Data with PivotTables4 minutes
Give It a Try: Explore Data with PivotTables5 minutes

What's included

5 videos2 assignments

5 videosTotal 8 minutes

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

2 assignmentsTotal 14 minutes

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

What's included

5 videos2 assignments

5 videosTotal 6 minutes

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

2 assignmentsTotal 9 minutes

Check-In: Creating Visualizations Using PivotCharts4 minutes
Give it a Try: Create a PivotChart5 minutes

What's included

5 videos2 assignments

5 videosTotal 10 minutes

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

2 assignmentsTotal 12 minutes

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

What's included

6 videos2 assignments

6 videosTotal 9 minutes

Intro: Review, Protect, and Share Workbooks1 minute
Manage Access for Shared Workbooks2 minutes
Manage Permissions for Specific Cells in a Worksheet2 minutes
Protect and Unprotect Workbooks from Changes1 minute
Insert a New Comment0 minutes
Review Recent Changes in a Workbook1 minute

2 assignmentsTotal 9 minutes

Check-In: Reviewing, Protecting, and Sharing Workbooks4 minutes
Give it a Try: Protect a Workbook5 minutes

Instructor

Keith Gibson

Knowledge Accelerators

17 Courses383,080 learners

Offered by

Knowledge Accelerators

Explore more from Data Analysis

Status: Free Trial
Macquarie University
Excel Fundamentals for Data Analysis
Course
Status: Free Trial
IBM
Excel Basics for Data Analysis
Course
Status: Free Trial
Macquarie University
Excel Skills for Data Analytics and Visualization
Specialization
Illinois Tech
A Comprehensive Excel Masterclass
Course

Why people choose 糖心vlog官网观看 for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, 糖心vlog官网观看 is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. 糖心vlog官网观看 allows me to learn without limits."

Open new doors with 糖心vlog官网观看 Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose 糖心vlog官网观看 for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

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 purchase a Certificate you get access to all course materials, including graded assignments. Upon completing the course, 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鈥檛 afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you鈥檒l find a link to apply on the description page.

糖心vlog官网观看