Intermediate Microsoft Excel tutorials

Use the text function in Excel to add leading zeros

When you type in numbers in Excel, the leading zero will get dropped. Use the Text function in Excel to add back the leading zeros.

Create a data validation drop down list in Excel by Chris Menard

You can make a drop down list so only correct data is entered. If bad data is entered, sorting, filtering, pivottables, and other stuff will be incorrect.

Create your own custom sort in Excel

Excel already has built-in custom lists for sorting, but you can create your own custom sort list in case you don't want to sort alphabetically or A to Z.

Create a combo or two-axis chart in Excel 2016 by Chris Menard

If you are trying to chart values in Excel that are far apart numerically, you need to create a combo chart in Excel. It is very easy in Excel 2016.

How to calculate the weighted average in Excel

Need to calculate the weighted average in Excel? It is very easy if you use the sumproduct function in Excel. This is useful for school or work.

Create a treemap in Excel to spot patterns

A treemap chart provides a hierarchical view of your data and makes it easy to spot patterns, such as which items are a store's best sellers.

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

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.

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.