welcome to the board and good luck
This is a discussion on Excel test - top 3 things to study ? within the Lounge v.2.0 forums, part of the The Lounge category; I work as an accountant and consider myself somewhere between novice and intermediate based on this: http://www.xl-logic.com/modules.php?...showpage&pid=1 I've got a ...
I work as an accountant and consider myself somewhere between novice and intermediate based on this:
I've got a job interview with an excel test. What would you consider to be the top 3 things to study/review? Pivot tables? Macros?
welcome to the board and good luck
go for pivot tables first. Also look at Sumif and Countif, and understand which works best in different scenarios, pivots or formulas. If you have time, explore Sumproduct, too.
You need time for macros. Start recording a few macros and study the difference and effects of absolute and relative cell differences.
Ditto texasalynn's pleasantries, islandguy11.
Specifically, in terms of formulas, I would get familiar with:
Math formulas (MOD, INT, etc.)
There is a good Workbook you can download from this site, that shows working examples of most of the formulas Excel has to offer:
Though the site is down for the moment for some reason...
Good luck with the interview.
With regards to finance, I would say the VLOOKUP is one of the most useful formulas too.
.select, overused and inefficient.
Welcome to the Board!
Have you asked how in-depth the test will be and if it's targeted toward any specific competency?
thanks for the welcome and advice everyone...
One question with macros: would it be expected for an intermediate user to know VBA, or is the macro record tool sufficient? i did some vba programming in the past, but it was quite some time ago and have not used it in daily work
Smitty: i think the test will be targeted more towards analysis, and being able to summarize a large amount of data... perhaps in a format that could be used in a report. It's not a programming job, so I'm not so sure about how much VBA is expected, if any.
Last edited by islandguy11; Nov 20th, 2008 at 06:57 PM.
I would make darn sure you know what a VLOOKUP formula is and, if you have time, understand how to use INDEX/MATCH instead of VLOOKUP. Also SUMIF and COUNTIF.
I would also check out Pivot Tables and know how to create a chart from data (and maybe how to add a secondary axis - I've had that in an Excel test before!).
I wouldn't expect anything truly advanced (by advanced meaning what counts as intermediate on this board).
Do expect a lot of questions about cell navigation, formatting, basic formulas, and a simple chart, pivot table, possibly a list. Do not expect macros, advanced filter, external data sources - although I could be wrong.
Definitely know if you'll be tested on XL2003 or XL2007
Code:Format Cells - Number Formats, Date Formats, Alignment, Merge and Center, Borders/Underline Sum, Average, Count, Round, IF, LEFT, RIGHT, MID, MATCH, VLOOKUP Hide Columns, Rows Tab Name, Color Copy a Sheet Share workbook Protect Sheet Name a cell Subtotal Validate an entry (must be number, must be date) Sort Filter Split a window or freeze a pane Page Setup - headers, footers, Rows to Repeat at Top/Left Print Area, Page Breaks Create a Simple Chart Create a Simple Macro
Using: Office 2007/Win7 (work) Office 2010/Win7 (home)
You are rich in proportion to the number of things you can let alone.
-- Henry David Thoreau