Products
-
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
-
Excel, Accelerated: Create invoice ID from existing information
CourseTime: 1:57 | Task: Create invoice ID from existing information | Acceleration techniques: LEFT, TEXT, FIND, &, LOWER, UPPER, a variety of date formats, IFERROR
$4.99
-
Excel, Accelerated: Test for whether a number falls within a range
CourseTime: 1:55 | Task: Test for whether a number falls within a range | Acceleration techniques: Control cells, RANDBETWEEN, IF, AND, greater than or equal to operator, less than or equal to operator, absolute referencing, named ranges
$4.99
-
Excel, Accelerated: Count survey responses
CourseTime: 2:52 | Task: Tally survey response totals for each question | Acceleration techniques: COUNTIF, Create a database layout, keyboard shortcuts, PivotTable, PivotChart, Slicer
$4.99