#1   Report Post  
steve
 
Posts: n/a
Default new user

i'm just learning how to program these sheets. is there a book or some kind
of reference for all of the syntax? would it be a vba book or an excel book?
or is there one that combines the two. thank you
  #2   Report Post  
Bernard Liengme
 
Posts: n/a
Default

If you are a newcomer, you do not need VBA yet.
A complete list of all functions would be of little use till you get
familiar with the basics.
If you have a newer version (post 97) the Formula Palette is very helpful;
just type a brief idea of the task you want and Excel shows possible
functions.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"steve" wrote in message
...
i'm just learning how to program these sheets. is there a book or some
kind
of reference for all of the syntax? would it be a vba book or an excel
book?
or is there one that combines the two. thank you



  #3   Report Post  
SunshineX
 
Posts: n/a
Default

There is a little button to the left of the formula bar that say 'Fx'. By
clicking that button it opens a Fomula Wizard that can help you make a
formula. It also has individual wizards for each function too.

There is a great tutorial on pivot tables in the Excel help, it is called
"What's so great about Pivot Tables"

With those two things you can do most all of what excel has to offer. It is
really a fairly simple application but can be very powerful if you get good
at it.

"steve" wrote:

i'm just learning how to program these sheets. is there a book or some kind
of reference for all of the syntax? would it be a vba book or an excel book?
or is there one that combines the two. thank you

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
User forms "back" buttons DavidObeid Excel Discussion (Misc queries) 1 June 22nd 05 09:07 AM
Finding a record based on user input Soundman Excel Discussion (Misc queries) 5 June 21st 05 03:06 AM
Positioning 2 User Forms mully New Users to Excel 3 June 11th 05 08:15 PM
Default User Defined Functions - How? flycast Excel Discussion (Misc queries) 4 May 26th 05 04:26 AM
find and match the max buffyslay Excel Worksheet Functions 0 November 2nd 04 01:57 PM


All times are GMT +1. The time now is 04:40 AM.

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

About Us

"It's about Microsoft Excel"