Microsoft Excel Blog: Tutorials and How-Tos

Excel DateDif function - difference between two dates

In Excel if you need to calculate the difference between two dates in years, month, or days, the DATEDIF function will handle it. DATEDIF is "Date & Dif".

Excel: College Decision Helper Template

Whether you want to attend a large public university or a small private college, knowing all about the schools you're considering is essential to making a good decision.

Excel Automatic Data Type: Dog Breeds and Diseases

Excel's Automatic Data Types recognizes similar data. In this video, I type in different dog breeds in columns A and Excel finds the breeds and returns data information.

Zip Code data type in Excel

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

Average Function in Excel

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

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

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

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

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

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

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

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.