Protecting Sheets and Locking Cells

Creating Hyperlinks Between Cells, Sheets, and FilesPrev Printing and Exporting Clean ReportsNext

Covers how to lock specific cells (like formulas) while leaving input cells editable, plus full sheet and workbook protection with passwords — essential when sharing a spreadsheet template with a team.

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