If you use spreadsheets for your day to day life or need it a lot at work here are some links to commonly used but not very well known tricks.
Basics:
Basics about formulas:
Some powerful stuff about Pivot Tables:
Data Tables and Excercises:
Theres tonnes more at the Duke Web site:
Thanks hmcq…some of these are indeed helpful :k:
wow! this is so useful to me....thanks
interesting url for duke. put a slant on it and it expresses how i feel about them. :o
bhar-hard-core-terp-fan-ish
hehehe you should try using some of the Excel functions to figure out what happened to the terps :D
How can u make excel like Jump to specific cells each time? so lets say after your done pressing ENTER on a4 it will jump to cell d9 or something. I am doing some billing/invoicing for a small company in Excel and i need to like use my mouse all the time to jump to specific fields :( ......company doesnt wanna spend $$ for custom made program.
[QUOTE]
*Originally posted by Furqan: *
How can u make excel like Jump to specific cells each time? so lets say after your done pressing ENTER on a4 it will jump to cell d9 or something. I am doing some billing/invoicing for a small company in Excel and i need to like use my mouse all the time to jump to specific fields :( ......company doesnt wanna spend $$ for custom made program.
[/QUOTE]
Furqan Jigar...You have 4 options
You can record a macro..or if you know VB u can write a macro..making cursor come back to a particular cell after every entry..
You can customize keys
OR:
Excel is best used w/o mouse...you need to set your fingers on 5 keys...ALt, Ctl, Shift, Tab and space bar..esp your left thumb and index finger..w/ keyboard it is way much faster and easier to work in s/s.
Try MS Access..