Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jul 2002
    Location
    melbourne, Victoria, Australia
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Advance functions (Excel 2003)

    Can anyone help me, Please? I am in urgent need for information regarding excel advance functions eg. index, vlookup, nesting functions scenarios, consolidation. Can anyone suggest some tutorial sites? I need information about how to and when to use these functions.

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Advance functions (Excel 2003)

    Hi there

    Try www.cpearson.com a brilliant site often referred to on this site.
    Jerry

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Advance functions (Excel 2003)

    In the long term, you might invest in a reference book. See for example Excel Books by John Walkenbach, they are generally very good.

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Advance functions (Excel 2003)

    I have an Excel file (created by Peter Noneley) that I found on the web years ago that has examples of most functions and how to use them in Excel. It is a great resouce and is quite handy. I would post the file to the Lounge but there is a file restriction of 100k. The zipped file size is 285k.

    If you provide me an e-mail account, I will be happy to send you the file.

    Regards,
    John

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Advance functions (Excel 2003)

    I believe this is the link to Peter's Page http://www.xlfdic.com/
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

Posting Permissions

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