If I had to cram for an Excel test, I would study up on the
following:

SUMIF
COUNTIF
VLOOKUP
HLOOKUP
Pivot Tables
Charts


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"DonaldCX"
wrote in
message
...

Hello. I have a job interview coming up next week, for an entry
level
position as marketing analyst. I was told I will be tested on
Excel. I
am a novice Excel user, and need to intermediate by next week
(I don't
suppose they are looking for an entry level Excel guru :)).

I checked out a 1000 page Excel book from the local library
this
morning... Instead of attempting to read the entire book in 6
days, I'd
like to concentrate on only the most important concepts (I have
some
knowledge of VB so that part shouldn't be a hurdle).

What are the most important concepts every intermediate Excel
user
should know?


--
DonaldCX
------------------------------------------------------------------------
DonaldCX's Profile:
http://www.excelforum.com/member.php...o&userid=33695
View this thread:
http://www.excelforum.com/showthread...hreadid=534701