Where do you learn advanced excel?

[CompPro]

I use excel extensively for my work (compensation). I use user groups
extensively to find shortcuts for managing the large volumes of data
and complex data sets. I am at the point where the "solutions" are a
step beyond formulas in excel. The recommended solutions contain
things such as macros and large scripts of programming language. Where
would I go to learn how to use this type of thing? I don't want to be a
programmer, but I would like to know how I can use the complex macros,
etc. that are appearing in user group posts. Is it as simple as
cutting and pasting these long formulas into an excel function or do I
need special software? I don't know what I don't know and would
appreciate any advice. Thank you in advance.

 

[Guest]

You could take a course, or get a book on the Excel programming language
called VBA (Visual Basic for Applications).........and/or you could spend
more time in the microsoft.public.excel.programming newsgroup........after
enough exposure it starts to come together.......(at least a little bit).

hth
Vaya con Dios,
Chuck, CABGx3

 

[Dave Peterson]

Debra Dalgleish has a list of books at her site:
http://www.contextures.com/xlbooks.html

John Walkenbach's is a nice one to start with.

Depending on how advanced you are...

Professional Excel Development
By Stephen Bullen, Rob Bovey, John Green

See if you can find them in your local bookstore/internet site and you can
choose what one you like best.

 

[CompPro]

Chuck,

Thank you for replying to my message. Below is a suggestion from a
user group I visited. Is this an example of Visual Basic, or can this
be done in excel? I couldn't figure out how to insert it based on the
traditional macros in excel.

Option Explicit
Sub testme()

Dim wks As Worksheet

For Each wks In ActiveWorkbook.Worksheets
wks.Copy 'to a new workbook
With ActiveSheet
..Parent.SaveAs Filename:="C:\temp\" & .Name, _
FileFormat:=xlWorkbookNormal
..Parent.Close savechanges:=False
End With
Next wks

End Sub

Make sure C:\temp\ already exists (or change the code to point at an
existing
folder)

 

[R..VENKATARAMAN]

try this url for vba turoial

http://www.vbtutor.net/vbtutor.htm