Products
-
Hangout: How to Use a Simple COUNTIF Formula
CourseTechnique: How to Use a Simple COUNTIF Function | Why: Count the number of items in a list | Step 1: Create or import a list of items | Step 2: Use the COUNTIF to determine the number of items in the list
$4.99
-
Hangout: How to use a simple IFERROR Function
CourseTechnique: How to use a simple IFERROR Function | Why: Cleans up your presentation | Step 1: Create your formula | Step 2: Add the IFERROR function
$4.99
-
Hangout: How to Record and Use a Macro
CourseTechnique: How to Record and Use a Macro | Why: To simplify a routine task | Step 1: Add the Developer Tab if you don't already have it | Step 2: Record the macro | Step 3: Add the button to your spreadsheet | Step 4: Save as Macro-Enabled
$4.99
-
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