Pleasant Grove, UT

©2017 by Office Newb


Recent Posts

March 18, 2020

Microsoft just released a new Excel function called LET(). The LET() function allows users to associate a value or calculation with a name/variable.


=LET(name1, value1, [name2...], [value2...], calculation)


  • LET() allows users to poten...

March 10, 2020

Microsoft PowerPoint Zoom allows you to create more dynamic and exciting presentations. The Zoom feature gives the presenter the ability to jump to and from any portion of their presentation while presenting.


  • PowerPoint for Office 3...

March 6, 2020

Microsoft has introduced a new feature in PowerPoint Office 365. This is a subscription feature through Office 365.


The Morph Transition allows the creator to create smooth animations for objects on the slide. This is accomplished by creating the origina...

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

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

Please reload

Please reload


Please reload


Please reload