Pleasant Grove, UT

©2017 by Office Newb


Recent Posts

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

June 8, 2018

Create dynamic, interactive Charts with Microsoft Excel Offset Function.

What is the OFFSET() Function


Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single c...

May 25, 2018

As many of you know, I recently released a new course on working with Advanced Excel Formulas using the built in Index() and Match() functions. This course covers the basics of working with Advanced Formulas and builds into real world examples of working with two very...

December 27, 2017

2018 is about you! Take all the time and knowledge you invest learning the Microsoft Office applications and get certified and let me continue helping you do this. All you need to is participate in the contest for a chance to win!


Participating in the...

December 20, 2017

The technique of NESTING Microsoft Excel functions within one another allows for more dynamic and powerful formulas.

I got an excellent question the other day, in one of my Excel courses on Udemy, asking how to look up the largest value in a column, then return an assoc...

December 18, 2017

Microsoft Excel offers many ways to work with and analyze your data. There are loads of functions to calculate and lookup data, charts to visualize, PivotTables to quickly summarize and much more. These features, and more, combine to make Microsoft Excel a very powerfu...

October 18, 2017

I'm excited to announce that I have a new Microsoft Excel course in the pipeline. I plan on having it released before the end of Oct. 2017, called...

Microsoft Excel Data Analysis and Dashboard Reporting

Below are the first few videos introducing the course and what you...

Please reload

Please reload


Please reload


Please reload