Create a Form Letter with Mail Merge in Word and Excel

Do you create mass mailings? For example you have a standard form letter or template and you needed to incorporate a mailing list with the first and last names to semi personalize the letter. The list is on Excel and your form letter template is in Microsoft Word. There is actually a utility on Word to combine the Excel list and your Word file and create these type of letters. See the video to learn how to create form letters with mail merge in Word and Excel.

Create a Calculated Field in a PivotTable

Calculated Fields in PivotTables are just an extra way to create different calculations for your data without messing with the source data. Say you had sales data and wanted to get the profit margin. Instead of adding an extra column in your source data for the PivotTable, you can can create the PivotTable and then use the calculated field command to create the formula to do that. It sounds complicated but it's not really that hard to do. Check out the video to see an example.

Use the Excel Solver Tool

There's a neat tool in Excel that helps you answer what if type of questions. It can help you solve some basic math problems or figure out how to price a product. See the video to learn how to use the solver tool with a simple example.