Many thanks.
Hoping to get the job as I'm looking forward to the challenge!
Will let you know what happens.
Thanks again
Maria
"Bernard Liengme" wrote:
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?