Products
-
Hangout: How to Use the COUNTIFS Function
CourseTechnique: How to Use the COUNTIFS Function | Why: Determine if matching items are in a list using multiple criteria | Step 1: Import 2 item lists | Step 2: Use COUNTIFS to determine if line items match in both lists
$4.99
-
Hangout: How to Change List Names Using VLOOKUP
CourseTechnique: How to Change List Names Using VLOOKUP | Why: Data format and consistency | Step 1: Create a cross reference table | Step 2: Create the VLOOKUP formula
$4.99
-
Hangout: How to Add Formulas to a Pivot Table
CourseTechnique: How to Add Formulas to a Pivot Table | Why: Create formulas that will update automatically | Step 1: Insert a Pivot Table | Step 2: Insert a Calculated Field
$4.99
-
Hangout: How to Add % of Grand Total to a Pivot Table
CourseTechnique: How to Add % of Grand Total to a Pivot Table | Why: Create a % formula that will update automatically | Step 1: Insert a Pivot Table | Step 2: Insert the total twice in the Values box in the Pivot Table fields list
$4.99
-
Hangout: How to Protect Your Excel Worksheet with Data Validation
CourseTechnique: How to Protect Your Excel Worksheet with Data Validation | Why: Protect cells from being overwritten | Step 1: Highlight cells you want to protect | Step 2: Set data validation rules
$4.99
-
Hangout: How to Use a Spin Button in Excel
CourseTechnique: How to Use a Spin Button in Excel | Why: Creates a user friendly way to update values in a formula | Step 1: Create your formula | Step 2: Insert the Spin Button from the Developer Tab
$4.99