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

Annie,

Have you looked in HELP

--
Don Guillett
SalesAid Software
[email protected]
"Annie" <[email protected]> wrote in message
news:[email protected]...
>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

You can download a function dictionary from here

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

--
Regards,

Peo Sjoblom

(No private emails please)


"Annie" <[email protected]> wrote in message
news:[email protected]...
>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

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

"Annie" <[email protected]> wrote in message
news:[email protected]...
>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

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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>

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
> [email protected]
> "Annie" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>
>

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" <[email protected]> wrote in message
> news:[email protected]...
> >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
>
>

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> > news:[email protected]...
> > >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
> >
> >
> >

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> > > news:[email protected]...
> > > >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
> > >
> > >
> > >
>
>
>

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

--
Don Guillett
SalesAid Software
[email protected]
"Annie" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
>> > > news:[email protected]...
>> > > >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
>> > >
>> > >
>> > >
>>
>>
>>

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
> [email protected]
> "Annie" <[email protected]> wrote in message
> news:[email protected]...
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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" <[email protected]> wrote in message
> >> > > news:[email protected]...
> >> > > >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
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>
>

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" <[email protected]>
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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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" <[email protected]> wrote in message
>> > > news:[email protected]...
>> > > >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
>> > >
>> > >
>> > >
>>
>>
>>

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" <[email protected]>
> 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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" <[email protected]> wrote in message
> >> > > news:[email protected]...
> >> > > >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
> >> > >
> >> > >
> >> > >
> >>
> >>
> >>
>
>

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

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

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
>
>