Logical Operations

Data Analysis and Visualization with Microsoft Excel Specialization

Logical Operations

Data Analysis and Visualization with Microsoft Excel Specialization

Analyze and Visualize Data with Excel.

Harness the power of Excel to extract insights from data and present that data visually.

Bill Rosenthal

Instructor: Bill Rosenthal

Access provided by SVEC + MBU

2,486 already enrolled

Get in-depth knowledge of a subject

from 9 reviews of courses in this program

Intermediate level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace
Get in-depth knowledge of a subject

from 9 reviews of courses in this program

Intermediate level

Recommended experience

4 weeks to complete
at 10 hours a week
Flexible schedule
Learn at your own pace

What you'll learn

  • In this Specialization, you will learn a comprehensive set of data-analysis and visualization skills using Excel.

Details to know

Shareable certificate

Add to your LinkedIn profile

Taught in English
Recently updated!

January 2026

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

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

Advance your subject-matter expertise

  • Learn in-demand skills from university and industry experts
  • Master a subject or tool with hands-on projects
  • Develop a deep understanding of key concepts
  • Earn a career certificate from Logical Operations

Specialization - 5 course series

Excel: Data Analysis and Visualization Fundamentals

Excel: Data Analysis and Visualization Fundamentals

Course 1, 3 hours

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

Category: Data Storytelling
Category: Data Analysis
Category: Microsoft Excel
Category: Data Presentation
Category: Data Science
Category: Pivot Tables And Charts
Category: Exploratory Data Analysis
Category: Spreadsheet Software
Category: Productivity Software
Category: Data Visualization
Category: Microsoft 365
Category: Data Visualization Software
Category: Analysis
Category: Data Literacy

What you'll learn

  • Construct advanced spreadsheet formulas using named ranges, logical functions, and nested evaluation criteria.

  • Control user input quality using data validation dialog boxes, custom error alerts, and interactive form layout controls.

  • Summarize massive transactional datasets into dynamic reporting views using dynamic array lookups and automated PivotTables.

  • Data files for this course are provided in the first course of this specialization, "Excel: Data Analysis and Visualization Fundamentals".

Skills you'll gain

Category: Pivot Tables And Charts
Category: Excel Formulas
Category: Data Validation
Category: Productivity Software
Category: Data Integrity
Category: Microsoft 365
Category: Interactive Data Visualization
Category: Microsoft Excel
Category: Data Analysis
Category: Spreadsheet Software
Category: Data Visualization
Excel: Dashboards and Geospatial Visualizations

Excel: Dashboards and Geospatial Visualizations

Course 3, 3 hours

What you'll learn

  • Build interactive business intelligence dashboards using dynamic PivotCharts, key performance indicators, and automated data refresh options.

  • Streamline report navigation by linking multi-chart views to synchronized data slicers and interactive timeline filters.

  • Generate advanced geospatial visualizations by integrating geographic information system data directly into custom map charts.

  • Data files for this course are provided in the first course of this specialization, "Excel: Data Analysis and Visualization Fundamentals".

Skills you'll gain

Category: Pivot Tables And Charts
Category: Dashboard Creation
Category: Microsoft Excel
Category: Dashboard
Category: Data Presentation
Category: Microsoft 365
Category: Productivity Software
Category: Interactive Data Visualization
Category: Data Visualization
Category: Data Analysis
Category: Datamaps
Category: Spreadsheet Software
Category: Geospatial Information and Technology
Category: Data Storytelling
Category: Geospatial Mapping
Category: Data Visualization Software
Excel: Statistical Analysis and Data Transformation

Excel: Statistical Analysis and Data Transformation

Course 4, 3 hours

What you'll learn

  • Project meaningful statistical trends across datasets using automated sparklines, moving averages, and varied trendline models.

  • Automate data connections from external sources into a centralized data model utilizing background query pipelines.

  • Clean, shape, and transform unformatted information blocks by splitting columns, merging attributes, and extracting text properties.

  • Data files for this course are provided in the first course of this specialization, "Excel: Data Analysis and Visualization Fundamentals".

Skills you'll gain

Category: Microsoft Excel
Category: Data Transformation
Category: Data Analysis
Category: Data Cleansing
Category: Productivity Software
Category: Data Integration
Category: Data Wrangling
Category: Statistical Analysis
Category: Statistical Visualization
Category: Data Analysis Software
Category: Microsoft 365
Category: Sampling (Statistics)

What you'll learn

  • Activate the Power Pivot interface to build unified data models, map database relationships, and define table cardinalities.

  • Formulate custom calculations and key performance indicators using Data Analysis Expressions syntax and functions.

  • Structure automated corporate reports using macro-enabled workbooks, specialized templates, and flat file exports.

  • Data files for this course are provided in the first course of this specialization, "Excel: Data Analysis and Visualization Fundamentals".

Skills you'll gain

Category: Data Analysis Expressions (DAX)
Category: Data Modeling
Category: Pivot Tables And Charts
Category: Business Reporting
Category: Microsoft 365
Category: Data Presentation
Category: Data Analysis
Category: Data Visualization Software
Category: Microsoft Excel
Category: Report Writing
Category: Data Visualization
Category: Productivity Software
Category: Spreadsheet Software

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Bill Rosenthal
Logical Operations
158 Courses38,664 learners

Offered by

Why people choose Coursera 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, Coursera 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. Coursera allows me to learn without limits."