View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default What is contained in excel intermediate?

Things to look at while waiting for book

For more details on SUMPRODUCT
Bob Phillips
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
J.E McGimpsey
http://mcgimpsey.com/excel/formulae/doubleneg.html


EEE 754
Floating-point arithmetic may give inaccurate results in Excel
http://support.microsoft.com/kb/78113/en-us
(Complete) Tutorial to Understand IEEE Floating-Point Errors
http://support.microsoft.com/kb/42980
What Every Computer Scientist Should Know About Floating Point
http://docs.sun.com/source/806-3568/ncg_goldberg.html
http://www.cpearson.com/excel/rounding.htm

Chip's stuff on array formulas:
http://www.cpearson.com/excel/excelF.htm

Know about F9 (recalc) and the Formula Auditing tool in XL 2003 (View |
Toolbars | Formula Auditing - Evaluate Formula

Know how many row and cols in XL2003 and that nesting limit is 7. Beware
that XL2007 has about 1 million rows and over 1000 columns and nesting 64
deep.

If you are weak with charts visit Jon's site
http://peltiertech.com/Excel/ChartsHowTo/index.html

Other people will add/subtract from my list but just get on and doing some
thinking about Excel.

Be honest - you will be unhappy if the job is beyond your abilities.
all the best
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Maria" wrote in message
...
Thank you Bernard,

However, I wonder if you could advise on any areas which would be
considered
the next step up from beginner?

You're right I've a 3 hour job interview on Friday morning which includes
testing on Excel - they require Intermediate/Advanced skills and I'm
panicing
- copy of excel for dummies should be with me on Tuesday!!

Maria

"Bernard Liengme" wrote:

Only the person who wrote the document using that phrase!
Sorry, but I cannot really tell you more.
Buy Excel for Dummies asap, read it from cover to cover, pray hard, and
go
to the interview
Tell us the outcome - we are routing for you!
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Maria" wrote in message
...
I need to have covered the content of the intermediate level in Excell
by
Thurs 06th Nov 2008 but I don't know where to start. Does anyone know
what I
should be covering?