Hey there! Sign in to join this conversationNew here? Join for free
    • Thread Starter
    Offline

    2
    ReputationRep:
    I have been teaching myself Excel and would like to know if anyone has suggestions on what I can learn?
    I have already gone over ifs, vlookups, pivot tables, a bit of VBA, match+index, cell referencing, creating invoices, budget sheets. Are there any more useful things to know? Hopefully I will have gone through everything over time but I just want to learn the important things first.
    Offline

    12
    ReputationRep:
    Functions might be good.
    Offline

    0
    ReputationRep:
    (Original post by loloway)
    I have been teaching myself Excel and would like to know if anyone has suggestions on what I can learn?
    I have already gone over ifs, vlookups, pivot tables, a bit of VBA, match+index, cell referencing, creating invoices, budget sheets. Are there any more useful things to know? Hopefully I will have gone through everything over time but I just want to learn the important things first.
    Tables (Excel 2010 onwards) I think are useful. Others would include - conditional formatting, number formatting, charts and graphs, SUMIFS/SUMPRODUCT, concatenating and splitting out data, sorting and filtering data, protecting stuff (either the whole workbook or worksheet/s or even a cell or a group of cells).
    Offline

    5
    ReputationRep:
    Iferror is good for vlookups and representing numbers.

    keyboard shortcuts are an absolute must. I have a work tutorial if you want me to send it to you that captures a load of excel tips and tricks ranging from beginner to expert.


    Posted from TSR Mobile
    • Thread Starter
    Offline

    2
    ReputationRep:
    (Original post by Pipsico)
    Iferror is good for vlookups and representing numbers.

    keyboard shortcuts are an absolute must. I have a work tutorial if you want me to send it to you that captures a load of excel tips and tricks ranging from beginner to expert.


    Posted from TSR Mobile
    Yes please. That would be great!
    Offline

    1
    ReputationRep:
    (Original post by Pipsico)
    Iferror is good for vlookups and representing numbers.

    keyboard shortcuts are an absolute must. I have a work tutorial if you want me to send it to you that captures a load of excel tips and tricks ranging from beginner to expert.


    Posted from TSR Mobile
    Could I get a copy of this too please?
    Offline

    5
    ReputationRep:
    (Original post by Elasticity)
    Could I get a copy of this too please?
    (Original post by loloway)
    Yes please. That would be great!
    Sure, pm me your email addresses and I'll make sure to send it when I get to work tomorrow.


    Posted from TSR Mobile
 
 
 
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • Poll
    Did TEF Bronze Award affect your UCAS choices?
    Useful resources

    Articles:

    Guide to finance and bankingGuide to accountancy

    Featured recruiter profiles:

    Deutsche Bank logo

    Deutsche Bank is recruiting

    "Thrive in an international banking environment"

    ICAEW logo

    ICAEW

    "Choose a career journey with limitless possibilities."

    Quick link:

    Unanswered finance and accountancy threads

    Groups associated with this forum:

    View associated groups
  • See more of what you like on The Student Room

    You can personalise what you see on TSR. Tell us a little about yourself to get started.

  • The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

    Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

    Quick reply
    Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.