Microsoft Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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.
 
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.
 
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.
 
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
 
Sounds like the calculation mode is set to manual.

From the menu bar, try:

<Tools. <Options> <Calculation> tab,
And click on "Automatic".
 
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
 
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"
 
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
 
Back
Top