| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Need to learn about formulas
I feel pretty confident with my use of macros, but i need some work on formulas. I don't have help installed on my work PC (which is where i have my downtime...). are there any good sites around that can show me more about formulas? thanks. -- ForSale ------------------------------------------------------------------------ ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896 View this thread: http://www.excelforum.com/showthread...hreadid=274766 |
|
#2
|
|||
|
|||
|
I don't understand why anyone (group) would not include
HELP. I've seen that situation and it is really idiotic, perpetrated by groups that want to be the sole point for help and don't even provide decent help. I would suggest downloading Peter Noneley's workbook Excel Function Dictionary http://homepage.ntlworld.com/noneley --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ForSale" wrote in message ... I feel pretty confident with my use of macros, but i need some work on formulas. I don't have help installed on my work PC (which is where i have my downtime...). are there any good sites around that can show me more about formulas? thanks. -- ForSale ------------------------------------------------------------------------ ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896 View this thread: http://www.excelforum.com/showthread...hreadid=274766 |
|
#3
|
|||
|
|||
|
Or get a good book. John Walkenbach's Bible series is a very good start for
formulas, and he then has a Formula specific book if you want to take it to the next level. Amazon stock all of them. -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ---------------------------------------------------------------------------- It's easier to beg forgiveness than ask permission :-) ---------------------------------------------------------------------------- "David McRitchie" wrote in message ... I don't understand why anyone (group) would not include HELP. I've seen that situation and it is really idiotic, perpetrated by groups that want to be the sole point for help and don't even provide decent help. I would suggest downloading Peter Noneley's workbook Excel Function Dictionary http://homepage.ntlworld.com/noneley --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ForSale" wrote in message ... I feel pretty confident with my use of macros, but i need some work on formulas. I don't have help installed on my work PC (which is where i have my downtime...). are there any good sites around that can show me more about formulas? thanks. -- ForSale ------------------------------------------------------------------------ ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896 View this thread: http://www.excelforum.com/showthread...hreadid=274766 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.788 / Virus Database: 533 - Release Date: 01/11/2004 |
|
#4
|
|||
|
|||
|
David is completely right about this: pressing F1 should be everybody's first
port of call. For example, the other day I needed to work out the lowest common denominator of a range of about cells. First thing I did? Pressed F1, and typed Denominator in the dialogue box. Lo and behold, found an Add-In for the formula =CGD(num1,num2,num3..) (Greatest common divisor) Although HELP is wordy and not always clear to beginners, it was written by the programmers themselves and therefore pretty much covers everything you need to know about basic formulae. "David McRitchie" wrote: I don't understand why anyone (group) would not include HELP. I've seen that situation and it is really idiotic, perpetrated by groups that want to be the sole point for help and don't even provide decent help. I would suggest downloading Peter Noneley's workbook Excel Function Dictionary http://homepage.ntlworld.com/noneley --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ForSale" wrote in message ... I feel pretty confident with my use of macros, but i need some work on formulas. I don't have help installed on my work PC (which is where i have my downtime...). are there any good sites around that can show me more about formulas? thanks. -- ForSale ------------------------------------------------------------------------ ForSale's Profile: http://www.excelforum.com/member.php...o&userid=11896 View this thread: http://www.excelforum.com/showthread...hreadid=274766 |
|
#5
|
|||
|
|||
|
All these smart people here and not one of them gave the
most obvious answer. One of, if not the best place to "learn" about formulas is right here in this group. Visit this group as often as you can and just read the posts and replies. Although books are nice to have, you'll learn much more from this group. Biff -----Original Message----- I don't understand why anyone (group) would not include HELP. I've seen that situation and it is really idiotic, perpetrated by groups that want to be the sole point for help and don't even provide decent help. I would suggest downloading Peter Noneley's workbook Excel Function Dictionary http://homepage.ntlworld.com/noneley --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "ForSale" wrote in message ... I feel pretty confident with my use of macros, but i need some work on formulas. I don't have help installed on my work PC (which is where i have my downtime...). are there any good sites around that can show me more about formulas? thanks. -- ForSale -------------------------------------------------------- ---------------- ForSale's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=11896 View this thread: http://www.excelforum.com/showthread...hreadid=274766 . |
|
#6
|
|||
|
|||
|
Couple of resources with downloadable workbooks with example.......
Peter Nonely: Function list http://homepage.ntlworld.com/noneley/ Norman Harker: Function list http://www.contextures.on.ca/functions.html For books see Debra Dalgleish's site. http://www.contextures.on.ca/xlbooks.html#Top Specifically for formulas........ http://www.contextures.on.ca/xlbooks.html#Functions Gord Dibben Excel MVP On Tue, 2 Nov 2004 20:53:16 -0600, ForSale wrote: I feel pretty confident with my use of macros, but i need some work on formulas. I don't have help installed on my work PC (which is where i have my downtime...). are there any good sites around that can show me more about formulas? thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas not working | Excel Discussion (Misc queries) | |||
| How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
| Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
| Excel aficionado wants to learn Access | Excel Discussion (Misc queries) | |||
| Excel user desires to learn ABC of Access | Excel Discussion (Misc queries) | |||
Hybrid Mode
