Recent Posts

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

May 23, 2018

It's May 22nd, only 9 more full days to participate in the Microsoft Office Specialist Practice Exam contest.


A quick reminder, all you need to do is...

  • Watch at least 20 lectures in the course of your choice.

    • Master Microsoft Word Beginner...

May 11, 2018

It's that time again. Time for another Microsoft Office Specialist Practice Exam contest. I've run a few of these contests before and given away several free Microsoft Office Specialist Practice exam vouchers. These vouchers give you access to a practice exam for one o...

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

October 5, 2017

Its time for another CONTEST!

I’ve been getting a lot of students in my Udemy courses sending me message expressing interest in taking one of the Microsoft Office Specialist exams (MOS). So, I’ve decided to run a contest to help and inspire those interested. Whether you...

October 5, 2017

Got another great question from a student in my Excel VBA UserForms course on Udemy.


I have built and Excel UserForm that allows users to interact with worksheets within a workbook. I don’t want the users to interact with the worksheets directly. How can I hide...

Please reload

Please reload


Please reload


Please reload




Pleasant Grove, UT

©2017 by Office Newb