Excel: Data Analysis and Visualization Fundamentals

Excel: Data Analysis and Visualization Fundamentals

This course is part of Data Analysis and Visualization with Microsoft Excel Specialization

Instructor: Bill Rosenthal

Access provided by Course Builder (Internal Testing)

2,058 already enrolled

3 modules

Gain insight into a topic and learn the fundamentals.

3 hours to complete

Flexible schedule

Learn at your own pace

3 modules

Gain insight into a topic and learn the fundamentals.

3 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Apply foundational data science principles to organize, structure, sort, and filter tabular operational records.
Formulate impactful visual narratives by engineering clear, professional charts that adhere strictly to clean design best practices.
Maximize audience engagement by isolating core information blocks, tailoring contexts, and removing distracting visual clutter.
Learn by doing. Perform guided, step-by-step hands-on activities on your own computer.

Skills you'll gain

Tools you'll learn

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

1 assignment

Taught in English

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

Learn more about Coursera for Business

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

Build your subject-matter expertise

This course is part of the Data Analysis and Visualization with Microsoft Excel Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 3 modules in this course

This course will be useful for anyone who has a foundational knowledge of Excel and would like to perform more robust and advanced data analysis. You will begin by performing fundamental data-analysis tasks like creating tables and sorting and filtering data. You'll also start visualizing data with Excel through charts.

Embracing data analysis as part of a job role requires that you grasp fundamental concepts about data science, data analysis, and visualization. It also requires an understanding of the core data organization and segmentation capabilities in Excel. In this lesson, you'll perform fundamental data analysis tasks in Microsoft® Excel®.

What's included

1 reading6 plugins

Microsoft® Excel® provides you with powerful features to help organize and analyze data, but once your analysis is complete, you have to communicate your findings. The people you report or present data to might not have the same comfort level or expertise when it comes to viewing worksheets. Further, viewing rows of numbers in tables is not a natural way for people to process information. To communicate effectively, you need to provide a simple, easy-to-digest view of relevant data so your audience can quickly understand what's really important.