UdemyNewYearPromo.jpg
PaparazziAd-01.jpg

Recent Posts

April 30, 2020

Excel Power Query makes transforming and cleaning up data a breeze. By using Conditional Columns and Excel Power Query Fill Command you'll transform nested data into a clean, useable list.

Download the Exercise file to follow along: ExcelPowerQueryFeatures 

April 17, 2020

I recently recorded a handful of videos for my Complete Microsoft Excel course and thought I would share these videos. I've placed them in a YouTube playlist to make is accessible in order to go through each.

The videos include working with Excel's VLOOKUP, HLOOKUP and...

April 9, 2020

TEXTJOIN() FUNCTION DEFINITION

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

BENEFITS

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

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

Please reload

Please reload

Archive

Please reload

Tags

Please reload

FOLLOW

CONTACT

ADDRESS

Pleasant Grove, UT

©2017 by Office Newb