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 that application sitting on their PCs puts at their disposal. Most people think of coding done by traditional programmers as beyond their reach.

In reality however, coding is a skill that can be developed by anyone with the interest and passion for it.

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.

SCROLL DOWN TO READ FULL ISSUE

Tayo Solagbade’s
Performance Improvement IDEAS
(PI Squared) Newsletter

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 008: Master Spreadsheet Automation and Achieve Superior Productivity [Download video tutorial from my Excel Heaven Visual Basic Automation Club Workshop]

In reality however, coding is a skill that can be developed by anyone with the interest and passion for it.

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.

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.

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.

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!

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, just this morning.

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.

The tutorial video was accompanied by the actual workbook I used to create it.

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.

Click here to request a download copy of the tutorial and workbook.

I end this piece with a table of information I began using in 2006, to introduce my Excel-VB solutions development service.

	I Am..	Tayo Solagbade – I work with individuals and organisations to cost-effectively leverage 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.


	Who I Serve	Owners of Businesses/Business Users – Restaurants/Bars, Hotels, Hospitals, Factories, Consultants etc; Decision Makers/Job Holders in Corporations – Materials Managers, Sales/Marketing Analysts, Financial Analysts/Accountants, Project Engineers; And Anyone desiring to make BETTER sense – and use – of data!


	What I can do for you	1. Automation – I develop Excel VB driven spreadsheet 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.
	What I can do for you
		2. Optimisation – I review existing workbooks for improvements and with the client’s agreement incorporate modifications/additions using appropriate advanced Excel functions and Excel VB programming where necessary.

		3. Coaching – I offer Home Study Tutorials, Workshops and User Support services in Excel VB Programming.

	How I Work	a). Online – 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. b). On-Site – 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. c). I Empower You – While working on your project, I will gladly share my expertise with 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 they expect to occur in their work over time, and incorporate interfaces that allow users make adjustments.


	Why Work This Way?	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 (a). Engage me again and/or (b). Tell others about me.


	Why MS Excel ?	Because 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 had to learn to use an off-the-shelf commercial application.


	Why You Need Me	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. 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 am 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 like they’re in “heaven”! I don’t need to be an expert in your field to help you. And that’s because I have you. You will tell me what you do, how you do it, and what you WANT TO DO with Excel 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.


	Contact Me	Call +234-803-302-1263 or +229-66-122-136. Alternatively, email tayo at tksola dot com or fill/submit this contact form to tell me what you want me to do for you.

	More..	You can learn more about me here.

SDN Blog™

New posts from last week*

Monday:

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

[Tuesday]:

Re: “Agatu Killings and Buhari’s moral weakness” [Alternative Perspectives and a Possible Way Forward]

[Wednesday]:

Signup for Tayo Solagbade’s One-on-One MS Excel Heaven™ Visual Basic Coaching Program & Finish With Your Own Custom Excel-VB App You Can Use at Work and/or Sell to Clients!

[Thursday]:

N/A

[Friday]:

How You Can Create Income Generating Assets Without Having a Job or ANY Money! (True Story)

[Saturday]:

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]

[Sunday]:

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

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Creator of the Mastering Adversity for Perpetual Success Achievement Coaching Program

Mobile: +234-803-302-1263 (in Nigeria) or +229-66-122-136 (in Benin Republic)

http://www.tayosolagbade.com

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.

====
[IMPORTANT NOTE:====

On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net.

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.

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts

he’s published.

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
==================

You’re reading PII 008: Master Spreadsheet Automation and Achieve Superior Productivity [Download video tutorial from my Excel Heaven Visual Basic Automation Club Workshop] 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

PII 008: Master Spreadsheet Automation and Achieve Superior Productivity [Download video tutorial from my Excel Heaven Visual Basic Automation Club Workshop]

In reality however, coding is a skill that can be developed by anyone with the interest and passion for it.

Tayo Solagbade’s
Performance Improvement IDEAS
(PI Squared) Newsletter

PII 008: Master Spreadsheet Automation and Achieve Superior Productivity [Download video tutorial from my Excel Heaven Visual Basic Automation Club Workshop]

In reality however, coding is a skill that can be developed by anyone with the interest and passion for it.

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!

I end this piece with a table of information I began using in 2006, to introduce my Excel-VB solutions development service.

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

Re: “Agatu Killings and Buhari’s moral weakness” [Alternative Perspectives and a Possible Way Forward]

Signup for Tayo Solagbade’s One-on-One MS Excel Heaven™ Visual Basic Coaching Program & Finish With Your Own Custom Excel-VB App You Can Use at Work and/or Sell to Clients!

How You Can Create Income Generating Assets Without Having a Job or ANY Money! (True Story)

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]

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

====
[IMPORTANT NOTE:====

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:

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:

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:

No Comments Yet

Leave a Reply Cancel reply

Recent Posts

Recent Comments

Archives

Categories

Meta

PII 008: Master Spreadsheet Automation and Achieve Superior Productivity [Download video tutorial from my Excel Heaven Visual Basic Automation Club Workshop]

In reality however, coding is a skill that can be developed by anyone with the interest and passion for it.

Tayo Solagbade’s Performance Improvement IDEAS (PI Squared) Newsletter

PII 008: Master Spreadsheet Automation and Achieve Superior Productivity [Download video tutorial from my Excel Heaven Visual Basic Automation Club Workshop]

In reality however, coding is a skill that can be developed by anyone with the interest and passion for it.

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!

I end this piece with a table of information I began using in 2006, to introduce my Excel-VB solutions development service.

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

Re: “Agatu Killings and Buhari’s moral weakness” [Alternative Perspectives and a Possible Way Forward]

Signup for Tayo Solagbade’s One-on-One MS Excel Heaven™ Visual Basic Coaching Program & Finish With Your Own Custom Excel-VB App You Can Use at Work and/or Sell to Clients!

How You Can Create Income Generating Assets Without Having a Job or ANY Money! (True Story)

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]

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

==== [IMPORTANT NOTE:====

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:

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:

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:

Share this:

No Comments Yet

Leave a Reply Cancel reply

Recent Posts

Recent Comments

Archives

Categories

Meta

Tayo Solagbade’s
Performance Improvement IDEAS
(PI Squared) Newsletter

====
[IMPORTANT NOTE:====