Products
-
Excel, Accelerated: Dynamic rolling average
CourseTime: 3:50 | Task: Create a rolling n-month average that ignores annual totals | Acceleration techniques: AVERAGEIFS, EOMONTH, IFERROR, IF, MIN, absolute referencing, concatenate operator, helper row, use a named range in 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
-
Excel, Accelerated: Delete blank rows
CourseTime: 1:57 | Task: Delete blank rows | Acceleration techniques: Go To, activate the Delete Cells dialog, record a macro, assign a keyboard shortcut to a macro, make a macro available to all locally open Excel files
$4.99
-
Excel, Accelerated: Identify overdue items
CourseTime: 4:18 | Task: Identify overdue items | Acceleration techniques: Conditional formatting, AND, TODAY, <=, use a control cell, AutoFilter, table object, slicers
$4.99