+ Reply to Thread
Results 1 to 5 of 5

what are a few of the most useful functions in Excel? How do you use them?

  1. #1
    Registered User
    Join Date
    08-07-2018
    Location
    United States
    MS-Off Ver
    2010
    Posts
    2

    what are a few of the most useful functions in Excel? How do you use them?

    This is a tricky question, because it asks you to use your subjective judgement rather than answering objectively. As such, you'll have a wide range of latitude in your response and you should have a well thought-out reply prepared that demonstrates both your proficiency with Excel and your wide range of past experience using spreadsheets.

    Here are a couple of our top recommendations for features, formulas, and functions to discuss:

    INDEX MATCH
    . VLOOKUP and INDEX MATCH are two of Excel's most important and commonly-used functions. As veteran Excel users know, they're used to look up values from an external table, and are important parts of automating your work with dynamic spreadsheets. One of the two is bound to come up in any Excel interview, but if you get this question, we recommend bringing up INDEX MATCH. It's a slightly more useful function, and also lacks many of the disadvantages of VLOOKUP, like the inability to insert new rows and columns into your sheets. If you go with this function, outline how you've used it in the past to dynamically lookup values and populate columns of data that would otherwise need to be manually copied and pasted.

    IF statements. IF statements are another staple of any Excel veteran's arsenal. Bring them up to let your interviewer know that you've created advanced spreadsheets that make decisions based on criteria calculated in real-time.

    PivotTables. PivotTables are an extraordinarily useful tool, and if you're applying for a job that requires intermediate or advanced Excel knowledge, they're sure to be an important criteria used by your interviewer. You may have used PivotTables for any number of things in the past, but be sure to emphasize how useful they are when quick, accurate calculations are necessary based on large sets of data with hundreds or thousands of rows.
    Last edited by gracylayla; 09-20-2018 at 05:39 AM. Reason: add some more info

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2010, 2016
    Posts
    6,383

    Re: what are a few of the most useful functions in Excel? How do you use them?

    Why have you posted this to:
    Excel Programming / VBA / Macros sub-forum
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    10-30-2018
    Location
    Ramat Gan, Israel
    MS-Off Ver
    Office 365
    Posts
    8

    Re: what are a few of the most useful functions in Excel? How do you use them?

    This is a great one.
    Thanks a lot!

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    45,550

    Re: what are a few of the most useful functions in Excel? How do you use them?

    gracylayla , this sounds very much like a homework assignment?

    Rakel, what is the purpose of your post? I see nothing that could be considered "a great one"?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.

  5. #5
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2010, 2016
    Posts
    6,383

    Re: what are a few of the most useful functions in Excel? How do you use them?

    @Ford: I expect it is a kind of showing appreciation by Rakel - see her other post here: https://www.excelforum.com/tips-and-...ml#post5001314

    @Rakel: It is not standard way on this forum. You'd better use "Rate this thread" tool - the link is above first post of the thread (see screenshot). Also above first post you'll find Thread Tools - you may subscribe to the thread (not only to receive updates on new posts in the thread, but also to easily find it if you want to return to it in the future).

    Best,

    Kaper
    Attached Images Attached Images  

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1