Monday, May 13, 2019

Create a Motion Bubble Chart

If you're familiar with a TED talk given by the late Hans Rosling, you're problem familiar the the cool motion chart he showed with about world development. It had data, it had animation and it had drama! You can replicate the data and animation part (the drama you'll need to provide) in the example of how to create a motion bubble chart from this video.


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.