Mastering the IF Function

SUM, AVERAGE, COUNT, and Basic MathPrev VLOOKUP: Finding Data Across SheetsNext

IF statements are the backbone of decision-making formulas in Excel. This lesson builds from a simple single-condition IF up to nested IFs and IFS for multiple conditions, with practical examples like grading thresholds and pass/fail flags.

Excel Fundamentals

The Excel Interface: Ribbon, Cells, and Navigation Entering, Editing, and Formatting Data Rows, Columns, and Worksheet Organization Absolute vs. Relative Cell References

Core Formulas and Functions

SUM, AVERAGE, COUNT, and Basic Math Mastering the IF Function VLOOKUP: Finding Data Across Sheets INDEX/MATCH: The More Flexible Lookup Text Functions: LEFT, RIGHT, TRIM, and CONCATENATE

Data Validation and Clean Spreadsheets

Creating Dropdown Lists with Data Validation Restricting Numbers, Dates, and Custom Rules Finding and Managing Duplicate Data

Pivot Tables and Data Analysis

Building Your First Pivot Table Grouping, Filtering, and Slicers Calculated Fields in Pivot Tables

Charts and Visual Reporting

Choosing the Right Chart Type Formatting Charts for Clarity Linking Charts to Live Data

Sharing, Linking, and Protecting Workbooks

Creating Hyperlinks Between Cells, Sheets, and Files Protecting Sheets and Locking Cells Printing and Exporting Clean Reports

Exam and Interview Readiness

Common Excel Assessment Question Patterns Speed Techniques for Timed Exams Putting It Together: A Full Practice Walkthrough