Adkins Books Companion Resources
Excel for Beginners
The Complete Step-by-Step Guide to Formulas, PivotTables, XLOOKUP & Real-World Projects in Microsoft Excel
Learn Microsoft Excel step by step and access the companion resources for every chapter.
Chapter Resources
Select a chapter to access its tutorial, practice file, completed example, and updates.
Chapter 1
Welcome to Excel
Open resources →
Chapter 2
Your First Worksheet
Open resources →
Chapter 3
Rows, Columns, and Cells
Open resources →
Chapter 4
Basic Formatting
Open resources →
Chapter 5
Basic Formulas and Functions
Open resources →
Chapter 6
Sorting and Filtering Data
Open resources →
Chapter 7
Data Validation and Cleaning Errors
Open resources →
Chapter 8
Excel Tables
Open resources →
Chapter 9
Intermediate Formulas
Open resources →
Chapter 10
Lookup Functions
Open resources →
Chapter 11
Charts
Open resources →
Chapter 12
Advanced Conditional Formatting
Open resources →
Chapter 13
PivotTables Part 1
Open resources →
Chapter 14
PivotTables Part 2
Open resources →
Chapter 15
SUMIFS, COUNTIFS, and AVERAGEIFS
Open resources →
Chapter 16
Page Layout and Printing
Open resources →
Chapter 17
Keyboard Shortcuts
Open resources →
Chapter 18
Protecting and Sharing Workbooks
Open resources →
Chapter 19
Collaboration with OneDrive and Excel Online
Open resources →
Chapter 20
Introduction to Macros and Automation
Open resources →
Chapter 21
Excel and AI
Open resources →
Chapter 22
Capstone: Build a Budget Dashboard
Open resources →