BSHS 375 Week 4 Database Creating a Pivot chart ( New ) For more course tutorials visit www . uophelp . com
www . uophelp . com
Resources : Database Template , Spreadsheet Guide on Excel ®, and Lynda . com ® Tutorials Complete the Encounters worksheet in the Database Template you started in Week 2 .
· Enter five encounters for three of the clients you entered in the Demographics worksheet in Week 2 . The client ' s name in the Encounters worksheet should be linked to the client ' s name on the Demographics worksheet .
· The formula in column G should reflect the number of hours of service times the fee per hour .
· The number in column H is up to you . Add a dollar amount that each client paid . The dollar amount paid in this column should be unique to each client .
· The formula in column I should reflect the amount due minus the amount paid . Once you have correctly entered the formulas for columns G and I in row 2 , copy and pastethe formulas down both the entire columns so that all rows in these two columns contain the formulas . Save your work . ================================================
BSHS 375 Week 4 Database Creating a Pivot chart ( New ) For more course tutorials visit www . uophelp . com