Microsoft Excel

[Guest]

I am quite impatient and would like to watch a tutorial on excel that takes
one through the basics to advanced spreadsheet management. soes such a thing
exist?

 

[Guest]

Good luck, let me know if you find one

 

[Gord Dibben]

No one tutorial could possibly cover your needs.

A multitude of tutorials might do the job.

http://office.microsoft.com/en-us/m.../downloads/results.aspx?qu=training&av=DCT000

Your impatience will most likely deter you from learning very much.

Your "basics through advanced" learning could take years like the rest of us are
experiencing.


Gord Dibben MS Excel MVP

 

[Dave Thomas]

I can assure you that excel is very complex. You will learn little from
watching a tutorial.
The only way to learn Excel is by doing. I can guarantee you that you will
never learn Excel by watching.
The Step by Step books walk you through examples. You actually do them, step
by step.

I suggest you buy a books on Excel. The books are available at Barnes and
Noble and also Amazon.com

The starter books are Excel 2003 Step by Step (ISBN: 0-7536-1518-7), $24.99
and Excel 2007 (ISBN: 0-7356-2304-X), $24.99
Both books by Curtis Frye are about 300 pages. The Step by Step books are
mandatory reading for beginners in Excel.

Then you should buy Microsoft Office Excel 2003 Bible (ISBN: 0-7645-3967-1),
$39.99 or Microsoft Office Excel 2007 Bible (ISBN: 0-4700-4403-9), $39.99.
Both books by John Walkenbach are about 900 pages.

You should also take advantage of the following web sites:
John Walkenbach's The Spreadsheet Page: http://www.j-walk.com/ss.
Chip Pearson's Pearson Software Consulting:
http://www.cpearson.com/excel.htm.
Stephen Bullen's Excel Page: http://www.bmsltd.co.uk/excel
David McRitchie's Excel Pages
http://www.mvps.org/dmcritchie/excel/excel.htm.
Jon Peltier's Excel Page: http://peltiertech.com/Excel/Charts/index.html
For charts
Spreadsheet FAQ (Frequently Asked Questions):
http://www.faqs.org/faqs/spreadsheets/faq This site is filled with links for
Excel.

 

[Dave Thomas]

I can assure you that Excel is very complex. You will learn little from
watching a tutorial.
The only way to learn Excel is by doing. I can guarantee you that you will
never learn Excel by watching.
The Step by Step books walk you through examples. You actually do them, step
by step.

I suggest you buy a books on Excel. The books are available at Barnes and
Noble and also Amazon.com

The starter books are Excel 2003 Step by Step (ISBN: 0-7356-1518-7), $24.99
and Excel 2007 (ISBN: 0-7356-2304-X), $24.99
Both books by Curtis Frye are about 300 pages. The Step by Step books are
mandatory reading for beginners in Excel.

Then you should buy Microsoft Office Excel 2003 Bible (ISBN: 0-7645-3967-1),
$39.99 or Microsoft Office Excel 2007 Bible (ISBN: 0-4700-4403-9), $39.99.
Both books by John Walkenbach are about 900 pages.

Another good Excel book is Microsoft Office Excel 2003 Inside Out (ISBN:
0-7356-1511-X), $44.99
and Microsoft Office Excel 2007 Inside Out (ISBN:0-7356-2321-X), $44.99.
Both books by Mark Dodge and Craig Stinson are about 1,000 pages.

You should also take advantage of the following web sites:

John Walkenbach's The Spreadsheet Page: http://www.j-walk.com/ss.

Chip Pearson's Pearson Software Consulting:
http://www.cpearson.com/excel.htm.

Stephen Bullen's Excel Page: http://www.bmsltd.co.uk/excel

David McRitchie's Excel Pages
http://www.mvps.org/dmcritchie/excel/excel.htm.

Jon Peltier's Excel Page: http://peltiertech.com/Excel/Charts/index.html
For charts

Spreadsheet FAQ (Frequently Asked Questions):
http://www.faqs.org/faqs/spreadsheets/faq This site is filled with links for
Excel.

 

[Guest]

I wish I could just get the thing to work at all for me without my silly
bypass the problem moves!

Exel is not using formulas correctly in one file. I have to click on the
cell and then click in the editing bar and click enter before any existing
formulas work. Copying sections onto new files brings the problem to the new
file too. Filling formulas does not work as just the value gets copied with
no option to fill formula appearing in the list. Three different machines
have the same problem with the file. The machine that the file was on
originally had to have a new hard drive when sent in for repairs.

 

[Gord Dibben]

You could one or more of a couple of problems.

1. Your calculation mode is set to "manual"

2. Your numbers are not real numbers, but text numbers.

I suspect 2.

Format all to General then copy an empty cell.

Select your "numbers" range and Edit>Paste Special(in place)>Add>OK>Esc


Gord Dibben MS Excel MVP

 

[Ragdyer]

Sounds like the calculation mode is set to manual.

From the menu bar, try:

<Tools. <Options> <Calculation> tab,
And click on "Automatic".

 

[Guest]

I've been working Excel for nearly a year and I still dont know everything

 

[Gord Dibben]

Aggie

Believe it or not but many who have been using Excel for a couple of decades
don't know "everything".

Drop back in a few years and let us know how you're making out<g>


Gord Dibben MS Excel MVP

 

[Don Guillett]

Like Gord, I have been doing this for many, many years and despite the fact
that I am a graduate of the University of Texas, I too, do not know nearly
everything.
"Hook em horns"

 

[Guest]

I'm so sorry to hear your graduated as a T-sip. I heard that they finally
found the three that got lost in the cave the other day, but then again my
friends are cavers too, but... I cant really say alot, your from the best
state in the Union, Texan born and raised and thats all that matters


--
If this reply was helpful, please indicate that your question has been
answered to help others find anwsers to similar questions.

www.silverbirddesigns.com

Fighting Texas Aggie Class of 2009