Download Files:

Start File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1333Start.xlsx

Finish File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1333Finished.xlsx

Download File: http://people.highline.edu/mgirvin/excelisfun.htm

Learn about Banker’s Rounding or Gaussian Rounding:
1. (00:15) What is Banker’s Rounding?
2. (02:30) Normal Excel ROUND Function (Arithmetic Rounding, NOT Banker’s Rounding)
3. (03:18) Excel formula to do Banker’s Round using IF, MOD, MROUND and ROUND functions.
4. (07:11) Power Query’s (Get & Transform) Transform Round option
5. (08:28) Power Query’s (Get & Transform) Number.Round function
6. (09:58) Summary