Here’s a brief overview video I made using Jing to teach some basic tips and tricks in Microsoft Excel. The free version of Jing is limited to 5 minutes, so the video doesn’t cover much. During the video, I’ll cover:

  1. Using Excel to automatically fill in the next months in a series.
  2. Creating a SUM formula for a range of data in a column.
  3. Adding a SUM formula for a range of data in a row.
  4. Highlighting the most important information on the table, the grand total, so it’s easy to find at a glance.

If you have any questions, or other ideas to cover, let me know in the comments. You can make the video full screen (and thus actually readable) by clicking the small icon on the bottom right of the video after hitting play.

Unable to display content. Adobe Flash is required.