Products
-
Excel, Decelerated: Cross-check an invoice batch
CourseTechniques: UNIQUE, SORT, DROP, MAP, LAMBDA, ROW, SUMIF, SUMPRODUCT, COUNTA, PivotTable. Need to check your stats before uploading an invoice batch to Xero? Watch the video and download the Excel template to learn how.
$9.99
-
Excel, Decelerated: Parse a single cell into multiple rows
CourseTechniques: TEXTSPLIT, CHAR, spill range, paste values | Did you ever convert a PDF to Excel only to see that you need to parse a list from one cell into multiple rows? Watch the video and download the Excel template to learn how.
$9.99
-
Excel, Decelerated: Create a function for sentence case
CourseTime: 00:03:23 | Techniques: LEFT, RIGHT, LEN, LAMBDA, Name Manager | Need to change title case or upper case to look like a sentence? Watch the video and download the Excel template to learn how.
$9.99
-
Excel, Decelerated: Extract a column from external data
CourseFunction: DROP | When pulling in external data, at times too many columns are included and you'd like to drop some rather than having to ignore them or hide them. Watch the video and download the Excel template to learn how.
$9.99
-
Excel, Decelerated: Pull selected columns from another tab
CourseTime: 6:47 | Would you like to pull selected columns from another tab? To learn how, watch the video and download the template. Acceleration Technique: Helper column Function: FILTER, INDEX, MATCH, TRUE Object: Create a tab, Name a table
$9.99
-
Excel, Decelerated: Highlight cells that match the adjacent cell
CourseTime: 3:27| Would you like to highlight cells that match the adjacent cell? To learn how, watch the real time video and download the Excel template. Acceleration techniques: Technique: Conditional formatting Technique: Paste formats
$9.99