Not Just Numbers
▼
Tuesday, 27 November 2012

EXCEL TIP: Creating a rolling graph

›
A time-taking Excel task that I see many clients accepting as necessary, is copying and pasting graph data every month to populate graphs...
9 comments:
Thursday, 22 November 2012

EXCEL TIP: How to make data entry screens easy to use

›
Most spreadsheets require some kind of data to be entered into cells by the user and there are a couple of simple steps you can take to m...
4 comments:
Tuesday, 13 November 2012

EXCEL TIP: Using data in sentences

›
Microsoft Office users will tend to use Excel to handle numbers and data, and Word to handle text - which, of course, is how it should be...
14 comments:
Tuesday, 16 October 2012

EXCEL TIP: Look up commission or tax rates from earning bands

›
Just a short post today on a very useful use for the VLOOKUP function. Typically when we use VLOOKUP, we are looking for an exact matc...
1 comment:
‹
›
Home
View web version
Powered by Blogger.