Products
-
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, 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, 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
-
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
-
Excel, Decelerated: Create a base + variable pricing matrix
CourseTechniques: SUMPRODUCT, XLOOKUP, MROUND, table object, named ranges | Do you offer flat monthly fees to your clients? Are you contemplating a base + variable calculation? Watch the video and download the Excel template to learn how.
$9.99
-
Excel, Accelerated: Create a base + variable pricing matrix
CourseTime: 00:06:54 | Techniques: SUMPRODUCT, XLOOKUP, MROUND, table object, named ranges | Do you offer flat monthly fees to your clients? Are you contemplating a base + variable calculation? Watch the video and download the Excel template to learn how
$4.99