Course 4 of 4 in this specialization
Master Excel for Data Analysis and Automation
Coming soon 24 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 9781394317264
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.
Master Excel for Data Analysis and Automation is a self-paced online course built from the Wiley title of the same name.
What this course covers
- Introduction
- Part 1: Explaining Excel Fundamentals
- Chapter 1: Getting Started with Spreadsheets
- Chapter 2: Carrying Out Basic Calculations
- Chapter 3: Formatting Cells and Worksheets
- Chapter 4: Sifting Through Data
- Chapter 5: Tackling Tables
- Part 2: Mastering Formulas and Functions
- Chapter 6: Leveraging Lookup Formulas
- Chapter 7: Transforming Text and Numbers
- Chapter 8: Harnessing Logic Functions
- Chapter 9: Carving Data with Dynamic Arrays
- Chapter 10: Tracing and Debugging Formulas
- Part 3: Expanding Beyond the Basics
- Chapter 11: Navigating Through Worksheets and Workbooks
- Chapter 12: Visualizing and Summarizing Data
- Chapter 13: Contemplating Conditional Formatting
- Chapter 14: User-Proofing Excel Spreadsheets
- Part 4: Automating Analysis
- Chapter 15: Accessing Artificial Intelligence
- Chapter 16: Recording Macros
- Part 5: The Part of Tens
- Chapter 17: Ten Timesaving Keyboard Shortcuts
- Chapter 18: Ten Disaster Recovery Techniques