Turn on thread page Beta
    • Thread Starter
    Offline

    0
    ReputationRep:
    Hey
    I would like to know what complex functions or features i could add into my spreadsheet to get an A grade. I am using Excel 2003.
    For instance i have used Macros. My spreadsheet is about teams and there scores. Anyone got any ideas on how i could improve my spreadsheet? Any help would be greatful.
    Thanks
    Offline

    1
    ReputationRep:
    Is this for GCSE or AS level? I'll tell you what you need for AS level seen as though thats what I'm doing. To get good marks you must do all of these things:
    validation
    cell naming
    conditional formating
    and a selection of these:
    hlookup
    vlookup
    pivot table
    nested IF statements (IF's withing IF's)
    Buttons
    macros
    auto_open and auto_close (code/macro)
    Hope this help. If you don't know what any of these functions do just do a search in google or something.

    Adam
 
 
 
Poll
Favourite type of bread

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

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