What are the most important Excel concepts I should know (will be tested soon)?

[DonaldCX]

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?

 

[Chip Pearson]

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"
message
news[email protected]...

 

[Dave Peterson]

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.

 

[arad]

some other important functions:

a nice shave.
and a nice suit.
a lot of charm.

and don't worry be happy !

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.

 

[Dominic]

Did they tell you what type of test it would be?

Many companies will use an automated testing software program. These
programs typcially really focus on you knowing the menu system (in one try).
So I second Dave's suggestion.