Skip to main content
Excel Workbook Basics
0%
Previous
Course data
General
Announcements
Getting Oriented in a Workbook
Overview: Getting Oriented in a Workbook
What a workbook contains
Cells, rows, columns, and ranges
Selecting without changing data
Moving around a sheet quickly
Beginner-friendly data entry rules
Reading a workbook structure before you edit
Review: Getting Oriented in a Workbook
Entering and Editing Data Safely
Overview: Entering and Editing Data Safely
Why safe data entry matters
Typing into cells with control
Editing cells without breaking structure
Using AutoFill and copy patterns safely
Finding and fixing common entry mistakes
Reading a worksheet as a grid of addresses
Review: Entering and Editing Data Safely
Organizing Data with Tables and Basic Formatting
Overview: Organizing Data with Tables and Basic Formatting
Why Tables Matter for Clean Lists
Turn a Range into a Table
Use Headers, Rows, and the Total Row Well
Apply Basic Formatting for Readability
Format Numbers So the Data Means the Right Thing
Keep Formatting Useful Across the Workbook
Review: Organizing Data with Tables and Basic Formatting
Sorting, Filtering, and Finding Records
Overview: Sorting, Filtering, and Finding Records
What sorting and filtering do
Sort one column and sort by more than one column
Filter records to narrow a list
Use Find, Go To, and keyboard shortcuts
Judge whether the visible rows make sense
Finding records in a busy worksheet
Review: Sorting, Filtering, and Finding Records
Building Simple Formulas and Summary Calculations
Overview: Building Simple Formulas and Summary Calculations
How formulas work in a workbook
Common operators and order of calculation
Using AutoSum and summary functions
Relative and absolute references
Copying formulas across rows and columns
Checking formula results before you trust them
Review: Building Simple Formulas and Summary Calculations
Assembling a Small Business Starter Workbook
Overview: Assembling a Small Business Starter Workbook
Plan the workbook layout
Build the data sheet
Turn the records into a table
Add the summary sheet
Connect summary cells with formulas
Check readability and safe entry
Review: Assembling a Small Business Starter Workbook
Course Study Guide
Overview: Course Study Guide
Recap
What You Can Do Next
Additional References
Review: Course Study Guide
Lab: Build a Small Business Starter Workbook
Overview: Lab: Build a Small Business Starter Workbook
Lab: Build a Small Business Starter Workbook
Review: Lab: Build a Small Business Starter Workbook
Lab: Build a Small Business Starter Workbook
Next
Side panel
Categories
All categories
Course Demonstrations
Free Mini Courses
AI Learning Hub
AI Essentials
Level 1: Generative AI Foundation
Level 2: Grounding AI with your Data
Level 3: Automating AI Workflows
Office
Webinars
Power BI
Programming
WordPress
Microsoft Official
Accounting
CompTIA
Google
Upskilling Series
ONLC Staff Training
Generative AI Skills
Instructor Review
Private Classes
Home
Log in
Username
Username
Password
Password
Forgot your password?
Log in
Categories
Collapse
Expand
All categories
Course Demonstrations
Free Mini Courses
AI Learning Hub
AI Essentials
Level 1: Generative AI Foundation
Level 2: Grounding AI with your Data
Level 3: Automating AI Workflows
Office
Webinars
Power BI
Programming
WordPress
Microsoft Official
Accounting
CompTIA
Google
Upskilling Series
ONLC Staff Training
Generative AI Skills
Instructor Review
Private Classes
Home
Course info
Excel Workbook Basics
Start with sheets, ranges, tables, and safe data entry.
Skill Level
:
Beginner
