Excel Links

Uncle Joe's Book of Lookups

• Lookup Functions—for the kids!

  • Download the PDF

Slides

RACON functions

• RACONs: The Logical Test

• RACONs: COUNTIF, SUMIF, and AVERAGEIF

• RACONs: COUNTIFS, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS

• • • What are the RACON funcitons?

Conditional Formatting

• Conditional Formatting

• Conditional Formatting with Formulas

• Protecting cells, worksheets, & workbooks

• Using VLOOKUP with HLOOKUP

Functions Microsoft Wants You to Know

• For the current Excel 365 Associate and Expert Exams

• For the previous 2019 Excel Associate and Expert Exams

MO-211/TestOut Prep

• MO-211/TestOut Quick Reference Guides (PDFs)

• Most troublesome tasks for students on the Excel Expert certification exam

PivotTable Skills You Should Know

• Focused list of useful PivotTable skills

• Building PivotTables: Drop Zones

  • PDF  (more detailed instructions)