Excel Links

The two 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. Conditional Formatting

• Conditional Formatting

• Conditional Formatting with Formulas

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)