Products
-
Excel, Accelerated: Convert a Word list into a columnar Excel database
CourseTime: 2:16 | Task: Convert a Word list into a columnar Excel database | Context: Contact list | Acceleration techniques: ROW, CEILING.MATH, CONCAT, VLOOKUP, COLUMNS, 5 keyboard shortcuts, asymmetric absolute references
$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
-
Hangout: How to Use a Simple COUNTIF Formula
CourseTechnique: How to Use a Simple COUNTIF Function | Why: Count the number of items in a list | Step 1: Create or import a list of items | Step 2: Use the COUNTIF to determine the number of items in the list
$4.99
-
Excel, Accelerated: Calculate totals for columns of different lengths
CourseTime: 2:04 | Task:Calculate totals for columns of different lengths | Context: List of values | Acceleration techniques: VBA: Insert a new module, create a macro, define a variable, select a cell, assign a value to a cell
$4.99