Complete Excel Bundle: 5-in-1 Beginner to Advanced Course
Taught by Gary Newport
Learn how to use Microsoft Excel like a pro with this step-by-step course!
About $0.24 per hour of instruction.
Get this course for $19 Watch the first lessons free30-day money-back guarantee · lifetime access
What you'll learn
- Excel fundamentals: interface, formatting, workflows
- Core formulas and functions (SUM, IF, COUNTIF, etc.)
- Advanced formulas (XLOOKUP, FILTER, INDEX/MATCH, dynamic arrays)
- Data cleaning and error handling techniques
- Text, date, and logical functions
- Data visualization: charts, dashboards, 2D/3D maps
- How to create a budgetary system
- Pivot Tables and Pivot Charts
- Power Query and Power Pivot
- Predictive analysis techniques
- Tips and tricks for using Excel functions to check and manipulate data
- Dashboard creation and reporting
- Excel VBA and automation fundamentals
- Creating macros and custom Excel tools
That's about $0.24 per hour of expert instruction.
Get this course for $19 Watch the first lessons free30-day money-back guarantee
- Instant, lifetime access on any device
- All project files & resources included
- Try it risk-free - full refund, no questions asked
30-Day Money-Back Guarantee
100% refund, no questions asked.
Lifetime Access
Access your content on any device, at any time.
Friendly Support
Got a question? Ask in the course Q&A and our team is happy to help.
About The Course
Become an Excel expert! Master spreadsheets, powerful data analysis, and impactful visualizations with this comprehensive course.
Ever wanted to confidently use Excel to manage finances, analyze data, or create professional-quality reports? Excel is one of the most powerful and widely-used tools in the world for both personal and professional purposes, making spreadsheet skills essential for anyone.
This complete course covers everything from the basics to advanced techniques. You’ll learn to navigate Excel’s interface, create robust formulas and functions, and master essential skills such as conditional formatting, pivot tables, charts, and dynamic dashboards. Explore advanced topics including predictive analysis, power queries, dynamic array formulas, and powerful data visualization tools. Each lesson includes practical, step-by-step demonstrations and exercises to help you build practical, real-world skills.
Whether you’re managing personal finances, preparing business reports, or diving into complex data analytics, this course offers clear instructions from experienced instructors who specialize in making Excel accessible and engaging.
Enroll today and transform your spreadsheet skills into expertise!
Curriculum
5 sections · 78 hours of content
1 Excel Basics 20 lessons
- Introduction to Excel
- Getting to know the Interface
- Using Formulae
- Protecting Cells and Worksheets
- Data, Formatting and the First Function
- Basic Functions in Excel
- Shapes and Images
- Importing Data into Excel
- Averages in Excel
- Using Lookups in Excel
- More Functions in Excel
- Functions and Conditions
- Working with Dates and Text
- Simple Graphs and Charts
- Handling Text and Importing WWW Data
- Generating Test Data
- Creating a Budgetary System
- Revision Exercise: Astronomical Modelling
- New Functions in Excel 365
- More Basic Features of Excel
2 Excel Formulas & Functions 6 lessons
- Getting Started with Formulas & Functions
- Math & Logical Functions
- Text & Date Functions
- Lookup & Reference Functions
- Error Handling, Data Analysis & Aggregation
- Advanced Topics & Automation + Bonus Section
3 Excel Data Visualization 11 lessons
- Introduction
- Data Visualization through Tables
- From Tabular to Graphical Representation
- Chart Customizations
- Must-Know Charts & Graphs
- Specialized Charts & Graphs
- Useful Visualizations
- Dashboards in Excel
- Excel for Cartography
- Excel Add-Ins for Visualization
- Managing and Presenting Visualizations
4 Excel Data Analysis 10 lessons
- Introduction
- Reviewing the Basics
- Data Cleaning and Preparation
- Pivot Tables
- Power Query
- Power Pivot
- Dynamic Array Formulas
- Predictive Analysis
- Additional Practice and Exercises
- Capstone Project
5 Excel Programming 7 lessons
- Introduction
- Visual Basic for Applications and Getting Started
- Menus and Tools
- First Code and Statements
- Variables
- Procedures
- Application Methods and Additional Topics
What students are saying
“Well out of all those excel online i finally found out the best excel learning video and this course.”
“Very detailed course! This course teaches you so many things about excel.”
“Comprehensive guidance highlighting the essential need to know tools. Great learning platform for people who wants to learn excel but never has gotten any exposure before.”
“So far, it's interesting and the teacher explains it very well. It is what I needed.”
“Great course which really helped to advance my skills in Excel.”
“The Excel course was very well organized and easy to follow. The instructor explained each topic clearly and provided practical examples that made the lessons engaging and easy to understand.”
Free Excel tutorials
Quick, step-by-step how-to guides. A taste of what you'll master in the full course.
Related courses
Keep building momentum with these picks.
Ready to start learning?
Get lifetime access to this course for a single $19 payment. Or save with a bundle.
Get this course for $19Complete Excel Bundle: 5-in-1 Beginner to Advanced Course
$19 $139.99 -86% · lifetime access