{"id":9371,"date":"2016-04-04T22:22:00","date_gmt":"2016-04-04T22:22:00","guid":{"rendered":"http:\/\/tayosolagbade.com\/sdnuggets\/?p=9371"},"modified":"2019-05-07T14:30:55","modified_gmt":"2019-05-07T14:30:55","slug":"pii-008-master-spreadsheet-automation-and-achieve-superior-productivity-download-video-tutorial-from-my-excel-heaven-visual-basic-automation-club-workshop","status":"publish","type":"post","link":"http:\/\/tayosolagbade.com\/sdnuggets\/pii-008-master-spreadsheet-automation-and-achieve-superior-productivity-download-video-tutorial-from-my-excel-heaven-visual-basic-automation-club-workshop\/","title":{"rendered":"PII 008: Master Spreadsheet Automation and Achieve Superior Productivity [Download video tutorial from my Excel Heaven Visual Basic Automation Club Workshop]"},"content":{"rendered":"

In my article titled \"Use Excel-VB to Create Limitless Possibilities BEYOND What Off-The-Shelf Software Make Possible<\/a>\", I explained why <\/span>Visual Basic for Applications (VBA) today enjoys a respectable position in the world of softeware development as an authentic programming language.<\/p>\n

Many users of MS Excel however remain sadly unaware of the powerful software development capabilities that application sitting on their PCs puts at their disposal. Most people think of coding done by traditional programmers as beyond their reach.<\/p>\n

In reality however, coding is a skill that can be developed by anyone with the interest and passion for it.<\/h3>\n

A 5 year old can learn to code competently using conventional programming languages. All s\/he needs is to be able to read and write.<\/p>\n

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

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

Tayo Solagbade's<\/a>
\nPerformance Improvement <\/span> IDEAS
\n(PI Squared) Newsletter <\/strong><\/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 008:<\/span> Master Spreadsheet Automation and Achieve Superior Productivity [Download video tutorial from my Excel Heaven Visual Basic Automation Club Workshop<\/span>]<\/h1>\n

In my article titled \"Use Excel-VB to Create Limitless Possibilities BEYOND What Off-The-Shelf Software Make Possible<\/a>\", I explained why <\/span>Visual Basic for Applications (VBA) today enjoys a respectable position in the world of softeware development as an authentic programming language.<\/p>\n

Many users of MS Excel however remain sadly unaware of the powerful software development capabilities that application sitting on their PCs puts at their disposal. Most people think of coding done by traditional programmers as beyond their reach.<\/p>\n

In reality however, coding is a skill that can be developed by anyone with the interest and passion for it.<\/h3>\n

A 5 year old can learn to code competently using conventional programming languages. All s\/he needs is to be able to read and write.<\/p>\n

When it comes to coding using Excel-VB as a programming language, things get even more exciting. This is because VBA is a much more intuitive medium for coding. Also, the Excel engine on which VBA coding is applied, offers an amazing array of preprogrammed features and functions that make development of automation much easier.<\/p>\n

Every business user of spreadsheet applications, will value any opportuniy to boost the accuracy and reliability of the data recording, analysis and report generation process s\/he depends on for decision making in paid or self-employment.<\/p>\n

Whether for your personal benefit as an employee or business owner, or for the benefit of your clients, in your capacity as a consultant, knowing how to automate routine and repetitive tasks and procedures in your spreadsheets save you LOTS of time, effort and even money!<\/h3>\n

Below is the screenshot image of the final video tutorial in a downloadable series, that I sent to members of my Excel Heaven Visual Basic Automation Club<\/a>, just this morning.<\/p>\n

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

They received the first set of videos in the series, last Monday, following the maiden issue of the FREE monthly workshop I conducted for them in Lagos<\/a>.<\/p>\n

The tutorial video was accompanied by the actual workbook I used to create it.<\/p>\n

The club members will have access to view the code I ended up with, that dynamically creates a monthly report format from January to December, using a drop menu driven by Excel-VB code created using a Macro recorder and then modified to execute a repetitive task.<\/p>\n

Click here<\/a> to request a download copy of the tutorial and workbook.<\/p>\n

I end this piece with a table of information I began using in 2006, to introduce my Excel-VB solutions development service.<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
<\/td>\nI Am..<\/td>\n\n

Tayo Solagbade - I work with individuals and organisations to cost-effectively
\nleverage Microsoft Excel for their business data management\/decision making, so they can do what they do with less effort, at less cost, in less time and using less resources. This boosts their productivity, and helps them retain more of their revenue as profits.<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
<\/td>\n<\/tr>\n
<\/td>\n\n
\n<\/td>\n<\/tr>\n
<\/td>\nWho I Serve<\/td>\n\n

Owners of Businesses\/Business Users <\/strong> - Restaurants\/Bars, Hotels, Hospitals, Factories, Consultants etc; Decision Makers\/Job Holders <\/strong> in Corporations - Materials Managers, Sales\/Marketing Analysts, Financial Analysts\/Accountants, Project Engineers; And Anyone<\/strong> desiring to make BETTER\u00a0<\/span>sense - and use - of data!<\/span><\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n\n
\n<\/td>\n<\/tr>\n
<\/td>\nWhat I can do for you<\/td>\n1. <\/strong> Automation<\/strong> - I develop Excel VB<\/a> driven spreadsheet<\/strong> software - with friendly Graphical User Interfaces - to make your data handling, analysis and report generation less difficult\/time consuming and at the same time more accurate and useful.<\/span><\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n2. Optimisation<\/strong> - I review existing workbooks for improvements<\/strong> and with the client's agreement incorporate modifications\/additions using appropriate advanced Excel functions and Excel\u00a0<\/span>VB programming where necessary. <\/span><\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n3. Coaching <\/strong>- I offer Home Study Tutorials<\/a>, Workshops<\/a> <\/strong>and User Support<\/strong> services in Excel VB Programming.<\/span><\/td>\n<\/td>\n<\/tr>\n
<\/td>\n\n
\n<\/td>\n<\/tr>\n
<\/td>\nHow I Work<\/td>\na). Online -<\/strong> You can send me your data and the report layout you use(or that you want) and I will develop an application that will generate the report(s) you want.
\n<\/span><\/p>\n

b). On-Site<\/strong> - You can bring me in to work with you\/study your work processes and develop the most suitable application that will help you achieve your purpose.<\/p>\n

c).\u00a0<\/strong>I Empower You<\/strong> - While working on your project, I will gladly share my expertise
\nwith you - or any member(s) of your team. This way, you end up with in-house expertise to maintain the application I develop after I am gone. I build my applications for the \"future\" by working with clients to anticipate changes
\nthey expect to occur in their work over time, and incorporate interfaces that allow
\nusers make adjustments.<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n\n
\n<\/td>\n<\/tr>\n
<\/td>\nWhy Work
\nThis Way?<\/td>\n		\n

Because I want my clients to see that their interests will ALWAYS be protected, and their needs always MET. This way they know that they have gotten a worthwhile bargain - and will be more likely to<\/p>\n

(a).Engage me again and\/or<\/p>\n

(b). Tell others about me.<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n\n
\n
\n<\/div>\n<\/td>\n<\/tr>\n
<\/td>\nWhy MS Excel
\n?<\/td>\n		B<\/span>ecause MS Excel is already on your PC. It therefore becomes much easier and CHEAPER to train your people to use the applications I develop(complete with PDF or browser based user guides containing screen shots and detailed notes) than if they
\nhad to learn to use an off-the-shelf commercial application.<\/span><\/td>\n		<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n\n
\n<\/td>\n<\/tr>\n
<\/td>\nWhy You Need Me<\/td>\n\n

I am not a programmer. Like you, I am a user - only I have developed my skills in Excel Visual Basic programming combined with extensive knowledge of many time\/cost-saving advanced functions of MS Excel.<\/p>\n

As a result, I am able to develop professional quality Excel Software that help YOU achieve levels of productivity that you would normally have imagined IMPOSSIBLE. I
\nam driven by a vision to make my Excel software boost clients' productivity, by solving their data handling\/report generation problems so quickly and effortlessly, that they feel\u00a0<\/strong><\/em>like they're in \"heaven\"!<\/strong><\/em><\/p>\n

I don't need to be an expert in your field to help\u00a0<\/strong>you.<\/strong> And that's because
\nI have you.<\/p>\n

You will tell me what you do, how you do it, and what you WANT TO DO with
\nExcel to make life easier for you,and those you work with. I will then use my knowledge, skills and experience, in conjunction with your guidance to develop a 100% custom, automated spreadsheet application that meets your needs. A conventional programmer willing to do the foregoing, would be hard to find\/pay.<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n\n
\n<\/td>\n<\/tr>\n
<\/td>\nContact Me<\/td>\nCall +234-803-302-1263 or +229-66-122-136. Alternatively, email tayo at tksola dot com or fill\/submit this contact form<\/a> to tell me what you want me to do for you.<\/span><\/td>\n<\/td>\n<\/tr>\n
<\/td>\n\n
\n<\/td>\n<\/tr>\n
<\/td>\nMore..<\/td>\nYou can learn more about me here<\/a>.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Monday<\/h2>\n

PII 007: Parenting Is NOT A Democracy [Hint: The Need to Assert Yourself to Get Results That Matter \u2013 Lesson from True Story of a Girl Who Made Pizza Without An Oven]<\/a><\/h2>\n

Tuesday<\/h2>\n

Re: \u201cAgatu Killings and Buhari\u2019s moral weakness\u201d [Alternative Perspectives and a Possible Way Forward]<\/a><\/h2>\n

\u00a0Wednesday<\/h2>\n

Signup for Tayo Solagbade\u2019s One-on-One MS Excel Heaven\u2122 Visual Basic Coaching Program & Finish With Your Own Custom Excel-VB App You Can Use at Work and\/or Sell to Clients!<\/a><\/h2>\n

\u00a0Thursday<\/h2>\n

How You Can Create Income Generating Assets Without Having a Job or ANY Money! (True Story)<\/a><\/h2>\n

\u00a0Friday<\/h2>\n

Financial Freedom Goes Beyond Just Having Money, to Also Being FREE to Live Your Life the Way You Want It [True Story: How Relocating to Cotonou on 1st April 2013 Helped Me Succeed As a Location Independent Multipreneur]<\/a><\/h2>\n

Sunday<\/h2>\n

Protected: THE FARM CEO (Issue 39): Farmers \u2013 and Suppliers \u2013 Contact Details, Maize Daily Prices\/Charts & Data, Climate-smart agriculture, Using text messaging to train fish farmers<\/a><\/h2>\n

\u00a0<\/p>\n

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

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

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

*Creator of the Mastering Adversity for Perpetual Success Achievement Coaching Program<\/em><\/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 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>, 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 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>Manager\u2122 software.<\/p>\n

He has delivered talks\/papers to audiences in <\/a>various groups and organizations, including the Centre for Management Development, University of Lagos, Christ Baptist Church, Volunteer Corps, Tantalisers Fast Foods 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 traveling across the West African region.<\/p>\n

His key purpose is to deliver talks, seminars <\/strong>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 Manager.<\/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 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>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 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\u00a0<\/strong><\/em>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>\u00a0SpontaneousDevelopmentDotCom ?\" 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\n\n\n\n\n\n\n\n\n\n\n\n
<\/td>\n<\/tr>\n
<\/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<\/td>\n<\/td>\n<\/tr>\n
\n

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

<\/td>\n<\/td>\n<\/tr>\n
[Wednesday<\/span>]: <\/strong><\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
[Thursday<\/span>]: <\/strong><\/span><\/td>\n\n
N\/A<\/div>\n

\n<\/td>\n

<\/td>\n<\/tr>\n
[Friday<\/span>]: <\/strong><\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
[Saturday<\/span>]:<\/strong><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
[Sunday<\/span>]: <\/strong><\/span><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
\n\n\n\n\n
<\/td>\n<\/tr>\n
\n

<\/h3>\n

\n

\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

In my article titled \"Use Excel-VB to Create Limitless Possibilities BEYOND What Off-The-Shelf Software Make Possible\", I explained why Visual Basic for Applications (VBA) today enjoys a respectable position in the world of softeware development as an authentic programming language. Many users of MS Excel however remain sadly unaware of the powerful software development capabilities […]<\/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":[2358,2357,2356],"class_list":["post-9371","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-download-video-tutorial-from-my-excel-heaven-visual-basic-automation-club-workshop","tag-master-spreadsheet-automation-and-achieve-superior-productivity","tag-pii-008"],"aioseo_notices":[],"views":975,"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/9371","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=9371"}],"version-history":[{"count":4,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/9371\/revisions"}],"predecessor-version":[{"id":14379,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/posts\/9371\/revisions\/14379"}],"wp:attachment":[{"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/media?parent=9371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/categories?post=9371"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/tayosolagbade.com\/sdnuggets\/wp-json\/wp\/v2\/tags?post=9371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}