Excel Magic Trick 1138: Basic Future Value Calculation: FV Function or Math Formula
Download
Excel Magic Trick 1140: VLOOKUP, TEXT & DOLLAR functions To Create Dynamic Finance Test Text Labels
Download
Excel Magic Trick 1017: BMX State Point Calculation Worksheet: VLOOKUP and Data Validation List
Download
Excel Magic Tricks # 1: Formulas & Cell References
Video 1 – 10 Download
Excel Magic Trick 1189: Extract Color From Description Create Revenue by Color PivotTable, 2nd Take
Download
Excel Magic Trick 1149: Dynamically Sum by Category without VLOOKUP Helper Column (2 methods)
Download
Excel Magic Trick 1145: Create Random Data Set with Formulas: 4 Unusual Formulas
Download
Excel Magic Trick 1181: Formula to Count Cells with 4 or More Characters: COUNTIFS & SUMPRODUCT
Download
Excel Magic Trick 1137: Excel & PowerPivot DAX Formula: Approximate Match Lookup Without VLOOKUP
Download
Excel Magic Trick 1190: Formulas To Extract Unique List County Numbers & List Zip Codes Horizontally
... https://www.youtube.com/playlist?list=PLrRPvpgDmw0kjL4875H36yNhWBb0f-nci
Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)
Download
Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?
Download Excel Start File: https://excelisfun.net/files/EMT1178.xlsx
Excel Magic Trick 1168: Get Time Value From Date Time Value (2 Formula Examples)
Download