Skip to content

Adding rounded values in Excel

Sometimes you want to add up the rounded values in Excel, for example

1.7 = 2
1.2 = 1
3.9 = 4
3.4 = 3
5.2 = 5
6.4 = 6
4.3 = 4

26.1   25 are the actual totals, you want 25 to appear.  This video shows you to do this task.  


Using Arrays in Excel formulas

In the example shown here, you will learn how to use either an absolute reference in calculating an insurance premium for a list of items.  Or, you can use an array formula – both have their advantages.

Create an animated GIF simply & quickly

You can create an  animated GIF of photos in Photoshop – this shows a few shortcuts to get this done quickly – you can use the results in w website, facebook, PowerPoint presentation.  You can also create a mini movie from a photo burst or a quick video of any series of photos.  It is recommended that all photos be the same size and DPI.  Tips are shown how to adjust or resize a photo in the series.

Create a “matted” photo to fit in a stock frame

We all love to frame our photos and hang them on the wall or provide them as gifts.  What happens is that if you have an irregularly shaped photo this means either a custom frame and/or mat.  This video tutorial shows how to put irregularly shaped photo onto a “mat” of a standard size such as 8 x 10.  Effects such as adding a texture to the mat are included as well as creating a drop shadow or bevel on the photo.

Tutorial was done in Photoshop CS 6 yet is applicable to any version as can be useful for those using Elements (you won’t have all the features of drop shadows and textures)

Excel 2013 – vlookup, pmt, if statement, naming ranges

The title in this video is self explanatory – this shows how to do everything mentioned in it.  This works with any version of Excel – even 2007 or earlier!

print part of an Excel worksheet

Sometimes you only want to print out part of an Excel worksheet.  This video demonstrates selecting a range, naming a range, and setting up the document for printing.

Using the eBay app on your iPad or iPhone

This is a brief summary showing you the steps in working with the app – a set of screen shots is used in this video.  There are a few shortcuts and tips that you’ll definitely find useful.  I’ve used this video in many classes – if you are using this app, make sure you are on a SECURED network!  Happy selling!


Get every new post delivered to your Inbox.