Pleasant Grove, UT

©2017 by Office Newb


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

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

September 15, 2017

I got an excellent question from a student in my Excel course hosted on Udemy.


"How can you schedule Microsoft Excel automation?"

I've paraphrased the question a little. The student has a specific task that needs to be schedule for daily output. But, in writing...

September 11, 2017

A student, in my Excel Beginner to Advanced course on Udemy, recently asked an excellent question on Excel's VLOOKUP function. I thought I'd share the question and one solution here on the Office Newb blog.

Standard VLOOKUP()

Microsoft Excel's VLOOKUP() function is great...

September 8, 2017

Using Microsoft Excel's IF() function and a sprinkle of VBA you can play a sound when a condition is met.

Chances are you may have used Microsoft Excel's CONDITIONAL FORMATTING feature.


 In the above example, cell A2 is conditionally forma...

August 20, 2017

In my Complete Microsoft Excel Course on Udemy, Excel from Beginner to Advanced, I recorded some instruction on working with Microsoft Excel’s powerful Power Query and PowerPivot Add-Ins. When Excel 2013 was released, Microsoft made some changes and the 2 Add-Ins are n...

August 20, 2017

The video below is part of my Complete Microsoft Excel training course on Udemy, Excel with Microsoft Excel from Beginner to Advanced.

Please reload

Please reload


Please reload


Please reload