Products
-
Hangout: How to Create a Pivot Chart in Excel
CourseTechnique: How to Create a Pivot Chart in Excel | Why: Create a graphical view that can be easily updated | Step 1: Ensure that your data is in table format | Step 2: Create the pivot table and pivot chart
$4.99
-
Hangout: How to Use the HLOOKUP Function in Excel
CourseTechnique: How to Use the HLOOKUP Function in Excel | Why: Look up a value in a row based on the column heading | Step 1: Create your formula with the HLOOKUP function
$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
-
Excel, Accelerated: Create scenarios from columns in different combinations
CourseTime: 2:05 | Task: Add different combinations of cost sets for different scenarios | Acceleration techniques: Create an in-cell drop-down list, Name a range, COUNTIF, SUMPRODUCT, Absolute and relative referencing
$4.99
-
Excel, Accelerated: Control date groupings in a PivotTable
CourseTime: 1:13 | Task: Control date groupings in a PivotTable | Acceleration techniques: Group and ungroup dates in the PivotTable
$4.99