Excel tutorial sites

[Bill in SD, CA]

Does anyone know of any sites on the web or other good tutorial material that can help me learn to use Excel? I've always used Lotus and pretty much ignored Excel. However, I see most companies require Excel for their positions.

Thanks,
Bill

[NeoStarO1]

Hi Bill,

I have an old Exel 2000 book you can have if you want, Just pay me shipping when you recieve it.

Its from and old college class. I also have the Word, Access books that go with it. they are fairly small books but good tutorials to get down iwth the basics and creating some neat documents. Just let me know if you want it. if you want them all or just the excel tutorial book.

[Epidemic]

http://www.angelfire.com/biz7/julian...ans_macros.htm


http://www.mindspring.com/~tflynn/excelvba.html

http://coolvb.cooltech.org/clinks.shtml

I only quick glanced these.

The first one seemed to be pretty nice.

I addressed my searches only based on programming aspects.


A little tid bit. depending on what you want there are several functions I think that a lot of people should pay close attention to because they hold many solution to your problems.

Built in Spread sheet functions
1) auto filter
2) Pivot tables
3) Vlookup

Macro's
1) Private and public Functions (you can write your own functions like sum but on steroids)
2) Cell functions Cell(1,2).select can easily be converted to Cell(X,Y).select. now you can select cells via variables.
3) Application.DisplayAlerts = False You can bypass display alerts for automatic saving and such.
4) Application.ScreenUpdating = False. When using a macro which sequentially does many calculation and updates this little feature will speed things up by near 2 X


one of my favorite little macro functions is work book open.
the function checks the list of open workbooks against a specific file and comes back with a true or false.


Use this line in another subroutine.
it will call the private function workbookisopen.
and check it against either a variable or a fixed name.
below is an example of a fixed name.

a = workbookisopen("pocket engineer.xls")

Private Function workbookisopen(wbname) As Boolean
Dim x As Workbook
On Error Resume Next
Set x = Workbooks(wbname)
If Err = 0 Then workbookisopen = True Else workbookisopen = False
End Function

More than you wanted well tough, suffer.

[dunbar]

www.techrepublic.com