Login Sign Up

Microsoft Excel for Complete Beginners w/ Case Studies

Via Udemy

Udemy based on 626 ratings

Share

0

Overview

This course offers a step-by-step introduction to Microsoft Excel, designed for absolute beginners. It covers spreadsheets, formulas, functions, formatting, data entry, and charts with a focus on real-world applications. Case studies reinforce each concept, helping learners understand how Excel can solve business problems, track data, and perform calculations. The course is ideal for students, professionals, and small business owners looking to build confidence with Excel for daily tasks and reporting. No prior experience is required, and by the end, you'll...

Syllabus

  • Start Here
  • Jumpstart Case - A Little Fun with MBA Statistics
  • Foundations: Knowing your way around Excel
  • Foundations: Essential Excel Functions, Formulas, and Concepts
  • Foundations: Mastering Times, Dates, and Text
  • Foundations: Essential Statistics for Excel
  • Essentials Excel Charts for Business
  • Lookups and Data Functions
  • Analyzing with Pivot Tables
  • Data Models with Power Pivot
  • Intro to Excel Macros
  • Data Prep with Power Query
  • Case Studies
  • Case: User Activity with Google Analytics
  • Case: Simple Analysis of Gaming Industry
  • Case: Analyzing Trends for Cryptocurrency
  • Case: Evaluating survey data
  • Case: 2020 Pandemic Data Visualization
  • Case: Evaluating a rental income property
  • Case: SaaS Conversion Funnel with Google Analytics
  • Case: Venture Market Research
  • Case: Keyword Analytics for Marketing
  • Appendix Extras
  • For First Time Udemy Users
Microsoft Excel for Complete Beginners w/ Case Studies
Go to Class

via Udemy

18 hours 49 minutes

Certificate Available

English

On-Demand

Beginner

Instructor

Symon He

Reviews

No reviews yet. Be the first to review!