Calculated Fields in Pivot Tables

Grouping, Filtering, and SlicersPrev Choosing the Right Chart TypeNext

Sometimes the raw data doesn't have the metric you need — like profit margin from separate revenue and cost columns. This lesson shows how to add a calculated field directly inside the pivot table without altering your source data.

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