Products
-
Hangout: How to Use Formulas in Conditional Formatting in Excel
CourseTechnique: How to Use Formulas in Conditional Formatting in Excel | Why: Creates a simple and visual way to see errors | Step 1: Determine where conditional formatting is needed | Step 2: Create conditional formatting with a formula
$4.99
-
Hangout: How to Create a Database in Excel from a Messy QB Export
CourseTechnique: How to Create a Database in Excel from a Messy QB Export | Why: Create a usable data table | Step 1: Use the F5 "Go To" Key | Step 2: Delete rows with blanks and subtotals
$4.99
-
Hangout: How to Add a Menu Tab to Your Presentation in Excel
CourseTechnique: How to Add a Menu Tab to Your Presentation in Excel | Why: Create simple navigation of the worksheet for users | Step 1: Insert shapes on the Menu Tab for each worksheet | Step 2: Link the shapes to the appropriate tab
$4.99
-
Hangout: How to Use a Pivot Table to Reconcile Data in Excel
CourseTechnique: How to Use a Pivot Table to Reconcile Data in Excel | Why: Provides a quick way to visualize data | Step 1: Ensure that your data is in table format | Step 2: Create the pivot table
$4.99
-
Hangout: How to Use the LOOKUP Function in Excel
CourseTechnique: How to Use the LOOKUP Function in Excel | Why: Look up a value in a range and return a corresponding value | Step 1: Create your formula with the LOOKUP function
$4.99
-
Hangout: How to Add a Calculation to a Pivot Table in Excel
CourseTechnique: How to Add a Calculation to a Pivot Table in Excel | Why: Create a pivot table that will update automatically | Step 1: Create the pivot table | Step 2: Add a calculated field
$4.99