Microsoft Excel

Excel Beginner to Advanced Ultimate Course

Dr. Robert Ryan
Overview
Curriculum
  • 2 Sections
  • 45 Lessons
  • 16h 21m Duration
Collapse All
Beginner's Guide
15 Lessons
  1. Introduction
  2. Additional Resources
  3. Excel Structure
  4. Data Entry
  5. Formulas
  6. Math Functions
  7. Number Formatting
  8. Challenge #1
  9. Useful Functions
  10. Conditional Formatting
  11. Simple Charts
  12. Excel Table
  13. Data Validation
  14. Challenge #2
  15. Project: Personal Finance Tracker
Advanced Guide
30 Lessons
  1. Section Introduction
  2. Logical Functions
  3. Date & Time Functions
  4. Text & Regex Functions
  5. Lambda Toolkit Functions I
  6. Lambda Toolkit FunctionsII
  7. Challenge #1
  8. Pivot Tables and Charts 6A
  9. Pivot Tables & Charts 6B
  10. Pivot Tables and Charts 6C
  11. Pivot Tables and Charts 6D
  12. Pivot Tables and Charts 6E
  13. Pivot Tables and Charts 6F
  14. Pivot Tables and Charts 6G
  15. KPI Cards
  16. Dashboard Design
  17. Power Query
  18. Useful Charts
  19. Challenge #2
  20. Project: Sales Dashboard
  21. Project Sales Dashboard Part A
  22. Project Sales Dashboard Part B
  23. Project Sales Dashboard Part C
  24. Project Sales Dashboard Part D
  25. Project Sales Dashboard Part E
  26. Project Sales Dashboard Part F
  27. Project Sales Dashboard Part G
  28. Project Sales Dashboard Part H
  29. Project Sales Dashboard Part I
  30. Project Sales Dashboard Part j

Take your Excel skills from a beginner level to an advanced level. Starting with the fundamentals, you'll learn formulas, functions, formatting, charts, tables and data validation before progressing to powerful advanced features including Dynamic Arrays, the LAMBDA Toolkit, PivotTables, Slicers, Power Query and advanced data visualisation. You'll learn how to analyse data, turn raw information into meaningful insights, and design professional Excel dashboards.

Learn by doing through practical challenges and real-world projects, including a Finance Tracker and a Sales Dashboard. Whether you're completely new to Excel or looking to take your existing skills to the next level, this course gives you the knowledge and practical experience to work confidently with Excel, solve real-world problems, and build professional, portfolio-ready projects.

Deleting Course Review

Are you sure? You can't restore this back

Course Access

This course is password protected. To access it please enter your password below:

Related Courses

Microsoft Excel

Suitable for beginners

Learn math, logical, lookup & array functions

Use pivot tables and charts to build interactive dashboards

4h 38m
4
14
Microsoft Excel
5 (2)

Learn cell references, number formatting, conditional formatting and data validation

Learn with practical examples and additional practice exercises

Suitable for beginners

2h 14m
19
10
Scroll to top