Products
-
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
-
Excel, Accelerated: Forecasted accrual of multiple staggered bills
CourseTime: 2:50 | Task: Forecast and accrue expenses for multiple staggered bills | Acceleration techniques: MAXIFS, SUMIFS, table object, format painter, ROUND, use a control cell, fill down
$4.99
-
Excel, Accelerated: Create a chart from the most recent form entry
CourseTime: 2:16 | Task: Create a chart from the most recent form entry values | Acceleration techniques: MAX, VLOOKUP, COLUMNS, create and name a table, pie chart
$4.99
-
Excel, Accelerated: Create a basic startup 3-year P&L forecast
CourseTime: 5:17 | Task: Create a basic 3-year P&L startup forecast| Acceleration techniques: ROUND, dynamic rounding, goal seek to forecast revenue based on owner compensation requirements, Group and Outline, asymmetrical absolute referencing
$4.99