Hey there! Sign in to join this conversationNew here? Join for free
x Turn on thread page Beta

Excel Report help watch

Announcements
    • Thread Starter
    Offline

    0
    ReputationRep:
    I am completing a Sample Assessment paper and I have successfully created a spreadsheet which includes names of books borrowed and when they are due back. My question now is: Use the database to create a report of the books that are overdue, as they would be due back on or before 01/04/2011.

    How do I create a report showing this?
    Thank you, Any help appreciated
    • Study Helper
    Offline

    16
    ReputationRep:
    Study Helper
    (Original post by katyxsmith)
    I am completing a Sample Assessment paper and I have successfully created a spreadsheet which includes names of books borrowed and when they are due back. My question now is: Use the database to create a report of the books that are overdue, as they would be due back on or before 01/04/2011.

    How do I create a report showing this?
    Thank you, Any help appreciated
    It depends what you mean by a 'report'.

    Obvious things that spring to mind are using:

    filtering to extract the rows where the due date is before the date you are given;

    advanced filtering to copy rows meeting the criterion to a separate location in the worksheet;

    conditional formatting to highlight rows where the criterion is met


    Are you familiar with techniques like this to highlight or extract data from a table in Excel?
    • Thread Starter
    Offline

    0
    ReputationRep:
    (Original post by davros)
    It depends what you mean by a 'report'.

    Obvious things that spring to mind are using:

    filtering to extract the rows where the due date is before the date you are given;

    advanced filtering to copy rows meeting the criterion to a separate location in the worksheet;

    conditional formatting to highlight rows where the criterion is met


    Are you familiar with techniques like this to highlight or extract data from a table in Excel?
    I do yes, thank you so much, I just couldn't understand the term 'report'. Thank you again
 
 
 
Reply
Submit reply
Turn on thread page Beta
Updated: November 13, 2015
Poll
Do you agree with the proposed ban on plastic straws and cotton buds?

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.