Complete Excel Bundle: 5-in-1 Beginner to Advanced Course
Learn how to use Microsoft Excel like a pro with this step-by-step course!
Start LearningWhat 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
30 Day Money-Back Guarantee
100% refund, no questions asked.
Lifetime Access
Access your content on any device, at any time.
Teaching Support
Never get stuck with our teaching assistants on call.
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 · 54 lessons · 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
Ready to start learning?
Get this course plus the entire Skillademia library for one price.
Start Learning