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
-
Hangout: How to Rename List Items with a Cross Reference Table in Excel
CourseTechnique: How to Rename List Items with a Cross Reference Table in Excel | Why: Rename items so they can be imported into the accounting system | Step 1: Create and name a cross reference table | Step 2: Use VLOOKUP to change the names
$4.99
-
Hangout: How to Dynamically Update Start and End Dates for a List of Transactions in Excel
CourseTechnique: Dynamically Update Start and End Dates for a List of Transactions in Excel | Why: Create a visual that quickly shows the start and end dates of a list | Step 1: Import your data into a named table | Step 2: Create the MIN and MAX formulas
$4.99
-
Hangout: How to Avoid the Divide by Zero Error in Your Presentation
CourseTechnique: How to Avoid the Divide by Zero Error in Your Presentation | Why: Eliminate displaying unsightly errors in your presentation | Step 1: Create your formulas | Step 2: Add the IFERROR function
$4.99