Excel Tips
July 18, 2017
Superscript and subscripts in Excel! Finally, in 2017, Microsoft gave us faster ways to create superscripts and Subscripts in Excel.
July 17, 2017
Learn about a serious bug in Excel's Calculation Engine. Excel is supposed to use 15 digits of precision. Microsoft is storing 17 digits in the XML, and now a few functions are using all 17 digits, causing calculation anomolies.
July 13, 2017
Use a formula in Excel to put the worksheet name in a cell. Also in this episode: =CELL("filename",A1) returns the path and file name
July 13, 2017
Excel and Office now offer support for displaying 3D Models. I am not sure of a good accounting use for this, but it is cool to rotate a model of the Asteroid Bennu in your Excel worksheet.
July 11, 2017
A great trick for adding Total Row and Total Column in a single click. Also in this episode: