Products
-
Hangout: How to compare data and summarize with PivotTable
CourseTechnique: How to compare data and summarize with PivotTable | Why: Create a sales by state summary | Step 1: Create and name your tables | Step 2: Use XLOOKUP to combine data from the 2 tables | Step 3: Summarize with a PivotTable
$4.99
-
Hangout: How to Use Formulas in Excel to Get Your Data Just Right
CourseTechnique: How to Use Formulas in Excel to Get Your Data Just Right | Why: Easily modify exported data so that it is useful | Step 1: Create a table with formula columns | Step 2: Paste raw data into your formatted table
$4.99
-
Excel Hangout: How to use a simple VLOOKUP function
CourseTechnique: How to Use a Simple VLOOKUP Function | Why: Match criteria and select a value | Step 1: Create or import a list of items | Step 2: Use the VLOOKUP formula to add values using a matching criteria
$4.99
-
Excel Hangout: How to use a simple SUMIF function
CourseTechnique: How to use a simple SUMIF function | Why: Add values from a table that match your criteria | Step 1: Create or import a list of items | Step 2: Use the SUMIF formula to add values using a matching criteria
$4.99
-
Excel Hangout: How to Eliminate that Rounding Problem on Your Financial Statements
CourseTechnique: How to Eliminate that Rounding Problem on Your Financial Statements | Why: Don't give clients a statement that is out of balance | Step 1: Import trial balance | Step 2: Create the financial statement | Step 3: Setup rounding placeholder
$4.99
-
Excel Hangout: How to Create and Use a Slicer for Dynamic Presentation
CourseTechnique: How to Create and Use a Slicer for Dynamic Presentation | Why: Creates a visual way to filter data on the fly | Step 1: Create a data table | Step 2: Add a totals row | Step 3: Insert a slicer
$4.99