Tier One Services Learning Center

Excel, Accelerated: Allocate payroll to projects with inconsistent employee names

Course

Time: 2:13 | Would you like to know how to allocate payroll to projects with inconsistent employee names? To learn how, watch the video and download the Excel template. Techniques: XLOOKUP, SUMIF, ROUND, Name mapping, Create and name a table

Excel, Accelerated: Automatically change a week of dates based on the first date in the week

Course

Time: 0:26 | Would you like to know how to automatically change a week of dates based on the first date in the week? To learn how, watch the video and download the Excel template. Techniques: Name a cell, Perform math on a date

Excel, Accelerated: Transpose a list into a 3-column database

Course

Time: 0:47 | Would you like to know how to transpose a list into a 3-column database? To learn how, watch the video and download the Excel template. Techniques: INDEX, Helper columns, Fill down, Absolute referencing

CFO Advantage: Economic Leakages

Course

Excel, Accelerated: Nested IF

Course

Time: 1:57 | Would you like to know how to determine price by filtered price points? To learn how, watch the video and download the Excel template. Techniques: IFS, IF, Nesting IF statements

CFO Advantage: Business Ecosystems

Course