Microsoft Office Tips & Tricks

InIT Software Training Blog – On Course for Success

Google Calculator

 

Google Calculator

To use the Google Calculator simply type the calculation in the search bar.
Use the same operators as you would use when using Microsoft Excel Spreadsheet

Add +

Minus –

Divide /

Multiply *

How to check your Data Entry – Excel

Check your Data Entries in Excel Spreadsheets

If you wish to check your data you can either asked someone to read the hard copy while you check the screen or you can check the data by keep looking up and down between the hard copy and the screen. Excel has a really neat way to help you. Watch the video below. If you want more tips then book InIT Learning to come to you. GetonCourse for Success with our SoftwareTraining @ Yours.

Import Currency Format to Word from Excel

Import Currency Format

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Often I get asked how to import the currency format from Excel to Word as a straight forward mail-merge import loses the formatting. The formatting is carried out within Word by formatting the field within the document. The three currency fields in this example do not have the £ symbol and do not have two decimal places.

You can display the field codes by clicking the Preview Results command on the Mailing ribbon tab.

Now right click on the field code you wish to format
Select Toggle Field Codes

Place your insertion point at the end of the code but before the }

Type \# £##,00    

note the space before and after \#

Outlook Shortcut Keys

Microsoft Outlook

Use shortcut keys to create a new message or a new appointment – wherever you are in Outlook, press Ctrl + Shift + M to create a new email or Ctrl +Shift + A to create a new appointment.

Speed up your PC

Speed up your Laptop or PC with CCleaner

One of the best methods that I have used to speed up my PC or laptop is a free program called CCleaner

I run the program about once per month or when I feel things are slowing up. I only perform the first two tasks. I press the cleaner button which deletes all the tempory files that are clogging up the system. Then I run the registery part that checks for files no longer in use by the registery.

These two create more disk space and speed the computer up.

When ever I purchase a new PC or laptop I always install CCleaner on the first day. This is in preperation to keep everything running fast and smoothly. I really can’t recommend this software enough. I have recommended this to many people all of whom have been very pleased with the results.

There are three options Free, Professional and Professional Plus. Which ever one you choose it will speed things up. http://www.piriform.com/ccleaner

The Spreadsheet

VisiCalc Spreadsheet

 The spreadsheet started life way before computers were invented. Records were made using paper and pencil and were commonly called a ledger.

A spreadsheet contains rows and columns of numbers and text. A ledger is a book containing accounts in spreadsheet format showing debits and credits from the original entry.

A spreadsheet is the electronic version of the paper spreadsheet used by the accountant.

The electronic spreadsheet consists of pages known as worksheets. The file containing all the worksheets is called a workbook.

Brief History of the Spreadsheet

1961 – Richard Mattessich developed a concept for business accounting.

1978 – Dan Bricklin – Prottype for VisiCalc

1979 – VisiCalc released to the public.

1980 – SuperCalc released – first spreadsheet to allow data to be shared and imported to other programs.

1982 – Multiplan released (to become Excel)

1983 – Lotus Development Corporation – Lotus 1-2-3 (named as it handled three tasks: spreadsheets, graphs and databases).

1985 – Excel released for the Mac (could also handle three tasks)

1987 – Excel released for Windows PCs

1987 – Quattro Pro released (runs in a graphical environment)

1988 – Excel outselling Lotus 1-2-3