Microsoft Excel for Complete Beginners w/ Case Studies

Master or review Excel with 10 real world case studies. Packed with supplemental material for analysts.

Created by: Symon He
Author | Investor | MBA

Created by: Travis Chow
Tech Veteran Mentoring & Teaching for 20+ Years

What Will I Learn?

• Learn and master Excel from complete beginner to advance
• Walk through 10 real-world business case studies
• Cover all Excel essential features with Foundation Series
• Build Excel models with advanced formulas
• Analyze with Pivot Tables, Data Models and Power Pivot
• Learn data lookups and preparation including Power Query
• Impress with charts, data viz and dynamic reports
• Intensive 6-week bootcamp for complete beginners on your own time
• Analytics expertise from two practicing professionals
• Excel instruction from version 2010 to 2020

Requirements

• Course is created using Microsoft Excel 2016 - 2020. Almost all features apply to Excel 2010 or newer while all analysis concepts and techniques will work for all versions.
• Recommended: Excel 2013 or newer
• No prior knowledge needed.

Target audience

• Complete beginners who want to master Excel from the ground up
• Beginner or intermediate users who want to see Excel applied to real world use cases
• Anyone who wants to feel confident in their Excel abilities in almost any business context