[Recommended Resources] Stop Chasing Sales and Start Providing Value or Lose to Price – By Jeffery Gitomer

Jeffery Gitomer is a guru in sales from USA who influenced my use of article marketing a lot when I was struggling in the early years of my business.. In this article I feature examples of how he uses his Youtube channel (and how Google LOVES to shown them) and his book (the Sales Bible) etc

 

I continue to borrow some ideas from the way he operates to build to develop and implement Web marketing for you.

 

For now, here are links to some of his stuff’;

 

<H3>1. The Sales Bible – Jeffrey Gitomer</H3>

 

 

<a href=”http;//www.gitomer.com/­products/samples/­Pages-from-Sales-Bibl­e.pdf” target=”blank”>http;//www.gitomer.com/­products/samples/­Pages-from-Sales-Bibl­e.pdf</a>

 

Practical sales information you can read daily and use immediately. Read it from cover to cover. Open it anywhere and learn.

 

<H3>2. Jeffery Gitomer in PDF</H3>

 

This is a Google results page for the string “Jeffery Gitomer PDF”

 

<a href=”https://­www.google.bj/­search?q=jeffrey+gito­mer+pdf&oq=jeffery+g­it&aqs=chrome.5.69i5­7j69i59j0l4.7679j0j7-&sourceid=chrome&es_­sm=93&ie=UTF-8″ target=”blank”>https://­www.google.bj/­search?q=jeffrey+gito­mer+pdf&oq=jeffery+g­it&aqs=chrome.5.69i5­7j69i59j0l4.7679j0j7-&sourceid=chrome&es_­sm=93&ie=UTF-8</a>

 

 

<H3>3. Jeffrey Gitomer’s Sales Training Channel – YouTube</H3>

 

<a href=”https://­www.youtube.com/user/­BuyGitomer” target=”blank”>https://­www.youtube.com/user/­BuyGitomer</a>

 

<H3>4. Jeffery Gitomer on Youtube

</H3>

 

https://­www.google.bj/­search?q=jeffrey+gito­mer+youtube&oq=jeffe­ry+git&aqs=chrome.4.­69i57j69i59l2j0l3.79­87j0j7&sourceid=chro­me&es_sm=93&ie=UTF-8

 

<a href=”https://­www.google.bj/­search?q=jeffrey+gito­mer+pdf&oq=jeffery+g­it&aqs=chrome.5.69i5­7j69i59j0l4.7679j0j7-&sourceid=chrome&es_­sm=93&ie=UTF-8″ target=”blank”>https://­www.google.bj/­search?q=jeffrey+gito­mer+pdf&oq=jeffery+g­it&aqs=chrome.5.69i5­7j69i59j0l4.7679j0j7-&sourceid=chrome&es_­sm=93&ie=UTF-8</a>

 

This guy built a reputation for writing 300 to 400 word articles. Short but full of practical, ready to use wisdom. Notice his unusual dressing in the videos.

 

<H3>A critic in one of the video comments (<a href=”https://­www.youtube.com/­watch?v=fTFhHY4YUqo” target=”blank”>https://­www.youtube.com/­watch?v=fTFhHY4YUqo) went as far as saying:</H3>

 

====

Sennanchie3 years ago

Funny. He’s an experienced salesman with a lot of good advice, but he always dresses like he’s a mechanic.

=====

 

Funny how some people tend to leave the substance and chase shadows.

 

For Gitomer to have achieved the amazing success he enjoys, anyone can see that his dressing did little or no damage to him – because he PRODUCED results that mattered to those willing to pay him for it…looool!

 

PII 013: Sometimes When Your World Feels Like it’s Falling Apart, It May Actually be Evolving to a New Level of Success [Hint: Why Burning One’s Bridges Works Better In Pursuit of Success]

Recently, I read a write-up by a coach advising against taking risks in starting a business, without having a safety net in place first.

He argued that it would be wiser to hold on to some safety net (like a job) until your new venture takes off fully and you’re certain it will stay up, giving examples of well known individuals, who in his assessment made use of such safety nets to secure their successes.

Now, I do not disagree that it pays to take precautions and setup plans to fall back on in case things go south in the venture you embark on.

That’s just common sense!

What I simply did not agree with was the manner he presented the idea of following one’s dream by burning one’s bridges.

SCROLL DOWN TO READ FULL ISSUE

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

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

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 013: Sometimes When Your World Feels Like it’s Falling Apart, It May Actually be Evolving to a New Level of Success [Hint: Why Burning One’s Bridges Works Better In Pursuit of Success]

Recently, I read a write-up by a coach advising against taking risks in starting a business, without having a safety net in place first.

He argued that it would be wiser to hold on to some safety net (like a job) until your new venture takes off fully and you’re certain it will stay up, giving examples of well known individuals, who in his assessment made use of such safety nets to secure their successes.

Now, I do not disagree that it pays to take precautions and setup plans to fall back on in case things go south in the venture you embark on.

That’s just common sense!

What I simply did not agree with was the manner he presented the idea of following one’s dream by burning one’s bridges.

He made it look like there was often more to be lost than one could ever hope to gain.

It is however my considered opinion that nothing could be further from the truth. I say this from 14 solid years of building a business from scratch, while struggling BADLY to support my wife and kids – after burning all my bridges to achieve the growing success I enjoy today.

I argue below, that that those who go for their dreams without assurance of a safety net, often emerge better rounded and more competent, than those who lean on safety nets to get to the top.

This is because they get forced to dig deeper than others who operate in the secure knowledge that they have a safety net to fall back on. As a result, they end up having more staying power to remain at the top for the long term. In contrast, persons who use safety nets tend to lack the “steely” quality needed to deal with and overcome inevitable setbacks – hence they tend to stay small and play safe.

History attests the veracity of the above statement. Those who had to pursue success under swim-or-sink circumstances are the ones noted for exceptional accomplishments that most others find hard to imagine themselves doing.

I happen to have met and worked closely with people belonging to both groups. Guess what? Those who get there without safety nets often have better quality advice to share!

Exposure to suffering happens in degrees, and the ability of each person to persist in pursuit of his/her goals despite the suffering, ultimately determines how successful s/he becomes.

This is why we have entrepreneurs who are able to bounce back to higher levels of success no matter how many times they encounter setbacks or failure. Those who muster the courage to go after what they want even when they have nothing to fall back on are often those who develop such resilience.

Not just that, they are also often those who help society to take badly needed quantum leaps in terms of development or advancement, using the solutions they discover in the process of battling to find ways to escape the prolonged suffering they find themselves confronted with.

Take it from me as one who has been there many times.

If I had had anything to fall back on during a major part of the past 14 years of building my brand as a provider of custom Excel-VB software in a market that it did not previously exist, I would NEVER have gained the insights I used at this stage where I get buyers from different part of the world PERSISTING in reaching out to me.

The thousands of lonely hours I spent thinking (and thinking and thinking!) of how to build Excel apps that people would buy, and how to do my marketing to the right people with as little money as possible, are what led me to develop apps that today earn me income from within and outside Africa.

Is it possible for a soldier to go through training in the military academy without being made to face and learn to deal with pain, hardship, deprivation and even some form of suffering?

How would such a soldier fare in the battle field over weeks and months as happens during real time war?

What about an athlete who wants to win a medal at the Olympics?

Will taking it easy when s/he feels the pain is getting too much really get him/her to the point where s/he can really stand a chance of winning?

The answers to the above are obvious!

“Every adversity carries with it the seed of an equivalent benefit”

Napoleon Hill made the above statement in his book, noting that it is often up to the person undergoing the adversity to search for, find and take possession of that benefit.

Let me tell you this dear reader. I do not know how you came to discover this website or how long you’ve been reading my stuff, but what you see here is a product of YEARS of undiluted and unwavering persistence in the face of great suffering and major deprivation.

Like I said in a past article, even though I now enjoy growing success and recognition for what I do today, I continue to work on my brand as if nothing has changed.

I still write original articles virtually everyday on this blog – and that is despite doing same for clients who have hired me too ghostwrite for them.

Not just that, I have several groups of clients that I write and publish learning resources for every week.

On top of that, I provide one on one coaching as I travel, while responding to buyer requests for product information,; and providing support to users of my software.

So many times in my journey to success, while doing the above, I repeatedly experienced peaks and troughs i.e. progress and setbacks.

Quite often when the latter happened it felt like my entire world was falling apart. In the early stages I wanted to run into hiding from the resulting embarrassment.

But because I had no safety nets, there was never any place to run to, so I was forced every single time to confront my demons (figuratively speaking) and exorcise them.

Click here to read a PDF in which I shared examples of several painful experiences I had during those years of struggle. It was so bad I began to call myself the Bambiala of the Solagbade family.

The result of all that suffering, and my relentless persistence in refusing to give up, was that I developed new and better skills, got more competent, while learning to weather the storms of adversity whenever they occurred.

Today, I tell people all the time that it is virtually impossible for anyone to know if I have a problem, no matter how bad it  is, if I do not tell them. That is how much control I have over myself.

The best part is that my exceptional proficiency now makes me get valued virtually everywhere I go, in a way that continues to help me make more money – AND SAVE lots of it too.

True Story: An example of the latter benefit i.e. saving money

Over the past 3 weeks I have been using the Internet here in Cotonou, in a cyber café whose owner was so impressed with my knowledge and skills in Web Marketing that he’s given me an unlimited 24 hour Internet browsing account, as part payment for my Web Marketing coaching.

Considering the fact that I spend over 10  to 18 hours per day most days in cyber cafes here at about 0.5 US dollars per hour, the savings I’m making are quite hefty!

tks-sympo

Another True Story (Coming soon):

In a few months from now, I will share details of a true story of something that happened to me about 4 weeks ago, that should have ruined me completely, but which I have used as a stepping stone to open multiple doors of new opportunities in my business that I never even thought possible.

Up till now, I have told very few people, and even fewer know the full extent of the devastation visited upon me i:e I’ve deliberately not told “everything” to everyone.

So just stay tuned and I assure you that you WILL be inspired!

There were many times when I was making little or no sales, and frequently had to go borrowing to meet basic needs in providing for my family.

Yet that psychological situation challenged me to look deeper at what I was doing and how I was doing it, until I discovered unique insights to progress towards my goal.

Today, clients and other persons who encounter me often ask me how I got to be so proficient at many things I do, and I readily tell them it was my exposure to prolonged suffering in which I had no means of escape, that forced me to develop that level or rare competence.

The best part is that I have gotten so good at doing it all; and NOT failing to meet any client deadlines to satisfaction, while still creating quality time to give Best Practice Parenting for Personal Success Achievement to my kids.

Most recently, they began producing their own range of home baked cookies, chin-chin, bread and African Pizza, using our trademark no-oven charcoal stove baking system. Check out their Facebook page here.

I mention the above not to brag, but to illustrate how the lack of safety net I had to endure helped to mould me into a much more productive person than I could ever have become, if I had NOT followed that path.

So here’s a tip: When you know in your mind that you have something you can go back to if what you’re about to start fails, THAT awareness becomes your inevitable psychological Achilles heel. Once you get to a point in your venture or journey where you feel you can’t go on, the seductive thought of retreating to the comfort of your safety net will find a way to the surface.

And that will weaken your resolve to continue, keeping you from staying hungry enough to continue pushing to succeed. Just like it happens when one exercises the muscles, if you stop when you start feeling pain, you end up with no gain in muscle mass. Hence the popular saying: No pain, no gain.

“I don’t count my sit-ups; I only start counting when it starts hurting because they’re the only ones that count.” ― Muhammad Ali

It goes without saying that not everyone will be willing to go this zero safety net route, however I will point out that every single human being has within him/her the capability to do so. S/he only needs to be willing to do it.

But if you really want to achieve exceptional success, that will make you stand out in any area of endeavour, this route is likely your best bet.

Napoleon Hill’s Think and Grow Rich explains how to go about doing it.

NB: Bear in mind that some of the world’s most accomplished achievers attribute their success to following the advice contained in this little book!

Here are some excerpts you will find instructive…

Burn all your bridges behind you!

Stake your entire future on your ability to get what you want:

Leave yourself no possible way of retreat:

Cut all sources of retreat:

You have to win or perish:

Get a copy of this wonderful book, and read it as many times as it will take you to internalize all the wisdom it offers. That’s exactly what I did, and I’m better off for it!

The quotes below further underscore the importance of the points I’ve made in this piece:

…we rejoice in our sufferings, because we know that suffering produces perseverance; perseverance, character; and character, hope.” (Romans 5:3,4, NIV)

“The strongest steel is forged in the hottest fire. The strongest character is molded in the most difficult circumstances. Most of God’s greatest leaders endured long periods of suffering as they were shaped and honed for the work ahead. When the pressure mounts and the heat rises, keep your eyes on the prize. When the molding process is over, you may find that you can do more than you ever thought possible…and that God can do more with you than He has ever done before. “ ~ Mark Phillips

Final Words: I honestly believe some people who should not be coaching others are finding ways to get certified to do just that today.

Technology, especially mobile/PC and Internet technology,  have made the business of training and accrediting coaches more and more a matter of dishing out electronic content; with minimal attention being paid to the personal attributes and experiences the prospective coaches possess.

The result is that we have some people offering coaching advice and counseling based on what is at best a shallow foundation of real world relevant insights and wisdom. Indeed, some coaches today betray their own lack of depth and self-belief through advice they give.

Ultimately, the best coaches will often be those who have qualitative life experiences and real world relevant research based knowledge and insights to share.

Unfortunately, in today’s digital world, it can be hard to tell such coaches apart (especially for the prospective coaches) from others!

I do not mean to cast aspersion on anyone, but the truth is that many of those guilty of what I’m saying here are unknowingly doing damage to those who trust them enough to learn from them.

SDN Blog

New posts from last week*

Monday:

 

[Tuesday]:

[Wednesday]:

[Thursday]:

[Friday]:

Advertise Your Products and Services on Tayo Solagbade’s Buyers-Meet-Sellers Platform for Agro based businesses – and others!

[Saturday]:

Succeed More by Using the Web Creatively [Features True Story]

 

 

[Sunday]:

To Succeed in Spreadsheet Programming You Need Sound Understanding [Hint: Do You Know Where New Excel-VB Macros Are Stored?]

 

THE FARM CEO (Issue 46 – Exclusive Offer): Send in Your FREE Advert details for LIFETIME publishing on my Buyers-Meet-Sellers Platform for Farm Businesses & Others!

 

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

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

 

THE FARM CEO (Issue 46 – Exclusive Offer): Send in Your FREE Advert details for LIFETIME publishing on my Buyers-Meet-Sellers Platform for Farm Businesses & Others!

This offer is exclusive to members of my Cost-Saving Farm Business Ideas Club and clients in other fields.

 

A few days ago I announced that my buyers-meet-sellers platform was LIVE in a blog posted (featuring 3 initial adverts for real life clients) at http://tayosolagbade.com/sdnuggets/advertise-your-products-and-services-on-tayo-solagbades-buyers-meet-sellers-platform-for-agro-based-businesses-and-others/

 

Within 24 hours of publishing that post, I got an enquiry from a Facebook friend that I’ve been connected with for a few years, but never met in person. He wanted details about the English LLB Law course offered by UPIB (International University & Polytechnic of Benin). Read the full story at <a href= “http://tayosolagbade.com/sdnuggets/succeed-more-by-using-the-web-creatively-features-true-story”>http://tayosolagbade.com/sdnuggets/succeed-more-by-using-the-web-creatively-features-true-story</a>

 

Even I was surprised, and I told my client so when I informed him about the request and got his consent to give the enquirer his contact details.

 

It’s now time for me to create ads for the rest of you who are my clients. All you need do is send your advert information to me in the format shown for current participants on the page at http://tayosolagbade.com/contact-buyer-seller.htm.

 

<b>Fill and submit your full contact details, with specific information for the ad you want published, using the form on the page linked above.</b>

 

I wiil setup a general marketplace page for all my clients where these ads will appear automatically. Note that they will remain FREE for you as my client and will therefore never expire or stop being visible on that page..

 

<h3>One suggestion: Get a website or even a web page</h3>

 

Lack of a functional website and online presence can severely limit your ability to reap full benefit of the exposure this FREE advert will give your company.

 

I suggest you get a website built or at least setup a sales page online.

 

Alternatively, if you wish I can offer you an extension of my 1 year Web Marketing Support promo which expired last December.

 

See details at

 

http://tayosolagbade.com/smclub-nonfarm.html

 

<h3>Get Started!</a>

 

Fill and submit your full contact details, with specific information for the ad you want published, using the form provided at

<a href= “http://tayosolagbade.com/contact-buyer-seller.htm” target=”blank”>http://tayosolagbade.com/contact-buyer-seller.htm</a>.

To Succeed in Spreadsheet Programming You Need Sound Understanding [Hint: Do You Know Where New Excel-VB Macros Are Stored?]

[NB: This is a tutorial note created for members of my Excel Heaven Visual Basic Automation Club – but left open without password protection for viewing by interested non-members]

You’ve been using MS Excel and the Visual Basic Editor for some time now, since we started this series. I am quite aware that it is NOT easy for most of you to make sense of some of the new stuff being presented to you.

However, I want you to know that the human mind is very powerful and regardless of your background, you CAN learn to do ANYTHING you set your mind to.

In the course of developing myself in various fields of interest as a Multpreneur, starting from my 7 year stay in Guinness Nigeria, up till today as a Location Independent Multipreneur, I have discovered that DELIBERATE REPEATED exposure to ANY subject matter is a GUARANTEED way to develop familiarity with it, and ultimately proficiency IN IT.

Just keep going at these tutorials, and sooner than later, you’ll start wondering why you ever thought it would be hard to “get it”. Remember I’m ready to help anytime  :-)

When I first encountered spreadsheet coding sentences in Lotus 1-2-3 macros written by an expatriate boss I had during my graduate training in Guinness in 1995, they looked like total gibberish to me!

But the results I saw them produce in form or automatic data handling and reports/charts generation, even to the point of printing without prompting, I KNEW I wanted to be able to control the spreadsheet application in that manner too.

My motivation stemmed from the fact that I hated the way many of the senior colleagues I was working with used manual calculators for hours, sometimes days, to prepare reports to be used for decision making.

Not only was it stressful for the person preparing the report, it was also a process fraught with risk of avoidable calculation errors arising from such stressful conditions under which it was being done.

I did not want to work that way.

Luckily for me, my expatriate boss, being the Training Coordinator, had a vision to influence a change in the way formal management reporting was being done in the company, using his apps.

One day we got talking about how spreadsheet automation he did could save time, effort and minimize errors, and he looked at me say “You can change the way things are done using this method.”

THAT day my mind was made up. I became a new man, and began sitting with him to watch as he worked, whenever I had free time.

Less than a year later, I was solving spreadsheet automation problems in Guinness Benin Brewery Edo state, where I was assigned.

In the years that followed, up until I quit the company to develop custom spreadsheet software for a living (as I do today), I built a reputation across the company for building custom apps (without being asked) that eliminated paper based data recording, analysis and report generation.

Among other benefits, my apps boosted productivity and made the lives of co-workers better. All of that did not go unnoticed, as I was rewarded with great career advancement opportunities.

You can achieve even better results in your workplace than I did in mine, by developing and applying your spreadsheet automation skills to the benefit your employer and/or clients.

You can do so with my help.

In my time I had NO one to look up to within or outside the company for guidance. Indeed when I quit my job in December 2001, to develop custom spreadsheet software for a living, I found no one else doing it, and many who I thought would understand told me I could not succeed with this idea of earning a living doing Spreadsheet Programming.

But what I saw happening in the Excel-VB industry in places like USA, Singapore, Canada, UK and Australia, convinced me I just needed to identify the right target audience and market;

Today, I enjoy the benefit of having done that, as I continue to attract buyers and clients for my products and development services respectively.

My success despite years of harrowing adversity and rejection derives from having a SOUND foundation in my chosen vocation.

The truth is I LOVE working with numbers and data, to establish trends, and extract meaning/insights for decision making. But I LOVE, even more being able to accelerate that process using a reporting application like MS Excel, which comes with its own in-built dynamic calculation engine.

If you want to succeed in Excel-VB Solutions Development, you need to build a sound foundation of understanding like I do

Mine has enabled me rapidly build myself up to adopt and adapt wisdom from some of the world’s foremost Excel-VB developers to create a unique range of solutions for my target audience.

A good place to start is getting a firm understanding of how Excel creates and manages macros

I’ve shown you how to use the macro recorder to record tasks you carry out as you work.

But if you do not understand how Excel creates, and manages the macros, you may have difficulty finding them as you create more in a particular workbook.

Here are simple tips to guide you:

1. When you create a macro for the first time, MS Excel will create a new code module in the Visual Basic Editor (VBE) under the Object Explorer

2. Open a new, blank workbook and press Alt+F11, to access the VBE. You will see that the” Object Explorer has not folders in it, and only the default worksheet objects (sheet1 etc) are visible there.

3. Now, click the macro recorder button and type in a name for a macro, then go to the workbook interface and type in an entry into a cell.

4. Return to the VBE, and click the STOP button to end the recording. Look into the Object Explorer and you will see that a yellow folder named “Modules” has been created there. Double click on it and it will reveal a code module named “Module 1”

5. While that workbook remains open, every single time you record a new additional macro, MS Excel will append it to the bottom of that same module 1.

6. However when you SAVE, then close and reopen the workbook, and record another macro, the macro recorder will open a new module incrementing based on the number for the last module. So if the last was Module 1, the new one after the workbook is reopened will be Module 2.

7. It is in that new module that the recorder will write all the code sentences for your new macro.

8. Note that it is not possible for you to control where the macro recorder puts your new macro. Instead you simply need to understand how it decides where to put it, as explained above, so that you can quickly easily find your macros at any point in time.

9. Incidentally, regardless of how many modules get created, you should have no difficulty locating your macros in order to edit or run them. All you need to is to call up the Macro dialog box, select the name of your macro from the list it will present you, of ALL the macros in that workbook.

10. Next week, I will discuss this with a practical example. For now, I recommend you open the workbooks I’ve sent you before now to study them based on what I’ve explained here.

RELATED

  1. Welcome to my MS Excel Heaven Visual Basic Automation Club [Introductory Videos You Need to Watch]
  2. 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!

Succeed More by Using the Web Creatively [Features True Story]

I posted a blog yesterday, featuring 3 adverts I have published on my buyers-meet-sellers platform using a plugin I found that does exactly what I want.

Like I explained in that post, the FREE advertising opportunity is for my paid clients who I have a vision to support in as many zero to low cost ways as I can.

Why?

Because my philosophy in business and in life has always been to continually find ways to make others better off from having contact with me. The Science of Getting Rich philosophy that I subscribe to advocates adoption of that philsophy, if one is to achieve authentic long lasting success in life.

The quote below captures the above sentiments perfectly:

“I have found no greater satisfaction than achieving success through honest dealing and strict adherence to the view that, for you to gain, those you deal with should gain as well.” – Alan Greenspan

What follows below are verbatim excerpts of an response I wrote to an enquiry sent to me by a Nigerian gentlman who happened to see the adverts I posted on behalf of my clients.

As shown in the screenshot below, he wrote in as follows:

Good Morning Sir,

I am interested in the UPIB law program. Is this in English? Can I please have your phone number?

olawale-screenshot-upib

To be honest, I must admit that I was not expecting anyone to indicate interest in any of the adverts so quickly – at least not within 24 hours! So when I saw the enquiry I was not quite sure how to handle it, since I hadn’t even spoken with the client about what I’d done!

Long story short, I called up the client and told him about the enquiry, then asked his permission to give his mobile phone number to the enquirer.

See the text below for the details.

I share this post to prove that it pays to use the web in creative ways to attract potential buyers. I do it for myself and get great results continually. Same happens when I do it for clients as well – as shown in this example!

Hi Ola(name partially removed for provacy),

Thanks for your message.

Regarding the Law program, YES it is in English. Incidentally there have been updates posted by the course coordinator himself about the Law Week recently on Facebook.

For example this one: https://www.facebook.com/permalink.php?story_fbid=1766500850236417&id=100006295578233

In order to give you a proper response, I first had to speak with Barrister (Dr.) Nana ARNOLD this morning, that you’re requesting details of the Law program, which he coordinates for the university as Head of Department.

He has given his consent for me to send you his mobile phone number: (removed for privacy)

You can also send him a message via his contact page on the website at:

http://upib-eng.com/index.php/using-joomla/extensions/components/contact-component/single-contact

(See attached: I’ve taken a further step to send you a photo of his complimentary card that I have in my possession, if that would be of use)

By way of interest, the university – UPIB – is a client for whom I built and have hosted the website at www.upib-eng.com since 2014.

As part of my best practice vision, ALL my clients get to feature ONE free ad on my site – hence the one you saw, alongside those for 2 farm CEO clients in Nigeria.

Dr. Arnold Nana Kouayep (https://www.facebook.com/profile.php?id=100006295578233&fref=ts)is the Founding Director of Administration and Admission for UPIB, who also happens to be a personal friend, with a private consulting firm I’ve developed various solutions for (see www.nanaarnold.com and www.globalkonsultgroup.com)

Hope this helps.

Let me know if you have any questions or require clarification. My mobile numbers here in Benin as well as Nigeria are listed in my signature below.

I hope the above story or case study excites you enough to consider investing in using the web to promote your business.

No matter what kind of business you are in, or where you are based, a well developed Web Marketing System can give help you cut your marketing costs, while generating more sales leads for you at very low to zero cost.

I LIVE this stuff – and my experiences/studies over the past decade tell me it will work for ANY business model in ANY market, if you know how to use it.

If you need help doing it, let me know!

RELATED READING

  1. You Are an “Illiterate of the 21st Century” If You Cannot Learn, Unlearn and Relearn
  2. No. 166: Seek Success by Being CREATIVE and NOT by being COMPETITIVE
  3. No. 180: 3 Key Strategies for Making Clients Want to Hear From You
  4. Stop Hurrying – And You’ll Get Anything You Want

Advertise Your Products and Services on Tayo Solagbade’s Buyers-Meet-Sellers Platform for Agro based businesses – and others!

I’m pleased to finally be able to announce that my buyers-meet-sellers platform is LIVE.

Right now, I’m using the contact details and information from businesses belonging to both groups, that I have so far obtained via the market surveys I’ve been doing on behalf of clients in Benin Republic and Nigeria.

The platform is still evolving, but already fully functional – and automated

See below, three 200 x 200 pixel size rotating image banners that I’ve created for 3 different real life clients (2 are farm businesses and one is a private university).

[adrotate banner=”2″]  [adrotate banner=”3″]
[adrotate banner=”4″]

The platform will be open for use by all my clients (in and out of Africa) as well as other businesses who indicate interest and meet the required terms of access.

This is because I intend to employ strict quality controls in running it to ensure integrity.

If you seek clients, buyers or distributors within our outside the African continent for any products, services or solutions you offer, get in touch with me using this form (click here) for details of how to get started.

 

DISCLAIMER

This is information passed to me by those who choose to advertise. Those who are my clients get FREE access to this platform.

However, you must take the due diligence action of checking and verifying whatever information you read in the ads or the linked pages I setup, especially if you choose to use it, or to make contact directly with the supplier. I do NOT play the role of a middle man.

 

How to Make Drinks You Can Sell from Pineapple Peels (Real Life Phone Coversation Session Prospective Attendee Based in Nigeria’s Abuja

Few days ago, a gentleman called me from Abuja to ask how he could come down to Cotonou to learn how to make my Pineapple peel drink.

I was quite surprised by how determined he was. He told me he’d tried making the drink at a basic level, but that he’d prefer getting the full training from me.

I sent him the details on the night of the next day. I’m hoping the prices will not scare him off lool! (Will forward the message to you. The guy is into natural herbal remedies and already makes and sells all sorts of medicinal drinks made from plants)

Below I share exceprts from the email I sent him, which contains details of the options for accessing the training

Pictures showing some stages of my pineapple peels based drink's production

peelp

Hi,

Thanks for your call yesterday – regarding the above mentioned learning event.

As promised here are the details you need to know:

1. The page linked below announces the small group On-Demand learning event I offer for a minimum of 10 persons.

http://tayosolagbade.com/boisson-tayo.html

Each attendee gets my Step-By-Step Guide PDF titled “How to Make Drinks You Can Sell from Pineapple Peels” at N7,500 (Seven Thousand Five Hundred Naira per person).

NB: Normal Price for the guide is N10,000 (Ten Thousand Naira).

In other words the training is FREE.

2. The step-by-step guide is actually based on the real-life process I use in producing the Non-Fermented version of my Pineapple Peel Based drink, which someone in Calavi (Benin Republic) named “Boisson Tayo”(French for “Tayo’s Drink”).

See details at http://tayosolagbade.com/boisson-tayo.html

3. During the LIVE event, I will:

a. Demonstrate the production process I use from start to finish

b. Explain key considerations for setting up and operating your home-based drinks production business using recommended best practices to meet World Class standards, that can even enable you export your products.

See the attached flyer for more specific details.

4. The Required Investment for YOU:

Now, since the training is to be for you alone, the required investment, based on the fee per person in the minimum group of 10 attendees, becomes N75,000.0 (Seventy Five Thousand Naira).

a. One possible way to lower that fee is to find one or more pêrsons to share it with you.

For instance, if you can find 4 other persons interested in learning, you will EACH pay N15,000.0 (Fifteen Thousand Naira)

b. Alternatively, you may wish to take up the following time limited offer, which I make as a gesture of goodwill:

Pay N60k (instead of N75k) if you make payment on or before MNT Thursday 5th May 2016, and I will come down to Lagos-Nigeria at an agreed date and venue to conduct the training for you.

This will save you time, effort and money that you would expend to meet me in Cotonou.

c. But if you prefer to come down to Cotonou for the training…

Pay N50k (instead of N75k) if you make payment on or before MNT Thursday 5th May 2016, and I will agree a date and venue for you to meet me here to conduct the training for you.

Let me know if you have any questions or require clarification.

My Pineapple Peel-Based Drinks Production Project UPDATE: Pilot Scale Shelf-Life, and Variable Cost-Reduction “Trials”

ppeelsdn

 

How Studying a Great African Achiever is Leading Me to Self-Actualization

“Va vers les gens, vit avec eux. Apprend d’eux. Aime-les. Commence avec ce qu’ils connaissent. Planifie avec eux. Construit sur ce qu’ils ont. Enseigne en montrant. Apprend en pratiquant. Ne te conforme pas, mais transforme. Ne soulage pas mais libère. Et quand avec les meilleurs leaders, le travail est fait, la tâche accomplie, les gens diront nous l’avons fait nous-mêmes”. Lao Tsu, Fondateur de la philosophie Tao, 600 av J.C.

English Translation:

“Go to the people. Live with them. Learn from them. Love them. Start with what they know. Build with what they have. But with the best leaders, when the work is done, the task accomplished, the people will say ‘We have done this ourselves.” – Lao Tzu, founder of the Tao philosophy, 600 B.C

I discovered the above wise quote through reading a publication by a great African man here in Benin Republic, whose works have inspired me since I read about an award he received way back in 1987.

That was during my first undergraduate year as a student of Agricultural Extension Services in Nigeria’s University Of Ibadan.

I was 17 years old at the time. In another 2 months from today I will clock 46.

How time has flown – almost 30 years have passed – yet this man has continued to be a leading light and inspiration to many across the world, for his works.

I constantly drew inspiration from following his progress, and often visualised myself doing something similar in my chosen area of interest.

Over the past 10 years I’ve taken concrete steps closer to achieving my dream. And I resolved that I would find a way to meet and thank him for doing what he’s been doing.

Relocating to Benin Republic in 2013 made the possibility of that happening just a matter of time.

And now it has…

About 2 weeks ago I met and spoke with him for the first time ever. The next day I ran into him again and we had a short exchange.

In between those 2 meetings I had a good opportunity to observe him from a distance as he moved around and interacted with the people. It was obvious, to me, that there was deliberate purpose in his actipns and utterances.

Later that day I got handed a document published by his organization in which I read the quote reproduced above, and had my inner eyes opened to the secret of his success.

Click here to read the page on his organisation’s website, where the quote is reproduced.

Click below to view a page with the english version of the quote, along with several other quotes by the same Chinese philosopher.

This man does not know it, but he’s been mentoring me remotely as I followed his progress, over the past 2 and a half decades.

As soon as I read this quote, I instantly knew it was what I needed to adopt to achieve the new plans I’ve been working on.

Before now, I periodically sensed a need to do what it advised but resisted the impulse each time mainly because I was not sure how to proceed.

Luckily for me, this great man chose not to be miserly in sharing the sources of his own inspiration. As a result, the rest of us benefit.

How I wish there was a way I could add value to him the way he has done to me and many thousand others who continue to benefit from the enduring solutions provided by his organisation.

For now, one way I know I can thank him is by succeeding in using this quote’s wisdom to implement my own evolving plans to start a centre that help others with solutions I offer.

PS: By the way, in case you’ve not discovered it yet, from clicking the above mentioned link to his website, this man that I have spoken so highly of in this article, is Father Godfrey Nzamujo – the Founder of the world renowned Songhai Integrated Farming centre, headquarted here in Benin Republic’s Porto Novo. He makes me proud to be African!

Marriage is Not for Everyone [You Don’t Have to Get Married to Prove You’re Normal]

Yes.

 

It is my considered opinion, based on my personal observations over the past 25 years of my adult life (16 of them as a husband and father) that marriage is not for everyone.

 

You don’t have to get married to prove you’re normal. And when you’re a high performing achiever or “genius”, getting married successfully will require finding someone who often COMPLEMENTS you, making you better than you were – and who, in doing so will NEVER feel inadequate or threatened by the success that consequently accrues to YOU in the process!

 

Henry Ford and his wife; Andrew Carnegie and his wife (as mentioned in Napoleon Hill’s Think and Grow Rich) reportedly enjoyed that kind of blissful union.

 

As a result, when fame and fortune came into their lives, they kept their partnership going strong and did not lose focus on what mattered – which was the preservation of the true love, friendship and affection they began their journey with, no matter the conflicts or disagreements they had!

 

<h3>In Nigeria I consider Tunde and Wunmi Obe (TWO) to be an exemplary celebrity couple who undoubtedly will have LOTS of useful wisdom to pass on to couples – be they celebrities or everyday married people. </h3>

 

In Napoleon Hill’s Think and Grow Rich, he expounded (in a chapter dedicated to it) on the concept he called “Sex Transmutation”.

 

That phrase, despite the presence of the ever suggestive 3 letter word in it, has less to do with the act itself, and a lot more to do with the degree to which a couple can use their “sexuality” to connect “symbiotically” on a deep emotional and psychological level, that makes them flourish and excel, seemingly at virtually anything they do.

 

Check out Tunde and Wunmi’s many hit songs, videos – as well as photos of they share of their kids/family. Check out the way they “roll” in public and how they “flow” in private (even while still in public view).

 

Then go back and pay close(r) attention to the often very instructive messages in the lyrics of most of their songs, and you will begin to understand what I mean: those two (pun intended) are in sychrony with one another: the closest thing one will ever see to a perfect marital union – especially for a celebrity couple.

 

<h3>It takes two (pardon the pun…again) to make marriage work that way. </h3>

 

Everyone – man or woman, husband or wife – can and will make mistakes. What counts is not how loudly you prove you can scream when you feel genuinely aggrieved.

 

What really matters is how far you are willing to go to protect what you have, by trying your best to repair any damage that may be done by the other party, using the “connection” you share.

 

You would do the above within reason of course (however subjective that may be). You don’t, for instance, want to make yourself a willing accomplice in unrepentant visitation of abuse (physical, emotional or psychological) on your person. This is after all the 21st century.

 

<B>Not everyone is willing to adopt this kind of attitude however, and many believe they must prove they are right, and the other person wrong, before they can let things be. </b>

 

How very wrong!

 

<h3>The worst part of it all is the misguided belief majority seem to have that there is some kind of wisdom inherent in the act of putting your private affairs up for consideration in the “court of public opinion” e.g newspapers, TV, social media etc. </h3>

 

In most cases that simply ends up messing the relationship up the more.

 

The sad part is however that they forget their loved ones (parents, siblings, unclues/aunts/cousins, friends, associates, clients, business partners and more!) will also suffer major pain and embarrassment as a result of that singular move into the public space.

 

Quite often those people would have attended the couple’s engagement and wedding events, playing influential, often visible roles – with pride!

 

Most would have received the wedding videos and excitedly played it for guests to watch and admire the couple.

 

When it all falls apart, they will want to avoid being mentioned in relation to the former love birds!

 

The simple scenario I’ve painted above proves that the collateral damage that can result from going “public” with your marriage/private issues, can be far reaching, hard to quantify or contain, and often impossible to repair!

 

<h3>Case Study: There is story of a celebrity couple’s marriage collapse currently trending in the news…</h3>

 

As far as I’m concered BOTH of them are the losers. Neither is better off – especially with the court of public opinion session they have now started.

 

They may not admit it, but the pain and embarassment is there and it will continue eating at them for a long time to come. No one will ever look at them the same way again.

 

Could they – as well as their respective fans – have been better off if they had never gotten married?

 

On the benefit of hindsight…the answer seems to be an obvious YES.

 

That’s what doing what society expects of you can sometimes do to you e.g bite you in the you-know-where.

 

But nothing is impossible – so I hope they can find a way to make up, especially for the sake of the little child between them.

 

<h3>This is why I believe – and I’ve been hammering it into the heads of all my kids – that Marriage is not for everyone.</h3>

 

You don’t have to get married to prove you’re normal.

 

Alternatives exist and we have examples in history and many today to refer to.

 

If you’re keen to do, get all the help you can to choose the right partner, then be prepared to fight to keep your marriage: YES, be ready to fight!

 

Some smart thinking women with great visions and ambitions choose to stay single, but arrange to have a child or two via what today are available as “professional services”.

 

Many end up proving to be great parents, and raising well rounded and successful kids.

 

I won’t bore you by giving specific examples. I know you can think up a few, all by yourself :-)

 

Single parent Moms and Dads can be found all over the planet.

 

Some chose the life, while others were forced into it via being abandonned by a partner or through the loss (via death) of the partner.

 

But they went on/are going on to make the most of it. So, it’s not impossible.

It may not be normal, but the risks of emotional trauma, pain and suffering are greatly minimised.

 

<h3>Not everyone can endure the B.S that staying married sometimes requires both parties to swallow from another at various times.</h3>

 

Such persons must therefore get real and consider that the marriage option is simply NOT for them: No be by force O!

 

In other words my message is this:

 

<blockquote>Unless you are damn sure you can deal with things not working out with the person you’re currently crazy and raving about, DO NOT get married to him/her!</blockquote>

 

Period.

PII 012: Succeed by Solving Problems Using MS Excel Visual Basic [How I Started Spreadsheet Programming in Guinness Nigeria Using Lotus 1-2-3 Macros in 1995, Before Discovering Microsoft’s Excel Visual Basic in 1999]

Today I enjoy patronage from buyers within and outside Africa, for my customizable Excel Visual Basic software. But the journey to this point began for me 2 decades ago when I worked as a young graduate trainee brewer in Guinness!

Back then Lotus 1-2-3’s was the industry spreadsheet application standard worldwide and it had a keystroke based macro programming language. 

Guinness had the Lotus SmartSuite installed on all its computers.

By the year 2000 however, the company rolled out MS Office installations across all its sites and relevant personnel received training to begin using it.

SCROLL DOWN TO READ FULL ISSUE

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

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

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 012: Succeed by Solving Problems Using MS Excel Visual Basic [How I Started Spreadsheet Programming in Guinness Nigeria Using Lotus 1-2-3 Macros in 1995, Before Discovering Microsoft’s Excel Visual Basic in 1999]

Today I enjoy patronage from buyers within and outside Africa, for my customizable Excel Visual Basic software. But the journey to this point began for me 2 decades ago when I worked as a young graduate trainee brewer in Guinness!

Back then Lotus 1-2-3’s was the industry spreadsheet application standard worldwide and it had a keystroke based macro programming language.

Guinness had the Lotus SmartSuite installed on all its computers.

By the year 2000 however, the company rolled out MS Office installations across all its sites and relevant personnel received training to begin using it.

NB: At the end of this piece, I’ve included a Wikipedia link to read the history of how MS Excel Visual Basic came to life 23 years ago, and how it has evolved since then.

Having always been very adaptable to changing circumstances, I wasted no time in learning to use the new application.

I did that using the Reed Jacobson authored “MS Excel ’97 Visual Basic Step by Step” manual given out to attendees of an 2 day on-site Introduction to MS Excel course facilitated by a representative from a Microsoft partner organisation – Bitrax International.

There were about 15 of us, but I was the only one with any interest in or knowledge of spreadsheet automation. Indeed when the copies of the manual were being shared out, the facilitator actually called out asking:

“Which one of you is Tayo Solagbade?”

When I raised my hand, a bit surprised by the fact that I’d been singled out, he said (holding up a copy of the book):

“I’m told by the managers in the Head Office’s IT department that you are the only one likely to understand what is in this manual.”

It was a great complement, but at the same time a challenge for me to take my game to the next level.

I immediately realized I needed to quickly learn to use Excel VB to control Excel, as proficiently as I used Lotus macros to automate spreadsheet reports.

Indeed the IT department had had to help out in the rollover to MS Office, when users of 4 apps I’d developed to automate daily, weekly and monthly data recording and report generation in Lotus 1-2-3, repeatedly requested for the apps to be converted to versions that would run in MS Excel, if they were to agree to move to the new platform.

Their reason was simple: the apps had saved them hundreds of hours normally spent doing most of their work manually. Not only were they getting work done faster, there was much less occurrence of reporting errors.

Since the company’s IT department had no in-house expertise in spreadsheet automation, my apps had to be sent to the UK office where a developer with skills in use of both spreadsheet development platforms did a great job of converting my apps to versions that worked satisfactorily in MS Excel.

After I got hold of the manual by Reed Jacobson, I dug in and quickly began using the new coding language.

Before I left the company to start my own business (offering custom spreadsheet automation solutions), I built an Excel VB driven Training Records Database that was deployed across the brewery’s intranet for use by departmental heads.

This was a solution I developed as a last resort under 2 weeks in the final stage of ISO 9000 audits being conducted by officers of the Standards Organisation of Nigeria (SON).

They had requested that every department head show proof of access to “easily retrievable” training records of all members of their respective departments.

I was Training and Technical Development Manager at the time, having been promoted from Shift Brewer less than a year earlier.

Unfortunately we were still waiting for the IT department to get back to us with an app fitting the specifications we’d sent to them. At that point, it became obvious that it was up to the Training department to provide an alternative solution, if only temporarily.

Up until that time, I’d only been practising my new found skills in Excel VB coding privately.

This training database challenge made me get serious about developing an app for users again – and this time around they were to be busy senior managers across the brewery.

Long story short, I got it done – with round-the-clock (weekends included) training records data entry help from my training instructors and engineering trainees (which I facilitated by providing refreshments using my personal funds).

Only when it became apparent that the app worked, did I inform the brewery head (Andy Jones) that we had developed an alternative solution, which I then demonstrated for him to see ob his PC.

The rest as they say is history.

With Andy’s consent, I went round to show each department head how to launch the app from the brewery’s intranet, using shortcuts I placed on their respective desktops.

By the time the audiors went round again, the brewery passed with Zero Non Conformities on that front!

Just to add some perspective for you, it was in 1995 that I first began developing custom spreadsheet software using my self-taught skills.

As I’ve noted in several articles over the years, I discovered spreadsheet automation via Macro Programming while reporting, as a Graduate Trainee brewer to Richard Chambers, a young Scottish manager who worked as an expatriate Training Coordinator in Guinness Nigeria’s Ikeja brewery.

We never sat down one day for a training session on spreadsheet programming. Instead, what happened was that I took an interest in sitting and watching him develop reporting applications for use by senior management personnel in the head office and in the breweries.
After some time he noticed my persisting interest and began giving me his laptop to check the integrity of the many mega (nested) formulas he used in the apps.

In order to do what he asked successfully, I had to study and fully understand how to manually calculate all the different usage rates and Key Performance Indicator ratios used in the reports.

It was his way of giving me more of the training he knew would help me succeed in the Technical Function.

Doing those tasks excited me as I discovered that I was mastering stuff that would enable me reason at the level of, and rub minds with the top minds in the company’s technical function.

My curiousity made me begin studying Richard’s macro programming code and as I got more familiar with them and what they did, I began copying out and making my own modifications in a test workbook.

Over time my confidence and competence grew to the point that Richard noticed I could correctly write or modify code in his app, to remove bugs identified.

That assignment introduced me to Manufacturing Usage Rates as well as Variable Costs Reduction Analysis.

In 1995, I got redeployed to Guinness’ Benin Brewery. One day his counterpart there (Joe Sheehy) called him in Lagos about a problem in the app used for generating brewery month end reports for the Technical Review Meeting.

Richard told him I could help solve the problem. So Joe sent for me, and I did solve the problem. From that day onwards, the training department became my “home” – and news about me and what I could do began to spread.

Today, I’ve used those insights from my time in Guinness to develop custom apps for clients in various industries, with the most popular of them being sold to buyers within and outside Africa – such as my Excel VB Ration Formulator and my Poultry Farm Manager.

My story proves that anyone who is willing to do the hard work required, with undiluted persistence, and who has a passionate desire to solve data handling and report generation problems in any field, will succeed in doing so using MS Excel-VB programming.

If you can read and write, you can learn to code proficiently in any language – MS Excel Visual Basic for Applications being no exception.

I offer learning solutions you can adopt via my Excel VB club and workshop events, as well as my private coaching – all available online in experiential format.

Click here to request details of how to get started with me.

Below is the promised Wikipedia link you can click to read the history of how MS Excel Visual Basic came to life 23 years ago, and how it has evolved since then.

Visual Basic for Applications – Wikipedia, the free encyclopedia

Click here .

SDN Blog

New posts from last week*

Monday:

 

[Tuesday]:

[Wednesday]:

[Thursday]:

N/A

[Friday]:

Protected: Use This VBA Code Snippet to Make MS Excel Remind You to Save Your Work at Regular Intervals, to Avoid Data Loss!

[Saturday]:

How the Excel-VB Driven Poultry Farm Manager is Used (True Stories)

 

 

[Sunday]:

Protected: THE FARM CEO (Issue 45 – International Business Opportunity): Agro-processing Companies in Benin Republic Seek Buyers/Distributors in Nigeria and Other English/French Speaking Countries for their Organic Health Boosting Agro-based Food/Drink Products

 

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

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