FOLLOW

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb

UdemyNewYearPromo.jpg
PaparazziAd-01.jpg

Recent Posts

April 3, 2020

I recently got a question about cleaning up a list of addresses in order to make it useable for a mail merge. The original data looks something like this.

It's a pretty simple list of addresses. But, not very useable. The data is in two columns and organized into addres...

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

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

BENEFITS

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

CURRENT AVAILABLILITY (March 2020)

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

MORPH TRANSITION

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.

PARTICIPATE

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

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

Please reload

Please reload

Archive

Please reload

Tags

Please reload