Products
-
Excel, Decelerated: Add automatic checkboxes to your Control Panel
CourseTechniques: 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.
Free
-
Excel, Decelerated: Pull totals from a large timesheet
CourseTechniques: 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.
$9.99
-
Excel, Decelerated: Create a simple payroll allocation tool
CourseTechniques: 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.
$9.99
-
Excel, Decelerated: Write notes in complex formulas
CourseTechniques: 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.
$9.99
-
Excel, Decelerated: Create a function to map names to a new list
CourseTechniques: 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.
$9.99
-
Excel, Decelerated: Add weights to regular and OT time totals
CourseTime: 00:03:57 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.
Free