Resources: Database Template, Spreadsheet Guide on Excel\u00ae,\u00a0and Lynda.com\u00ae\u00a0Tutorials\tComplete\u00a0the Encounters worksheet in the Database Template you started in Week 2.\t\u00b7\u00a0 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.\u00a0\t\u00b7\u00a0 The formula in column\u00a0G\u00a0should reflect the number of hours of service times the fee per hour.\u00a0\t\u00b7\u00a0 The number in column\u00a0H\u00a0is up to you. Add a dollar amount that each client paid. The dollar amount paid in this column should be unique to each client.\t\u00b7\u00a0 The formula in column\u00a0I\u00a0should reflect the amount due minus the amount paid.\tOnce you have correctly entered the formulas for columns\u00a0G\u00a0and\u00a0I\u00a0in row 2,\u00a0copy\u00a0and\u00a0pastethe formulas down both the entire columns so that all rows in these two columns contain the formulas.\tSave\u00a0your work.<\/p>\n","protected":false},"excerpt":{"rendered":"
Resources: Database Template, Spreadsheet Guide on Excel\u00ae,\u00a0and Lynda.com\u00ae\u00a0Tutorials Complete\u00a0the Encounters worksheet in the Database Template you started in Week 2. \u00b7\u00a0 Enter five encounters for three of the clients you entered in the Demographics worksheet in Week 2. The client’s Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-203757","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203757","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=203757"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/203757\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=203757"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=203757"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=203757"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}