Skip to content

Download free Software

VLC Media Player

A splendid media player, specializing in many different formats, including .mp4, .flv, .avi and loads more!

www.sourceforge.net/projects/vlc/files/1.1.7/win32/vlc-1.1.7-win32.zip/download

Avira Free Anti-Virus. 10.0.0.611
Avira AntiVir Personal – Free Antivirus is a comprehensive, easy to use antivirus program, designed to offer reliable free of charge virus protection to home-users

http://dlce.antivir.com/package/wks_avira/win32/en/pecl/avira_antivir_personal_en.exe

Adobe Reader 10.0

This software lets you view and print Adobe PDF files
on a variety of hardware and operating system platforms. Acrobat Reader provides a host of features that enable you to submit PDF forms created with fillable form fields to such applications as Adobe Acrobat Professional and Adobe Form Designer.
ftp://ftp.adobe.com/pub/adobe/reader/win/10.x/10.0.1/en_US/AdbeRdr1001_en_US.exe

Faststone Photo Resizer

FastStone Photo Resizer is an image converter / resizer intended to enable users to convert, rename, resize, crop, rotate, change color depth, add text and watermarks to images in a quick and easy batch mode. Drag and Drop mouse operation is well supported.

http://www.faststone.org/DN/FSResizerSetup30.exe

 

How To Use Calculations in Excel

This is a short lesson on how to calculate “Quantity” multiplied by “Unit Price” to get a total of the sale. We will then also be looking at how to calculate a grand total for your spreadsheet.

Step 1:

Once you have prepared your cells and fields, click in the “total” column (indicated in red). This is the cell where your “Quantity” will be multiplied with your “Unit Price”.

Step 2:

Once your have selected the “Total” Cell, type the following:

+ C2*D2

This tells Excel that you would like to multiply the contents of “C2” (Quantity) with “D2” (Unit Price)

Then Press enter. Your total for that row will now appear in the total column as shown below:

Step 3:

Next we need to “copy” this calculation to the rows below, in order for excel to calculate totals for all your rows.

To do this, we select the cell which we just calculated. Now drag this cell down by clicking and dragging it by its “bottom right corner” / handle. Drag this cell down until the end of the rows you wish to calculate:

You now have totals for each row as shown below:

Step 4:

Now we need a grand total for our sales. To do this, select the following rows: (from the first calculated total, up until and including the cell in which your grand total should appear)

Once you have selected the necessary cells, click on the “SUM” button as indicated here:

This will SUM (add) your “Totals” rows, and calculate your Grand Total:

You now have functional calculations in your spreadsheet.

Thank you for joining me, please stay tuned for more tutorials on Excel, and other software

How to Auto-Hide The Taskbar

Right click on the taskbar, select “Properties”, then tick / select “Auto-Hide”

This feature will hide your taskbar automatically when it is not in focus, and show it when you hover your mouse over it