Level:
All Levels
Length:
78 hrs
Lectures:
296
Productivity & Business

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 Learning

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

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!

Complete Excel Bundle: 5-in-1 Beginner to Advanced Course

Curriculum

1 EXCEL BASICS: Introduction to Excel
2 Getting to know the Interface
3 Using Formulae
4 Protecting Cells and Worksheets
5 Data, Formatting and the First Function
6 Basic Functions in Excel
7 Shapes and Images
8 Importing Data into Excel
9 Averages in Excel
10 Using Lookups in Excel
11 More Functions in Excel
12 Functions and Conditions
13 Working with Dates and Text
14 Simple Graphs and Charts
15 Handling Text and Importing WWW Data
16 Generating Test Data
17 Creating a Budgetary System
18 Revision Exercise: Astronomical Modelling
19 New Functions in Excel 365
20 More Basic Features of Excel
21 EXCEL FORMULAS & FUNCTIONS: Getting Started with Formulas & Functions
22 Math & Logical Functions
23 Text & Date Functions
24 Lookup & Reference Functions
25 Error Handling, Data Analysis & Aggregation
26 Advanced Topics & Automation + Bonus Section
27 EXCEL DATA VISUALIZATION: Introduction
28 Data Visualization through Tables
29 From Tabular to Graphical Representation
30 Chart Customizations
31 Must-Know Charts & Graphs
32 Specialized Charts & Graphs
33 Useful Visualizations
34 Dashboards in Excel
35 Excel for Cartography
36 Excel Add-Ins for Visualization
37 Managing and Presenting Visualizations
38 EXCEL DATA ANALYSIS: Introduction
39 Reviewing the Basics
40 Data Cleaning and Preparation
41 Pivot Tables
42 Power Query
43 Power Pivot
44 Dynamic Array Formulas
45 Predictive Analysis
46 Additional Practice and Exercises
47 Capstone Project
48 EXCEL PROGRAMMING: Introduction
49 Visual Basic for Applications and Getting Started
50 Menus and Tools
51 First Code and Statements
52 Variables
53 Procedures
54 Application Methods and Additional Topics

54 chapters · 296 lectures · 78 hours of content

Ready to start learning?

Get this course plus the entire Skillademia library for one price.

Start Learning