Microsoft - Blog: Chris Menard Training

The Rule of 72 answers "When will my investment double?"

Posted by Chris Menard on 04/22/2019

The rule of 72 is an easy way to determine when will my investment will double at a given interest rate. Divide 72 by the annual rate of return.

Snap a picture of an Excel table with your smart phone and edit the spreadsheet

Posted by Chris Menard on 03/03/2019

Excel on Android has a new feature where you can take a picture of a table and edit it in Excel.

Covert date to fiscal quarter in Excel

Posted by Chris Menard on 01/27/2019

In Excel, to calculate the fiscal quarter that starts with a month other than January, use the CHOOSE function. We will look at fiscal years starting in July, October, and then April in this exercise.

Be careful when averaging percentages

Posted on 01/12/2019

When averaging percentages, use caution. It is a common mistake to in data analysis.

Use What-If Analysis with Data Tables in Excel

Posted by Chris Menard on 12/21/2018

Calculate multiple results by using a data table in Excel.

COUNTIF Function in Excel

Posted by Chris Menard on 12/17/2018

One of the most powerful functions in Excel is the COUNTIF function. It counts the cells that meet a certain criteria.

Excel Loan Amortization for new car, new house, or refinance

Posted by Chris Menard on 12/08/2018

Use Excel to create a loan amortization schedule. This is table to that shows each periodic payment on an amortizing loan (typically a mortgage or car loan).

Webinar on Excel Functions on 12/04/2018

Posted by Chris Menard on 12/03/2018

Webinar on Excel function on Tuesday, December 4, 2018. Functions covered will include trim, count, average, median, large, countblank, and many other functions.

Outlook: Add buffer time between appointments / meeting

Posted by Chris Menard on 11/14/2018

A new feature in Outlook 2016 with an Office 365 subscription allows you to add buffer time between appointments and meetings. This is an awesome new feature. You can use that time to check in with your team, get coffee, and answer critical emails.