{"id":12621,"date":"2017-08-28T00:22:05","date_gmt":"2017-08-28T00:22:05","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=12621"},"modified":"2017-08-28T00:22:23","modified_gmt":"2017-08-28T00:22:23","slug":"excel-heaven-video-part-7-using-in-cell-drop-down-menus-to-offer-users-access-to-name-lists-etc-how-to-use-best-practice-design-to-track-expense-totals","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/excel-heaven-video-part-7-using-in-cell-drop-down-menus-to-offer-users-access-to-name-lists-etc-how-to-use-best-practice-design-to-track-expense-totals\/","title":{"rendered":"[EXCEL HEAVEN VIDEO] Part 7 \u2013 Using In-Cell Drop Down Menus to Offer Users Access to Name Lists etc | How to Use Best Practice Design to Track Expense Totals"},"content":{"rendered":"<p><i>NB: See email (sent to club members) to download and watch the 2 part video tutorial for this week, which continues from that for last week.<\/i><\/p>\n<div>In Part 1 demonstrate how in-cell drop down menus, like those created last week, for safely choosing dates from a list, can be used to offer users access to other list types e.g list of names etc.<\/div>\n<div><\/div>\n<div>In part 2 I demonstrate how to apply best practice worksheet design considerations in adding TOTALS \u00a0to columns in the expense section of the Imprest cashbook. This is done in a way that enables the user quickly, easily and conveniently reconcile the changing totals for each columnwith those in the paper source (e.g ledger) as s\/he posts the data into the cells.<\/div>\n<div><\/div>\n<div>The example workbook used to create this week's video tutorial was also emailed to Excel Heaven Club members.<\/div>\n<div><\/div>\n<div><\/div>\n<div><a href=\"http:\/\/tayosolagbade.com\/contact.htm\" target=\"_blank\">Click here to request a copy of the video and\/or workbook...<\/a><\/div>\n<p><a href=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/08\/tut27th-August-2017.png\" rel=\"attachment wp-att-12622\"><img decoding=\"async\" class=\"alignnone size-full wp-image-12622\" src=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/08\/tut27th-August-2017.png\" alt=\"tut27th-august-2017\" width=\"580\" srcset=\"http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/08\/tut27th-August-2017.png 1280w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/08\/tut27th-August-2017-300x188.png 300w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/08\/tut27th-August-2017-768x480.png 768w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/08\/tut27th-August-2017-1024x640.png 1024w, http:\/\/tayosolagbade.com\/sdnuggets\/wp-content\/uploads\/2017\/08\/tut27th-August-2017-150x94.png 150w\" sizes=\"(max-width: 1280px) 100vw, 1280px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>NB: See email (sent to club members) to download and watch the 2 part video tutorial for this week, which continues from that for last week. In Part 1 demonstrate how in-cell drop down menus, like those created last week, for safely choosing dates from a list, can be used to offer users access to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,1375,266,1440],"tags":[3074,3094,3093],"class_list":["post-12621","post","type-post","status-publish","format-standard","hentry","category-employeescareer-persons","category-excel-vb-solutions","category-my-dn-travel-news","category-recommended-websites-articles","tag-excel-heaven-video","tag-how-to-use-best-practice-design-to-track-expense-totals","tag-part-7-using-in-cell-drop-down-menus-to-offer-users-access-to-name-lists-etc"],"aioseo_notices":[],"views":896,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/comments?post=12621"}],"version-history":[{"count":3,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12621\/revisions"}],"predecessor-version":[{"id":12625,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/12621\/revisions\/12625"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=12621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=12621"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=12621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}