EXCEL HEAVEN VIDEO

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

September 4, 2017

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!] Email sent to […]

[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

August 28, 2017

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 […]

[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]

August 21, 2017

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 […]

Facebook