Excel Bible: Basic to Advanced in 2.5 Hours

Learn Excel fast: Logical functions, lookup, Pivot Tables, charts & intro to VBA – all in just 2.5 hours

What you'll learn

• Mastering Basic and Advanced Excel Functions
• Creating and Managing Tables and Charts
• Data Analysis and Interpretation
• Automating Processes with Macros and Formulas

Requirements

• You don't need any prior knowledge of Excel to get started with this course.
• You need a laptop/desktop and a Microsoft Excel licence

Description

Welcome to the Excel Bible – a fast and practical course designed to take you from beginner to advanced in just 2.5 hours!

Whether you're new to Excel or already familiar with its basics, this course is structured to help you simplify your daily work, automate repetitive tasks, and analyze data with confidence.

You'll start with the fundamentals: logical functions like IF, AND, OR, data validation, conditional formatting, and cell referencing. Then, you’ll dive into powerful lookup functions like VLOOKUP, XLOOKUP, and INDEX & MATCH, which will help you build dynamic and flexible formulas.

From there, we’ll explore Pivot Tables, one of Excel’s most valuable tools for summarizing large data sets — followed by creating professional charts (bar, column, line, pie) to visualize your insights effectively.

You’ll also learn how to recognize and fix common Excel errors, improving your confidence and troubleshooting skills. To top it off, the course includes an introduction to macros and VBA programming to help you start automating tasks in Excel.

This course is hands-on and includes downloadable Excel files so you can follow along with each lecture.

Who is it for? Students, professionals, entrepreneurs, or anyone who wants to master Excel without wasting time.

By the end, you’ll not only understand Excel—you’ll use it like a pro.