Excel Links

Slides

RACON functions

• RACONs: The Logical Test

• RACONs: COUNTIF, SUMIF, and AVERAGEIF

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

1. • Using VLOOKUP with HLOOKUP

Pivot Table

• Building PivotTables: Drop Zones

  • PDF  (more detailed instructions)

Conditional Formatting

• Conditional Formatting

• Conditional Formatting with Formulas

• Protecting cells, worksheets, & workbooks

Functions Microsoft Wants You to Know

• For the 2019 Excel Associate and Expert Exams

• For the new (as of 2023) 365 Associate and Excel Expert Exams

MO-211/TestOut Prep

• Most troublesome types of tasks for students on the certification exam

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

PivotTable Skills You Should Know

• Focused list of useful PivotTable skills