Explore

Data Visualization with Advanced Excel

Approx. 15 hours to complete

Save Course

Go to Course

Course Summary

This course teaches advanced Excel skills such as data analysis, visualization, and automation. It also covers lesser known features such as Power Query and Power Pivot.

Key Learning Points

Learn advanced Excel skills for data analysis and visualization
Discover lesser known features such as Power Query and Power Pivot
Automate tasks using macros and VBA programming

Job Positions & Salaries of people who have taken this course might have

- USA: $65,000 - $110,000
- India: ₹4,00,000 - ₹12,00,000
- Spain: €25,000 - €45,000
- USA: $65,000 - $110,000
- India: ₹4,00,000 - ₹12,00,000
- Spain: €25,000 - €45,000
- USA: $55,000 - $95,000
- India: ₹3,50,000 - ₹10,00,000
- Spain: €20,000 - €40,000
- USA: $65,000 - $110,000
- India: ₹4,00,000 - ₹12,00,000
- Spain: €25,000 - €45,000
- USA: $55,000 - $95,000
- India: ₹3,50,000 - ₹10,00,000
- Spain: €20,000 - €40,000
- USA: $75,000 - $125,000
- India: ₹5,00,000 - ₹15,00,000
- Spain: €30,000 - €50,000

Learning Outcomes

Develop advanced Excel skills for data analysis, visualization, and automation
Learn how to use lesser known features such as Power Query and Power Pivot
Create macros and VBA programs to automate tasks

Prerequisites or good to have knowledge before taking this course

Proficiency in basic Excel functions and formulas
Familiarity with data analysis and visualization concepts

Course Difficulty Level

Intermediate

Course Format

Self-paced online course
Video lectures
Hands-on exercises

Similar Courses

Data Analysis and Visualization with Excel
Excel Skills for Business: Essentials

Related Education Paths

Notable People in This Field

Excel Expert
Excel Guru

Related Books

Description

In this course, you will get hands-on instruction of advanced Excel 2013 functions. You’ll learn to use PowerPivot to build databases and data models. We’ll show you how to perform different types of scenario and simulation analysis and you’ll have an opportunity to practice these skills by leveraging some of Excel's built in tools including, solver, data tables, scenario manager and goal seek. In the second half of the course, will cover how to visualize data, tell a story and explore data by reviewing core principles of data visualization and dashboarding. You’ll use Excel to build complex graphs and Power View reports and then start to combine them into dynamic dashboards.

Outline

Preparing a Professional Excel
Welcome to Course 3
Introduction to the Scenarios Used in this Course
Tao of Excel Recap and Guiding Principles
The Power of Visualization
Introduction to Working with Data Sets
Introduction to the Components of Data Sets and the Relational Database Model
Introduction to Keys and Forming Data Tables
Introduction to Joins
Overview of SQL and Other Database Tools
A Message from our Chief People Officer at PwC
PowerPivot: Importing and Preparing Data
Linking Data Tables and Building the Relational Model
Using PowerPivot to Visualize Data
Calculated Fields
Multiple Data Tables and Filters
Week 1 closing
Course Overview and Syllabus
Meet the PwC Instructors and Content Developers
Guiding Principles Handout
Week 1 Excel Student Exercise Workbook
Week 1 Quiz

Advanced Scenario Analysis
Introduction to Week 2
Advanced Scenario Analysis
Goal Seek
Scenario Manager
One-way Data Tables
Two-way Data Tables
Simulations
Solver
Week 2 Closing
Week 2 Excel Student Exercise Workbook
Week 2 Quiz

Data Visualization
Week 3 Opening
Introduction to Data Visualization
Effective and Ineffective Charting
Selecting the Right Type of Chart
Introduction to Chart Navigation
Column Chart
Combo Chart
Stacked Column Chart
Heatmap
Gantt Project Plan
Power View
Week 3 closing
Week 3 Excel Student Exercise Workbook
Week 3 Quiz

Dashboarding
Introduction to Week 4
Introduction to Dashboarding
Dashboarding: Beyond the basics
Form Controls and Grouping
Slicers and PowerPivot
Conditional Formatting and KPIs
Dashboard Finalization and Securing the Workbook
Week 4 Closing and Course Recap
Week 4 Excel Student Exercise Workbooks
Learn More About Career Opportunities at PwC
Week 4 Quiz

Summary of User Reviews

Discover the secrets of Advanced Excel with this highly-rated course on Coursera. This course has received rave reviews from users who have found it to be an excellent resource for improving their Excel skills. Many users have praised the comprehensive and practical approach taken by the course instructors, making it easy to understand and apply in real-world scenarios.

Key Aspect Users Liked About This Course

The course is highly practical and applicable to real-world scenarios.

Pros from User Reviews

The course covers a wide range of advanced Excel topics.
The instructors provide clear explanations and examples.
The course is well-structured and easy to follow.
The hands-on exercises and quizzes are helpful for reinforcing learning.
The course is suitable for both beginners and advanced users.

Cons from User Reviews

Some users find the pace of the course to be too slow.
The course may be too basic for users with extensive Excel experience.
Some users have experienced technical issues with the course platform.
The course may not be suitable for users seeking in-depth programming knowledge.
The course may not cover some of the latest Excel features.

Recommended for you

The Complete Core Java Course : Learn to Code

Learn Java from scratch. Ideal for testing professionals transitioning to DevOps or Automation. Java for Selenium. This course covers Core Java topics in detail from basic to advanced levels....

Save Course

[2021] Data Science: A-Z Bootcamp + Real Cases (Version 8.1)

A-Z Data Science Training: Advanced Statistics & Machine Learning with R, Excel + Tableau, Power BI from Best Seller Do you want a rewarding career?...

Save Course