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

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

Download the example file to try yourself: ExcelBalanceSheet-01

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

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

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

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 + N —– NEW DOCUMENT

• CTRL + P —– PRINT

...

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