Tutorials and training articles on Microsoft Excel - Microsoft: Chris Menard Training

Zip Code data type in Excel

Posted on 07/10/2020

To use the Zip Code data type, select your zip codes, and Excel will return important information. Data includes the median household income, latitude, longitude, population by marital status

The AVERAGE function is one of the most popular functions in Excel. This video shows how to use the Average function, handles zero values when using the Average function. Zero values vs. blank cells will give different results with Average. As a bonus, using the AverageIF function with zero values.

Workbook Statistics in Excel for Microsoft 365

Posted by Chris Menard on 05/09/2020

Excel for Microsoft 365 subscribers now have Workbook Statistics. Workbook Statistics is a window that shows a summary of the workbook statistics including the number of sheets, tables, formulas, charts, and pivottables.

8000 royalty-free images are available in Office 365 - April 2020 update

Posted by Chris Menard on 04/16/2020

Microsoft brings 8000 royalty-free images and icons to Office 365. These images work in Word, Excel, PowerPoint, and Outlook. Right now, these are only available to Office 365 Fast Insiders.

Future Value Function in Excel

Posted by Chris Menard on 02/10/2020

The Future Value Function will give you the answer to the future value on investment. Compound interest is interest on interest vs. simple interest that interest only on the principal.

Annual Percentage Yield (APY) vs. Interest Rate

Posted by Chris Menard on 01/17/2020

The annual percentage yield takes the interest rate and compounding periods to show what your money could earn in a year. The Future Value (FV) and EFFECT functions are shown.

Excel for Office 365: Fuzzy Matches with the Power Query Editor by Chris Menard

Posted by Chris Menard on 12/30/2019

Power Query in Excel will now handle to do approximate matches (fuzzy matches). This is handy since you can't use VLOOKUP or XLOOKUP since you don't have exact matches.

Create a dynamic two color column chart in Excel to show increases and decreases

Posted on 12/09/2019

A dynamic column chart in Excel will allow you to show increases and decreases in two colors. This is great for showing the monthly trends for one year of sales data.

Keyboard shortcuts for Paste Values in Excel

Posted by Chris Menard on 09/28/2019

Paste Values in Excel is an excellent feature. It copies only the value of a cell, not the formula. When you copy a cell with a formula and paste, the formula gets pasted. Frequently, you want just the value.