Cover
Acknowledgements
Excel Overview
Time Saver
Auto Fill and Fill Series
Cell Referencing
Absolute and Relative Referencing
Navigation Shortcuts
Managing Cells
Sorting and Filtering
Hiding and Grouping
Paste Special
Named Ranges
Ranking
Rounding
Sum and Count
Managing Worksheets
Lookup Functions
Data Validation
IF Statements
Formula Errors
Text Functions
Text to Columns
Logic Functions 2
Date and Time
Conditional Formatting 1
Standards of Professionalism
Spreadsheet Formatting and Design
Basic Charts
Dashboards
Conditional Formatting 2
Spreadsheet Protection
Basic Pivot Tables
Advanced Pivot Tables and Slicers
Logic Functions 3
Advanced Lookup Functions
Loan Amortization Schedule
Advanced Charts
Macros 1
Macros 2
Macros 3
How to Use Search Engines

Acknowledgements

Senior Contributing Authors

Kevin Poaletti
Steve Rigby
Ashley Smith

Head Editor

Elizabeth Pingry

Associate Editor

Angela Talley
Cecelia Pendell
Katie Blunck

Contributing Authors

Mckenzie Foster
Hailey Pearson
Kurtis Venema