Recent Posts

June 24, 2020

Join us for a live Q&A on Microsoft Excel, Wednesday June 24th at 10:00 AM Mountain Time US.

I've asked those that will be attending to post questions in the comment section of the page that I can use in this Q&A session. I've also created an exercise file that you can...

April 9, 2020


=TEXTJOIN(delimiter, ignore_empty, text_1, [text_2], [text_3], …)


  • The TEXTJOIN function combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. I...

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

Please reload

Please reload


Please reload


Please reload




Pleasant Grove, UT

©2017 by Office Newb