Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
21 Hour(s) 58 Minute(s)
Language
English
Taught by
Kyle Pew • 2,000,000+ Students, Office Newb
Rating
Course Overview
All-in-One Excel Training: Transform Your Skills with Hands-On Projects and Real-World Applications! - Excel 2007-2025
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, TEXTSPLIT and 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!
Course Content
- 10 section(s)
- 272 lecture(s)
- Section 1 Microsoft Excel 101 Course Introduction
- Section 2 Microsoft Excel Fundamentals
- Section 3 Entering and Editing Text and Formulas
- Section 4 Working with Basic Excel Functions
- Section 5 Modifying an Excel Worksheet
- Section 6 Formatting Data in an Excel Worksheet
- Section 7 Inserting Images and Shapes into an Excel Worksheet
- Section 8 Creating Basic Charts in Excel
- Section 9 Printing an Excel Worksheet
- Section 10 Working with Excel Templates
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
Skills covered in this course
Reviews
-
BBenito Georges
I really like the way he explains the lessons. Content well-structured and detailed. Your patience makes the contents very easy to understand. I'm just waiting for the end of this course to take another one. Thank you so much for sharing your knowledge.
-
NNiki Mooneyham
This was one of the best online courses I have ever taken. Mr. Pew was excellent at explaining things clearly and keeping me engaged. I really enjoyed following along and learning so much more about excel and vba. I highly recommend the is course.
-
NNguyen Hoang Phi
Perfect course, especially for beginner who know nothing before. With my purpose I just need to complete 64% this course, don't need to learn about VBA Macro.
-
JJoel Sebastian Samuel
My experience in this MS Excel course was amazing. I learned a lot about MS tools and functions. I hope the knowledge I gained from this course will help me in my life, postgraduate studies, and job. Thank you very much.
