Products
-
Hangout: How to Use Absolute Referencing to Create a Dynamic Financial Statement
CourseTechnique: How to Use Absolute Referencing to Create a Dynamic Financial Statement | Why: Easily create and update financial statements from a raw trial balance | Step 1: Import trial balance | Step 2: Create and design the financial statement
$4.99
-
Hangout: How to Automatically Update a Date Value in a Table in Excel
CourseTechnique: How to Automatically Update a Date Value in a Table in Excel | Why: Not all dates export in the right format | Step 1: Set up your table and formula | Step 2: Import data into the table
$4.99
-
Hangout: How to Use a Checkbox in Excel
CourseTechnique: How to Use a Checkbox in Excel | Why: Creates a way to show or hide values in a table | Step 1: Create your formula | Step 2: Insert the Checkbox from the Developer Tab
$4.99
-
Excel, Accelerated: Create uniform starting column
CourseTime: 3:08 | Task: Create uniform starting column from comparative Balance Sheet | Acceleration techniques: TRIM, CONCAT, Delete columns, Format Painter, absolute referencing, VLOOKUP, MATCH
$4.99
-
Excel, Accelerated: Create a database layout with multiple dimensions
CourseTime: 5:03 | Task: Create a multidimensional database layout from information laid out in a different format | Acceleration techniques: Transpose, VLOOKUP, INDEX, MATCH, Format Painter, absolute referencing, PivotTable
$4.99
-
Excel, Accelerated: Format a number in a text string
CourseTime: 1:40 | Task:Format a number in a string which concatenates both text and numbers from cells in a database | Acceleration techniques: CONCAT, TEXT, TEXTJOIN
$4.99