Tag Archives: EXCEL HEAVEN VIDEO

Excel-VB Solutions, My DN Travel News, Self-Development

[EXCEL HEAVEN VIDEO] Part 8 – How I Built My Automated Cash Book/Bank Reconciliation Software [Three Ways to Create In-Cell Drop Down Menus]

Leave a comment

This week, I demonstrate 2 other ways, in addition to the first method shown last week, you can use to Create In-Cell Drop Down Menus using the demo cash book.

[NB: This latest tutorial would have gone out yesterday, but for poor connectivity. I’ll just Keep On Keeping On, as they say lol!]

tut03rd-september-2017

Email sent to members of the Excel Heaven club, with the video and example workbook attached.

Click here to request download access.

 

Career Development, Excel-VB Solutions, My DN Travel News, Recommended Websites & Articles

[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

Leave a comment

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

Excel-VB Solutions, My DN Travel News, Self-Development

[EXCEL HEAVEN VIDEO] Part 6 – How I Built My Automated Cash Book/Bank Reconciliation Software” [Adding In-Cell Drop Down Menus for Users to Post Dates Without Errors Into the Automated Cash Book]

Leave a comment

This week, I once again have to battle with crazily erratic connectivity to get the latest tutorial out :-)

In the video sent to club members, I demonstrate the steps to follow in creating a list to be used in an in-cell drop down menu under the DATE column in the EXPENSE section of the IMPREST CASHBOOK in the automated cashbook I’m building.

Click here to request download access to the step by step screenshot video demonstration tutorial

tut20thaugust2017