Microsoft Excel Blog: Tutorials and How-Tos

Post covering sorting, filters, getting started with Excel, Excel functions, subtotals, PivotTables, and other Excel features.

Calculate difference in time in Microsoft Excel

Calculate difference in time in Microsoft Excel
Posted by Chris Menard on 12/19/2016

You can calculate the difference between two times in Excel. Subtract one time from the other time and format the answer for h:mm. Hour function also shown.

Datedif function in Microsoft Excel

Datedif function in Microsoft Excel
Posted by Chris Menard on 12/13/2016

Use the Datedif function in Excel to find the difference in years, months, and days between two dates. This is a great function for HR people.

Securing your Excel and Word files with passwords

Securing your Excel and Word files with passwords
Posted by Chris Menard on 11/18/2016

If you have confidential or sensitive information in your Excel or Word files, you should encrypt your files with a secure password.PowerPoint, excel, word