Individual course

Transform and Visualize Data with Excel Tools

Coming soon 23 topics Self-paced · Online

Notify me when it launches

Where this comes from

Built from the Wiley title of the same name — professionally edited, technically reviewed, and already relied on by people doing this work.

Source ISBN 9781119844471

How it was built

Sejal Learning Systems rebuilt the book as a course: objectives first, then short video, worked examples, and practice with real feedback. It runs on Coursera at your own pace, with a certificate on completion.

Transform and Visualize Data with Excel Tools is a self-paced online course built from the Wiley title of the same name.

What this course covers

Introduction
Part 1: Getting Started with Data Analysis
Chapter 1: Learning Basic Data-Analysis Techniques
Chapter 2: Working with Data-Analysis Tools
Chapter 3: Introducing Excel Tables
Chapter 4: Grabbing Data from External Sources
Chapter 5: Analyzing Table Data with Functions
Part 2: Analyzing Data Using PivotTables and PivotCharts
Chapter 6: Creating and Using PivotTables
Chapter 7: Performing PivotTable Calculations
Chapter 8: Building PivotCharts
Part 3: Discovering Advanced Data-Analysis Tools
Chapter 9: Dealing with Data Models
Chapter 10: Tracking Trends and Making Forecasts
Chapter 11: Analyzing Data Using Statistics
Chapter 12: Analyzing Data Using Descriptive Statistics
Chapter 13: Analyzing Data Using Inferential Statistics
Part 4: The Part of Tens
Chapter 14: Ten Things You Ought to Know about Statistics
Chapter 15: Ten Ways to Analyze Financial Data
Chapter 16: Ten Ways to Raise Your PivotTable Game
Appendix: Glossary of Data Analysis and Excel Terms
Author Bio