Products
-
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
-
Excel, Accelerated: Compare 4 key metrics for 350 companies over 10 years
CourseTime: 5:48 | Task: Create a dynamic dashboard to compare 4 key metrics for 350 companies over 10 years | Acceleration techniques: ROUND, RANDBETWEEN, TEXT, Remove Duplicates, Name a range, Data validation, Drop-down list, SUMIFS, Line graph
$49.99
-
Excel, Accelerated: Total database figures in new columns
CourseTime: 2:46 | Task: Total database figures in a new report with dates in columns | Acceleration techniques: SUMIF, RANDBETWEEN, TEXT, Remove Duplicates, Table, PivotTable, copy a column to a row
$4.99
-
Excel, Accelerated: Create sheet tabs from cell data
CourseTime: 3:03 | Task: Create sheet tabs from cell data | Acceleration techniques: Record a macro; edit the VBA code; create a For/Next loop; Sheet, Range, and Cell objects
$4.99