What do you consider intermediate skills for Excel 2007?
| Posted By | Message |
|---|---|
|
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. |
|
Posted 10/29/14 1:33 PM
|
|
|
Long Island Weddings
Long Island's Largest Bridal Resource
| |
|
What do you consider intermediate skills for Excel 2007? Graphing, perhaps? |
|
Posted 10/29/14 1:35 PM
|
|
|
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. Message edited 2014-10-29 13:50:49.873000. |
|
Posted 10/29/14 1:46 PM
|
|
|
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
|
|
|
What do you consider intermediate skills for Excel 2007? Linking cells / workbooks |
|
Posted 10/29/14 2:17 PM
|
|
|
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
|
|
|
Re: What do you consider intermediate skills for Excel 2007? As an accountant I think what the others listed above is sufficient. |
|
Posted 10/29/14 10:39 PM
|
|






