Microsoft Tutorials

Use Sparklines in Microsoft Excel

Sparklines in Excel provide a fast way to see patterns at a glance. There are three type of sparklines in Excel: Win/Loss, Column, and Line.

Excel - make accounting, currency, and number style zero decimal places by default

Use the Control Panel to change the default decimal places to zero for accounting, currency, and numbers in Microsoft Excel. Video by Chris Menard

Mail merge letters in Micrsoft Word using Excel spreadsheet as data source

To perform a letter mail merge in Microsoft Word you need a data source. Excel is a great data source. This covers setting up your letters - Chris Menard

Add the filename and path to a Word document

If you put the filename and path in a Word document, when you need to update the file, you know exactly where you saved it.

Outlook mail merge - personalize email messages

Need to send emails to a group? Instead of sending to a contact group, you can do a mail merge and personalize each recipient's email.

Turn off Outlook notifications and alerts

Microsoft Outlook's desktop alerts are great when you are working alone, but if you are doing a presentation or one-on-one training, turn them off.

Use the COUNTIF function in Microsoft Excel

The Countif function in Excel is one of the top 10 functions to know. You can use Countif for text, numbers, greater than, and other criteria.

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.