View Detailed Profile
Excel Magic Trick 372: WORKDAY function - Find Date in Future

Excel Magic Trick 372: WORKDAY function - Find Date in Future

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT371-376.xls See how to find the school evaluation ...

Excel Magic Trick 563: WORKDAY.INTL & WORKDAY Excel 2010 Functions

Excel Magic Trick 563: WORKDAY.INTL & WORKDAY Excel 2010 Functions

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT563-567.xls See how to use the

Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula

Excel Magic Trick 1122: Repeat Row Headers Vertically For Each Day Activity Exists: Array Formula

Download

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Excel Magic Trick 1012: Automatically Add All Subtotals In A Column (6 Methods)

Download

Excel Magic Trick 1178: Conditional / AND Percentage: PivotTable Slicer, COUNTIFS or DCOUNTA?

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 #182: Workbook References

Excel Magic Trick #182: Workbook References

Download

Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Excel Magic Trick 1142: Get Every Other Row with Formula: INDEX and ROWS*2

Download

Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & Country

Excel Magic Trick 1387: Data Model & DAX Formulas: Quantity Frequency Distribution by Year & Country

Download Files: Start File: https://excelisfun.net/files/EMT1387Start.xlsx Finish File: ...

Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples)

Excel Magic Trick #502: Excel Date Formatting & Calculations (21 Examples)

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT502-505.xls See how to: 1.Dates in

Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897

Randomize Workdays with Excel Worksheet Functions? How!! Excel Magic Trick 1897

Download

Excel Magic Trick 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula?

Excel Magic Trick 994: Min Digit From A Cell: MIN or AGGREGATE Array Formula?

Download

Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.)

Excel Magic Trick 438: Counting Workdays Without NETWORKDAYS Function (Weekend is not Sat. & Sun.)

Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT431-439.xls See how to Count

Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123

Excel Magic Trick 993: Conditional Formatting Row Where Last Three Numbers In ID Equal 123

Download