Excel Links

The three most problematic areas in BUSI 2345

1. RACON functions

• RACONs: The Logical Test

• RACONs: COUNTIF, SUMIF, and AVERAGEIF

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

2. Lookup functions

   • VLOOKUP

   • INDEX & MATCH

     1. INDEX alone

     2. MATCH alone

   • Using VLOOKUP with HLOOKUP

   • XLOOKUP

   • XMATCH

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

Building a Pivot Table

• Drop Zones

• PDF  (more detailed instructions)

Conditional Formatting

• Conditional Formatting

• Conditional Formatting with Formulas