{"id":9224,"date":"2016-03-14T19:41:47","date_gmt":"2016-03-14T19:41:47","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=9224"},"modified":"2016-03-15T00:00:58","modified_gmt":"2016-03-15T00:00:58","slug":"pii-005-you-need-excel-vb-coding-skills-to-make-and-save-money-attend-tayo-solagbades-free-4-hour-practical-introduction-to-ms-excel-vb-automation-workshop","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/pii-005-you-need-excel-vb-coding-skills-to-make-and-save-money-attend-tayo-solagbades-free-4-hour-practical-introduction-to-ms-excel-vb-automation-workshop\/","title":{"rendered":"PII 005: You Need Excel-VB Coding Skills to MAKE and SAVE Money [Attend Tayo Solagbade\u2019s FREE 4 Hour \"Practical Introduction to MS Excel-VB Automation\" Workshop]"},"content":{"rendered":"

I have been paid as much as N200, 000 (Two Hundred Thousand Naira) - proof available<\/strong><\/em> - to build a single Excel-VB driven spreadsheet application<\/a>. That same company \u2013 a large hospital with over 120 staff - went on to hire me in the course of the year that followed, to build two other apps (a Payslip Generator, and a Cash Office Payments Manager - designed for checking a patient\u2019s payment status).<\/p>\n

Late last year I stopped over at the hospital (for the first time in 3 years) when I came in from Cotonou, and they were still using 2 of the 3 apps: Since 2008 i.e. 8 years ago! <\/strong>That, more than anything else, is proof that those 2 apps continue to meet the company's needs!<\/p>\n

SCROLL DOWN TO READ FULL ISSUE<\/strong><\/p>\n

\u00a0<\/p>\n

\u00a0<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

\"Tayo<\/a><\/h1>\n

Tayo Solagbade's<\/a>
\nPerformance Improvement <\/span> IDEAS
\n(PI Squared) Newsletter <\/strong><\/span><\/h1>\n

\"Logo<\/a><\/p>\n


\nNB: <\/strong>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.<\/strong><\/em> 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.<\/p>\n

****<\/strong><\/em>******<\/strong><\/p>\n

\"View<\/span><\/a>\"Join<\/a>\"Connect<\/a>\"Connect<\/a><\/span>\"Connect<\/a><\/p>\n

PII 005:<\/span> You Need Excel-VB Coding Skills to MAKE and SAVE Money [Attend Tayo Solagbade\u2019s FREE 4 Hour \"Practical Introduction to MS Excel-VB Automation<\/span>\" Workshop]<\/h1>\n<\/td>\n<\/tr>\n

\n

I have been paid as much as N200, 000 (Two Hundred Thousand Naira) - proof available<\/strong><\/em> - to build a single Excel-VB driven spreadsheet application<\/a>. That same company \u2013 a large hospital with over 120 staff - went on to hire me in the course of the year that followed, to build two other apps (a Payslip Generator, and a Cash Office Payments Manager - designed for checking a patient\u2019s payment status).<\/p>\n

Late last year I stopped over at the hospital (for the first time in 3 years) when I came in from Cotonou, and they were still using 2 of the 3 apps: Since 2008 i.e. 8 years ago! <\/strong>That, more than anything else, is proof that those 2 apps continue to meet the company's needs!<\/p>\n

And all of that happened in Nigeria, NOT in the USA.<\/h3>\n

Now, I should point out that only a few of my apps have been for financial reporting or accounts. In my part of the world, too many people readily assume Excel is for accounts. WRONG!<\/p>\n

Hotels\/Restaurants and bars, Construction Engineers\/Quantity Surveyors, Database consultants, Health and Fitness Clubs, Medical Hospitals\/Clinics, Manufacturing companies, Farm Businesses are just a few that have hired me.<\/p>\n

Most wanted their apps to capture routine OPERATIONS data handling and report summaries auto-generation. The decision makers in the organizations signed cheques to pay me, AFTER I showed them what was possible with my demos. I rarely had anything ready to use.<\/em><\/p>\n

Instead they had often been using MS Excel manually, for routine reporting in formats unique to their businesses. They had tried using conventional off-the-shelf apps, but the peculiarities of their unique needs made it too difficult to customize them enough.<\/p>\n

What's more, the steep learning curve and the need to retrain as staff left made using such conventional off-the-shelf software unattractive for some individuals\/businesses.<\/p>\n

In one client's accounts department, I was shown over 100 Excel workbook reports they had generated weekly, for well over a year. But it had become cumbersome generating monthly, quarterly and annual summaries, using the weekly reports.<\/h3>\n

So, when the accounts manager learnt I could create an app that would have a SINGLE report interface that would use drop menus to enable dynamic generation of the reports weekly, monthly and annually, he instantly bought the idea<\/p>\n

For him the savings in time and effort were worth the required investment of money.<\/p>\n

If you have routine and repetitive data recording, analysis and report preparation tasks you do manually or using Excel, adopting Excel-VBA Automation can help you GREATLY.<\/h3>\n

2 options exist: Either identify a competent Excel-VBA resource INSIDE your organization or hire one from outside to do it for you.<\/em><\/p>\n

Unless your in-house expert is really good, and has enough exposure and experience, it's always wise to hire an external resource, so your in-house personnel can learn from him\/her.<\/p>\n

That way, they will be equipped to subsequently maintain or modify\/improve whatever application is developed for your company - saving you money that would otherwise be expended in calling in the external resource in future.<\/p>\n

According to Pierre Le Clerc, an Excel-VB Solutions Developer whose work has influenced me greatly, Excel is the best reporting application on the market.<\/p>\n

I agree. And I have found evidence of it in many forms - including the earlier mentioned fact that many business users, professionals in various fields, make serious use of it for their routine data recording, analysis and report generation.<\/p>\n

Data handling - in virtually any form, for virtually any purpose, can be productively subjected to analysis for decision making, using MS Excel - IF the user possesses the required know-how or competence.<\/h3>\n

But there is a only so much you will be able to do with MS Excel, if you do NOT know how to automate the routine and repetitive aspects of whatever it is you do with it.<\/p>\n

It does not matter how many functions you know or how good you are at designing and formatting data entry tables, reporting interfaces etc.<\/p>\n

You will eventually get a to a point where integrating intelligent Excel-VB driven automation into your usage of your MS Excel workbooks will dramatically boost your productivity in terms of time, effort and even money you expend.<\/p>\n

I say this as one who virtually single-handedly transformed the manual reporting systems in different departments I worked in a corporate multinational manufacturer<\/a>, over a 7 year period, in my spare time as a brewer\/manager, using my self-taught spreadsheet programming skills.<\/h3>\n

I began with Lotus 1-2-3 macro programming before moving to MS Excel-Visual basic coding (when the company migrated to MS Office from Lotus Smart Suite).<\/p>\n

But what I knew while in paid employment pales in comparison to what I've since moved on to doing for clients within and outside Africa, as an entrepreneur. I have developed a wide range of customizable applications for individuals and businesses in various industries.<\/p>\n

Examples include hospitals, hotels, restaurants\/bars, medical clinics, pure (sachet water) factories, business centres, health and fitness clubs, churches, farm businesses (e.g. Ration Formulator<\/a>, Poultry Farm Manager<\/a>) and others.<\/em><\/p>\n

The fact that I continue to make sales to buyers locally and internationally - over a decade after I started this journey confirms that this solution is relevant to the FELT needs of the target market I serve.<\/h3>\n

In addition, the increasing interest being shown by independent consultants, and career persons in joining my Excel VB club<\/a>, to access my home study tutorial videos and other resource, is proof that MORE people are waking up to the realization that they NEED Excel-VB programming skills to take their productivity to the next level.<\/p>\n

This is why I've invited current members of my Excel-VB club<\/a> to attend the first run of what is to be a monthly FREE 4 Hour Workshop to be conducted by me. It will be holding on 19th March 2016 here in Lagos - Nigeria. The venue will be agreed with my club members, if they choose to invite me over to their preferred location or they will meet with me at the usual venue I use in Lagos.<\/p>\n

In case this event interests you, or you'd like to get a copy of my branded auto run DVD (containing home study video tutorials I will be giving to them), read the details on the post below:<\/p>\n

Attend Tayo Solagbade\u2019s FREE 4 Hour Practical Introduction to MS Excel-VB Automation Workshop [Get Home Study DVD Video: How to build an automated Cash Book with Bank Reconciliation table, Debtors\/Creditors Schedule etc]<\/a><\/h3>\n

\"Attend<\/a><\/p>\n

\u00a0<\/td>\n<\/tr>\n

\n

<\/a>SDN Blog<\/strong>\u2122<\/p>\n<\/td>\n

New posts from last week* <\/span><\/td>\n<\/tr>\n
Monday<\/span>:<\/strong><\/span><\/td>\n\n
\n

PII 004: Get YOUR FREE Copy of Tayo Solagbade\u2019s Quick & Dirty Guide to English Language for French Speakers<\/a><\/h2>\n

\u00a0WARNING: This Workbook<\/span> based guide is NOT a standard language learning resource. I\u2019ve called it a quick and dirty guide because that\u2019s what it is. This workbook assumes you\u2019re willing to spend time sitting behind your PC (and also on your mobile) listening to audiios corresponding to clickable words and phrases, (and pictures that appear [\u2026]<\/p>\n

\n<\/div>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

[Tuesday]<\/span>:<\/strong><\/p>\n<\/td>\n

\n
\n

Developing Positive Income Earning Competence In Nigeria Is The Key to Eliminating Corruption Amongst Nigerians [Case Study: Aljazeera \u201cAfrica Investigates\u201d video report titled \u201cNigeria\u2019s Baby Farmers\u201d]<\/a><\/h2>\n

If you have not yet watched the Aljazeera \u201cAfrica Investigates\u201d video<\/span> report titled \u201cNigeria\u2019s Baby Farmers\u201d, starring Ghana\u2019s famous under cover journalist \u2013 Anas \u2013 and Rosemary an investigative journalist from Nigeria, then click here to watch<\/span> it now. The revelations of the sickening yet vibrant trade in babies, actively engaged in by hospitals and [\u2026]<\/p>\n

\n<\/div>\n<\/td>\n

<\/td>\n<\/tr>\n
[Wednesday<\/span>]: <\/strong><\/span><\/td>\n\n
\n

The Need to Conquer Our Fears to Live in Harmony With Nature\u2019s Gifts [True Story With Photos: The Scared Stray Kitten I Rescued 5 Years Ago Is Now A Mother of Two Lovely Kittens!]<\/a><\/h2>\n

In certain societies<\/span>, people live in harmony with snakes, and even worship them. In others the mere sight of a baby snake will have everyone taking to their heels. It\u2019s a simple question of familiarity. A child that\u2019s never seen (or been near) a dog before, could get scared, and even burst into tears when [\u2026]<\/p>\n

\n<\/div>\n<\/td>\n

<\/td>\n<\/tr>\n
[Thursday<\/span>]: <\/strong><\/span><\/td>\n\n
\n

FREE Talk for Farm CEOs About Best Practice Ways to Avoid Disease Outbreaks & Generate EXTRA Income to Cushion Income Loss!<\/a><\/h2>\n

I continue to write formal FREE talk offers for consideration by farmer groups and organizations. This is in line with what I\u2019ve identified as the need to inform and educate farm CEOs on how to: (a) adopt best practice bio-security measures against disease outbreaks and (b) generate complementary\/additional income streams to boost their earnings\/cushion the [\u2026]<\/p>\n

<\/div>\n<\/div>\n<\/td>\n

<\/td>\n<\/tr>\n
[Friday<\/span>]: <\/strong><\/span><\/td>\n\n
N\/A<\/div>\n<\/td>\n
<\/td>\n<\/tr>\n
[Saturday<\/span>]: <\/strong><\/td>\n\n<\/td>\n<\/tr>\n
\n\n\n\n\n
<\/td>\n<\/tr>\n
\n

<\/h3>\n

\"\"<\/a><\/p>\n

Tayo K. Solagbade*<\/span><\/span><\/p>\n

Self-Development\/Performance Improvement Specialist<\/strong><\/p>\n

*Creator of the Mastering Adversity for Perpetual Success Achievement Coaching Program<\/em> <\/span><\/p>\n

Mobile:<\/strong> +234-803-302-1263 (in Nigeria<\/strong>) or +229-66-122-136 (in Benin Republic<\/strong>)<\/p>\n

http:\/<\/a><\/span>\/www.tayosolagbade.com<\/a><\/p>\n

Tayo K. Solagbade<\/a> is a Location Independent Performance Improvement <\/b><\/p>\n

Specialist and Multipreneur (i.e. a highly versatile\/multi-skilled entrepreneur), with a bias for delivering Best Practice solutions to<\/p>\n

Farm Businesses and others.<\/p>\n

Since 2002, he has earned multiple streams of income providing individuals and organizations with personal development training and coaching, custom MS Excel-VB solutions<\/a>, web marketing<\/a> systems\/web hosting<\/a>,<\/p>\n

freelance writing services, and best practice extension support services (for farm business owners<\/a>).<\/p>\n

Tayo is the author of the Self-Development (SD) Bible\u2122<\/a> and the<\/p>\n

popular Livestock Feed Formulation<\/a> Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator\u2122<\/a> and the Poultry Farm <\/a><\/p>\n

Manager\u2122 software.<\/p>\n

He has delivered talks\/papers to audiences in <\/a><\/p>\n

various groups and organizations, including the Centre for Management Development, University of Lagos, Christ Baptist Church, Volunteer Corps, Tantalisers Fast Foods<\/p>\n

and others.<\/p>\n

In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development\u2019s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos.<\/p>\n

On 1st April 2013, Tayo (who reads, write and speaks the French language) relocated to Cotonou, Benin Republic<\/a> to begin slowly<\/p>\n

traveling across the West African region.<\/p>\n

His key purpose is to deliver talks, seminars <\/strong><\/p>\n

and workshops on his key areas of focus and interest to interested audiences (Email tayo at tksola dot com for details).<\/p>\n

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
\nManager.<\/p>\n

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.<\/strong><\/a><\/p>\n

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\u2019s(NIM) Young Managers\u2019<\/p>\n

competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development\u2122 (SCfS-D\u2122), and Founder of the Self-Development Academy (SDAc)<\/a>.<\/p>\n

When he's not amazing clients with his superhuman skills (wink), Tayo works as the creative force behind his Daily Self-Development Nuggets blog<\/a> - on which he also publishes The Farm CEO Weekly Newspaper (sent via email to paid subscribers) and his Weekly Performance Improvement IDEAS <\/a><\/p>\n

newsletter.<\/p>\n

You can connect with him on Twitter @tksola.com<\/a> and Facebook<\/a>.<\/p>\n

Visit Tayo Solagbade Dot Com<\/a>, to download over over 10 performance improvement resources to boost your<\/p>\n

personal and work related productivity.<\/p>\n

====
\n[IMPORTANT NOTE:====<\/h3>\n

On 4th May 2014, Tayo's 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net. <\/em><\/p>\n

Within a few days however, Tayo used his advanced self-taught web development skills to build a SUPERIOR \"reincarnation\" of it the website http:\/\/www.tayosolagbade.com<\/a>.<\/p>\n

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts <\/strong><\/em><\/p>\n

he's published.<\/p>\n

If you experience any difficulties finding a page or document, email Tayo at tksola dot com.<\/p>\n

Click \"Tayo, What Happened to <\/a><\/p>\n

SpontaneousDevelopmentDotCom ?\" to read a detailed narrative about how the above event occurred :-))<\/p>\n

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:<\/h4>\n
\n

Succeed by Emerging from Adversity Like a Phoenix <\/a><\/p>\n

(TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)<\/p>\n<\/div>\n

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:<\/h4>\n

A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name<\/a>
\n==================<\/p>\n

\"View<\/span><\/a>\"Join<\/a>\"Connect<\/a>\"Connect<\/a><\/span><\/span>\"Connect<\/a><\/p>\n

Home<\/a> |About<\/a> | Contact<\/a> | SD Nuggets\u2122<\/a> | Speaking\/Web Marketing IDEAS<\/a> | Web Marketing Systems<\/a> | Freelance Writing<\/a> | MS Excel\u00ae Heaven\u2122<\/a> | Cost-Saving Farm Biz Ideas<\/a><\/span><\/p>\n

\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

I have been paid as much as N200, 000 (Two Hundred Thousand Naira) - proof available - to build a single Excel-VB driven spreadsheet application. That same company \u2013 a large hospital with over 120 staff - went on to hire me in the course of the year that followed, to build two other apps […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7,8,1375,266,10],"tags":[2295,2312,2313],"class_list":["post-9224","post","type-post","status-publish","format-standard","hentry","category-employeescareer-persons","category-entrepreneurs","category-excel-vb-solutions","category-my-dn-travel-news","category-self-development","tag-attend-tayo-solagbades-free-4-hour-practical-introduction-to-ms-excel-vb-automation-workshop","tag-pii-005","tag-you-need-excel-vb-coding-skills-to-make-and-save-money"],"aioseo_notices":[],"views":1142,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/9224","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=9224"}],"version-history":[{"count":4,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/9224\/revisions"}],"predecessor-version":[{"id":9227,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/9224\/revisions\/9227"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=9224"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=9224"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=9224"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}