Wednesday, May 8, 2019

Link an Excel Table to PowerPoint

This video shows how to link an Excel table into PowerPoint. I show two ways this can be done to link the Excel data into a slide. The link updates dynamically as long as there is a viable path between the two files.

Tuesday, May 7, 2019

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.

Monday, May 6, 2019

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.