This week, I’ve chosen not to write much. Especially because what I want to share is better appreciated audio-visually. That’s why I’ve added 2 of the user demonstration videos for my Excel-VB driven apps to illustrate my point.
And what is the point? It is that when you’re a business user of Microsoft Excel, especially as an accountant, you will find it periodically necessary to build and interact with large spreadsheet tables with lots of columns and rows.
SCROLL DOWN TO READ FULL ISSUE
Tayo Solagbade’s
Performance Improvement IDEAS
(PI Squared) Newsletter
Monday 25th July 2016
NB: This PI Squared newsletter will be published weekly, on Mondays, in place of the Speaking/Web Marketing IDEAS newsletter, starting from today – 15th February 2016. I’m reinventing my Monday newsletter content and theme, to accommodate my vision of serving the growing audience of serious minded individuals and organizations reaching out to me, with information, education. news and research findings designed to help them do what they do better.
**********
PII 024: Use Custom Modeless Floating Data Entry Forms to Effortlessly Post Unlimited Entries into Large Spreadsheets Without Stress (Video Demonstration from Real Life Apps)
This week, I’ve chosen not to write much. Especially because what I want to share is better appreciated audio-visually. That’s why I’ve added 2 of the user demonstration videos for my Excel-VB driven apps to illustrate my point.
And what is the point? It is that when you’re a business user of Microsoft Excel, especially as an accountant, you will find it periodically necessary to build and interact with large spreadsheet tables with lots of columns and rows.
Doing so will necessarily involve scrolling in different directions for long periods and that can sometimes get both confusing and tiring. It can also be quite hard to find specific data you’ve entered after some time.
In thc course of building bullet proof custom automated Excel-VB driven apps for clients, I discovered that some of them did not want to learn to do what I did. They just wanted me to do it all for them. And they were often prepared to pay to get an app that was novice-proof.
In order to deliver that kind of benefit to them, I had to come up with creative ways to enable them do their work using my apps. The result was that I began using modeless data entry forms, customized to do what the client wanted.
That included auto-scrolling to select specific cells in huge spreadsheets containing over 50,000 records, with over 100 columns of data.
They loved me for it. and told others about me as a result. In this edition I invite you to watch the videos below, and listen as I explain how my custom floating data entry and report generation forms work in the apps featured below.
If you’d like to know how I can help you incorporate such smart form automation into your existing workbooks, click here to send me a message.
1. Excel-VB Poultry Generating The Dynamic Farm Operations Reports & Key Performance Indicator (KPI) Charts for Layers and Broilers – Daily/Weekly/Monthly
2. Advanced Payslip Generator DEMO 1 : Modeless Data Entry Form MS Excel-VB Driven Version (2012)
SDN Blog™
New posts from last week*
Monday:
[Tuesday]:
[Wednesday]:
[Thursday]:
[Friday]:
N/A
[Saturday]:
[Tutorial 01 – ExcelVB Coding Tips & Tricks for Accountants: How to Enable Macros in different versions of MS Excel I.e 2003, 2007, 2010 and 2013!]
[Sunday]:
THE FARM CEO (Issue 55): On-farm biosecurity as perceived by professionals visiting Swedish farms, Protecting produce: Ten African countries get biosecurity investment, Australia and Africa to work together on plant biosecurity
|
Tayo K. Solagbade* Self-Development/Performance Improvement Specialist *Best Practice Farm Business Support Specialist & Founder of the MS Excel Heaven Visual Basic Automation Club and Competition Mobile: +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin Republic) Tayo K. Solagbade is a Location Independent Performance Improvement Specialist and Multipreneur (i.e. a highly versatile/multi-skilled entrepreneur), with a bias for delivering Best Practice solutions to Farm Businesses and others. Since 2002, he has earned multiple streams of income providing individuals and organizations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems/web hosting, freelance writing services, and best practice extension support services (for farm business owners). Tayo is the author of the Self-Development (SD) Bible™ and the popular Livestock Feed Formulation Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator™ and the Poultry Farm Manager™ software. He has delivered talks/papers to audiences in various groups and organizations, including the Centre for Management Development, University of Lagos, Christ Baptist Church, Volunteer Corps, Tantalisers Fast Foods and others. In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development’s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos. On 1st April 2013, Tayo (who reads, write and speaks the French language) relocated to Cotonou, Benin Republic to begin slowly traveling across the West African region. His key purpose is to deliver talks, seminars and workshops on his key areas of focus and interest to interested audiences (Email tayo at tksola dot com for details). In a previous life, before leaving to become self-employed, Tayo served for seven years (October 1994 to December 2001) as a high performing manager in Guinness Nigeria. He rose from Shift Brewer to Training & Technical Development Manager, and later acted in senior roles as Production Manager and Technical Manager. In addition to constantly challenging the status quo and influencing positive work changes, he built a reputation for using self-taught spreadsheet programming skills (starting with Lotus 1-2-3, and later moving to Excel Visual Basic) – in his spare time – to develop Automated Spreadsheet Applications to computerize manual report generation processes in the departments he worked. Over four(4) of his applications were adopted for brewery level reporting. Tayo holds a B.Sc degree in Agricultural Extension Services from the University of Ibadan, Nigeria, having graduated top of his class – with Second Class Upper Division honors – in 1992. He is an Associate Member of the UK Institute & Guild of Brewing, a 1997 National Finalist of the Nigerian Institute of Management’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc). When he’s not amazing clients with his superhuman skills (wink), Tayo works as the creative force behind his Daily Self-Development Nuggets blog – on which he also publishes The Farm CEO Weekly Newspaper (sent via email to paid subscribers) and his Weekly Performance Improvement IDEAS newsletter. You can connect with him on Twitter @tksola.com and Facebook. Visit Tayo Solagbade Dot Com, to download over over 10 performance improvement resources to boost your personal and work related productivity. ====
|
You’re reading PII 024: Use Custom Modeless Floating Data Entry Forms to Effortlessly Post Unlimited Entries into Large Spreadsheets Without Stress (Video Demonstration from Real Life Apps) by Tayo Solagbade, originally posted on his Daily Self-Development (SD) Nuggets™ blog. If you loved reading this post, be sure to follow Tayo on Twitter, Facebook, and Google+.
You may also wish to check out his growing library of tutorial and demonstration videos on Youtube. Click here, to download over 10 resources to boost your personal and work related productivity.
IMPORTANT NOTE:
On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), was taken over by Aplus.net. Within a few days however, Tayo used his advanced self-taught web development skills to build (and move his website contents into) a SUPERIOR “reincarnation” at http://www.tayosolagbade.com.
Most URLs bearing the old domain name appearing in search engines should now work if “spontaneousdevelopment.com” is replaced with “tayosolagbade.com”. If you experience any difficulties finding a page or document, email Tayo at tksola dot com.
Click “Tayo, What Happened to SpontaneousDevelopmentDotCom?” to read a detailed narrative about how the above event occurred :-))
Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:
Succeed by Emerging from Adversity Like a Phoenix (TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)
And he wrote the one below, to explain why losing a domain name, no matter how old NO LONGER determines your online success or otherwise:
A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
Source: ExcelVB
