What do you consider intermediate skills for Excel 2007?

Posted By Message

BeachGrl
LIF Adult

Member since 10/11

2140 total posts

Name:
Kristy

What do you consider intermediate skills for Excel 2007?

I'm taking a test tomorrow for an accountant job and in the email it said Basic & Intermediate Excel skills are a big part of the test.

I want to brush up tonight, what would you consider this to be?

Pivot Tables?
Macros?

Or are those more advanced functions?

Thanks!

Posted 10/29/14 1:33 PM
 
Long Island Weddings
Long Island's Largest Bridal Resource

Blazesyth
*yawn*

Member since 5/05

8129 total posts

Name:

What do you consider intermediate skills for Excel 2007?

Graphing, perhaps?

Posted 10/29/14 1:35 PM
 

Bridex100
Two Under Two Mommy

Member since 3/08

10420 total posts

Name:
Momx100

Re: What do you consider intermediate skills for Excel 2007?

I would think that you should be able to do basic formulas and formatting. For an accounting role, I would think you should be able to link different tabs to roll into other tabs. You will most likely be tested for knowledge and how you translate that knowledge into excel. Your future employer will see very quickly if you can produce the right charts, schedules, financial reports, etc. or if you are stumbling.

My background is in finance but I work closely with accountants. My #1 pet peeve is when people hardcode and do not use formulas. A lot of errors are made this way. I also don't like when people drag formulas incorrectly. Also causing errors.

I don't think you need macros. I spent the majority of my life on excel doing financial modeling and would consider myself advanced in excel. I don't use macros. I do use a lot of tables.

Message edited 2014-10-29 13:50:49.873000.

Posted 10/29/14 1:46 PM
 

BeachGrl
LIF Adult

Member since 10/11

2140 total posts

Name:
Kristy

Re: What do you consider intermediate skills for Excel 2007?

Posted by Bridex100

I would think that you should be able to do basic formulas and formatting. For an accounting role, I would think you should be able to link different tabs to roll into other tabs. You will most likely be tested for knowledge and how you translate that knowledge into excel. Your future employer will see very quickly if you can produce the right charts, schedules, financial reports, etc. or if you are stumbling.

My background is in finance but I work closely with accountants. My #1 pet peeve is when people hardcode and do not use formulas. A lot of errors are made this way. I also don't like when people drag formulas incorrectly. Also causing errors.

I don't think you need macros. I spent the majority of my life on excel doing financial modeling and would consider myself advanced in excel. I don't use macros. I do use a lot of tables.



Thanks for your input! Do you have any specific tutorial recommendations?

Posted 10/29/14 1:56 PM
 

blue11
LIF Adult

Member since 2/11

1706 total posts

Name:
kat

What do you consider intermediate skills for Excel 2007?

Linking cells / workbooks
Vlookups
Filtering / sorting / subtotal functions
pivot tables
simple graphs
formulas

Posted 10/29/14 2:17 PM
 

JAPH23
LIF Adolescent

Member since 10/13

769 total posts

Name:
:)

Re: What do you consider intermediate skills for Excel 2007?

Posted by blue11

Linking cells / workbooks
Vlookups
Filtering / sorting / subtotal functions
pivot tables
simple graphs
formulas



This

maybe some If, then statements etc.

Posted 10/29/14 2:53 PM
 

MrsO
Big Brothers to Be

Member since 1/07

4521 total posts

Name:
Maureen

Re: What do you consider intermediate skills for Excel 2007?

As an accountant I think what the others listed above is sufficient.

Formulas
Pivot tables are helpful

Posted 10/29/14 10:39 PM