Products
-
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
-
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
-
Hangout: How to Use AND and OR in an IF Statement in Excel
CourseTechnique: How to Use AND and OR in an IF Statement in Excel | Why: Consider multiple values for the truth of an IF statement | Step 1: Create or import a list of items | Step 2: Use the IF statement along with AND or OR
$4.99