Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Excel test - top 3 things to study ?

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 ...

  1. #1
    New Member
    Join Date
    Nov 2008
    Posts
    0

    Default Excel test - top 3 things to study ?

    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 job interview with an excel test. What would you consider to be the top 3 things to study/review? Pivot tables? Macros?

    thanks..

  2. #2
    Board Regular texasalynn's Avatar
    Join Date
    May 2002
    Location
    Houston, TX
    Posts
    8,316

    Default Re: Excel test - top 3 things to study ?

    welcome to the board and good luck

    formulas
    pivot tables

  3. #3
    Board Regular teylyn's Avatar
    Join Date
    Sep 2008
    Location
    New Zealand
    Posts
    296

    Default Re: Excel test - top 3 things to study ?

    Hi,

    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.

    good luck

    teylyn

  4. #4
    Board Regular
    Join Date
    Feb 2007
    Location
    England
    Posts
    3,248

    Default Re: Excel test - top 3 things to study ?

    Ditto texasalynn's pleasantries, islandguy11.

    Specifically, in terms of formulas, I would get familiar with:

    Lookup formulas
    If formulas
    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:

    http://www.xlfdic.com/

    Though the site is down for the moment for some reason...

    Good luck with the interview.

    Matty

  5. #5
    Board Regular Blade Hunter's Avatar
    Join Date
    Mar 2008
    Location
    Sydney, Australia
    Posts
    3,004

    Default Re: Excel test - top 3 things to study ?

    With regards to finance, I would say the VLOOKUP is one of the most useful formulas too.
    .select, overused and inefficient.

  6. #6
    MrExcel MVP
    Moderator
    Smitty's Avatar
    Join Date
    May 2003
    Location
    Crested Butte, CO
    Posts
    27,393

    Default Re: Excel test - top 3 things to study ?

    Welcome to the Board!

    Have you asked how in-depth the test will be and if it's targeted toward any specific competency?
    Smitty

    Every once in a while, there's a sudden gust of gravity...

    Check out my new book at the Mr. Excel Bookstore!

    Mr. Excel HTML Maker - Post a shot of your sheet

  7. #7
    New Member
    Join Date
    Nov 2008
    Posts
    0

    Default Re: Excel test - top 3 things to study ?

    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.

  8. #8
    MrExcel MVP
    Moderator
    Rediscovering the love
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,678

    Default Re: Excel test - top 3 things to study ?

    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!).
    Richard Schollar

    Using xl2013

  9. #9
    Board Regular Blade Hunter's Avatar
    Join Date
    Mar 2008
    Location
    Sydney, Australia
    Posts
    3,004

    Default Re: Excel test - top 3 things to study ?

    Quote Originally Posted by islandguy11 View Post
    i did some vba programming in the past, but it was quite some time ago and have not used it in daily work.
    If you were to say that to me in an interview, I would take it as a plus, it shows you can pick it up if you need to but are a little rusty.
    .select, overused and inefficient.

  10. #10
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,168

    Default Re: Excel test - top 3 things to study ?

    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

Page 1 of 2 12 LastLast

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com