Excel Cram Kit (Exam 2)
AND vs. OR
2 Concepts
|
1 Practice Exercise
AND
OR
AND vs. OR – Practice!
Advanced IFs
4 Concepts
|
1 Practice Exercise
IFERROR
What if you have multiple conditions?
Nested IFs
IFS
Advanced IFs – Practice!
HLOOKUP
1 Concept
|
1 Practice Exercise
HLOOKUP
HLOOKUP – Practice!
Excel Tables
6 Concepts
|
1 Practice Exercise
Why use Excel Tables?
Create an Excel Table
Select a design
Sort records
Filter records
Insert Totals Rows
Excel Tables – Practice!
PivotTables
13 Concepts
|
1 Practice Exercise
Why use PivotTables?
Create a PivotTable
Assign rows / columns
Specify values for rows / columns + Slicers
Assign sub-rows / sub-columns
Top / Bottom results
Filter for records that meet condition
Place “all other values” in a different column
Handling no data in row / column
Order rows / columns
Percentages for rows / columns
Group records in range of values
Calculated field
PivotTables – Practice!
COUNTIF, SUMIF, AVERAGEIF
4 Concepts
|
1 Practice Exercise
What do COUNTIF, SUMIF, & AVERAGEIF do?
COUNTIF
SUMIF
AVERAGEIF
COUNTIF, SUMIF, AVERAGEIF – Practice!
SUMPRODUCT
1 Concept
|
1 Practice Exercise
SUMPRODUCT
SUMPRODUCT – Practice!
3D Cell References
1 Concept
|
1 Practice Exercise
3D Cell References
3D Cell References – Practice!
Practice Excel Exam 2, Module 1
Practice Excel Exam 2, Module 2
Practice Excel Exam 2, Module 3
Practice Excel Exam 2, Module 4
Practice Excel Exam 2, Module 5
Previous Module
Next Module
Advanced IFs
Excel Cram Kit (Exam 2)
Advanced IFs
Module Content
0% Complete
0/4 Steps
IFERROR
What if you have multiple conditions?
Nested IFs
IFS
Advanced IFs – Practice!
Previous Module
Back to Cram Kit
Next Module
Close
Home
Pricing
Courses
BUS 104
ACC 221
CSE 148
ECO 201
ECO 202
ISA 225
MTH 141
Contact
About
FAQ
Terms & Conditions
Course File Upload
Login