Products
-
Hangout: How to Add a Menu Tab to Your Presentation in Excel
CourseTechnique: How to Add a Menu Tab to Your Presentation in Excel | Why: Create simple navigation of the worksheet for users | Step 1: Insert shapes on the Menu Tab for each worksheet | Step 2: Link the shapes to the appropriate tab
$4.99
-
Hangout: How to Use a Pivot Table to Reconcile Data in Excel
CourseTechnique: How to Use a Pivot Table to Reconcile Data in Excel | Why: Provides a quick way to visualize data | Step 1: Ensure that your data is in table format | Step 2: Create the pivot table
$4.99
-
Excel, Accelerated: Delete blank rows
CourseTime: 1:57 | Task: Delete blank rows | Acceleration techniques: Go To, activate the Delete Cells dialog, record a macro, assign a keyboard shortcut to a macro, make a macro available to all locally open Excel files
$4.99
-
Excel, Accelerated: Identify overdue items
CourseTime: 4:18 | Task: Identify overdue items | Acceleration techniques: Conditional formatting, AND, TODAY, <=, use a control cell, AutoFilter, table object, slicers
$4.99
-
Excel, Accelerated: Forecasted accrual of multiple staggered bills
CourseTime: 2:50 | Task: Forecast and accrue expenses for multiple staggered bills | Acceleration techniques: MAXIFS, SUMIFS, table object, format painter, ROUND, use a control cell, fill down
$4.99
-
Excel, Accelerated: Create a chart from the most recent form entry
CourseTime: 2:16 | Task: Create a chart from the most recent form entry values | Acceleration techniques: MAX, VLOOKUP, COLUMNS, create and name a table, pie chart
$4.99