FOLLOW

CONTACT

Pleasant Grove, UT

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 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()

XLOOKUP is named for its ability to loo...

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.

• I get to make more videos!!

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

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

Description

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

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