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

Monday 15th August 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 027: Make Money Selling Spreadsheet Workbooks You Use

The key to making money is finding a solution to problems that others around us are prepared to pay us profitably for.

If you know how to go about it, you CAN make good money selling the Workbooks you build for use in your work as a business user of MS Excel, or indeed any other spreadsheet application.

I say this as one who has done just that for well over a decade and (as I explain below, I have come across many other experts in various fields of endeavour who do the same.

If there is any area of endeavour packed with potentially limitless profitable problem solving opportunities, it is that of Data Recording, Analysis/Trending and Report generating for timely and Accurate Decision Making.

We are today, in a fast changing technology driven world, whose evolution is greatly dependent on access to and accurate/timely interpretation of data.

Think about it for a moment, and you’ll see that it’s true. Everywhere you turn, “data” is being collected, reviewed, analyzed, trended and presented. Sports, Business, Education, Entertainment, Religion, Politics/Government etc!

Anyone who is able to create a useful system for helping people tasked with responsibilities for routine data handling and report generation for decision making stands a good chance of making money selling such solutions to them.

But s/he needs to learn HOW to do it.

I argue that an important foundation on which to build any such solution are spreadsheets. And my preferred platform is Microsoft Excel – because it remains by far the best reporting application on the market.

Last night, I sent out the first podcast/audio version of my Excel-VB Automation Tutorial to members of my Excel Heaven Visual Basic Automation Club.

And it was on this same theme: Make Money Selling Spreadsheet Workbooks You Use

My purpose is open business users’ eyes to a possible goldmine of opportunities existing in form of the spreadsheet templates they routinely use to deliver value to their employers and/or clients.

The podcast I recorded was however sent to my club members via Whatsapp, in a deliberate effort to bring the club members into my Whatsapp network, where I’ve been actively supporting clients in/out of Africa (especially those in the UK, Ghana, Nigeria) since April 2016.

Join my MS Excel Heaven Visual Basic Automation Club [Introductory Videos You Need to Watch]

I’ve found the Whatsapp platform exceptionally versatile in delivering varied forms of support to those I serve!

Click here to request the Whatsapp audio, by sending me your Whatsapp number and other details via the form at the bottom of the page that appears.

Think about what you do with MS Excel, for your employer or clients in the formal work you do.

Chances are good that if you’re reasonably competent in the use of MS Excel, and have been doing that work for a reasonable period of time, colleagues or co-workers who do what you do may find them your Workbooks useful templates they can adapt to their needs.

Some common examples of purposes to which spreadsheets are applied include:

1. Preparing Pay slips

I’ve visited many forums and met various people who were in search of a template spreadsheet format they could simply modify with their personal or company information and plug data into, in order to generate needed Salaries Schedules and Pay slips, with Income Tax payments for each employee.

The basic version of my Automated Pay slip Generator app has been on sale since 2007, when I first built it for Lagos based medium sized hospital’s accounts department, who still use it till this day.

If you work use MS Excel to generate pay slips for employees or clients’ staff, that workbook you use can be customized as a template you can sell to earn passive income “as is” – without a single line of code – believe me!

2. Preparing Cash Book Income/Expense Summaries

I’ve built 3 different types of Automated Excel-VB driven Cash Books for accountants in different organizations, based on their specifications. This told me there is great potential for money making in this area, for any competent accountant who chooses to use the ideas I propose for adoption in this article.

Considering the fact that I did not study Accountancy, and have no formal training in that field, it goes without saying that my ability to sell the Automated Cash Books I’ve built to new clients is proof that those with training in that field can do so much more, if they learn to use Excel-VB like I do.

But even with what they already know, without any coding whatsoever, the workbooks I’ve seen some of them use, if properly formatted and structured for use as templates, can be sold for good money.

Many CPAs in developed societies build and sell such workbooks with little or no code for download and use by buyers looking for simple, easy to use solutions. YOU can start from there!

3. Preparing Tax Summaries

I know tax/audit consultants who complain of slowdown in business. Their clients are unable to pay for the traditional big budget audit projects of the past. What I always ask them is: Why not look at creating customizable template versions of the workbooks you use to generate the tax reports for your clients, then build data entry spreadsheets to feed those spreadsheets, which you can then sell to your clients, and train them to post data into.

By the end of the month or year, you could then come over to generate reports, for a smaller fee. So you would make money selling the workbooks, and/or helping to generate the tax reports. But it would cost the client much less, than the conventional work you do. The best part is that you’d be able to serve more clients, and earn passive income.

Note that I’ve used mainly examples relevant to financial reporting. However, the point I’m making here applies to virtually every other field in which data handling and report generation is done.

The range of apps (see examples below) I’ve built for clients in various markets illustrates this point perfectly.

1. Automated Church Records Manager

2. Clients Contacts/Records Manager
3. Membership Records Manager
4. Hotel, Restaurant & Bars Manager
5. Clinic Records Manager
6. Pure Water Business Manager
7. Manufacturing Business Manager
8. Supermarket Business Manager

Click here to visit a page where you can click links to watch videos of the apps listed above in use

Manufacturing organizations in particular will find the “Usage Rates Tracking and Variable Cost Analysis” spreadsheet applications (like those I develop – see screenshots below) invaluable for more efficient reporting.

The above report formats for product costing and Key Performance Indicator auto-generation were adapted from those I’d been involved in creating for a different organisation in the past. You can do the same – and get to a point where you end up with a generic customizable workbook you can sell to clients. See Excel-VB Automation Can Boost Employee Productivity in Your Company [Hint: Custom Manufacturing Business Manager App Built for a Lagos-Nigeria based SME]

Serious Minded Business Users ALWAYS Value Problem-Solvers

That’s a known fact – which is why they readily pay to hire such persons, or buy the solutions they create.

Such people never wants to go through the hassle of re-inventing the wheel e.g. building spreadsheet tables daily weekly, or monthly to handle data, when a ready-to-use format with formulas already correctly inputted, in a print-ready arrangement is available to be had.

Except they are unaware of its existence!

Little wonder, that some websites feature simple workbooks on sale for significant sums. A quick Google search will reveal ready examples you can relate to.

Note that this is an area of opportunity for which the potential demand in almost limitless. You can literally create your own market, by focusing on a niche you identify, to meet the needs of people you deduce are NOT being attended to adequately or satisfactorily.

If you can study your target marketplace and identify the preferred format used in most organizations, you can adapt the one you have to cater for any unique features they have and offer them for sale.

Abundant elbow room exists for multiple solution providers in this kind of market, as your CREATIVITY in adapting your solution to meet the client’s needs is what will determine your success or otherwise.

Like I tell my clients, this has been the key to my success in selling customizable spreadsheet solutions in my primary target market (Africa). And I’ve quietly held back from putting all I offer into the first generation of apps I’ve offered to buyers.

Instead, I continue to study my users and the feedback they give me, towards building what I aim to be a new generation of apps designed to overwhelm users with so much powerful value, that will make them industry standard.

In other words, what I’m asking you to do, is what I have been doing for YEARS, and which I continue to do, even though at a higher level of competence.

It therefore goes without saying that I can help anyone interested in learning to do the same -which is why I launched my Excel Heaven Visual Basic Automation Club.
Join my MS Excel Heaven Visual Basic Automation Club [Introductory Videos You Need to Watch]

SDN Blog™

New posts from last week*

Monday:

[Tuesday]:

[Wednesday]:

[Thursday]:

[Friday]:

Get my Excel-VB driven Catfish Farm Biz Manager, Pig Farm Biz Manager or Rabbit Farm Biz Manager. First 15 to signup as partners

[Saturday]:

N/A

[Sunday]:

Protected: THE FARM CEO (Issue 57): ADVANTAGES OF SOILLESS AGRICULTURE, 4 SOILLESS GROWING METHODS, How Soilless Agriculture Differs from Soil-based Agriculture

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)

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:

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

Home |About | Contact | SD Nuggets™ | Speaking/Web Marketing IDEAS | Web Marketing Systems | Freelance Writing | MS Excel® Heaven™ | Cost-Saving Farm Biz Ideas