Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Udemy

Microsoft Excel - Excel from Beginner to Advanced

via Udemy

Go to class Write review

Overview

All-in-One Excel Training: Transform Your Skills with Hands-On Projects and Real-World Applications! - Excel 2007-2025

What you'll learn:
  • Create and manage organized, professional Microsoft Excel spreadsheets from scratch
  • Master essential Excel functions like SUM, VLOOKUP, IF, and more
  • Analyze large Excel data sets with confidence and find key insights
  • Build dynamic reports using Excel PivotTables and visualizations
  • Automate repetitive tasks efficiently with Excel Macros and VBA
  • Design interactive dashboards and reports with Excel PowerPivot
  • Use advanced Excel functions to tackle real-world business problems
  • Improve productivity with time-saving Excel shortcuts and best practices
  • Gain the confidence to solve complex Excel tasks with ease

Master Microsoft Excel: Beginner to Expert All-in-One Course

Unlock the full potential of Microsoft Excel in this comprehensive course designed to take you from beginner to advanced—plus expert-level tools like Macros and VBA. Perfect for any version from Microsoft Excel 2007 to 2025, this course bundles four intensive classes into one powerful package.


What You’ll Learn
Whether you’re just starting or looking to automate your workflow, we’ve got you covered:

  • Building organized and effective spreadsheets

  • Managing and analyzing large data sets with ease

  • Mastering essential Excel functions like SUM, VLOOKUP, IF, and INDEX/MATCH

    • Including new Microsoft 365 Functions like XLOOKUP, SWITCH, TEXTSPLITand more

  • Creating dynamic reports with PivotTables

  • Harnessing PowerPivot for more advanced data modeling

  • Cleaning and auditing formulas to ensure accuracy

  • Automating tasks with Macros and VBA


What’s Included?

  • 22+ hours of in-depth video instruction led by a Microsoft Certified Trainer

  • Downloadable exercise files to follow along and practice

  • Section quizzes to reinforce learning

  • An interactive Q&A board for questions and support


Student Success Story

  • "This course is amazing. Not everyone has the gift of teaching, but Kyle truly makes Excel easy and engaging. I now know Excel better than ever and feel ready to tackle any project!"

  • "This course made me an Excel pro! I was a total beginner, and now I feel confident tackling any Excel task. Kyle’s course is well-structured and easy to follow—highly recommend!"

  • "Excel has been a mystery to me until this course! Kyle’s teaching made it simple to understand. If you’re hesitant, don’t be—this is the course to buy!"


Take the next step in mastering Excel. Enroll now and transform from an Excel novice to an Excel expert!

Syllabus

  • Microsoft Excel 101 Course Introduction
  • Microsoft Excel Fundamentals
  • Entering and Editing Text and Formulas
  • Working with Basic Excel Functions
  • Modifying an Excel Worksheet
  • Formatting Data in an Excel Worksheet
  • Inserting Images and Shapes into an Excel Worksheet
  • Creating Basic Charts in Excel
  • Printing an Excel Worksheet
  • Working with Excel Templates
  • Excel 101 - Practice What You've Learned (DOWNLOAD)
  • Congratulations! You've Built a Solid Microsoft Excel Foundation
  • Microsoft Excel 102 Course Introduction
  • Working with an Excel List
  • Excel List Functions
  • Excel Data Validation
  • Importing and Exporting Data
  • Excel PivotTables
  • Working with Excel's PowerPivot Tools
  • Working with Large Sets of Excel Data
  • Excel 102 Additional Practice Exercises
  • Congratulations! You're an Intermediate Excel User
  • Microsoft Excel 103 Course Introduction
  • Working with Excel's Conditional Functions
  • Working with Excel's Lookup Functions
  • Working with Excel's Text Based Functions
  • New Excel Functions for Excel 2019 and Microsoft 365 Excel Editions
  • Auditing an Excel Worksheet
  • Protecting Excel Worksheets and Workbooks
  • Mastering Excel's "What If?" Tools
  • Automating Repetitive Tasks in Excel with Macros
  • Excel 103 Additional Practice Exercises
  • Congratulations!
  • Microsoft Excel Macros and VBA Course Introduction
  • Project #1: Using Excel's Macro Recorder Tool
  • Excel VBA Concepts
  • Working with Excel VBA Logic Statements
  • Project #2: Moving Beyond the Basics and into VBA
  • Project #3: Preparing and Cleaning Up Data with Excel VBA
  • Project #4: Using VBA to Automate Excel Formulas
  • Project #5: Bringing it All Together and a Weekly Report
  • Project #6: Working with Excel VBA User Forms
  • Project #7: Importing Data from Text Files
  • Course Wrap Up

Taught by

Kyle Pew and Office Newb LLC

Reviews

4.0 rating, based on 1 Class Central review

4.7 rating at Udemy based on 525673 ratings

Start your review of Microsoft Excel - Excel from Beginner to Advanced

  • Mahale Priti Balasaheb
    2
    I enjoyed this course so much as well as all course in the specialization. I learned a lot about how I can become a better learner. This course was very intersecting and useful . I have some tools that I can use to optimize my learning potential. However ,I feel some difficulty to pass week -5 of this Advance course in which there are more volatile formulas but I devote more time to understand and clear the concept of formulas.
    Practise makes permanent so the periodic quiz questions and weekly assessment helped ensure that I had grasped the learning objectives
Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.