Products
-
Excel, Accelerated: Add automatic checkboxes to your Control Panel
CourseTime: 00:01:43 | Techniques: Command button, in-cell checkbox, name a range, use VBA to change a cell value | Do your users need to keep track of their progress through your Excel macros? Watch the video and download the Excel template to learn how.
$4.99
-
Excel, Accelerated: Pull totals from a large timesheet
CourseTime: 00:02:38 | Techniques: SUMIFS, table object, PivotTable, timeline, named ranges, time number formatting | Do you need to pull a total from a range in a database? Watch the video and download the Excel template to learn how.
$4.99
-
Excel, Accelerated: Create a simple payroll allocation tool
CourseTime: 00:04:01 | Techniques: Multi-criteria XLOOKUP, MAP, LAMBDA, table object, spill ranges, absolute referencing | Need to apply your job allocation percentages to earnings & taxes? Watch the video and download the Excel template to learn how.
$4.99
-
Excel, Accelerated: Write notes in complex formulas
CourseTime: 00:02:08 | Techniques: The N function | Do you have long formulas which are hard to parse and easy to forget? Do you need to leave a note for an assistant or for Future You? Watch the video and download the Excel template to learn how.
$4.99
-
Excel, Accelerated: Create a function to map names to a new list
CourseTime: 00:04:10 | Techniques: LAMBDA, SUMIF, SUMIFS, XLOOKUP, ROUND, Create your own function, table object | Have you ever needed to simplify a very long formula? Watch the video and download the Excel template to learn how.
$4.99
-
Excel, Accelerated: Add weights to regular and OT time totals
CourseTime: 00:02:00 | Techniques: SUMPRODUCT, absolute referencing | Do you need a weighted denominator in order to allocate payroll to jobs using regular and OT hours as an allocation base? Watch the video and download the Excel template to learn how.
$4.99