Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Annie
 
Posts: n/a
Default Formula reference site

I use Excel a bit but I don't have much experience with formulas. I'm finding
more and more things that I would like to put into a spreadsheet and have
Excel do the math.

Could anyone post some links to sites that would help a formula newbie? If I
can see some examples of what can be done, I'd be grateful.

Annie
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Peo Sjoblom
 
Posts: n/a
Default Formula reference site

You can download a function dictionary from here

http://www.rondebruin.nl/files/xlfdic01.zip

--
Regards,

Peo Sjoblom

(No private emails please)


"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas. I'm
finding
more and more things that I would like to put into a spreadsheet and have
Excel do the math.

Could anyone post some links to sites that would help a formula newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie


  #4   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme
 
Posts: n/a
Default Formula reference site

Can I suggest that very modern technology called BOOK?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas. I'm
finding
more and more things that I would like to put into a spreadsheet and have
Excel do the math.

Could anyone post some links to sites that would help a formula newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie



  #5   Report Post  
Posted to microsoft.public.excel.newusers
Annie
 
Posts: n/a
Default Formula reference site

Have you ever tried to do a Search in a BOOK? I've yet to find a single F1
key in a BOOK.

"Bernard Liengme" wrote:

Can I suggest that very modern technology called BOOK?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas. I'm
finding
more and more things that I would like to put into a spreadsheet and have
Excel do the math.

Could anyone post some links to sites that would help a formula newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie






  #6   Report Post  
Posted to microsoft.public.excel.newusers
Annie
 
Posts: n/a
Default Formula reference site

I have but haven't always found Help files to be as helpful as I'd like. I've
bookmarked some sites but I thought that some of the people here may have a
little gem tucked away in their Favorites folder.

Annie

"Don Guillett" wrote:

Annie,

Have you looked in HELP

--
Don Guillett
SalesAid Software

"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas. I'm
finding
more and more things that I would like to put into a spreadsheet and have
Excel do the math.

Could anyone post some links to sites that would help a formula newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie




  #7   Report Post  
Posted to microsoft.public.excel.newusers
Annie
 
Posts: n/a
Default Formula reference site

Wow! That is really cool! I have a mailing list that I get from another
person. She keeps the names in "First name Last name" format. It's a royal
pain. I've just had to accept her choice of layout up until now. *Maybe* I
can break it down using this spreadsheet as an example. Awesome!!

Thank you so very much Peo!

Annie


"Peo Sjoblom" wrote:

You can download a function dictionary from here

http://www.rondebruin.nl/files/xlfdic01.zip

--
Regards,

Peo Sjoblom

(No private emails please)


"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas. I'm
finding
more and more things that I would like to put into a spreadsheet and have
Excel do the math.

Could anyone post some links to sites that would help a formula newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie



  #8   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default Formula reference site

Hi Annie,

Since rearranging data is of interest you might take a look at using the mouse
I'd put the phone number first (right justified even as text), lastname, firstname, addresses, etc.

Fill-Handle, Replication and use of the Mouse
Use of Mouse and keys to move, and insert rows or columns (#mouse)
http://www.mvps.org/dmcritchie/excel/fillhand.htm#mouse

Shortcut Keys in Excel 2000 (Excel Vers. 9)
http://www.mvps.org/dmcritchie/excel/shortx2k.htm

Excel Lessons & Tutorials (#tutorials)
http://www.mvps.org/dmcritchie/excel....htm#tutorials
---
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



  #9   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips
 
Posts: n/a
Default Formula reference site

You use it in a different way. You read the book from the front to the back,
and assimilate the information in it. That equips you with skills that
enable you to works things out. Sometimes you have to invest some time and
effort to learn things.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Annie" wrote in message
...
Have you ever tried to do a Search in a BOOK? I've yet to find a single F1
key in a BOOK.

"Bernard Liengme" wrote:

Can I suggest that very modern technology called BOOK?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas. I'm
finding
more and more things that I would like to put into a spreadsheet and

have
Excel do the math.

Could anyone post some links to sites that would help a formula

newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie






  #10   Report Post  
Posted to microsoft.public.excel.newusers
Annie
 
Posts: n/a
Default Formula reference site

The idea is not to have everything memorized but to know where to easily
access the information. The human brain does not have the hard drive space
nor the RAM to memorize everything. Not even if your name is Steven Hawkings.

And I have invested the time - I'm looking for addition information, this
time electronically.

Annie

"Bob Phillips" wrote:

You use it in a different way. You read the book from the front to the back,
and assimilate the information in it. That equips you with skills that
enable you to works things out. Sometimes you have to invest some time and
effort to learn things.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Annie" wrote in message
...
Have you ever tried to do a Search in a BOOK? I've yet to find a single F1
key in a BOOK.

"Bernard Liengme" wrote:

Can I suggest that very modern technology called BOOK?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas. I'm
finding
more and more things that I would like to put into a spreadsheet and

have
Excel do the math.

Could anyone post some links to sites that would help a formula

newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie








  #11   Report Post  
Posted to microsoft.public.excel.newusers
Don Guillett
 
Posts: n/a
Default Formula reference site

That's OK. Bob doesn't mind being your memory.

--
Don Guillett
SalesAid Software

"Annie" wrote in message
...
The idea is not to have everything memorized but to know where to easily
access the information. The human brain does not have the hard drive space
nor the RAM to memorize everything. Not even if your name is Steven
Hawkings.

And I have invested the time - I'm looking for addition information, this
time electronically.

Annie

"Bob Phillips" wrote:

You use it in a different way. You read the book from the front to the
back,
and assimilate the information in it. That equips you with skills that
enable you to works things out. Sometimes you have to invest some time
and
effort to learn things.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Annie" wrote in message
...
Have you ever tried to do a Search in a BOOK? I've yet to find a single
F1
key in a BOOK.

"Bernard Liengme" wrote:

Can I suggest that very modern technology called BOOK?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas.
I'm
finding
more and more things that I would like to put into a spreadsheet
and

have
Excel do the math.

Could anyone post some links to sites that would help a formula

newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie








  #12   Report Post  
Posted to microsoft.public.excel.newusers
Annie
 
Posts: n/a
Default Formula reference site

But remembering Bob might mean forgetting something important - like whether
the brake pedal is the one on the left or the one on the right.

Annie ;-)

"Don Guillett" wrote:

That's OK. Bob doesn't mind being your memory.

--
Don Guillett
SalesAid Software

"Annie" wrote in message
...
The idea is not to have everything memorized but to know where to easily
access the information. The human brain does not have the hard drive space
nor the RAM to memorize everything. Not even if your name is Steven
Hawkings.

And I have invested the time - I'm looking for addition information, this
time electronically.

Annie

"Bob Phillips" wrote:

You use it in a different way. You read the book from the front to the
back,
and assimilate the information in it. That equips you with skills that
enable you to works things out. Sometimes you have to invest some time
and
effort to learn things.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Annie" wrote in message
...
Have you ever tried to do a Search in a BOOK? I've yet to find a single
F1
key in a BOOK.

"Bernard Liengme" wrote:

Can I suggest that very modern technology called BOOK?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas.
I'm
finding
more and more things that I would like to put into a spreadsheet
and
have
Excel do the math.

Could anyone post some links to sites that would help a formula
newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie









  #13   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default Formula reference site

I see what you mean Annie.

You have already forgotten that Hawkings is spelled without the "s"


Gord<g

On Mon, 21 Nov 2005 07:44:39 -0800, "Annie"
wrote:

The idea is not to have everything memorized but to know where to easily
access the information. The human brain does not have the hard drive space
nor the RAM to memorize everything. Not even if your name is Steven Hawkings.

And I have invested the time - I'm looking for addition information, this
time electronically.

Annie

"Bob Phillips" wrote:

You use it in a different way. You read the book from the front to the back,
and assimilate the information in it. That equips you with skills that
enable you to works things out. Sometimes you have to invest some time and
effort to learn things.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Annie" wrote in message
...
Have you ever tried to do a Search in a BOOK? I've yet to find a single F1
key in a BOOK.

"Bernard Liengme" wrote:

Can I suggest that very modern technology called BOOK?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas. I'm
finding
more and more things that I would like to put into a spreadsheet and

have
Excel do the math.

Could anyone post some links to sites that would help a formula

newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie







  #14   Report Post  
Posted to microsoft.public.excel.newusers
Annie
 
Posts: n/a
Default Formula reference site

Darn. I already gave up driving a manual shift to cut back on the number of
pedals. The is one slippery downhill slide!

A
n
n
i
e

"Gord Dibben" wrote:

I see what you mean Annie.

You have already forgotten that Hawkings is spelled without the "s"


Gord<g

On Mon, 21 Nov 2005 07:44:39 -0800, "Annie"
wrote:

The idea is not to have everything memorized but to know where to easily
access the information. The human brain does not have the hard drive space
nor the RAM to memorize everything. Not even if your name is Steven Hawkings.

And I have invested the time - I'm looking for addition information, this
time electronically.

Annie

"Bob Phillips" wrote:

You use it in a different way. You read the book from the front to the back,
and assimilate the information in it. That equips you with skills that
enable you to works things out. Sometimes you have to invest some time and
effort to learn things.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Annie" wrote in message
...
Have you ever tried to do a Search in a BOOK? I've yet to find a single F1
key in a BOOK.

"Bernard Liengme" wrote:

Can I suggest that very modern technology called BOOK?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Annie" wrote in message
...
I use Excel a bit but I don't have much experience with formulas. I'm
finding
more and more things that I would like to put into a spreadsheet and
have
Excel do the math.

Could anyone post some links to sites that would help a formula
newbie? If
I
can see some examples of what can be done, I'd be grateful.

Annie








  #15   Report Post  
Posted to microsoft.public.excel.newusers
tghcogo
 
Posts: n/a
Default Formula reference site


You might have a look at these free online tutorials:-

http://www.auditexcel.co.za/training.html


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=486697



  #16   Report Post  
Posted to microsoft.public.excel.newusers
Annie
 
Posts: n/a
Default Formula reference site

Thank you :-)

"tghcogo" wrote:


You might have a look at these free online tutorials:-

http://www.auditexcel.co.za/training.html


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=486697


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to replace a function with its result or resulting reference in a formula? Dmitry Kopnichev Excel Worksheet Functions 5 October 13th 05 12:15 PM
How do I use cell reference instead of name in a formula? Steve L Excel Discussion (Misc queries) 5 August 25th 05 02:16 PM
Copying a Formula To Reference Multiple Worksheets carl Excel Worksheet Functions 1 August 5th 05 01:06 AM
IF function: Reference cells - Value vs Formula Newsgal Excel Worksheet Functions 3 May 24th 05 08:51 PM
Is it Possible in a formula to have a formula for cell reference? RogerBarker Excel Worksheet Functions 3 February 16th 05 09:00 PM


All times are GMT +1. The time now is 08:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"