pivot tables and vlookups et al in Excel

Discussion in 'General Chat' started by sheriffwoody, Aug 31, 2012.

  1. sheriffwoody

    sheriffwoody
    Well-known Member

    Joined:
    Oct 7, 2010
    Messages:
    7,440
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    136
    Ratings:
    +1,526
    Bonjour,

    I need to brush up on my Excel skills and need to know the basics of (at least) Pivot tables and VLookups/WhatIfs etc.

    Are there any sites that you guys and girls have used before to aid you?

    I know google is my friend, but you get soo many different pages, most of them full of waffle.

    I just need to know what they do and how best to recreate them, ideally with some test data I can use.
     
  2. Mr_Wistles

    Mr_Wistles
    Distinguished Member

    Joined:
    Mar 11, 2004
    Messages:
    12,109
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    Essex
    Ratings:
    +3,035
    Go on youtube.

    Search how to do xyz. This is how my wife learnt and I filled in the gaps.
     
  3. Stuey1

    Stuey1
    Well-known Member

    Joined:
    Aug 14, 2009
    Messages:
    4,080
    Products Owned:
    1
    Products Wanted:
    0
    Trophy Points:
    136
    Location:
    Texas
    Ratings:
    +1,131
    There are a few forum that I have used in the past, the only ones I can remember enough to link to are:

    Free Excel\VBA Help Forum

    Ron's Excel Tips

    They could be more related to VBA, but can't really remember, hope this helps :smashin:
     
  4. michaelro

    michaelro
    Well-known Member

    Joined:
    Dec 15, 2008
    Messages:
    1,824
    Products Owned:
    0
    Products Wanted:
    0
    Trophy Points:
    83
    Ratings:
    +436
  5. Mr Incredible

    Mr Incredible
    Distinguished Member

    Joined:
    Dec 2, 2003
    Messages:
    23,879
    Products Owned:
    2
    Products Wanted:
    0
    Trophy Points:
    166
    Location:
    The Fylde Coast
    Ratings:
    +13,514
    +1 for MrExcel.com
     

Share This Page

Loading...
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice