All posts by Tayo Solagbade

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 organisations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems, freelance writing services, and best practice extension support services (for farm business owners). Tayo is the author of the Self-Development (SD) Bible™, the popular Livestock Feed Formulation Handbook, and developer of its accompanying Excel-VB driven Ration Formulator - as well as the increasingly popular Monthly Poultry Farm Manager app. On 1st April 2013, Tayo (who reads, writes and speaks the French language) relocated to Cotonou, in the French Speaking Benin Republic on the first lap of his slow travels 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). 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 previews of paid issues of The Farm CEO™ Newspaper (www.thefarmceo.net), in addition to his FREE Weekly Public Speaking/Web Marketing IDEAS newsletter - which he uses to promote Burt Dubin's Public Speaking Mentoring service to experts across the African continent. Visit Tayo's Flagship Performance Improvement website to download over 10 performance improvement resources to boost your personal and work related productivity. Join Tayo's international community of fans on his Flagship MS Excel Heaven Facebook page (click here). You can also connect with him via Twitter (@tksola).

[FREE] POWERFUL TRUTHS ABOUT REAL BLACK HISTORY, NOT TAUGHT IN SCHOOLS, BUT WHICH YOU (AND YOUR KIDS) NEED TO KNOW

Why do black people – and their nations – often lag behind others? I have argued for years that the reason is NOT genetic. Instead it is the mental attitude of majority of us.

No one can under develop us. We have the power to develop and advance ourselves. I am doing that for myself and my family. No one can stop me. I do NOT need the government to do it for me.

If more of us would adopt a similar mindset, we would transform our individual lives, and the fortunes of our respective families and societies.

My accomplishments over the past 2 decades prove that my sentiments are accurate. But the 2 books and a movie that I feature in this report offer incontrovertible proof that we, as a people have what it takes to excel on this planet.

I recommend you read this report and follow the URLs provided to learn more, so you (and your kids) can be empowered!

2books-1movie

[VIDEO] Anatomy of a Real Life Speaker One Sheet, and Why You Need One

Many business owners have problems attracting the right kinds of people to buy from them.

Marketing is not just about getting people to buy from you. Instead you need to focus on how to find the right kind of people.

But who are the right kinds of people?

How can – or should – you define/identify them?

Another way I like to ask this question is:

What is your target audience profile?

If you are not sure, or simply do not know, THIS is as good an opportunity as ever, right now, right here, as you read this, to begin THINKING it all up!

I offer a few insights below.

The right kinds of people are those…

  1. Who will appreciate what you do, enough to be willing to pay you good money, or whatever amount you want them to pay you, to get it.
  2. Who will be fair minded and speak impartially/objectively – and truthfully! – about what you’ve done for them, after you have parted ways.
  3. Who will be willing to tell other people what you have done for them, even when you’re not there – thereby attesting to the authenticity of solutions you offer.
  4. Who will have no difficulty – once satisfied with the solution you’ve provided – recommending you to others.
  5. With whom you will have relationships, hopefully for very long periods of time, that will evolve into friendships.

Those are the kinds of people I have as my clients.

They are the kinds of people I recommend YOU have as YOUR clients or buyers.

The ideas I share on this page, and this blog can enable you attract the above mentioned kinds of people to buy from you, if you apply them with intelligence, creativity, diligence and persistence.

Every results-focused business person engaged in marketing activities in the 21st century must – as a matter of necessity – invest in using writing and speaking to better connect with potential clients/buyers.

It is with regard to the latter, that we notice many smart business owners/independent consultants offering “talks” and other learning events, sometimes paid, but often free to their target audiences.

They do so because they understand the powerful client recruitment benefits to be had from speaking to large groups of likeminded people potentially interested at the same time.

You can use a Speaker One Sheet document – designed to meet your own unique needs – to boost your name/brand recognition and ultimately win clients over

I don’t really believe there is any limit to what you can do with the information I share here.

You only need to apply creativity and a willingness to persist till you get the results you want.

I’ve written lots of articles in the past about how to use your writing and speaking to attract profitable, high profile buyers.

The use of a Speaker One Sheet is yet another dimension to what I have already discussed with regard to using Public Speaking for Business Marketing.

Over the past decade or so, as I evolved my brand as a multi-skilled entrepreneur (aka Multipreneur) , I’ve learnt how to use a Speaker One Sheet to communicate details of what I offer by way of talks, seminars, coaching programs, workshops and other learning events.

Over the last 15 years or so, I’ve studied experts, especially outside Africa to learn how to develop unique resources, like the Speaker One Sheet, to attract potential clients – especially when one lacks money to use conventional paid channels or strategies.

In many cases, as I’ve noted in other articles describing how I’ve borrowed ideas from other cultures, I’ve had to creatively adapt what I learned about using the Speaker One Sheet, to suit my needs out here in Nigeria/Africa.

Indeed, experience taught me that when one is completely down to zero, with regard to having money to carry out marketing or advertising, the BRAIN tends can really be pushed to produce amazing ideas, if one is willing to test it to its perceived limits.

When you succeed in doing so, you suddenly discover it can be pushed even further – and much further too.

I’ve traveled that road, which is why I know it works – hence my recommendation that YOU think less of spending money of paid outlets, until you’ve put ideas like the one described on THIS page to test fully.

I recommend you aim to produce Speaker One Sheets, describing learning solutions you offer in a manner that makes people consider inviting you to SHARE your expert information and insights.

That process can ultimately opens potential doors of opportunities for you to communicate to others things you have to offer – whether for a fee or for free.

 

I’ve prepared this video and THIS article because I know there will be others looking for help in coming up with their own variant of this concept, to get around marketing/business promotion challenges they are facing.

Hopefully, what you learn will equip you to better evolve your own brand, with regard to marketing or any other business promotion goal you may have.

I try very hard to adopt strategies that enable me to get rid, as early as possible, of people who do not fit my target audience profile.

I do this because I do not want people who will be annoyances in my business, and I do not want to constitute an annoyance to anybody.

The instrument called a Speaker One sheet can be quite useful for achieving the above stated end.

I offer an analysis of the various sections (A to H) using one of my own Speaker One Sheets (below).

anatomy-of-a-real-life-spea-image

Like I noted earlier on in this piece, I evolved my own branded range of Speaker One Sheets, based on my studies of many others I’ve found online – especially on websites owned by experts based in the USA.

Final Words

It is noteworthy here that I publish each of my Speaker One Sheets in PDF as well as image (PNG) formats.

This is to ensure they can be accessed and viewed by as many persons fitting my target audience profile as possible – regardless of what platform they use.

I recommend you aim to do the same thing with your own Speaker One Sheet, and indeed any other similar resources you use for your business promotion.

One more thing I do is to publish a blog post with highlights of each Speaker One Sheet (like this one), linking it to the different downloadable format
s it is available in.

Then I send the URL to that blog post to any persons I wish to share the Speaker One Sheet with, so s/he can pick and choose from all that is provided.

To watch the video anatomy explanation – click below or go to www.tinyurl.com/tksAnatomyofS1S

anatomy-of-a-real-life-speaker-one-sheet

Also Read: Win New Customers Repeatedly/Inexpensively, Using YOUR Public Speaking For Business Marketing System

[Recommended] Opinion: Raising Africa’s middle class – howwemadeitinafrica.com

Preview: We already know that we do not know enough about African growth. This was revealed by the extent of upward revisions to estimates of GDP during recent rebasings – anywhere from up 25% in the case of Kenya, to up 89% in the case of Nigeria. Africa has been growing faster than we thought all along. We were not adequately equipped to measure this growth while it was happening.

The news on Africa’s middle class has also been mixed. When a well-known multinational in the consumer goods sector, Nestle, announced that it was disappointed by the scale and growth of Africa’s middle class and the return on its investment, and that it would be cutting its regional workforce by 15%, the news dominated headlines. What went relatively unnoticed?

Continue reading…

https://www.howwemadeitinafrica.com/opinion-raising-africas-middle-class/57312/

PII 056: Resisting Use of Barter Exchange Can Cost You Business Success [Based on True Stories]

The message in this week’s issue of my Performance Improvement Ideas (PII) newsletter is based on transcripts excerpts from an audio podcast I recorded, to explain how business persons can explore alternative ways to get paid for what they do or what they sell.

Whether you’re a service provider, or manufacturer or producer of anything whatsoever, there are so many alternatives to getting paid in conventional ways that you can pursue, which will enable you to achieve the desired ends you want as a business owner.

However, in our part of the world – Africa, Nigeria especially – people remain very fixed in their thinking about how they should get paid, and even how they should pay people.

SCROLL DOWN TO READ FULL ISSUE

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

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

Monday 6th March 2017

Logo - Tayo Solagbade's Self-Development Academy


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.

************

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

PII 056: Resisting Use of Barter Exchange Can Cost You Business Success [Based on True Stories]

The message in this week’s issue of my Performance Improvement Ideas (PII) newsletter is based on transcripts excerpts from an audio podcast I recorded, to explain how business persons can explore alternative ways to get paid for what they do or what they sell.

Whether you’re a service provider, or manufacturer or producer of anything whatsoever, there are so many alternatives to getting paid in conventional ways that you can pursue, which will enable you to achieve the desired ends you want as a business owner.

However, in our part of the world – Africa, Nigeria especially – people remain very fixed in their thinking about how they should get paid, and even how they should pay people.

NB: There are certain groups, in Nigeria, that I’ve noticed actively use a lot of barter, though. E.g the relationship between journalists/media houses and outfits like hotels, restaurant/bars as well as conference/event centres. They do a lot of bartering with one another. The rest of us can learn a lot from them

People are so focused on getting cash. And if they can’t get cash, they close their minds to any possibility of doing business with the other party.

Unfortunately, the rest of the world continues to evolve and move on, because people in those societies are willing to accept that payment does not necessarily have to happen in cash.

What is important is achieving the benefit for which payment is desired.

What do I mean? I’ll give an example…

In 2009, I connected with a company in the Anifowoshe area of Lagos’s Ikeja. It was an IT company. They were into telecommunication, VSAT installations, fibre optics. They did projects all over the state and even beyond.

However they were going through a bit of a cash crunch when they engaged me to help them develop a Web Marketing System.

Now being a multiprenur, I do a variety of things – like building software, websites etc.

But this was a time when I was not yet operating from home, 100% online. I was still doing pavement pounding, driving my car all over the place, hunting for clients

Back then most of those I approached were generally not keen to pay for software or services, especially when dealing with an individual. So, one had to look for ways to make payment one requested not appear to be too big, in the eyes of the client.

So, one of the things that I learned was from studying the works of Burt Dubin. Through his Speaking Success System, over the past 3 decades, he has taught expert speakers, who are basically service providers that they should not deny themselves of opportunities to grow their brands, by being fixated on only getting paid with money.

Using the phrase “Barter is Smarter”, Burt emphasizes that you have to consider “Barter Exchange”.

You must be open-minded about how you market yourself, and how you get paid. If you don’t, you may lose opportunities in the immediate period as well as possibly miss those that could open up to you in the future, if you were more flexible in your thinking.

Let me give an example of the company I served in 2009.

I gave the MD a bill of N150k to develop a web Marketing System for them. He was a pastor with a popular Pentecostal church movement.

He wanted to pay N50k and I told him that THAT would simply not work. Instead I proposed that they pay N100k, with 50% of that being via a Barter Exchange.

In that regard, I told them about my Eyo Masquerade graphics design which I wanted printed on T-Shirts that I could give out as gifts or sell.

Since they had a new company division that specialized in transfer printing technology, I suggested they produce N50k worth of such printed T-Shirts for me. Long story short: he agreed.

And by the time I delivered their completed WMS to them 20 working days later, I got 75 nicely printed T-shirts handed to me as agreed, based on the costing we’d done.

It was a win-win outcome!

I have other true stories of how I used Barter Exchange to get paid what I wanted (see articles at the end of this piece).

Many times, the willingness to explore this kind of alternative payment option will enable you keep going even during hard times, when clients are hard to find and/or money is not easy to get from them e.g. due to harsh economic times arising due to recession etc.

And this is where I see lots of people sabotaging themselves effectively. When you want to buy something from somebody, even if the person is not proposing it to you – YOU propose it to the person!

Why?

Because it is in YOUR interest to spend as little cash as possible, to buy what you want to buy. So, cash is an option: YES! But even if you have the cash, you can still think of a better way to pay the person.

Find out what the person wants. What is the person trying to achieve? Try and interact with people. Go beyond what is immediately of interest to YOU in terms of what you want to get from the person.

Find out what the person’s purpose in life is. What are the passions of the person? What are the interests of this person?

Find out what they are , and based on what you discover, begin to look for how you can provide a solution for that person to achieve those things you know are important to him/her.

You can also find out how you can create a solution that the person would appreciate or value towards achieving those goals that are important to him/her.

Now, when you do that, it effectively puts you in a position where without cash, you can give the person something s/he considers valuable enough to pay money for.

So, for example if you have a business in which there are certain things that are kind of waste products you produce.

Again, I’ll provide an example.

I once visited a farm in Ibadan, Oyo state in Nigeria, with an old client working as a consultant but looking to retire into farm business – Poultry specifically.

This farm had maggots crawling out en masse on to the floor, from the poultry droppings pits under the battery cages in one of their pens.

The maggots were so many that when we were walking around, we kept hearing the crunching of their bodies as they burst under our weights.

They were having problems removing them as they had to pay extra for that to happen along with the droppings removal.

What the owner eventually did was to invite a worker he had on the farm, who also happened to have a catfish farm business of her own, to pack the maggots away, at zero cost to him.

While we were there, within about 15 minutes she had packed 2 twenty five kilogram bags filled with maggots!

And maggots were still all over the floor. For her however, this was pure protein for her fish – something that would have cost her a hefty sum to provide if she had to buy it. And if she chose to rear them the work involved would have been considerable.

There are many opportunities for barter exchange in the kind of situation described above.

Most people who have fish farms would love to get hold of such maggots and feed to their Catfish or Tilapia.

Some people would go to great lengths (even pay money) to get large number of earthworms to feed their female catfish brood stock preparatory to spawning (reproduction via induced breeding).

So if I owned a poultry farm and a restaurant business, I could think, for instance, as follows:

Can I use the poultry droppings from my farm to generate a bank of maggots that I can then begin to give as alternative payment to somebody who runs a catfish farm and sells fish?

WHY?

Because I want to buy fish for use in preparing dishes for my restaurant. I want certain quantities of fish I want to put in my restaurant freezers. But I don’t want to pay for fish. I want to be able to give him say 10 bags of maggots that will amount to giving them 100% protein to feed his catfish.

And I would get in exchange X kg of that I can use in my restaurant.

With the above opportunity, every month that I have to spend, say N10k to buy fish for the restaurant, I find that I am able to drop that bill to just N2k, because I have someone supplying me LIVE fish in exchange for my providing him/her maggots to feed his/her pond fish.

Begin to think of yourself as a solution provider for the person you are going to buy something FROM!

In other words, apart from giving your money to the person, think of how you can give him something else that will make him decide to either give YOU money or better still, not need to take money FROM you!

Once you can spend less to get what you want, you will be able to retain more of the money you make as profits.

So, if for example, you have a budget today of say N10k, to advertise in a medium. Consider approaching the owner of that medium to propose a workable barter exchange arrangement, that can enable you spend less than N10k, so you have more cash to channel in other areas that may not lend themselves so easily to payment in kind via barter!

Simply put, there are various options you can explore to make use of the ideas proposed here. The most important thing is for you to maintain an open mind like an umbrella.

Otherwise, you risk making yourself lose valuable opportunities to grow your brand, when you don’t have the cash to take them up.

Closing your eyes to the barter alternative can also make you end up missing out on opportunities to connect further with people.

This is because when you close your mind to the option of barter exchange, it means you won’t be able to continue with that person.

No cash? No barter alternative? You will be left with nothing to do but go your separate ways!

But if you are able to use the barter exchange alternative to continue the relationship, you might get to a point when money will now come on either side (yours/his/hers/theirs). And you’d be able to then continue your business dealings using money that you previously lacked as a basis for interaction.

That would only however happen because the relationship continued/was maintained via barter exchange when there was not enough money to keep it going.

Final Words

Based on the above, it becomes apparent that if you give people an option to do business with you through barter exchange, you can create an opportunity for long term potentially profitable relationships to be built and maintained.

I urge you to keep THAT in mind whenever you find yourself in situations similar to any of those I’ve described in this article!

Related Articles

1. Barter Your Digital Products to Make More Money (True Story)

2. No. 175: Why Speakers Who Barter Products and Services Will Make More Money

3. No. 226: Products and Services Bartering Can Make You More Money! [True Stories & Research Proof – from Harvard & Others]

4. No. 194: How A NEW Client Paid For My Website! [Why “Bartering” Can Help You Sell More – True Story]

Excel-VB Driven Ration Formulator

Click to view larger screenshot

1. Click here to learn more about this app – watch demo videos etc

2. Click here to watch a 4 part video in which I demonstrate how to use this app to formulate rations using real life data sent to me by an Algerian PhD student.

Click here to contact me about purchasing this product.

EXCEL-VB DRIVEN POULTRY LAYER FARM MANAGER SOFTWARE

Click here to download a detailed PDF user guide and watch 15 screen shot user guide tutorials of the Monthly Poultry Farm Manager that I now offer Farm CEOs.

Click here to watch a screenshot demonstration of the Excel-VB Driven Poultry Farm Manager I built for a client farm business in Ekiti state, South West Nigeria.

Click here to contact me about purchasing this product.

SDN Blog™

New posts from last week*

Monday:

[Wednesday]:

[Thursday]:

Get Novice Proof Custom Automated Spreadsheet Software [Hint: From Tayo K. Solagbade – a Multidisciplinary Provider Guided by a Code of Ethics That Protects YOU!]

[Friday]:

[True Story] Defying Adversity As a Nobody, to Create a Lucrative Niche Market for my Custom Automated Spreadsheet Software in Nigeria

 

[Saturday]:

[Recommended] The Art of Shameless Self-Promotion

[Sunday]:

A Common Misconception About Spreadsheet Programming You Need to Know [Hint: What is Excel-VBA?]

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:

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

View Tayo Solagbade's video tutorials and demonstrations on Facebook Productivity Tips, Web Marketing, and for his Custom MS Excel-VB driven software applicationsJoin the SD Nuggets community on Facebook.comConnect with Tayo on Twitter.comConnect with Tayo on Google PlusConnect with Tayo on LinkedIn.com

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

A Common Misconception About Spreadsheet Programming You Need to Know [Hint: What is Excel-VBA?]

[NB: The 2nd and concluding part of my tutorial titled “What You Need to Create a Splashscreen for Your Custom Spreadsheet Application” will go out next week]

======
Today, I feature the article titled “What is Excel-VBA”, (which I wrote back in 2007) to inform and educate my desired target audience and other relevant stakeholders, about the difference between Excel-VB programming that I did, and Visual Basic – that most of them were more familiar with, and often tried to equate to what I did.
This need to put forward a clarifying piece like this comes from my recent discussion with a Farm CEO, who works a 9 to 5 job as a Network Administrator.

He caused me major amusement when he asked me to email him a “patch” to download to resolve a problem he had with one of my Excel-VB software that he’d purchased.

 I said “What patch?” – and he replied that he meant a “piece of software designed to fix or improve” my Excel-VB software that he had purchased.
At that point I was forced to bluntly inform hims that Excel-VB programming vocabulary does NOT include such terms used in the Windows Operating System world – which was where he’d gotten the word “patch” i.e. as per the downloads that happen on Windows PCs to plug bugs or vulnerabilities in the Operating System.

The fact that he chose to use that term (meaning he assumed that kind of resource existed!), in addition to calling me a “Visual Basic (VB) Programmer” proved conclusively to me that he had NO CLUE what Excel-Visual Basic for Applications (VBA) was about and just how VERY different it was from anything he knew.

 This is one tendency I’ve noticed in many people who feel they are IT expert or savvy in this part of the world. They readily assume they know what you do, and will often claim they can do it better than you.
I do not doubt that anyone with the right training and time can do what I do. I state that fact clearly in my 10 item code of ethics.
What I do however know is that most of those I have met lack the needed MENTAL discipline to commit the needed time and effort to acquire the needed training to be able to do what I do.
 
And that is what gives me the edge to stay more than one step ahead of them.
For those who learn from me, or who use the apps I build, the article below provides useful insights to help you educate and inform any such persons you may come across.
===========

What is Excel-VB?

What Is Excel-VB?

Microsoft Excel is a powerful tool for recording, re-organising, analysing and presenting information. By Excel VB, I refer to Excel VBA – where VBA means Visual Basic for Applications(VBA). VBA refers to the highly extensive and flexible macro programming language developed by Microsoft for use in their MS office applications – Word, Power Point, etc.

VBA is therefore different from the Standalone Visual Basic program used(by conventional programmers) for developing “standalone” or “executable” (.exe) software applications – though it borrows many of the latter’s features.

Think of Excel VBA as being the standalone Visual Basic software built into Excel for the benefit of Excel users/developers who are not traditional-minded programmers, but who are keen to exert more control over the application to enhance user productivity.

So, Excel VB offers any interested persons the necessary tools to make the application deliver more functionality. The final product is still an Excel document, but with extra functionalities added using VBA..

Continue reading…

http://excelheaven.tayosolagbade.com/?page_id=72

[Recommended] The Art of Shameless Self-Promotion

[Tayo Solagbade’s comment: If you’re not doing Shameless Self-Promotion (I call it “SSP” for short), you are short-changing yourself BIG TIME in your business marketing. This excellent Copyblogger article explains why SSP works, and how to do it] Here are some excerpts:

The Art of Shameless Self-Promotion”So self-adulation is something I try to stay away from. But self promotion? That’s a whole different story.If you take a look at the most successful (or talked about) people in any field, you’ll almost always see someone incredibly talented in the art of self-promotion….If you implement this plan successfully, you’ll probably take some flak. People might label you over-confident or cocky.That’s good. Define yourself in such a way that people either love you or hate you.There are fans out there for every self-promoter. Your task is to find them. That, and to make it easy for them to bring a friend.Your ideas need you. If you have a vision, don’t let anyone stand in your way.”Read the full article at:http://www.copyblogger.com/shameless-self-promotion/

[True Story] Defying Adversity As a Nobody, to Create a Lucrative Niche Market for my Custom Automated Spreadsheet Software in Nigeria

It all still feels like yesterday – when in 2002 I quit a high paying job as a manager in a corporate multinational, in which I was an established high-flyer, to start offering my custom Excel-VB software development (and Freelance Writing) solutions to paying clients.

Not a few friends, relatives and co-workers thought I’d lost it. Indeed, some co-workers called me “mad” for doing so – as I noted in a past article (click to read) based on feedback reaching me years later.

Today, my achievements speak for themselves (Read my article titled No. 119: How to Achieve Success in Any Field (True Story):

true-story-succeed-in-any-field

I have found a reliable way to get paid what I want, the way I want, for what I do, and I am recognized internationally for it.

So what do I do exactly?

Well, I do several things, as a Location Independent Performance Improvement Specialist and Multipreneur.

However, with regard to Excel-VB software development, I USED to work on client premises, face to face or in person, building a wide range of custom automated spreadsheet applications using Excel-VB programming.

Then in 2012, I moved to providing the same service 100% remotely using the web – and over time used the pattern of client requests I was getting, to settle on key applications I could offer for sale.

As time went on, I discovered it was better to build apps and offer them for sale, instead of looking to get hired by clients to build spreadsheet software.

That decision made me focus my efforts on identifying the best markets/buyer groups to sell to, and I eventually narrowed down to farm business owners as the most serious minded of them all.

Since I did that, I have had NO cause to regret it, as Farm CEOs (from within and outside Africa) continue to respond to the sales offers of my farm business support products. Examples include the Excel-VB Ration Formulator, its accompanying Feed Formulation Handbook, my Excel-VB Poultry Farm Manager and other information products on sale at www.lulu.com/sdaproducts!

But it’s been a long – and difficult – journey, especially to succeeding in selling my Excel-VB software, starting-up from a Nigerian market legendary for software piracy and abuse of intellectual property: a VERY hostile environment indeed!

I have LOTS of true stories to share on the challenges – seen and unseen – that I’ve had to overcome to survive, and ultimately begin to flourish like I do today. It took lots of unconventional thinking and creativity based on painful experiences and deep reflection to find a solution suited to my situation!

For instance, I’ve had employees of clients inform me that their bosses hired “expert” others to try hacking my spreadsheet software. Yep: my own client so badly wanted to avoid paying me call-out fees for maintenance/update of my software, that he invited supposed “experts” from elsewhere to try making the changes he wanted!

And THAT is just one of many examples I tell you.

I have seen – and heard – all sorts. It takes being a Ninja of sorts to function as a provider of creative intellectual solutions in the Nigerian market – especially when it has to do with SOFTWARE!

Apart from worrying about your work being stolen, a more serious challenge is getting paid ENOUGH to make it profitable to practice your software development service as a business.

Now, in my case, as I’ve explained elsewhere, when I started out NO ONE was doing anything remotely resembling offering custom commercial spreadsheet software for sale to individuals or organizations.

I literally created the market for myself as an Excel-Visual Basic for Applications Developer in Nigeria.

What made it easy was the fact that I had enjoyed great success developing business solutions that worked in a world class environment, while working in a large corporate multinational.

The experiences I had while I was there, convinced me that such solutions would be needed by others. It took me time to find them, but I eventually did, and after some years, I narrowed to the most profitable niche to serve.

Several articles I’ve written in the past (see bottom  of this article) feature true stories I’ve narrated, about how my self-taught ability to use spreadsheet programming to solve real life data recording, analysis and report generation for decision making problems in the different departments I worked.

The time, effort and money saving benefits delivered by the custom apps I built, in my spare time as a trainee brewer rapidly earned me a reputation as a problem solver – catching senior management attention at the corporate level.

That eventually led to rapid career advancement opportunities coming my way, so that in less than 6 years I’d earned promotions, and acting assignments at senior management positions well ahead of my peers.

But the workload, and the dreams I had of using my skills to serve a wider and more varied audience made me sure I needed to free myself from the restrictions of a 9 to 5 job.

So, I did my best to prepare for and eventually launch my entry into the world of self-employment.

Today, 15 long years later, my established name/brand recognition and accomplishments speak for me.

I enjoy positive attention from stakeholders in the various markets I serve, for the solutions I provide – especially my custom Excel-VB software development service, as well as my Custom Web Marketing Systems (WMS) Development service.

In case you wonder about the latter (i.e. WMS), it is what empowers me to market the former, in a manner that gets total strangers to send me payment for the growing library of performance improving products and services I offer via TayoSolagbade.com.

In other words, I find and win over buyers for what I sell, by using my unique WMS at low to zero cost. It took me YEARS to develop this system and make it work for me.

That’s why I offer to help clients develop their own unique/custom WMS to sell their own products/services at less cost, in less time and using less effort like I continue to do!

I settled on the WMS strategy after about 8 to 10 years of working face to face and on-site with clients, especially within the Nigerian market, and seeing that I was making less financially and emotionally rewarding progress than I believed was possible.

Indeed I found myself serving clients with my heart and soul, working round the clock like I did on my corporate job, to deliver solutions that worked and saved them money, time and effort – only to end up getting used and dumped, or manipulated one way or another.

There were exceptions i.e clients that treated me with consideration and respect. But they were few and far between.

Most times I found myself unable to reconcile my invested time and effort with the monetary compensation I got from majority of clients I served.

All of this happened despite the fact that I diligently served in line with the 10 item code of ethics I’d found online.

That code of ethics (click to read about it here) made it imperative that I ensure the client’s satisfaction at all times.

But after reflecting on my situation back then – especially after extricating myself from the “grip” of a particularly abusive client, in 2011, I realized that Pierre Le Clerc, who had conceived the original code of ethics I’d adapted for my use, had had a different experience from mine!

It struck me that the elderly Excel-VB Developer based in Canada, who I’d “borrowed” the code of ethics from, had conceived it for a market in which he was assured of a relationship of mutual respect and consideration from majority of his clients.

People tend to behave themselves MORE over there, compared to what happens in Nigeria.

Reflecting on my experiences over more than 8 years (doing business as “CB Solutions”), it was apparent that I could not boast of being in such a market, in Nigeria.

So, I resolved to CREATE for myself, a system that would protect my interests as a provider keen to do what Le Clerc did, without suffering the kind of abuse and exploitation I’d been exposed to in the past.

That decision led me to refine my marketing and solutions development techniques to what I use today, and on which my Web Marketing System is based.

This has enabled me, for over 4 years now, to work 100% remotely via the web, to repeatedly and SUCCESSFULLY deliver my growing library of solutions to a global paying audience.

In other words, I have evolved to a system that makes it possible for me to PLEASE my clients, in a manner that earns me great rewards, of the kind I cherish financially as well as emotionally.

Central to my continuing success has been the diligent use of the 10 item code of ethics I adapted from Pierre Le Clerc’s website – and which I described in yesterday’s post (click to read).

Related Articles

1. Creating Demand for Custom Automated Spreadsheet Software Solutions in Nigeria/Africa (True Story by Tayo K. Solagbade)

2. 1 Hour Talk(No. 5): Proven Strategies for Using MS Excel to Boost Employee and Company Productivity

3. How I Built a Bank Transactions Monitor (BTM) ™Excel-VB Driven App as a Gift for a Client in 2006 [Another Example of Real Life Problem Solving with Excel-VB]

4. Achieve Business Success Using Spreadsheet Data Analysis & Reporting Automation

5. What is Excel-VB?

6. Difference between Visual Basic 6.0 and VBA

7. Get Novice Proof Custom Automated Spreadsheet Software [Hint: From Tayo K. Solagbade – a Multidisciplinary Provider Guided by a Code of Ethics That Protects YOU!]

Get Novice Proof Custom Automated Spreadsheet Software [Hint: From Tayo K. Solagbade – a Multidisciplinary Provider Guided by a Code of Ethics That Protects YOU!]

Today, I enjoy the privilege/benefit of being able to win buyers for my custom Excel-VB driven software from within and outside Africa.

Working 100% online to get found using a unique Web Marketing System I developed for myself, I continue to convince total strangers to send me payment for my custom automated workbook applications.

It’s however been a long – and difficult – journey getting where I am now – especially starting-up a software solutions development business, as a complete NOBODY, in a Nigerian market notorious for reckless software piracy and abuse of intellectual property: a VERY hostile environment indeed.

Yet I did it. Though it took lots of hard work and endurance.

What I did and why I did it, is explained in the special report I will publish on my SD (Self-Development) Multidisciplinary Nuggets blog tomorrow – 3rd March 2017.

Go to www.tinyurl.com/tksxlvbNigeriaStory from 6p.m or 3/3/2017 (That URL will NOT be active until then).

I outline 10 elements of my code of ethics below – noting that anyone, including YOU, can successfully adapt them for use in paid or self-employment/business.

In my case, this code has guided for YEARS me in relating successfully with ALL clients I provide my multidisciplinary range of solutions.

Purpose: I aspire to provide flawless service that will make my clients feel good about investing in me, and even brag to others about what I’ve done for them.

To do the above, I ALWAYS strive to be as flexible – and response – as humanly possible to the needs and circumstances of EACH client – in line with the following code of ethics:

Article 1: The well informed – and profitable – client is always right.

Article 2: If the client is not well informed, I haven’t done my job.

Article 3: The services/products I provide answer to the needs of the client.

Article 4: I don’t do “miracles” and I know when to say “NO”.

Article 5: I haven’t been hired to prove that I am smart, but to be useful.

Article 6: My services/products enable the client master the use of computer and/or Internet technology to run his/her business operations, and not the other way round (i.e. my solutions do NOT overwhelm or intimidate my clients!)

Article 7: If the client feels stupid or thinks I am “God” there is something very wrong going on.

Article 8: What I do, the client could do, if s/he had the time and training.

Article 9: My services/products are public and I have no secrets.

Article 10: When I leave, the client who is interested is empowered.

*Adapted from Code of Ethics developed by Pierre Le Clerc, Excel-VB Developer

tks-xlvb-code-ethics-flyer

Email: tayo at tksola.com

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

Twitter: @tksola

Facebook: www.tayosolagbade.com/fbk

Excel-VB Club: Facebook.com/groups/736287616508718/

Tayo Solagbade | Best Practice Farm Business Support Specialist; Founder of the Excel Heaven Visual Basic Automation Club and Competition; Creator of the 9 Component Customisable Web Marketing System (WMS)

Related Articles

1. [TRUE STORY] He was NOT smiling when we met, face to face, for the first time, today – because of My Excel-VB Poultry Farm Mgr!

2. PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 1 of 2 | Based on a True Story

3. Tayo Solagbade’s Excel-VB Poultry Farm Manager – Video Interview With Lagos Farm CEO After Problem Resolution [PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 2 of 2 | Based on a True Story]

 

[RECOMMENDED] 15 Negotiation Tips From People Who Always Get Their Way | The winning secrets of master negotiators

[Quick Take-Away: This article is a gold-mine of information. For me, the experience based tips in it confirm the most important point I always emphasize to people about negotiating – which is that is NOT the same as “haggling”. The former involves people interacting based on empathy, while the latter is typically driven mainly by win-lose, selfish interests.]

===

15 Negotiation Tips From People Who Always Get Their Way

Negotiating can be intimidating. Uncomfortable. Even embarrassing in some cases.

Related: 9 Smooth Negotiation Techniques That Never Fail

Inveterate negotiator Niraj Jetly concedes that he can reach that extreme. “I think my son is embarrassed when I negotiate,” says Jetly, chief operating officer of NutriSavings, which helps companies educate employees about healthy eating. But that won’t stop him. “My only unconquered frontier is negotiating the college fee. I plan to try. We’ll see if I’m successful.”

Jetly learned negotiation techniques at Harvard Business School but found that taking the techniques into the real world was a whole other learning curve. Outside the ivy-covered walls, Jetly quickly realized even the best techniques won’t work unless administered in an environment of empathy. “It’s about building trust, nudging people in the right direction, and giving people space to move at their own pace.”

 Continue reading…

http://www.success.com/article/15-negotiation-tips-from-people-who-always-get-their-way

Tayo Solagbade’s Excel-VB Poultry Farm Manager – Video Interview With Lagos Farm CEO After Problem Resolution [PII 055: To Succeed Even When Things Go Wrong, You Need Mastery of Your Craft – Part 2 of 2 | Based on a True Story]

In this second and concluding part of yesterday’s newsletter, I feature the FULL video interview (with the verbatim text transcript). I recorded it with Thompson Obuseh, a Lagos based Poultry Farm CEO, after I’d resolved a major part of the “Compile Error” problem he’d been having, for 4 days with my Excel-VB Poultry Farm Manager on his 64-bit laptop computer.

Preamble/Background

On Sunday 26th February 2017, between 10:45 a.m. and 3p.m, I spent time with a young Poultry Farm CEO named Thomas Obuseh. It was the first time we were meeting face to face, in the flesh, since he first made contact with me on phone back in August 2016.

I’d made him an offer then which he’d not taken up. Then on Tuesday 20th February 2017 he’d called in at about 8a.m and 24 hours later, he’d made payment to take up a new offer I made to him.

However, over the next 4 days after I emailed him a personalized copy of the software, he had NOT once succeeded in making use of it, due to a nagging “Compile error” message it kept throwing on his Laptop.

I tried to support him remotely, to no avail. He was understandably disturbed – & even expressed doubts that the app worked!

To resolve the problem, I invited him to meet me in Ikeja, made upfront payment to his bank account to cover to/fro fueling of his car from his Victoria island based, so I could solve the problem – and prove that my app worked!

By the time we were done, I got him to take a photo with me and also recorded THE testimonial video you’re about to watch, of him sharing his feelings and observations about what had been done, and the experience he’d had using the app, in the few hours he’d used it.

Read Issue PII 055 of my Performance Improvement Ideas newsletter published yesterday Monday 27th February 2017, for details of how I identified the code module declarations (for Windows API calls I used in my app) that new requirements needed me to adding the PtrSafe attribute highlighted in the error message to.

1. Read this video’s text transcript below, and the full story about what happened here

2. Watch 16 step-by-step User Guide Video Demos at www.tinyurl.com/15pfmVideos

3. You can contact me using the form at www.tayosolagbade.com/contact.htm

The PFM has been proven to work in Excel 2007 up to 2016 without ANY problems – and this is captured in video demonstrations.

The problem Thompson had is more of a rare exception, than the norm. Thompson himself estimated there will probably be only 1 in 50 buyers I would encounter with his kind of peculiar situation, in which his laptop is always plugged into the corporate network where daily automatic updates happen to its Windows and Office installations.

An Excel-VB app like mine, meant for private use by the owner, when run on such a laptop would be encounter restrictions designed to prevent unauthorized apps with potentially malicious code from running without limitations on it, since it could infect other PCs on the network if it was a virus.

In case you’re not aware, Excel-VB code has been successfully used to create harmful virus applications that have caused major damage in the past.

This is the reason why Thompson’s 64 bit laptop settings were stricter than those on other 64 bit computers I’d seen my app run on before meeting him.

Read Issue PII 055 of my Performance Improvement Ideas newsletter published yesterday Monday 27th February 2017, for details of how I discovered I needed to make changes in the code module declarations (for Windows API calls I used in my app) by adding the PtrSafe attribute highlighted in the error message.

Below: Verbatim Text Transcript  of the Video Testimonial Interview with Thompson Obuseh which I recorded with him, AFTER we were done

Tayo: Right. So I’m speaking with Mr. Thomas. How do you pronounce your surname again?

Thompson Obuseh: It’s not Thomas actually. It’s Thompson Obuseh.

Tayo: Okay Thompson – sorry! Apologies for that. Okay, I know when we met this morning, I could see smoke coming (from your ears)

[Both laugh]

Tayo: So, so…maybe I should show my face [Camera turns to briefly show Tayo’s “mug” :-)]

Tayo: This is me O, guys Ehn! [Camera returns focus to Thompson]

Tayo: Now, it’s been a long time since I did a video, but I want to do this because this relationship has happened and I’m happy about the way we ended it. So ehm Thompson, we’ve had a session – about 2 hours right…probably more than that?

Thompson Obuseh: More like 2 hours

Tayo: More like 2 hours. Okay and ehm Thompson came (driving) all the way down from Ajah

Thompson Obuseh: Yes. It’s even beyond Ajah sef. Abijo – that’s where I stay.

Tayo: Oh really?

Thompson Obuseh: Yes, I stay in Abijo. I just dey say Ajah because…

[Video cuts off due to run down of my workhorse Blackberry Smartphone’s battery]

Luckily, I’d gotten my 18 year old son to lend me his Gionee E3T Smartphone as a backup in case that happened (Experience having taught me well in the past!).

So, about 2 minutes later, we started the interview all over again – but only after I’d gotten Tom to teach me how to use the touch screen interface of the phone.

By way of interest, I am yet to embrace those kinds of devices due my bias for the key based use of mobiles. As a result, my kids use cooler looking and more expensive mobiles than I do! Why? Well, that’s a subject for another day.

====

Tayo: Just a minute O. Okay. Alright, so ah, this is Mr. Thompson Obuseh. Ah I was just making a comment that when we first met, after I got directions to get him down to this place in Omole Phase 2, I’m serious, smoke was coming from his ears

[Both laugh]

Tayo: We had been on phone for 4 days or 5 days sef, and it was not funny. He was getting compile errors from the Excel-VB Poultry Farm Manager, and me I could not understand where compile error was coming from.

Anyway, long story short, I had to direct him to meet with me. You know, we were all blowing grammar on the phone.

I said “Let’s just meet and sort this thing out once and for all!”

Ah, he’s going to speak now. We’ve finished…we’ll we’ve gotten some things started. At least we have sense of direction and I just want him to comment on how he feels NOW!

[Both laugh]

Thompson Obuseh: Well, I’m a lot (better) because I invested some amount of money and I was not getting results. Like every customer

Tayo: Naturally…

Thompson Obuseh: Yes. Naturally, like every customer if you don’t get service for what you have paid for…

Tayo: You start wondering…

Thompson Obuseh: Yes, you have to wonder. But now I think there’s a sense of direction. He’s been able to resolve let’s say 50% of the problem. I can now use it, but the others as they should come up, he promised to fix them.

Tayo: Yeah. Okay, good. And eh, what would you say in terms of, how do I put it now, the application itself. How easy it is to relate to? How to you find it?

Thompson Obuseh: Ah, from what I’ve seen, just like I saw online, I think it’s good…the interaction is perfect. You just need to have the basic knowledge of Excel just to use it. Yes. You can interact with it excellently.

Tayo: Right, so this is me speaking. Let me show myself [Laughter]

Thompson Obuseh: You can show yourself

Tayo: Yeah, you told me about how to do it, but you know, me and this thing, you guys are seeing us abi? [Laughter]

Tayo: Okay so, we’re  making fun of ourselves now. It turns out that Thompson’s wife speaks French and teaches French. So, since I speak French, that’s another dimension to the whole thing. Anyway but it’s been a useful experience for us today, and ehm I’m sure we’re gonna sort this out to final point. And then I’ll be using Thompson’s version for any other person that comes with this wahala of compile error. I just carry am throway – “Take, no disturb me!” [Laughter]

Thompson Obuseh: (Jokingly) Well, it’s good. maybe you just have to give me some commission

Tayo: Yeah, no…we’re going to…what we’re even going to do is, this video, we’re going to say, without Thompson coming up with his compile error thing, I wouldn’t have had a need to come and look at it and actually meet…I cannot remember when last I met with anybody. Because I’ve been selling and people are just using it, and we talk, and they say I’m made entry, I had this…plotted this chart…

So when this happened…he rightly pointed it out, I don’t disagree, that having the opportunity to do this has created a new dimension in terms of level of users. Because there are some users who will have this problem he’s having and we’ll be able to have an answer for them.

Thompson Obuseh: Instant answer. Once he’s just…say don’t worry, this is what we’ll do.

Tayo: Yes, no need to asking questions. Just say “Oh, that’s the problem you’re having? here is the solution! We’ll call it “The Thompson Solution” {Laughter]

Tayo: Alright, cheers men

Thompson Obuseh: Alright, bye bye.