Recent Posts

September 1, 2017

Below is a quick video demonstration on Microsoft Excel Array Formulas.

Arrays, simply put, are a collection of data. For example you may have a column of data in an Excel document.

All those values, in range C2:C27, are a collection of data or an array of data. An array...

September 1, 2017

Another great question from a student in my Complete Excel training course on Udemy.

Download the example file to try yourself: ExcelBalanceSheet-01

August 20, 2017

In my Complete Microsoft Excel Course on Udemy, Excel from Beginner to Advanced, I recorded some instruction on working with Microsoft Excel’s powerful Power Query and PowerPivot Add-Ins. When Excel 2013 was released, Microsoft made some changes and the 2 Add-Ins are n...

August 20, 2017

The video below is part of my Complete Microsoft Excel training course on Udemy, Excel with Microsoft Excel from Beginner to Advanced.

August 20, 2017

I got another excellent question from a student in my Complete Microsoft Excel course. Take a look at the video below on how to create a simple Excel Timeline using a list and an Excel Stacked Bar Chart.

Download the Exercise File: ConstructionTimeLine.xlsx

August 20, 2017

Microsoft Word is full of shortcuts that will boost your productivity. Below is a quick list of the most common shortcut keys.

  • CTRL + S —– SAVE

  • CTRL + Z —– UNDO

  • CTRL + C —– COPY

  • CTRL + V —– PASTE


  • CTRL + P —– PRINT

  • ...

August 1, 2017

The Microsoft Office Specialist exams provide one of the best opportunities to stand out from the average Microsoft Office user. Below are some quick facts about the various Office Exams available through Microsoft Certification program.

Short Blurb from the Microsoft O...

Please reload

Please reload


Please reload


Please reload




Pleasant Grove, UT

©2017 by Office Newb