What is contained in excel intermediate?

[Maria]

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?

 

[Bernard Liengme]

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

 

[Maria]

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]

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

 

[Maria]

Many thanks.

Hoping to get the job as I'm looking forward to the challenge!

Will let you know what happens.

Thanks again

Maria

 

[ShaneDevenshire]

Looks like you already have a challenge.

I teach an intermediate course on Excel we cover:

Customizing Toolbars and Menus

Displaying more buttons
Hiding or displaying toolbars
Personalized menus and toolbars
Creating a new toolbar

Working with Dates

Interpreting two-digit years
Date functions
Date formatting

Outlining

Creating outline levels manually
Creating outline levels automatically
Naming Cells

Using the Name box to create a range name

Naming cells by using existing row and column labels

Worksheet Functions

Use SUM to add nonadjacent ranges
Using the insert function command
Nesting functions
Simple vs. complex functions
Using the PMT() function
Using the IF() logical function
Using the AND() Operator within an IF() statement
Nested IF() statements
Using the VLOOKUP() function

Linking

Linking cells on the same worksheet
Linking values between worksheets
Linking cells in different workbooks
Changing the link source
Changing from a link to a value
Breaking links

Working with Excel Lists

Creating a list
Sorting a list
Using a data form
Filtering a list
Using advanced filtering

Using Database Functions with Lists

Using the DSUM() function
Using the DCOUNT() function
Using the SUM() function

 

[Maria]

Many Many thanks - this is just what I needed. Will be able to study long
and hard now.

Greatly appreciated

Maria