Microsoft Office Blog by Chris Menard

Using Array Formulas in Excel by Chris Menard

Array formulas make checking your work and doing complex functions easier. If you constantly do countif functions, use the Array Frequency function instead.

Compare two lists or columns in Microsoft Excel

If you need to compare two lists or columns in Excel, you can either use conditional formatting or the Countif function to compare.

Enter military time in Excel

If you want to type in military time in Excel, and the time show correctly, here are the steps. This method allows you to calculate the difference between two times.

Calculate difference in time in Microsoft Excel

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

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.

You should create bookmarks if you have a large pdf file so users can quickly navigate the file. You have indent bookmarks also.

Redact a word or phrase in a PDF file in Adobe Acrobat Pro DC

Adobe Acrobat Pro DC will allow you to redact a word or phrase from a PDF file. This is handy when you have 30 pages and need to redact a patient's name.

Securing your Excel and Word files with passwords

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