Tier One Services Learning Center

CFO Advantage: Economic Leakages

Course

CFO Advantage: Business Ecosystems

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

Excel, Accelerated: Dynamic dropdown lists

Course

Time: 2:15 | Would you like to know how to create a dynamic data validation lookup? To learn how, watch the video and download the Excel template. Techniques: IF, VLOOKUP, Create and name data ranges, Absolute referencing

Excel, Accelerated: Protect and Sort

Course

Time: 3:46 | Would you like to know how to Sort, Select, and Protect data in a locked table? To learn how, watch the video and download the Excel template. Techniques: Create and name a table, Create arrows for sorting, Lock/unlock cells

Excel, Accelerated: Identify most recent date

Course

Time: 1:55 | Would you like to know how to list each vendor with the most recent date that they were paid? To learn how, watch the video and download the Excel template. Techniques: NUMBERVALUE, MAXIFS, PivotTable, table