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 Gentera

2,467 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: Microsoft Excel
Category: Data Analysis
Category: Data Visualization Software
Category: Data Literacy
Category: Data Visualization
Category: Spreadsheet Software
Category: Microsoft 365
Category: Productivity Software
Category: Data Presentation
Category: Data Science
Category: Exploratory Data Analysis
Category: Analysis
Category: Pivot Tables And Charts
Category: Microsoft Office

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: Data Validation
Category: Excel Formulas
Category: Pivot Tables And Charts
Category: Microsoft Office
Category: Data Visualization
Category: Data Integrity
Category: Microsoft Excel
Category: Data Analysis
Category: Interactive Data Visualization
Category: Spreadsheet Software
Category: Productivity Software
Category: Microsoft 365
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: Microsoft Excel
Category: Dashboard Creation
Category: Pivot Tables And Charts
Category: Microsoft Office
Category: Geospatial Information and Technology
Category: Spreadsheet Software
Category: Interactive Data Visualization
Category: Microsoft 365
Category: Geospatial Mapping
Category: Data Visualization Software
Category: Dashboard
Category: Data Analysis
Category: Productivity Software
Category: Datamaps
Category: Data Visualization
Category: Data Presentation
Category: Data Storytelling
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: Data Cleansing
Category: Data Transformation
Category: Data Analysis
Category: Microsoft Excel
Category: Microsoft 365
Category: Microsoft Office
Category: Data Analysis Software
Category: Productivity Software
Category: Data Integration
Category: Statistical Analysis
Category: Statistical Visualization
Category: Sampling (Statistics)
Category: Data Wrangling

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 Modeling
Category: Pivot Tables And Charts
Category: Data Analysis Expressions (DAX)
Category: Microsoft Excel
Category: Microsoft 365
Category: Data Presentation
Category: Data Analysis
Category: Microsoft Office
Category: Data Visualization
Category: Spreadsheet Software
Category: Data Visualization Software
Category: Productivity Software
Category: Report Writing
Category: Business Reporting

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,028 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."