Products
-
Hangout: How to Create and Use a Timeline
CourseTechnique: How to Create and Use a Timeline | Why: Jazz up your presentation and make it more user friendly | Step 1: Insert a Pivot Table | Step 2: Insert a Timeline
$4.99
-
Hangout: How to Create and Use a Dropdown Box
CourseTechnique: How to Create and Use a Dropdown Box | Why: Data consistency | Step 1: Create a list of items | Step 2: Create the box
$4.99
-
Hangout: How to Automate a Bank Reconciliation in Excel
CourseTechnique: How to Automate a Bank Reconciliation in Excel | Why: Efficiency | Step 1: Set up your account register as a table | Step 2: Create the header for the bank rec | Step 3: Export the banking transactions to a separate tab | Step 4: Formulas
$4.99
-
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