Thread: Excel tutorial sites
January 20th, 2003, 10:51 AM #1
Excel tutorial sites
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.
The final legacy of the United States will be that in the end liberalism shamed & destroyed the heritage of this great nation. How sad as I see no turning back. When in Rome ..
January 20th, 2003, 02:57 PM #2
- Join Date
- Oct 2001
- Big Sky Country
- Blog Entries
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.
January 28th, 2003, 02:54 PM #3
- Join Date
- Mar 2002
- almost Virginia
- Blog Entries
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
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
More than you wanted well tough, suffer.
Last edited by Epidemic; January 28th, 2003 at 03:20 PM.
January 28th, 2003, 02:55 PM #4
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)