Excel Sparklines

Be Trendy!


Sparklines are an easy way to add visual trend-lines to your tabular data.
And what better way to distract your audience than by dangling something sparkly in front of them!

Watch this 60 second video to learn the what you need to know.

Inserting Sparklines to your Excel data

  1. On the Insert tab, in the Sparklines group, click Sparkline type (e.g., Line). The Create Sparklines dialog appears.
  2. In the Data Range field enter the values to be charted.
  3. In the Location Range field enter cell range where char is to be displayed.
  4. Click OK.

Tip: With an inserted sparkline selected, the Sparklines Tools: Design tab appears on the Ribbon. Use the tools on this tab to change colors and add markers.



Additional reading:

Comments and questions are always welcome!

Valentine’s Templates

Has Valentine’s day snuck up on you this year? Are you buried under too much snow to card shop? Borrow from Microsoft’s templates. Word and PowerPoint have hundreds of print-ready and animated templates to choose from.

Screenshot (25)
Word 2013 Templates
PowerPoint 2013 Templates

To Download and Create a Valentine

  1. In either Word or PowerPoint, click File tab and select New.
  2. In the Search bar enter Valentine and press Search icon.
  3. Click on image to preview.
  4. To select, click Create.




Comments and questions are always welcome!

PowerPoint: Set Transparency

Whitespace (or any other background color) can make your inserted images look like a kindergarten stickers. Solution: remove unwanted colors using Set Transparency.

Watch this 60 second video to learn all you need to know

  1. Select the picture or image to be edited.
  2. On the Ribbon, click on the Picture Tools: Format tab.
  3. In the Adjust group click Color (or Recolor, in version 2007) and select Set Transparent Color.
  4. On the selected image, click on the color to remove (i.e. make transparent). That color is erased from the selected image.



Comments and questions are always welcome!


%d bloggers like this: