Excel Cram Kit (Exam 2)

Current Status

Not Enrolled

Price

$50.00

Get Started

Take this Course

Want a FREE TRIAL? Click here!

Cram Kit Content

Expand All

AND vs. OR 2 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/2 Steps

AND vs. OR – Practice!

Advanced IFs 4 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/4 Steps

What if you have multiple conditions?

Advanced IFs – Practice!

HLOOKUP 1 Concept | 1 Practice Exercise

Expand

Module Content

0% Complete 0/1 Steps

HLOOKUP – Practice!

Excel Tables 6 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/6 Steps

Why use Excel Tables?

Create an Excel Table

Select a design

Insert Totals Rows

Excel Tables – Practice!

PivotTables 13 Concepts | 1 Practice Exercise

Expand

Module Content

0% Complete 0/13 Steps

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

Expand

Module Content

0% Complete 0/4 Steps

What do COUNTIF, SUMIF, & AVERAGEIF do?

COUNTIF, SUMIF, AVERAGEIF – Practice!

SUMPRODUCT 1 Concept | 1 Practice Exercise

Expand

Module Content

0% Complete 0/1 Steps

SUMPRODUCT – Practice!

3D Cell References 1 Concept | 1 Practice Exercise

Expand

Module Content

0% Complete 0/1 Steps

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