Category Archives: Self-Development

PII 045: Learn Spreadsheet Programming to Auto-generate Reports from Your E-Bank Statement [FREE App You Can Use]

One of wisest tips on business I ever came across was contained in the quote below:

“Because its purpose is to create a customer, the business enterprise has two – and only these two – basic functions: Marketing and innovation. Marketing and innovation produce results, all the rest are ‘costs’.” – Peter Drucker, described as the Grandfather of Modern Marketing (and in my opinion Management)

In this article I offer a FREE copy of a new Excel-VD driven app that I created, to solve a data handling and reporting challenge I had, in reconciling certain financial transactions details with 2 different clients, using an MS Excel bank statement downloaded from my bank’s website.

The thought occured to me that others who use online banking platforms similar to mine, especially in the Nigerian market, are likely to find this app useful.

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 19th December 2016

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 045: Learn Spreadsheet Programming to Auto-generate Reports from Your E-Bank Statement [FREE App You Can Use]

One of wisest tips on business I ever came across was contained in the quote below:

“Because its purpose is to create a customer, the business enterprise has two – and only these two – basic functions: Marketing and innovation. Marketing and innovation produce results, all the rest are ‘costs’.” – Peter Drucker, described as the Grandfather of Modern Marketing (and in my opinion Management)

In this article I offer a FREE copy of a new Excel-VB driven app that I created, to solve a data handling and reporting challenge I had, in reconciling certain financial transactions details with 2 different clients, using an MS Excel bank statement downloaded from my bank’s website.

The thought occurred to me that others who use online banking platforms similar to mine, especially in the Nigerian market, are likely to find this app useful.

So I resolved to use it for my annual year end mix of innovation and marketing to hit the ground running in 2017, with regard to my Excel Visual Basic Solutions Development.

 

Below: The 5 minute demonstration video I recorded for this app. Click here to watch it  in my Youtube Channel.

Below: Screenshot of the single sheet workbook file downloaded from my GTBank online banking platform.

 

webbasedstatement3

Below: This was modified from what was originally in the downloaded Excel worksheet bank statement downloaded via a query I did in my accounts interface on the bank’s website.

webbasedstatementpii1

 

Like I mentioned in yesterday’s preview, I was trying to make some sense of the transactions in my bank statement which I generated from my online banking interface.

I actually wanted a copy of the statement because I needed to review certain entries based on some repeat clients I had transactions with via online banking.

A need arose to trace some particular transactions for two such clients, and there was a bit of confusion and delays in finding the information because each of them had at some point done transfers to me through a 3rd party.

But the 3rd parties had not taken the pains to enter descriptions mentioning who they were making payments on behalf of.

As a result, there were some payments that I could not trace for each client since their names were not linked to them.

 To get started, what you need to do is simply click the IMPORT BANK STATEMENT button. In the case of this copy of the app, I’ve configured it to check for and import ONLY the workbook downloaded from the online banking interface.

This works well and is a safe strategy because typically, the online banking interface query will generate a statement that is saved using your account number as a unique filename identifier.

That means I only have to change the filename it refers to (with path modifications as needed), for this app to work with your own MS Excel based statement downloaded from THIS bank’s website.

If you use any other bank, modifications will simply be made to accommodate whatever differences exist in the data table layout/format, as well as the corresponding reports to be generated.

TIP: For those of you who take up the offer I’m making, you’ll get this app FREE to use for life, with 100% FREE support and upgrades, if you purchase ONE year membership of my Excel-VB club for N5k instead of N13k on or before Midnight of Saturday 31st December 2016.

Back to using the app…

Clicking the IMPORT BANK STATEMENT button loads a prompt informing you the app will first of all delete all existing data in the table, before it commences importation of data from the downloaded workbook.

I put in that procedure in anticipation of instances when you may be importing a new body of downloaded data that’s smaller than the one you just finished working with (For instance you download a 2013 to 2016 statement, after viewing a 2016 statement like I did).

The app imports the statement into the table and leaves the bank statement single sheet web page style workbook open in a separate window, which you can easily switch to, and compare data from.

Notice that even the worksheet tab for the database worksheet bears the same label as the filename.

Now, one of the things I wanted to be able to do, was to find information relating to a series of transactions with some specific individuals, for reconciliation purposes.

To make this easy, I got the app to generate a list of names from the “FROM” and “TO” columns in the data table – eliminating duplicates.

So, you simply click on a name from the drop list, that you want to query and review transactions for, and the app would filter the table’s contents, displaying only those matching your query, and hiding the others.

 

webbasedstatementpii2

webbasedstatementpii3

 

webbasedstatementpii4

 

webbasedstatementpii2

webbasedstatementpii3

 

webbasedstatementpii4

You then have the option to further query the table using month and year parameters, via drop menus provided.

So if someone tells me there was a transaction in 2014 March for a certain amount, I can use the above menu driven query items to easily locate relevant references to him/her.

Worst case scenario – if the information s/he supplies does not turn up matching records, I can simply do a blanket search with his/her name from the menu, and ALL records linked to it will appear, from which we can then review and decide the way forward.

At any point during your query based review, you have the option to click the PREVIEW button to see the pre-print view of the filtered table contents.

If you have a PDF creator installed, like I do, you will be able to generate PDF versions of your final table version – if you do not wish to print on paper. This PDF option may come in handy should you wish to send the scenario generated to a 3rd party without having to share the entire bank statement’s contents with him/her.

webbasedstatementpii5

webbasedstatementpii6

webbasedstatementpii7

 

Another thing to note is that the totals for DEBIT and CREDIT columns are updated dynamically using functions that recalculate to reflect the displayed contents.

This is quite useful because it saves you from worrying about recalculating the totals for the scenario you generated. Watch the way the totals change as the various menu items are clicked in the video demonstration.

When you’re done with querying the table, clicking the SHOW ALL button will return the table to its default display state, with all data visible.

Now, clicking the MENU button loads the floating Main Navigation Menu button.

On the Main Menu’s left 4-tabbed panel, the 2 middle tabs allow you to access 2 key summary dynamic reports generating interfaces.

  1. The Single Year Scenario: Allows you to generate a table of summaries with corresponding charts in bar and line formats. I created this interface to review trends on a month by month basis for a chosen year. Again, a PDF version of each scenario generated can be created and emailed to a 3rd party without needing to share the entire body of data.

Tip: Notice the auto-generated headers inserted into the print-ready page by the app, which personalizes the report with the owner’s name and other details

  1. The Single Month Scenario: Here you want to drill down through the data for a particular month of a particular year, on a daily basis. My purpose here was to see if I could establish any useful trends and relationships between the periods reviewed, towards making useful decisions or deductions.

webbasedstatementpii8

webbasedstatementpii9

webbasedstatementpii10

webbasedstatementpii11

webbasedstatementpii12

What I’ve done is to put in dummy data, to protect privacy of myself and those I transacted with. So what you see in the video and screenshots are NOT real values.

Tip: Now one of the things I had to do in this table was to cater for differences in numbers of days for some of the months, like February (Which has 28 or 29 days depending the year), and other months like November, September, June and April, which have 30 days, unlike the rest with 31 days.

The table’s TOTALS dynamically hide and display the last few rows for EACH month, as the month name changes, so that when February is clicked, no data from March appears in the table, regardless of the number of days it has, in that year.

This is a major time end effort saving format.

***The AUTO FIT button is used when a cell has generated entries are displayed as hash (####) signs due to inadequate cell width. Clicking in any cell in the column and clicking the AUTO FIT button will activate the auto size function, resizing the cell to allow proper display of the contents.

It goes without saying that what I have done with this app was simply basic level data handling for report generation. Nothing complex in terms of real financial analysis.

And that’s because my immediate need for basic information drove this app’s creation. But that’s why I want to bring others on board, especially financial experts and other serious business users, so they can learn Excel-VB coding as they use the app. I can help (and/or coach them) to do a LOT more.

Over the past decade, serving as an Excel-VB Solutions Developer, I have worked with many CEOs and financial consultants in various markets/industries, and I know they all have various tasks they use MS Excel to manually carry out on their business financial data – especially those found in their bank statements.

Indeed virtually any income earning adult in today’s society makes use of a bank account and is therefore likely to understand the potential benefits of being able to relate to his/her financial data using MS Excel, in the manner I have demonstrated with this app.

My vision is to empower interested business and other users of MS Excel, with Excel-VB coding competence to enable them do what I have done here, in terms of solving a data handling, analysis and report generation problem, to meet their peculiar individual needs.

Typically, any self-employed professional, marketing experts, HR Executives, and financial experts in paid or self-employment, and indeed any business owner or working adult with a need to use MS Excel, will find learning a little MS Excel-VB automation quite a handy skill to possess.

But if you cannot spare the time, maybe someone you know, or who works for you can learn it and then help you with it.

That is why I offer YOU this app, with FREE lifetime support to use it for your own purposes, if you sign up for ONE year membership of my Excel-VB Automation club.

All you need do is pay the promo signup fee of N5k, and I will send you the app, with details of your membership benefits, including the 50% discount you get on ALL my products and services as a member.

This offer remains valid until Midnight of Saturday 31st December 2016, when the fee will revert to N13k, the Standard membership fee.

NB: Current club members interested in getting a FREE copy of this app can do so by paying the N5k fee, instead of the standard N13k fee, to renew their membership for another year.

Click here to contact me if you have questions or require clarification.

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:

[Tuesday]:

[Wednesday]:

[Thursday]:

[Friday]:

Why “Cheap” Is Unlikely to be “Hip” (A Client Blindly Demanding Low Fees May Likely Hurt You)

[Saturday]:

N/A

[Sunday]:

[Coming Tomorrow] You Need this Custom Spreadsheet App to Accurately Analyze Your Bank Statement

THE FARM CEO (Issue 69): Importance of bank reconciliations for your farm business, Automate Your Farm Records Keeping For Profitable Farm Planning, [Coming Tomorrow] You Need this Custom Spreadsheet App to Accurately Analyze Your Bank Statement

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

[Coming Tomorrow] You Need this Custom Spreadsheet App to Accurately Analyze Your Bank Statement

On the 31st day of this month (December 2016), it will be exactly 14 years since I quit my high paying job as Technical Training and Development Manager with Guinness Nigeria, to (among other goals), pursue my dream of developing custom automated spreadsheet software for a living.

I’ve since made MAJOR progress, establishing my own unique range of custom spreadsheet apps used by high profile clients within and outside Africa. So much so that today I earn passive income selling my apps remotely via the web, without needing to meet face to face with clients.

Each time a New Year approaches, I always work hard to hit the ground running with a new and different concept, product or soliution.

This time around what I’ve come up with happened really by accident. A problem I had making sense of the MS Excel based bank statement I downloaded from the online banking interface for one of my accounts.

Below: Screenshot of online banking interface, with download of MS Excel statement in progress.

 

webbasedstatement3

The data was in too basic a format for me to find the information I needed, and trend it to arrive at useful deductions.

Below: Screenshot of downloaded copy of January to December MS Excel based statement I generated from my online banking interface on 15th December 2016. 

webbasedstatement4

Today I generated one covering 1st January 2012 till date, which I successfully used to test the new app I built. It worked superbly. Details, including screenshot of generated table and chart based summaries in tomorrow’s issue of my PII newsletter.

It was while I was crawling around in confusion in the downloaded spreadsheet version of my statement for 2016, that I remembered I possessed MS Excel-VB automation skills.

And that meant I could do something about the problem I had with the data I was looking at!

My desire to use the data for my planned purposes drove me to build an app to do what I want with the statement.

Then when I began using the finished app, it occurred to me that others who also use online banking interfaces to generate their bank statements would probably find this app useful.

So, I decided I would use it as my new “product” going into the new year.

Below is the description of the app, that I’ve put in its about window.

This Custom Automated Excel VB Driven Entreprise Information System(EIS) was built by Tayo K. Solagbade, for SDAc’s Creative Business Solutions(CB Solutions) arm, using MS Excel® Visual Basic. It allows even a PC novice quickly and effortlessly import bank statement data from an MS Excel based workbook downloaded from his/her bank’s Internet Banking platform. Using in-built cystom automation tools the user is then able to generate tabulated and charted reports.

Tomorrow, the Monday issue of my weekly Performance Improvement Ideas (PII) newsletter, will go out.

In it, I will provide detailed descriptions and screenshots, as well as a step-by-step video demonstration of how the app works.

Then I will end with an introductory promotional offer of the app. Members of my Excel Visual Basic Automation Club will get a heftier discount.

Stay tuned – in a few hours, the details will be LIVE.

 

Below: Screenshot of the data auto-imported from the MS Excel-based bank statement downloaded from my online banking interface

webbasedstatement

[PS: This post is a precursor to tomorrow’s special issue of my Performance Improvement Ideas (PII) newsletter, which will feature full details of this new product to be announced via a special promo offer]

Why “Cheap” Is Unlikely to be “Hip” (A Client Blindly Demanding Low Fees May Likely Hurt You)

“But Tayo, somebody did this same thing for me last year for ten thousand naira: why is what you call a promo offer so much higher priced? In this period of recession, all I want to hear are low prices”.

Prospects and clients have said stuff like the above to me in the past, with regard to my Web Marketing System development service offers. Most times they did it in a bid to beat down my fees to what they felt was “reasonable”.

I have however always been one to focus on finding clients with a good fit. Anyone too focused on paying a low fee regardless of value to be had, was/is NOT good for me. So I learned to tactfully offload such individuals, by asserting myself without offending them.

What follows below are excerpts from the text transcript version of an audio response I sent to one such CEO – an example of how I do the above.

You must be able to look at solutions other people offer you, compared to what someone like me is offering in terms of using the web for business promotion.

We need all to find customers. Every person who is in business is not joking around. You and I are looking for buyers for what we sell. Your purpose in marketing is to find somebody that will pay to buy what you are selling.

It’s stating the obvious, but I’m emphasizing it because I want you to understand what I’m offering to do for you from that perspective.

RESULTS!

That’s what is needed…!!

So, it’s not theory. We are looking, for example, at you saving money using this proposed solution, with regard to your business marketing, so that you can increase your profit margins.

How much is it currently costing you to get people to buy from you? This has to do with your Cost of Sales/Cost of Customer Acquisition.

If you are able to cut down your above mentioned cost, by 25% for example, that implies you’d have increased your profit margin by the same amount. In essence the amount of money you put in your pocket or the amount you retain in your business, will increase by 25%.

So THAT (i.e. reduced marketing/sales costs) is one immediate benefit you are likely to reap from implementing a Web Marketing System I will setup for you, if you use it the way I recommend.

It will enable you focus your time, effort and energy to doing the things that matter the most.

The second thing is that you want to attract people that are more likely to be willing to pay you what you want them to pay to buy from you,

So, the second benefit of the WMS, is that you will have a system, which even when you are sleeping, will be capable of influencing people who fit the above description to find you, and ultimately make contact with you.

In other words, there are 2 things to look forward to in this regard:

This system will make them find you, AND then it will make them arrive ready to do business with you, 80% of the time, on your own terms.

The above implies you want to find potential buyers in bulk. You want people, whether they are within or outside your immediate area, to buy from you in bulk.

So, whatever will help you find these people in larger numbers, with a greater degree of frequency and bring them to you, when you are just doing things that I recommend you do, using the system I setup for you, is something that definitely will NOT require an investment as low as ten thousand naira!

What I do is “value pricing” i.e you evaluate the potential worth of the solution I offer, based on the expected benefits you are to reap – mainly financially. That ensures both parties enjoy a win-win outing!

Like I tell clients and prospects all the time – the solutions I offer are designed to be pocket friendly/affordable, but NEVER cheap.

However, I use a low risk entry pricing strategy, – like this 12 month FREE Web Marketing Support Service – to give selected potential clients a taste of what I offer. What I do for this group of CEOs is then used to showcase to others I approach, what they stand to benefit if they signup.

It’s never wise to let people “commoditize” services they offer you.. Especially not Web Marketing solutions.

Trust me. I say this for over a decade of hard won experience that serves me well today, as a web marketing professional.

I did not study IT. I’m an Agricultural Extensions Services graduate., but believe me, what I do in terms of the way I used the web has put me way ahead of 80% of those who possess degrees in IT, in this part of the world. 

In addition I’m very unique in terms of the way I use the web, especially because I don’t use paid advertising. And yet I make sales to buyers within and outside the African continent.

The irony of it all is that I get these great results by using a marketing weapon or instrument that costs me only a fraction of the total income I earn annually from using it.

If you look at it from that perspective, you will understand  that what I want to do for you has nothing to do with what someone else may have done for you. Or indeed what s/he may be offering to do for you, at some cheap rate…and it certainly cannot be done for ten thousand naira.

Then the question to ask is:

Does this interest you? Would you like to be able to operate the way I just described?

I refer to a situation in which you get to lower your marketing costs and at the same time, almost simultaneously, boost your marketing reach and impact.

That is a situation in which people who are ready to buy from you (at least 80% of the time) will discover and come to you, on their own, even if they never knew about you before, and yet be willing to do business with you on your terms?

That’s how over 80% of my clients found – and connected – with me. No one told them about me: They discovered me online, via my own WMS. The foregoing probably applies to you READING THESE WORDS right now.

Every time I have a sales conversation – and I’m having them almost every day now – it’s amazing the results I get most times.

I have so many stories to tell in this regard – and some have been shared in my past articles (like this one – click here to read). This is because this system I use works by building on your past successes – it continues to grow.

That’s the beauty of Web Marketing the way I do it.

You will continue to leverage previous encounters. Your activities online are going to be reported by Google in a manner that enables more and more people to find you, or as long as you remain authentic.

So the WMS – as I conceive and implement it – is not for crooked or lazy people. It’s also not for marketing fraudulent offers. Instead it’s something that’s for authentic providers of solutions, whether product or service.

In summary therefore, my WMS offer at any time will be designed to empower the client willing to make the required investment, in a way that ultimately delivers the desired benefits, while at the same time equipping him/her to carry on competently using it, independently of me, after I’m done.

Does that interest you? Click here now, let me know how I can help you.

Can You Deliver RESULTS When Failure Is Not An Option? [Hint: Are You A “Choker” Or A “Big Match Player”?]

[Tip: This post is a Content-Repurposed version of a 2012 issue of my (now defunct) Public Speaking IDEAS newsletter. Even though the example used is based on public speaking, the ideas shared can be successfully applied in any other areas of endeavour]

In The Real World, Things Can Go Wrong – Sometimes Badly Too!

Even after we have done everything we think possible, to prepare ourselves for a speaking or project outing, one or more unexpected negative developments can still occur.

And it could affect upset us so much, that when we get on stage  (or client premises), the speech (or job) we have prepared well for before the D-day, might not come out as desired.

Possible Occurrences That Could Make You “Upset” – Before You Give A Speech or Do a Client Job

I discuss a few possible examples below. It goes without saying that there are  many others you may be faced with.

Know that the tips offered here can be applied to good effect in dealing with them as well.

1. BEFORE you have to go on stage :

Some years ago, I had to deliver a talk about 1 hour after I had engaged in a verbal (and near physical) exchange with my wife. It was so bad, that I left home late, and only managed to stop fuming minutes before I was called out to speak.

That took some major doing…but the tips I offer here made it possible!

Still another possibility:

You get some bad news via a phone call or SMS about a business deal, that’s fallen through. Let’s say you had been so sure you would win the bid. Imagine how deflated you would feel. 

Now what if this news got to you, say 30 minutes before you had to step on the podium to deliver a speech titled “Nothing Is Impossible” to a group of startup entrepreneurs. How convincing do you think your delivery would be?

Depending on your temperament, it can be quite difficult to avoid letting your bad mood spill over to your interactions with other people.

Think about the times you have been upset by someone at home. Were there instances when it happened just as you were on your way out of the house? If yes, how well were you able to handle yourself in relating with others, when you got to work, or whatever your destination was?

2. When You Are Already On Stage &/or Speaking:

Imagine that just as you are about to start (or while you are) speaking, someone shouts an embarrassing comment insult at you from the audience e.g. a heckler. If s/he hits a nerve or sore spot you have, your reaction could be anger, resentment.

In a separate article, I shared the story about how I flopped at the National Finals of a competition for young managers, because I could not find a particular (transparent) slide I wanted to use.

A Story That Illustrates One Way To Give A Speech When You Are “Upset”

Imagine having to give a speech just after UNEXPECTEDLY losing an election (for public office or otherwise). This situation actually played out in a movie I watched recently. A young US congressman had maintained an intimidating lead in the opinion polls, over an older candidate widely regarded by the public as no match.

But just 24 hours to the election day, a photo published on the front page of a national daily showed the young congressman carrying out a very naughty prank on colleagues when he was in college, caused uproar. There was no time for his team to react. He got roundly defeated in the elections by the other guy, even in his own state.

Once the results were in, he excused himself, and retired to the men’s room to rehearse his speech. He had previously prepared a speech to cater for (what was then) the unlikely possibility of his losing the elections. Faced with the reality that he had indeed lost the elections, he walked round the men’s’ speaking out the words to himself.

When he finally got on stage, he delivered the speech as is, but later added stuff NOT on the script. He told the audience for instance, how some of what had said about his personal philosophy was not really true, and had been added to the speech on the advice of experts and consultants.

He went on to say a lot more, which amounted to “Standing Psychologically Naked Before The Audience” – to paraphrase “Burt Dubin” – creator of the Speaking Success System™. The audience loved it, and the media raved about his speech, saying it was likely to make voters back him in larger numbers in the next elections.  Three years later, he ran again – and won.

What the congressman in the movie did was simple.

He used the setback of losing the election, as a psychological stepping stone to launch him into the future he desired. By refusing to let his loss UPSET him, and instead creatively adapting his prepared speech to “re-sell” himself to the voting public, he succeeded in making them overlook his college prank, and won them over towards his future campaign

.

You can do the same:

I would be the last person to say this will always be easy to do. But if one is to merit being called a “Professional” it becomes imperative that s/he be prepared to act like one, by developing the competence to effectively manage your moods, so as to ensure you deliver satisfactory performances, whenever you have to speak before an audience.

Before Speaking, Put AWAY Whatever Upsets You In “Little Mental Boxes”

One could infer that the congressman described above, probably applied a variant of this approach for his purposes.

In using it, I force myself to APPLY what I once read, about putting ANY worries one has, into separate little boxes in different corners of one’s mind

This is the method I use and it has repeatedly enabled me bring my feelings under enough control to ensure I have a good outing.

Indeed, it has enabled me function optimally in my interpersonal interactions in both my personal and work lives for over 2 decades now. In certain instances, close associates ( who are aware of potentially disturbing issues I’m dealing with) have accused me of  unmasking a “steely” or “unfeeling” side!

 

Doing so helps you free the larger part of your mind, from the potential distractions that dwelling on the upsetting experience could cause.

But you don’t stop there. Later on, when at the right place and time, you can re-open any of your worry boxes, and reflect on ways to eliminate their contents, without the conflicting psychological pressure of thinking about giving a coherent speech!

Believe me – this worry/mood management technique has worked for me, for many years now. And it has enabled me go out daily during many dark periods of adversity, to deliver outstanding presentations to individual and group audiences.

Many of the clients I won during those periods would NEVER believe me, if I told them the psychological circumstances under which I won them over back then.

Summary

My message, in essence, is that in order to increase your chances of succeeding, when you speak to others, you really need to develop the capacity to manage your moods, under ANY circumstances. Even when you are upset, train yourself NOT to show it. You will be amazed at the level of deliberate self-control and mastery that you can achieve.

The ability to do this, will equip you to deliver compelling performances more often, regard.

One positive implication of being able to function in this manner is that clients and/or audiences will come to perceive you as someone who can be DEPENDED upon to DELIVER when it matters.

When they need a speaker at short notice, for instance YOU will naturally come to mind ahead of other possible candidates!

Final Words: Will You Be A “Choker” Or A “Big Match Player”? WILL YOU be Able to Deliver RESULTS When Failure Is Not An Option ?

Reflect carefully on this question, especially as it relates to serving your clients, who will be depending on you to bring the expertise they believe you have, to bear in the event that a problem arises.

In the real world, things may not always happen to plan.

Sometimes they will go badly wrong. When that happens, you ability to stay firmly in control of yourself will determine how you end up performing as a speaker – or indeed as an expert in your chosen field!

In sports, people who are able to deliver under pressure are usually referred to as “BIG MATCH” players

Those who always seem to cave in as they get closer to high pressure, psychologically tasking game situations in Golf, for instance, are called “Chokers”.

So, which do you want to be called, in the mind of your clients, and/or audience members?

A BIG MATCH player or a “Choker”?

The preferable choice is obvious. But to be able to manifest the attributes that will get you thought of in that manner, you MUST work on yourself, and develop the CAPACITY to absorb the shock from events or experiences that could upset you.

You can start from today – right in your home, with the kids, your spouse and relatives – maybe the annoying brother, sister or mother-in-law? Or that difficult colleague or business partner at work etc.

Promise yourself that you will NEVER let anything they do upset you to the point that you actually transfer it to another social environment you have to be in later on. Learn to leave it behind in a little worry box in one small corner of your mind.

Keep doing it for long enough, and you WILL become able to speak IMPACT-FULLY, to ANY audience, even when someone just (tried to?) upset you!

Making Your Own Stuff Can Save YOU Money & EVEN Make YOU MORE! [True Story: Learning Home Based Footwear Making With My Kids – Photos]

One of my key objectives as a Best Practice Parenting Advocate is to challenge parents to coach their kids to make deliberate purpose driven INCOME EARNING skills acquisition a way of life.

Virtually no any area of endeavor or vocation should be exempted. As long as there is interest on the part of the learner, and the activity itself is value adding, ESPECIALLY in terms of income earning potential, as well as personal development benefits, you should encourage them to go for it.

It’s a slow – and necessarily messy process (especially when one is dealing with teenagers), but worth it in the long run, as it MATURES them in line with real world requirements quite effectively.

The best practice parenting articles I share on this blog provide ample evidence of the fact that I practice what I preach. 

This is why our home is always in a constant state of perpetual activity!

So many of my best practice parenting articles shared on this blog offer insights into the MANY exciting real life skills development projects we have successfully converted into semi-formal (and soon to be formalized) money making (and/or money saving) micro business enterprises.

Examples include our range of no-oven charcoal stove baked cakes, cookies, chin-chin, bread, African-Style-Pizza and Pineapple-Peel (Yes, the PEELS)-based drinks. See links at the bottom of this post, to detailed articles I’ve written about some of them – photos inclusive.

The ability to make the above foods and drinks now enable the kids make their own birthday cakes and other refreshments.

So, instead of having to go buying them, they simply purchase the flour and other items needed and then settle down to bake ALL they need.

What’s more, when friends and relatives are celebrating we now simply decide what to make and give to them as gifts, instead of thinking of what to buy and where to get it.

Now that we’ve added footwear making to the  mix, the kids have yet another option in terms of what they can give as gifts – EACH of them being what they can produce in a custom manner that does NOT exist in the marketplace, making it unique and therefore more likely to be appreciated by the recipient!

This article is meant to serve as a wake-up call to as many readers as possible

I feel compelled to use the insights I’ve so far gained, from the years of progressively implementing my best practice parenting vision for my OWN kids, based on a careful reflection on my personal experiences in life, to offer guidance to other parents – and indeed adults in society.

Not too long ago, I wrote a heartfelt piece in which I passionately appealed to parents and adults in society involved in education, to UNDERSTAND that schooling is MEANT to be a means to an end, and NOT an end in itself.

So many people in so many societies do NOT understand this truth and as a result, they continue to go about their “schooling” wrongly.

They do it in a way that denies them exposure to the RIGHT kind of education needed for them to survive, and indeed FLOURISH, in society as competent income earning responsible adults.

The recession we’re currently experiencing in Nigeria, as well as globally have thrown up this inadequacy in our schooling through our reactions towards it.

Those who lost jobs keep going out looking or new jobs – even accepting lesser pay, just to earn income. Those who lack jobs keep walking the streets, certificates in hand looking for jobs – sometimes even accepting to be grossly underemployed, taking on menial jobs, just to earn a living.

The irony is that while all the above happens, most of these schooled people fail to notice the elderly women on Lagos Island’s Balogun, and Akpongbon areas who for decades have operated high volume commercial trading businesses, dealing in fast moving consumer goods, DESPITE lacking formal education.

I used to smile, back in 2004, while still trying to find clear direction as a startup entrepreneur, at the paradox of the situation in which well dressed lady bankers would arrive in chauffeured official cars, to pressure the “Mamas” about the need to put their money in the bank.

Lacking formal schooling, and knowledge of conventional banking benefits, the latter routinely kept their money at home or in other non-bank storage locations.

This, despite the fact that the amounts they handled that way ran into the millions. The bankers knew this and saw massive opportunity to be had  in making the “Mamas” their clients.

As I said, whenever I saw the suited banker scurrying after the “Mamas”, I always smiled in silent amusement…

My amusement came from the obvious irony of the fact that the bankers NEEDED the money of illiterate big time traders who learnt to make money without attending school.

Yet in real life, in an economy that works, it is bankers who should ideally put their knowledge of money making at the disposal of business owners, with financial support where needed, so the latter can make money or make it more profitably!

This brings me back to my point about the schooling we get.

We often complete formal schooling without having real life competence in money making endeavors of any sort.

Instead most times we just emerge with lots of theoretical knowledge and the pieces of paper that confirm we passed those time limited exams.

Unfortunately, life does not give exams that we can sit down and pass the same way, using just what we read.

Instead, life demands that we demonstrate proficiency in something that adds tangible, measurable value and impact to others.

Anyone unable to find a way to function in that manner after completing his/her schooling and entering society is likely to struggle, to make him/herself get taken seriously. Especially as it relates to commanding income payment, from others.

This is the reason why unschooled people with exceptional abilities to do things others are willing to pay for, tend to end up rich, while schooled people lacking similar competence struggle in the same field.

Compare MANY graduates of music, who ventured into music making as a career, with Tu Face Idibia who never even studied the subject, yet is renowned for his music making prowess across Africa, and you’ll see what I mean.

It goes without saying that you can come up with so many more examples within and outside your own society.

This is why I argue that learning to DO THINGS that matter, especially in a way that makes others willing to pay you, is crucial to success in life.

Now, since most schooling available in our societies tend not to focus on giving learners exposure to develop the ability to do that, I believe EACH person must go get it for him/herself.

That’s what I am doing for my kids through my Personal Achievement Coaching for Kids (PACK) ™ program that I formally launched on a pilot scale with them in 2014.

One of its key objectives is to make the participants imbibe the mental attitude of constantly seeking to “Make their own stuff”.

Like I said earlier, it has to become a way of life. Like it is for me, the outcome will be the ability to function regardless of your seeming situation in life.

Even when you have no money, you will be so good at doing things that matter, and LEARNING new ones as needed, in a manner that equips you to get what you need at any point in time.

Anyone who functions that way will be effectively unstoppable.

I am able to conceive this model because it is based on my personal experiences having to succeed in spite of myriad potentially crippling limitations I’ve overcome during my startup years, to get where I am today.

My story, as told in many articles shared online over the past 10 years provides ample evidence that the claim inferred in my business motto is truly accurate i.e. “Acquire Self-Development Skills. Create The Future You Want™!”

That’s been the secret of my “unstoppability” since I started my journey to authentic long term success.

And it’s the secret I’m sharing with my kids in a very practical way.

As usual, I offer some examples of proof that I practice what I preach – this time, from the “Home based Custom Footwear Making” projects we’ve been making real progress with.

Below: A pair of leather slippers I purchased from a Cotonou based footwear maker in May 2016

wmsh-me0

Below: About 7 months later, they were worn out, and I’d discarded them. But when our new project on shoe-making began, I realized I could use the slippers to practice. This is the new slipper alongside the cover I removed from the old slipper.

wmsh-me1

Below: The new pair of slippers that I made using the soles from the old slippers

wmsh-me3

wmsh-me2

Below: First attempt by my 17 year old at  making a pair of rubber slippers

wmsh-fel2

wmsh-fel1

The Motivation:

Unreliable, yet costly footwear often on offer from local vendors. The alternative tended to be purchase of imported used shoes. I did not like that. So I formed a habit of doing shoes and clothes shopping for my kids whenever I returned home from Cotonou.

However, over time my bulky bags drew attention of custom officers at the border, who insinuated I was trading in shoes/clothes I brought. Then they informed me of duties imposed on certain items (e.g. shoes), which I should have paid.

That discovery got me thinking.

I had seen some shoe maker shops in Lagos, with show glasses displaying handmade shoes. I thought to myself: “What stops us from making (at least some) of our own stuff that we need daily e.g. footwear like shoes, slippers etc”

Summary: The Key to Lasting Progress and Authentic Success In Life Is A Problem Solving Mentality!

Every time I’ve implemented a new addition to what I can do, it’s been the direct result of a PROBLEM I wanted to solve.

Indeed, life itself, including money making, is all about finding solutions to problems. The problem could be yours or that of another person. Providing the solutions can either save you money or make you money.

And that is in addition to helping you make more productive use of your time and effort.

So, I began discussing the idea with my kids.

I have 3 teenage boys and they tend to set the mood for how well any idea will sell in the home, to their siblings. Since I understood how to “sell ideas”, and I knew EACH child’s personality and interests quite well (do you know your kids that well?), I had little difficulty getting 2 of the boys’ interested.

Within a month, we’d begun downloading and watching all sorts of home study videos on shoe-making from experts around the world.

Then each time we went out, we looked around for shoe-making shops and supplies stores.

Long story short, today, we’re in our 3rd month of trying our hands at shoe-making, and the results continue to get better.

The kids now make and wear their own rubber and leather slippers, as do I. We also salvage parts from old damaged footwear (shoes. slippers) lying around the house, to make new ones we then wear. See photos below for examples.

Today, not only do the kids (especially the 3 boys) now make some of their own footwear, they also know how to use various tools to FIX bad ones (for themselves and others).

The finishing of the items we make in this area still needs improvement, understandably, but we’ve improved to the point that some are good enough for casual outings already.

If you still don’t get it, this means we no longer spend money buying some kinds of footwear, neither do we pay to have our footwear mended by cobbler’s except in rare instances. It goes without saying that THAT is a smart way to live through a period of economic recession, like that happening now!

Now, it is only a matter of time before we settle on a range we can offer to others as gifts and for sale as well. Yep – that is where we are headed with this.

This kind of exposure is a crucial complement required for ANY formal schooling a person goes through, if she is to arrive adulthood and society with real world relevant competence.

Related Articles

1. [VIDEO] Build Your Battery Powered Toy Bike From Scrap [Case Study: Personal Achievement Coaching for Kids™]  – Read the article here (see screenshot images from the video)

2. We Need Schooling Systems That Transform Learners Into Real World PROBLEM SOLVERS!

3. PII 041: Avoid Intellectual Laziness, Learn How Things Work…to Achieve Success [Hint: A Culture of Making Your Own Things is Key to Individual/National Development – See Photos of Home Made Ankara Slippers and Shoes Inside]

4. Vocationally Skilled Population – Key to African Development!

5. [Workshop for Kids – by a Kid] Build Your Own Battery Powered Toy Bike!

6. Spend Time With Your Family to Create Products You Can Serve to the World As a Team

7. PII 011: You Need to Coach Your Child to be Resourceful in Life [Watch video of 12 Year Old Building Battery Powered Toy Power Bike from Scratch]

What You Need to Build Battery Powered Toy Bike From Scrap [Highlight Video by 13 Year Old – Personal Achievement Coaching for Kids™]

TayoSolagbade.com presents “What You Need to Build Battery Powered Toy Bike From Scrap [Highlight Video by 13 Year Old – Personal Achievement Coaching for Kids™] ”

This 13 year old makes battery powered toy bikes from sweet sticks and electronics scrap!

[Case study from my “Personal Achievement Coaching for Kids (PACK)™ Program”]

Click here to watch the highlight video on my Youtube channel

*********Below are Screenshot Images from the Videos – High points during the video******

bike-video0bike-video1a

This 13 year old makes battery powered toy bikes from sweet sticks and electronics scrap!

bike-video1

He gets the rotor to drive the toy bike from damaged electronic devices, like THIS old DVD player.

bike-video2a

He uses old microphone battery discarded in church  (or buys new one for N100) to power the rotor.

bike-video3

He improvises with matches & basic tools to apply ideas he got from a 3 min video by a US based expert

bike-video4

Fitting the rotor into the rear wheel made from 2 plastic coke bottle covers.

bike-video5

Joining the wheel to the bike frame

bike-video6

Fitting bike’s handle bars – made from discarded sweet sticks

bike-video7

All parts now fitted….

bike-video8

Initial test run…Adjustments to eliminate wobbling will be done till OK

bike-video9

Close-up of motorized bike wheel in motion

bike-video10

His name is Chika…& we intend to help him refine this toy bike’s finishing, so he can sell it.

bike-video11

bike-video12

LIKE this video and share it to inspire others. 

bike-video13

 

Email chika at tksola.com to request his 4 part video tutorial on how to build your own battery powered toy bike

bike-video14

A LIVE demonstration workshop by Chika is available for  groups of kids On-Demand [Email chika at tksola dot com]

bike-video15

© Copyright 2016 SDAc’s Creative Business (CB) Solutions | info@tksola.com | +234-803-302-1263 | +229-66-122-136

bike-video17

Video recording by: Chukwuemeka

Video Editing by: Tayo

Music by: Ville Nousiainen

bike-video16

 

 

 

He gets the rotor to drive the toy bike from damaged electronic devices, like THIS old DVD player.

He uses old microphone battery discarded in church (or buys new one for N100) to power the rotor.

He improvises with matches & basic tools to apply ideas he got from a 3 min video by a US based expert
Test running the rotor

Fitting the rotor into the rear wheel made from 2 plastic coke bottle covers.

Joining the wheel to the bike frame.
Fitting bike’s handle bars – made from discarded sweet sticks
All parts now fitted….
Initial test run…Adjustments to eliminate wobbling will be done till OK
Close-up of motorized bike wheel in motion

His name is Chika…& we intend to help him refine this toy bike’s finishing, so he can sell it.
Hear him: Now I have made my HW (battery) powered motorcycle. Thanks for watching. Bye!
LIKE this video and share it to inspire others.
Email chika@tksola.com to request his 4 part video tutorial on how to build your own battery powered toy bike

A LIVE demonstration workshop by Chika is available for groups of kids On-Demand [Email chika@tksola.com]

Video recording by: Chukwuemeka

Video Editing by: Tayo

Music by: Ville Nousiainen

© Copyright 2016 SDAc’s Creative Business (CB) Solutions | info@tksola.com | +234-803-302-1263 | +229-66-122-136

 

PII 044: Successfully Influencing A Difficult Co-Worker, Colleague or Partner

[Tip: This “content-repurposed” write-up was first published on Monday 16th July 2012 via spontaneousdevelopment.com (my 9 year old former website – defunct since 2014]

In order to work with anyone successfully, you have to speak with him/her. But sometimes that can be easier said than done, because the person we have to work (and speak) with, could have a reputation for being “difficult”. Or he could be somone you do not like or get along with.

How you handle that situation when it does occur, can be a crucial determinant of your success (or otherwise) in the workplace.

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 12th December 2016

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 044: Successfully Influencing A Difficult Co-Worker, Colleague or Partner

[Tip: This “content-repurposed” write-up was first published on Monday 16th July 2012 via spontaneousdevelopment.com (my 9 year old former website – defunct since 2014]

In order to work with anyone successfully, you have to speak with him/her. But sometimes that can be easier said than done, because the person we have to work (and speak) with, could have a reputation for being “difficult”. Or he could be somone you do not like or get along with. How you handle that situation when it does occur, can be a crucial determinant of your success (or otherwise) in the workplace.

We all know the type (and some of us are like that). The ones who are unable to get through a day at work without getting into some conflict with a colleague, or even the boss. The kind who seem to take ready offence at anything that’s said to (or about) them.

Sometimes these individuals are competent and make valuable contributions in the workplace. However their abrasive dispositions could make them relatively unpopular with colleagues. As a result, outside work related situations which force co-workers to be with them, they usually tend to get left alone.

What If You Get Assigned To Work With One ?

There is a real possibility of this happening. And except you have plans to leave that job anytime soon, you’ll want to find an effective way to work successfully with that difficult person.

Refusing to do so, could jeopardize your career prospects. For instance, decision makers would doubt your ability to handle positions of higher responsibility, which require objectivity and interpersonal effectiveness.

A simple, easy and painless solution to this dilemma exists. I often tell people that I can work with the devil himself, if that is what it will take to get an important job I have in hand done successfully!

I say this based on concrete, and verifiable achievements I recorded during my time in paid employment. Starting as a graduate managment trainee in Guinness Nigeria, I gained rapid career advancement, up to senior management level by LEARNING to handle the few “devils” I came across.

I honestly believe you need to adopt a similar mental attitude too (The reference to the “devil” being – of course – figurative).

So Here’s What You Can Do, To Work Successfully With A Difficult Co-Worker:

1. Focus On The Job To Be Done:

For the period you have to work with this person, put aside (I did not say give up) your biases. Interact with him based on the issues arising from the work you have to do together.

2. Find Out What Makes Him/Her Tick:

With very few exceptions, all human beings, no matter how difficult or unpleasant they may be, will have certain things they love or that gives them pleasure. Find out what it is (or they are). This may not be easy. But it could be worthwhile. If you can find a way to identify what brings out this person’s good (or better) side, you can use that insight to achieve a better working relationship with him.

3. Speak/Act With Emotional Intelligence:

An emotionally intelligent person demonstrates empathy in her interactions with others. She is sensitive to the feelings of others, but will at the same time not hesitate to act assertively in dealing with abusive or duplicitous behaviour.

Right from the time you meet him, resolve to speak and act with active consideration for his perspective. Make it clear by your words and actions that you respect him, and will do nothing to undermine him.

Gently try to establish what concerns and preferences s/he may have regaring the work to be done. Try to put them into consideration when you interact with him/her subsequently. Make friendly conversation as often as possible – except s/he stops you.

Stay alert to opportunities that will present themselves, to gain his trust or win his confidence. Sometimes people like this will warm up to someone who demonstrates a level of competence they appreciate. When this happens, be sure to tactfully offer praise for his own demonstrated abilities where possible. Avoid being patronizing though.

Most importantly, stay away from individuals or groups who may try to start unflattering conversation about the difficult co-worker you have to work with, even if the latter is not present. It does not benefit you in any way, and will only endager the relationship/rapport you’re working hard to build.

4. Support Unconditionally, But Demand Commitment:

Give your unreserved, active and positive cooperation towards getting the job done with your difficult partner. However, it’s important to send out a clear message that you expect him to reciprocate.

Therefore, do NOT hesitate to call him to order if he fails to play his part with the required commitment.

Once the project has been successfully completed, you can go back, and “pick up” your biases and reservations about him again.

I would however say, from personal experience, that if you apply the above suggestions diligently, you’re likely to establish a decent level of understanding, with him, that your colleagues will not have. And this could help you maintain a friendly or mutually respectful relationship for the long term.

Master This Strategy, And Your Career Advancement Prospects Will Blossom!

If you make a success of working with difficult co-workers, as the need may arise, you’ll be living up to your commitment as an employee, to give your service to the level that justifies the salary you get paid.

But even more importantly, decision makers would consider you capable of adapting your communication style to influence those you lead, in order to achieve your workplace goal. And that’s an attribute required for success in managing people. If/when they have to pick someone for promotion (or to lead others) therefore, your name would tend to come up for consideration. It’ll only be a matter of time, before you get chosen.

TIP:

On a final note, when next you meet (or get told about) a “difficult” co-worker (or boss), try getting some “practice” in handling difficult people, by using the ideas proposed in this article, in relating with him/her. You’ll come away better prepared for the day when you actually get “assigned” to do the real thing. Goodluck!

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:

[Tuesday]:

[Wednesday]:

[Thursday]:

[Friday]:

FREE Download Gifts from TayoSolagbade.com for Farm CEOs and Others

[Saturday]:

Formulating Livestock Rations by Adjusting for Dilution Effect of Non-Protein Contributing Ingredients [True Story: Helping a Farm CEO Client Understand the Thinking Required]

[Sunday]:

Why You Now Need to Exercise Caution in Accepting Invitations to Attend “Large-Crowd” Religious Functions in Nigeria [Feature News Report = Bloody Saturday In A/Ibom: 200 Worshippers Dead After Church Collapses, How Governor Escaped Death By A Whisker]

Protected: THE FARM CEO (Issue 68): Innovative feed formulation methods reduce feed cost, Practical Ideas to Address High Feed and Production Costs, Developments in the Indian feed and poultry industry and formulation of rations based on local resources – Dr.V.Balakrishnan, Opportunities to improve feeding precision and reduce costs with the latest NIR technology to be presented at Bangkok conference

[Excel Heaven Tutorial 06] Using The Macro Recorder to Learn Basic Excel-VB Coding – Recording a Macro and Viewing/Interpreting the Excel-VB Code in the Visual Basic Editor Interface

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

[Excel Heaven Tutorial 06] Using The Macro Recorder to Learn Basic Excel-VB Coding – Recording a Macro and Viewing/Interpreting the Excel-VB Code in the Visual Basic Editor Interface

The preview below is a text transcript version of my audio explanation in this 11 minute long screenshot video tutorial, about “Using The Macro Recorder to Learn Basic Excel-VB Coding”. It was emailed to members of my Excel Heaven Visual Basic Automation Club [Tip: Click here to request a copy of the video]

I’m going to show you how to use the Macro Recorder as your teacher.

In order to do that, I’m going to record a macro and then go into the coding intergface and explain how the various lines of code work, in terms of the references they make to various parts of the Excel object etc.

xlh-tut06-11thdecember2016

FREE Download Gifts from TayoSolagbade.com for Farm CEOs and Others

Some of the downloads below were originally made available (for Farm CEOs, Website Owners/Writers, Career Persons, Experts-Who-Speak etc) via my now defunct 9 year old domain – spontaneousdevelopment.com – before it was taken over by Aplus.net (click to read story).

Use the link provided below to signup and get download links to the one(s) that interest you.

18.0 Fruits You Eat That Leave Useful Peels Behind FREE PDF download created by Tayo K. Solagbade

Click here to subscribe and get the download links

17.0 Practical Feed Formulation Handbook(.pdf)

Many visitors to this site have already requested /downloaded this FREE chapter from the E-book version of my 70 page Practical LivestockFeed Formulation Handbook.

Click here to subscribe and get the download links

16. One-Page Operations Calculations Spreadsheet For A Startup Catfish Farm

Contains very detailed operations data calculation for Vats, Ponds, Stocking, Projections for Feeding, expansion, harvesting sales etc.

Click here to subscribe and get the download links

15. 10 Frequently Asked Questions About Feed Formulation

Click here to subscribe and get the download links

14. SPEAKING IDEAS™ – 25 Articles and True Stories for Experts Who Speak and Those Aspiring (Volume 1)

Click here to subscribe and get the download links

13. Variable Costs Analysis Control Quiz for Business Owners –(.pdf)

This is an Acrobat PDF document containing 17 questions designed to get you thinking about possible areas in which you can look to apply spreadsheet facilitated VC monitoring/control and reduction initiatives in your business. Read the article titled “You Can Icrease Your Profits Without Raising Your Prices“. to learn more.

Click here to subscribe and get the download links

12. Catfish Farm Resuscitation Action Plan Document (.zip)

Read An Action Plan Proposal Prepared For Resuscitation Of A Catfish Farm(zipped along with an article titled “Catfish Farmers, Beware Of Uncontrolled variable Costs!“. The plan never got used due to unexpected events. That however does NOT make the document any less valuable as a reference tool.

Click here to subscribe and get the download links

11. Action Plan/Progress Evaluation Checklist Template – (.pdf)

This Checklist will force you to document up front, the various key tasks you need to perform in order to achieve your set goal(s) over a defined time period.You will also be able to record DATE ACHIEVED next to each task successfully completed. Read the article titled “Where Do You Want Your Business To Be FIVE Years From Now? (Action Plan/Progress Evaluation Checklist)“. to learn more.

Click here to subscribe and get the download links

10. Breakthrough to Purpose – Andy Brine Interviews Efe Ohwofasa Verbatim Text Transcript Created by Tayo K. Solagbade ( FREE PDF)

Click here to subscribe and get the download links

 

9. Introduction To Public Speaking For Business Marketing (PDF)

This report explains why public speaking remains a powerful way strategy for cost-effectively marketing your products and services to large numbers of people at once – especially when you have a limited budget. It’s been used for decades by the smartest and most successful individuals and businesses in the world. You can learn to use it too.

Click here to subscribe and get the download links

8. KUKURU DANGER™ – 5 True Stories About the Adventures – & Misadventures! – of a School Age Child Trying to Find Purpose in Life

Click here to subscribe and get the download links

7. NEVER Let Anyone Tell You What YOU Cannot Do! (Transcript Slideshow Version of ESPN’s July 21 “SportsCenter” Profile video about Richie Parker – the engineer born without arms, who designs championship winning NASCAR race car parts/components) FREE Microsoft Power Point Show download in a compressed zipped folder created by Tayo K. Solagbade

Click here to subscribe and get the download links

6. Burt Dubin’s latest book: “On Being a Master”

Click here to subscribe and get the download links

5. A 2 chapter free PDF preview of my latest ebook (WHY YOU KEEP FAILING TO ACHIEVE YOUR WRITING GOALS! (10 Habits That are Holding You Back and How to Change Them for Good!), now on sale in my online store here.

Click here to subscribe and get the download links

4.0 Tayo Solagbade’s Self-Development Bible (.pdf)

This is a FREE e-book version of the Self-Development Bible. It is a 113 page Self-Help manual that I wrote in 2002, based on a 1 Hour Talk I offer. The glossy covered print version became available for online purchase at Cafepress.com in May 2005, and Lulu.com in July 2005).

Click here to subscribe and get the download links

3.0 SPECIAL REPORT: Your Company May Be Losing Money By Retiring Employees When They Clock 60 Years – And Above!

The title is provocative. But it’s message is based on scientifically established facts – references supplied. If you run an organisation, or have to manage people, you’ll find it a VERY useful read. Every working adult needs to read this report because it uncovers a massive LIE that’s been burned into our thinking from our youth. Correcting this wrong thinking can help YOU maximise your full potential in life right into your 90s!

Click here to subscribe and get the download links

2.0 Become UNSTOPPABLE:- Inspirational Mind Map Based On Abe Lincoln’s Life(.xls)

This download was created to support Tayo’s article titled “Become UNSTOPPABLE By Having “Blind Faith” And “Refusing To Recognise Failure“.

Click here to subscribe and get the download links

To Succeed, We Must Help Ourselves – the Government Cannot Help Us

It’s time for us to wake up from our slumber as Nigerians and Africans. I mean that with reference to EACH of us an individual and NOT our collective identity as a people.

I am self-driven, and have always believed no one outside of me (and the Creator) can control what happens in my life. By implication therefore, I never wait around for anyone to do anything for me, and I certainly am never prepared to beg anyone to give me anything either.

Some have called me arrogant because of that. But that’s an incorrect interpretation of my disposition. I simply know myself well enough to be sure I do not need to act subservient or over-humble to anyone, in order to get what I want.

What you need to succeed in life is too get a sound understanding of how things work, and then use that understanding to go after your goals.

My philosophy is that I alone am responsible for moving myself forward.

The actions or in-actions of others are of little or no consequence. For as long as I remain focused and determined, and persistent in pursuit of my goals, with intelligence, and faith, I will be furnished with what I need to get there!

Guess what? THAT is exactly what has happened in my life from as far back as I remember.

Initially, especially during my time in the university and later paid employment, I did it intuitively, without conscious thought. It just came naturally to me. I just knew it worked to be that way,

But when I became an entrepreneur in 2002, and began to dig deeper into principles for success achievement, to deal with severe setbacks I faced, I discovered the Science of Getting Rich (SOGR) philosophy

It took me time to learn how to make it work (and I continue learning even now), but eventually I got the hang of it, and my ability to succeed with more predictability has since grown tremendously.

A good indicator that one has gained mastery in use of this philosophy, is when you are able to get results you want, even when others complain about general downturn in fortunes e.g. during a recession. That’s what Wallace D. Wattles, the late author of that little book promised.

The World’s Future Prosperity Depends On Digital Multipreneurs™

eBook (PDF), 49 Pages
The World's Future Prosperity Depends On Digital Multipreneurs™
Subtitle: Sustainable Socio Economic Prosperity Worldwide is Achievable Through Creation and Proliferation of Digital Multipreneurs™ in All Societies This book is based on a White Paper first published online by Tayo Solagbade in January 2006. Tayo has since applied the ideas and strategies described in it to achieve the success he enjoys today as 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 – by providing solutions to buyers within and outside Africa. For policy and decision makers in private and public sectors, seeking tested ways to empower multitudes at less cost, and using less effort/money, this book’s contents offer limitless potentials – IF used correctly. Continue to online store. (Click here to request for a copy of this PDF ebook via email download)

The SOGR philosophy is what has helped me realize that EACH of us can become a viable agent of positive change and progress in his/her own area of influence. 

I have been succeeding doing just that, in my interactions with member of my target audience on and off the web, within and outside Africa.

It’s been amazing to see the results – and I know if more of us were to adopt a similar strategy, we would transform our societies for the better.

This is what happens in many developed societies. Everyday ordinary people taking control of their lives, instead of calling on the government.

They take action to create the opportunities they want, starting where they are, with what they have. If it means working completely alone for years, like I have done, they do it. Then when success begins to come, others join in.

If you feel you do not have the time, talent, training or resources, to do it, then look for ways to support others who are doing it, so they can be better equipped to succeed. Their success will still rub off on you and the rest of society. 

Let’s stop wasting valuable time waiting for government (or indeed “God”) to do things for us that we can – with focus, determination and persistence – do by and for ourselves.

I refuse to live my life complaining about what I lack because some government failed to do what it promised to do.

Instead, I wake up daily with the mental attitude backed by unshakable faith that ALL I need will be brought within my reach at the right time by the Creator, if I take regular/daily action towards it.

We can do the same thing.

Now don’t get me wrong. Applying the SOGR philosophy will come with delays, disappointments, setbacks and attendant lack/suffering. But all of that serves the necessary purpose of purifying you to EVOLVE to the superior state you are advancing into. Nothing good that lasts comes easy!

So, what matters is for those of us who are willing get the ball rolling, while those looking for ideas decide where to come in. Sooner than later we will succeed.

[REAL LIFE CASE STUDY from Ghana]: A real life example of an INDIVIDUAL home based African doing what I recommend in this article, that the rest of us also adopt as a way of life:

An Indigenous African Church Leader Who Makes World Class Talking Automobiles (Incl. Engines!) From Scratch, Using Local Materials in Ghana: Meet Apostle Dr. Kwadwo Safo

Related Article: Pre-Marital Sex Amongst Teenagers – A PROPOSED SOLUTION