Microsoft Excel Review
Welcome to class! Everything you need is on this page: your materials for today, and your next steps when we're done. Bookmark it so you can come back anytime.
Get Your Class Materials
Download these before we start. They're yours to keep.
Student Manual
Step-by-step instructions plus a quick reference you'll use long after class.
Download Manual (PDF)What you'll be able to do after this class
- Use over 60 keyboard shortcuts to navigate and edit a workbook
- Change fonts, colors, alignment, and number formats
- Insert and delete rows and columns
- Freeze header rows and columns so they stay visible
- Use AutoFill to fill values, formulas, and patterns
- Filter and sort data
- Prepare worksheets for printing
- Design a PivotTable
- Create simple and advanced formulas
- Use Summary, Lookup, Logical, and Advanced functions
Course outline & exercise files
Here's where we're headed, section by section.
Navigate and Format Worksheets
Keyboard shortcuts, fonts, alignment, number formats, inserting and deleting rows and columns, freezing panes
Manipulate Excel Data
AutoFill for lists, months, days, dates, and number patterns; filtering; sorting by one or more columns
Prepare Data for Printing
Print area, fit to page, headers and footers, repeating column headers on every page
Design a PivotTable
What a PivotTable is, the data rules to follow first, and building one
Create Advanced Formulas
Range, math, and logical operators; absolute, mixed, and relative references; resizing the formula bar; building mega formulas
Summary Functions
SUM, AVERAGE, COUNT, MIN, MAX, SMALL, LARGE, MEDIAN, MODE, SUMIF, COUNTIF, SUMIFS, COUNTIFS
Lookup Functions
VLOOKUP, HLOOKUP, INDEX, MATCH
Logical Functions
IF, AND, OR, NOT, IFERROR
Advanced Functions
After Class
A few minutes now helps you keep what you learned, and helps me make the next class even better.
Complete the class evaluation
Two minutes. Your honest feedback shapes every future class.
Book your free 30-minute follow-up session
Bring a real spreadsheet from your job or home, and we'll work through it together one-on-one. It's the best way to make today's skills stick.
Enjoyed the class? Leave a Google review
Reviews help other people find practical, hands-on training. It takes about a minute.
Share a testimonial
A sentence or two about your experience. With your permission, I may share it on the TechMentors website.
Keep learning with the Tips & Tricks newsletter
Short, practical Excel and Office tips in your inbox, so today's class keeps paying off.
Ready for the Next Step?
When you're comfortable with these skills, these courses take you further.
Training for Your Team
Bring this class, or one built around your own data, to your workplace.
Let's TalkTrouble downloading a file? Ask for help, or just raise your hand in class.
