And familiarize yourself with the menu system.

Know what's under Edit (copy, paste, paste special).

And remember that rightclicking on anything is your friend. Excel does its best
to show you want you can do with that thing you rightclicked on.

And to add to Chip's reply...

Debra Dalgleish has some tips for some of the counting functions:
http://contextures.com/xlFunctions04.html

and for =vlookup()
http://contextures.com/xlFunctions02.html

=====
I'd toss in Data|Subtotal and Data|Sort and Data|filter for things to know, too.

DonaldCX wrote:

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

--

Dave Peterson