Warning: Use of undefined constant style - assumed 'style' (this will throw an Error in a future version of PHP) in /home1/tayoswdg/public_html/sdnuggets/wp-content/themes/ThrillingTheme0/functions.php on line 522
668 views

[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

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 other list types e.g list of names etc.
In part 2 I demonstrate how to apply best practice worksheet design considerations in adding TOTALS  to 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.
The example workbook used to create this week’s video tutorial was also emailed to Excel Heaven Club members.

tut27th-august-2017


Warning: count(): Parameter must be an array or an object that implements Countable in /home1/tayoswdg/public_html/sdnuggets/wp-includes/class-wp-comment-query.php on line 399

Leave a Comment Here's Your Chance to Be Heard!

You must be logged in to post a comment.