The Workbook is the central navigation hub of The Excel Scholar. Each section below links to a dedicated learning hub organized by skill level and topic. Whether you’re just starting with Excel or advancing into more powerful tools, these hubs provide structured, step-by-step guides designed to build practical spreadsheet skills that you can use immediately.
Absolute Basics
The Absolute Basics hub is where every Excel journey should begin. These foundational tutorials introduce the most essential Excel functions used in everyday spreadsheets, including SUM, AVERAGE, COUNT, and conditional formulas like SUMIF and COUNTIF. If you’re new to Excel or want to strengthen your core skills, start here.
Start with the Absolute Basics Hub
Click here –> Absolute Basics Hub
Logical Functions
The Logical Functions hub focuses on decision-making formulas that allow Excel to respond to conditions. You’ll learn how to use IF statements, nested logic, error handling functions like IFERROR and IFNA, and tools that help automate spreadsheet behavior based on rules.
Explore the Logical Functions Hub
Click here –> Logical Functions Hub (Coming Soon)
Lookup Functions
The Lookup Functions hub introduces powerful tools used to search for and retrieve information from tables and datasets. This section covers widely used functions such as VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, and INDIRECT, all of which are essential for working with structured data.
Go to the Lookup Functions Hub
Click here –> Lookup Functions Hub (Coming Soon)
Text Functions
The Text Functions hub teaches how to manipulate and clean text data inside Excel. You’ll learn how to extract text, combine text values, format names and numbers, and prepare messy text data for analysis using functions like LEFT, RIGHT, MID, and CONCAT.
Visit the Text Functions Hub
Click here –> Text Functions Hub (Coming Soon)
Date & Time Functions
The Date & Time Functions hub focuses on working with dates and times in Excel. This section teaches how to calculate durations, track deadlines, determine ages, and automate time-based calculations using functions such as TODAY, NOW, and DATE.
Open the Date & Time Functions Hub
Click here –> Date & Time Functions Hub (Coming Soon)
Math & Statistical Functions
The Math & Statistical Functions hub expands your calculation abilities beyond basic totals. This section includes functions used for multiplication, rounding, statistical analysis, and advanced calculations that support reporting and data analysis tasks such as SUMPROUDCT, MEDIAN, and RANK.
Enter the Math & Statistical Functions Hub
Click here –> Math & Statistical Functions (Coming Soon)
Dynamic Array Functions
The Dynamic Array Functions hub introduces modern Excel tools that allow formulas to return multiple results automatically. You’ll learn how to filter data dynamically, sort results instantly, and reshape data using functions such as FILTER, SORT, and TOCOL.
Access the Dynamic Array Functions Hub
Click here –> Dynamic Array Functions (Coming Soon)
Logical + Array Combinations
The Logical + Array Combinations hub combines logical formulas with dynamic array functions to build flexible and scalable spreadsheet solutions. This section teaches advanced workflows that use filtering logic and multi-condition formulas to solve complex problems efficiently.
Explore Logical + Array Combinations
Click here –> Logical + Array Combinations (Coming Soon)
Financial Functions
The Financial Functions hub focuses on formulas used to calculate loans, payments, and financial projections. You’ll learn how to use functions like PMT and RATE to analyze borrowing costs, repayment schedules, and long-term financial scenarios.
Go to the Financial Functions Hub
Click here –> Financial Functions (Coming Soon)
Advanced & Specialty Functions
The Advanced & Specialty Functions hub contains powerful tools designed for advanced spreadsheet workflows. This section includes functions such as LET and other specialized tools that improve performance, reduce formula repetition, and enable complex spreadsheet solutions.
Open the Advanced & Specialty Functions Hub
Click here –> Advanced & Specialty Functions (Coming Soon)
How To Use The Workbook
The Workbook is designed to help you navigate Excel learning in a structured and logical way. Each hub builds on the skills developed in the previous sections, allowing you to progress from basic calculations to advanced spreadsheet techniques. If you’re new to Excel, begin with the Absolute Basics hub and move forward step by step. If you’re solving a specific problem, choose the hub that best matches your task and explore the tutorials within that section.