Recent Posts

September 19, 2019

Experience true Excel power by using Microsoft Excels Power Query (GET AND TRANSFORM - Excel 2016+) feature. In this video I will introduce you to some of the hottest features Power Query has to offer.

Full Microsoft Excel Power Query -- Beginner to Advanced course comi...

September 6, 2019

(Watch the video for a demonstration)

The Microsoft Excel function, SUM, is the most used function in all of Excel. We typically use the SUM function at the basic level. But, with a little bit of cell reference magic, we can use the SUM function to create a Running Tota...

September 3, 2019

It's that time again... Time for another CONTEST. For the month of September 2019 I will be running a contest in conjunction with my courses on Udemy.


Your already enrolled in one of my courses on Udemy. 

  • Excel Beginner to Advanced

  • Word Beginner to Ad...

September 2, 2019

Microsoft announced a brand new function for Microsoft Excel called the XLOOKUP(). This function provides an enhanced method of looking up information and overcomes the limitations that the popular VLOOKUP() function has.


XLOOKUP is named for its ability to loo...

Please reload

Please reload


Please reload


Please reload




Pleasant Grove, UT

©2017 by Office Newb