Recent Posts

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...

August 23, 2019

Microsoft Excel's Power Query makes it easy to combine multiple Excel tables, from different worksheets, into one master list. You can then use that master list to create your PivotTables and summarize the data.

Make sure you download the exercise file used in the video...

January 2, 2019

Microsoft Excel's VLOOKUP() Function is a very popular and powerful function, but it has some limitations. In the video below, you will learn how to overcome one of these limitations in order to use the VLOOKUP() Function to find a corresponding value based on multiple...

December 31, 2018

Everyday I take some time to get through the questions I get in my online courses. I enjoy getting questions for a couple of reasons.

  • Asking questions means that the person asking is learning.

  • I get to make more videos!!

I'd like to share one of the questions...

December 20, 2018

Excel has a few different ways to import data from various sources, including web content. If you visit the DATA TAB, found within the Excel ribbon, you'll find various import features.

 The GET & TRANSFORM tools provide a quick, easy and powerful method of importing da...

December 7, 2018

Microsoft recently announced a handful of new Microsoft Excel Functions. And, they are blowing my mind!!

"Note: September 24, 2018: The FILTER function is one of several beta features, and currently only available to a portion of Office Insiders at this time. We'll cont...

November 23, 2018


What better way to finish up a contest then to celebrate by giving thanks. I want to thank everyone that has been participating in my courses on Udemy. I love creating these courses and hope that you are finding the information beneficial and product...

October 23, 2018

It's time for another contest! 

Participating in this contest could help you on the path to becoming a Microsoft Office Specialist, certified in one or more of the Microsoft Office Applications.


Your already enrolled in one of my courses on Udemy. 

  • Excel Be...

Please reload

Please reload


Please reload


Please reload




Pleasant Grove, UT

©2017 by Office Newb