Category Archives: Excel-VB Solutions

A People’s Ability to Disagree Without Being Disagreeable is Crucial for Societal Advancement [Hint: Why Too Many of Today’s Nigerians Are Often Too Angry to be Reasoned With!]

It’s something that first began to really strike me when I visited Nigeria for the first time about 6 months after relocating to Cotonou.

I mean the fact that there are a LOT of (indeed too many!) VERY angry people within the geographical entity called Nigeria.

One time I was in the chauffeured 4 wheel drive of a Cotonou based Nigerian diplomat as we drove through the border town of Badagry, on our way to his farm house in Ekiti.

I could not help pointing out to the driver how readily one could see people shouting insults and curses at one another on either side of the road. Some were even fighting – right next to the highway, with most others simply walking past.

Motorists themselves acted no different as we continued. The tiniest misdeed on your part as you drove readily earned you a torrent of insults – or if you were lucky an impatient look of contempt!

This was in stark contrast to what I’d seen and experienced during the tough first 6 months I’d stayed in Benin Republic. Indeed, the only time I ever saw ANY form of aggression displayed by locals in Cotonou was when 2 robbers were given the beating of their lives, and left bleeding for the police to pickup, after they tried to rob a woman emerging from a bank around Etoile Rouge.

Look, as I’ve said in past articles, I once spent 3 months – in 2013 – living among undergraduates half my age, in a room on the National University campus Calavi, when I failed to find accommodation in Cotonou.

It was a last resort arranged by a friend I made which saved me from getting further duped of 2,000 FCFA multiples, by the greedy estate agents I naively trusted to take me around to see flats I could rent.

But my housing problem apart, I NEVER once saw a single fight occur on that campus all through my 90 day stay there. Not once – and believe me, I moved around a lot.

If anything, I discovered from being among those young Beninese male and female students, that theirs was an environment in which PEACE MAKING valued in the larger society, was not only actively promoted, but also strictly enforced.

Indeed, if you were heard or seen shouting at one another, without so much as physically touching one another, chances were good that those involved would get summoned and possibly disciplined.

I saw that happen at least once, before I left that campus.

One day in Cotonou, after I’d left Calavi and found my own apartment, I recall seeing a commercial bike rider accidentally splash water in a pothole on a man standing along the road.

The latter angrily called out to him, and the bike man stopped and retorted in like manner. Before they could do anything more, a 3rd person who was just passing by, stepped between both of them and said, in French “Ici au Benin, c’est toujours la paix!” (Translation: “Here in Benin, it is always peace!”).

Magically, that simple statement instantly deflated the anger in both men, and I marveled as all 3 men smiled, shook hands and parted ways!

That was the day I realized that citizens of a nation have the power to determine whether or not they get along – regardless of the antics their leaders may try to use to cause conflict among them.

Sadly, this is one more truth I see too many people in my country, Nigeria, simply do not understand: As a result, they routinely let their emotions get out of control in relating with one another, especially when holding opposing views, to the extent that understanding and peace become strangers in their societies.

I argue that we must “learn to disagree without being disagreeable“.

It’s hard to remember where I first read or heard the above phrase used, but it has stuck in my mind since.

Life would be a joke, or an exercise in deception if human beings did not periodically disagree with one another.

There is a quote I once read that:

“Where everyone thinks alike, no one is doing any thinking!”

For some strange reason, people raised in the Nigerian society arrive adulthood with a notion (and a VERY faulty notion it is!) that one must accept the reasoning or thinking adopted by the majority.

Some will even parrot the popular saying (used most times out of context) that “majority carries the vote” – to justify going along with what others say, and demanding that you do the same.

Anatole France, the shipping magnate however wisely noted as follows:

“If a million people say a foolish thing, it is still a foolish thing.”

Sadly, Nigerian society is a place where those willing to express divergent views on an issue often find themselves in the minority…

This is because most others would rather quietly align with the majority to avoid criticism, or worse, from others who have been taught o be viciously intolerant of opposing views.

It does not matter what the subject is – be it religious or intellectual. It does not matter how logical the arguments made need to be: If it so happens that some people are more “friendly” with one another, chances are good that they will simply gang up against those with opposing views – even if their own argument makes no sense!

After observing this happen for some time, and having it done to me several times, I conceived the following quote in an article published back in 2006, to describe those who allow themselves to be brow beaten and stifled by irrationally argumentative others who predominate in society.

“Some people join the crowd in order to become “hidden” or “protected” from criticism or scrutiny. Since they also take care never to voice contrary (and at times ANY) opinion, they are rewarded with the anonymity they seek – and the insignificance that results from it.” – Tayo Solagbade

I’ve done additional research on this subject and found that such irrationally argumentative people also exist in other societies around the word – including the wonderful US of America!

The difference I’ve noticed however, especially in the developed societies, is that those who hold divergent views from the irrationally argumentative group, generally REFUSE to give up their rights to FREELY EXPRESS their difference of opinion in public or private.

Not just that, the various sociopolitical structures extant in those countries make it literally impossible for ANYONE to stifle or intimidate others, even if they are a minority, from VOICING their opinions as and when they please, where and when they want.

It’s every human being’s fundamental right to speak FREELY what s/he believes about an issue. You do NOT have to accept it, but you must RESPECT his/her right to do so.

That is how a civilized society functions. We must never let our emotions blind us to the proper ways of doing things – or stop us from acting with consideration for the feelings of others around us!

It is my considered opinion that given what I see in today’s Nigeria, if Socrates had been born in our time, in our country, Nigerians would probably have lynched him to death before he could make a name for himself!

Yep. He would have probably been shouted down – or worse killed – for his adopted questioning technique, which forced those he debated with to furnish credible logic based arguments to defend their adopted positions on issues.

People intolerant of others unwilling to agree with them would find a person like Socrates simply intolerable!

Yet, if Nigeria is to evolve and mature into a progressive society, the QUALITY of debates we are able to have among ourselves, without rancour, really needs to improve.

I’ve witnessed lively debates on various issues under the sun by Beninese adults holding opposing views over the last 3 years, and NOT once have I ever seen it end in broken friendships, or harsh language. It seems to be something they’ve learnt to do from their youth – as my stay on their campus indicated!

Now here’s one quote I especially LOVE, because I think many people fail to realize how doable it is:

“I don’t have to agree with you to like you or respect you.” – Anthony Bourdain

You see, it is my considered opinion that unless a person you like, love or respect has done something UNWORTHY or UNBECOMING or simply BAD, you really have NO NEED whatsoever to CHANGE how you feel about him or her.

So, if s/he chooses to support a different candidate during the elections for instance, you will understand that s/he holds a different view of what that person is capable of achieving in office, compared to the candidate you prefer.

That should not stop both of you from remaining friendly with one another during or indeed after the elections are over.

I recall we used to say back in my undergraduate days that:

“We can agree to disagree”

Only people who take things too personally, fail to understand the need for this matured way of living. They believe they must either win you over to their line of thinking or stop liking you or speaking with you. Haba!

The quotes below provide a fitting end to this piece, and also throw a challenge to ALL of us, regarding our adopted attitudes towards debatable issues.

“I will never compromise Truth for the sake of getting along with people who can only get along when we agree.” – D.R. Silva

“I disapprove of what you say, but I will defend to the death your right to say it.” – S.G. Tallentyre, The Friends of Voltaire

“Few people are capable of expressing with equanimity opinions which differ from the prejudices of their social environment. Most people are incapable of forming such opinions.” – (Essay to Leo Baeck, 1953) Albert Einstein

“It’s okay to disagree with the thoughts or opinions expressed by other people. That doesn’t give you the right to deny any sense they might make. Nor does it give you a right to accuse someone of poorly expressing their beliefs just because you don’t like what they are saying. Learn to recognize good writing when you read it, even if it means overcoming your pride and opening your mind beyond what is comfortable.” – Ashly Lorenzana

Final Words: The ability to act in line with the above admonition will often be a function of the DEGREE of Emotional Intelligence(EI) an individual possesses.

It’s a shame that in this part of the world many still do not realize that EI is more important than IQ for achieving success in life.

Actually most do not even know what EI is or means!

And the few who do fail to understand that unlike IQ, it can be improved by any person willing to make the effort. Indeed, many progressive societies are modifying their schooling systems to incorporate activities that help learners (especially kids) develop their EI.

Click here to read my widely syndicated article on EI – based on what I learned by reading Daniel Goleman’s similarly titled book back in in 2006.

Here’s one final quote to drive home my point…

Truth does not become more true by virtue of the fact that the entire world agrees with it, nor less so even if the whole world disagrees with it. – Maimonides, The Guide for the Perplexed

So, dear reader, I say this to you:

Engage in intellectually stimulating debates with others, without letting your emotions get out of control. And while doing so, be sure to remain objective in looking at the issues from all perspectives, while keeping an open mind to acknowledge possibilities you may not have considered previously.

Most importantly however, AIM to always end your debates on a positive note with him/her or them.

Make it your resolve to never take anything that is said personally. The world NEEDS diversity to evolve – but the truth, about all issues, even if initially hidden will eventually be revealed to all!!!

Related Article:

Why I Voted for Buhari (Despite Voting Against Him in 3 Previous Elections), and Why I Believe He Has What it Takes to Reform Nigeria Now That He’s President

Download MS Excel-VB Screen shot Demonstration Video Tutorials for Tayo Solagbade’s Introduction to Excel-VB Automation Workshop Held on Sat 19th March 2016 in Lagos-Nigeria [Includes video recorded in response to last week’s request for Excel-VB coding help from a business user in India]

This post contains download details about the range of step-by-step home study video tutorials I’ve created (see screenshot below) for use by members of my Excel-VB Club, based on the practical exercises done during the maiden edition of my FREE Monthly Workshop for members.

As I said in the highlights I shared yesterday (Monday 19th March 2016), in my newsletter for this week, I promised them I would create videos for them to study at home to reinforce what they’ve learnt, and also build on it to improve to higher levels.

The case study was about preparing a month end 3 column report table, populated with Naira sales amounts serially numbered, then using code to replicate it, in different worksheets from January till December, assigning the relevant month’s name to EACH worksheet’s tab.

Screenshot of video tutorial - Introduction to the Visual Basic Editor (VBE) in MS Excel

This case study is one that a lot of business users can relate to, so it was no surprise that the attendees showed lots of interest, and made excellent suggestions about applying the same approach to work they do e.g. preparing monthly payrolls etc.

The following videos cover the stages we covered in developing the solution:

Video 1: Introduction to the Visual Basic Editor (VBE) in MS Excel – Ready

Video 2: Understanding the use of conditional expressions in automatically numbering entries made into the data table – Ready

Video 3: Building the Monthly Report Table (with macro recorder ON) – Part 1 – Ready

Video 4: Building the Monthly Report Table (with macro recorder ON) – Part 2 ] – Ready

Video 5: Adding form controls, and Modifying macro recorded code, to replicate the Monthly Report Table – Part 1 – Ready

Video 6: Adding form controls, and Modifying macro recorded code, to replicate the Monthly Report Table – Part 2 – Ready

Video 7: Adding form controls, and Modifying macro recorded code, to replicate the Monthly Report Table – Part 3 – Ready

Video 8: Adding form controls, and Modifying macro recorded code, to replicate the Monthly Report Table – Part 4 – Work In Progress

[Update] Video 5 to 8 descriptions above, added today Monday 28th March 2016 @11:04]

If you’re a club member, relevant download links would have been emailed to you. If you have not seen them email or call me.

If you’re a non-member, and would like to gain access to the above mentioned learning resources, click here to contact me.

This is the response he sent to me after seeing my modified code module, and test running it successfully - today Monday 21st March 2016 at about 3p.m

Now, in addition to the above mentioned video, I’ve included on this page, download links with explanatory notes, to the video I recorded in response to last week’s request for Excel-VB coding help from a business user in India.

The above screen shot of the email he sent me (after seeing my revised version of the code he sent me days earlier) indicates he was pleased with the result he’d gotten from me.

For members of my Excel-VB club, like I told the Indian gentleman from the start, THIS short problem solving project provides a REAL WORLD relevant problem solving opportunity to learn from.

That’s why I’ve included download links to the 2 zipped folders I sent to the man who requested the solution, for members to download:

1. A zipped folder containing the video recording in which I explained what I’d done, and demonstrated how to run the resulting code. [click here to request from me]

2. A zipped folder containing the workbook he sent me, with the modified code in it – no password protection.[click here to request from me]

IMPORTANT TIPS FOR WATCHING THE VIDEOS

To watch ANY of the tutorial videos, YOU MUST (and this is important!) REMOVE or EXTRACT the 2 files in the zipped folder, and place them in the same location on your PC.

Next, double click on the web page file (with the browser icon) among the two, to watch the video in your browser. If you get a prompt to activate “Adobe Flash Player” click on the prompt to activate it by following the instructions that appear.

WARNING: If you click on the SWF file, it WILL NOT play the video.

AND if you click on the files without REMOVING them from inside the zipped folder, you will get an error message. The video will not play.

For the video to play, YOU MUST copy out or EXTRACT both files from inside the zipped folder and place on your PC in the same location, TOGETHER. Then click the one with the browser icon.

PS: If you’re a club member, relevant download links would have been emailed to you. If you have not seen them email or call me.

If you’re a non-member, and would like to gain access to the above mentioned learning resources, click here to request from me.

PII 006: Succeed by Becoming an Expert at Solving Real World Problems [Hint: Highlights from Maiden Edition of Tayo Solagbade’s FREE Monthly Workshop for his MS Excel Heaven Visual Basic Automation Club Members Held on Sat 19th March 2016 in Lagos-Nigeria]

Photo[Apologies for slightly poor image]: Attendees at the maiden edition of my FREE Monthly Workshop for Members of my Excel-VB Club held in Lagos at Sherryville Arcade, Opposite First Bank Plc, Ojodu-Berger, Lagos.

The topic was Introduction to Excel-VB Automation.

It was VERY practical and I told lots of true stories to add useful perspective for the learners in the small group of 5. But we had NO power supply and NO petrol for generator. Thankfully, the laptops allowed us make useful progress, for about 2 hours before their batteries ran out of juice!

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 006: Succeed by Becoming an Expert at Solving Real World Problems [Hint: Highlights from Maiden Edition of Tayo Solagbade’s FREE Monthly Workshop for his MS Excel Heaven Visual Basic Automation Club Members Held on Sat 19th March 2016 in Lagos-Nigeria]

Photo[Apologies for slightly poor image]: Attendees at the maiden edition of my FREE Monthly Workshop for Members of my Excel-VB Club held in Lagos at Sherryville Arcade, Opposite First Bank Plc, Ojodu-Berger, Lagos.

Photo[Apologies for slightly poor image]: Attendees at the maiden edition of my FREE Monthly Workshop for Members of my Excel-VB Club held in Lagos at Sherryville Arcade, Opposite First Bank Plc, Ojodu-Berger, Lagos.

The topic was Introduction to Excel-VB Automation.

It was VERY practical and I told lots of true stories to add useful perspective for the learners in the small group of 5. But we had NO power supply and NO petrol for generator. Thankfully, the laptops allowed us make useful progress, for about 2 hours before their batteries ran out of juice!

In the coming weeks, I’ll build on this foundation given them with MORE online tutorials and tips, until next month’s edition.

By way of interest, before the workshop went into full swing, I received 2 phone calls from potential buyers in the presence of my attendees….

One was from a Startup Farm CEO in Enugu who had contacted hours before, in the morning, via my website auto response message about my Excel-VB Poultry Farm Manager.

xlvb-ife1

The other was an individual who called – for this first time – using a UK mobile phone number.

24 hours later (i.e. on Sunday p.m.), the former had made a deposit into my account to take up an offer I’d made to him. I delivered his personalized version of the products to him this morning before leaving to resolve some issues with my bank.

xlvb-ife2

I mention the above incident, because that development served to further convince my learners that acquiring Excel-VB development skills like I had, would translate to significant income earning benefits for them!

This journey of building a club based follower ship began in May 2015. But to get this far, I’ve had to work hard on myself for YEARS!

I’m a self-taught developer of Custom Excel-VB driven Spreadsheet Software – and I’ve been developing custom spreadsheet solutions for business users in a very wide range of industries using my self-taught skills for 2 decades (starting with Lotus 1-2-3 before switching to Excel-VB in paid employment).

Initially, I did it while in paid employment, in my spare time – but it transformed my career and opened many doors of rapid career advancement opportunities that would NEVER have materialized otherwise.

Since I quit paid employment to do it for a living, in 2001, my work has evolved to a whole new level – with my products getting purchased by clients within and outside Africa.

All this has happened with only my self-taught skills. However, my self-development efforts in this regard have NOT been haphazard.

In order to improve myself, I studied – and continue to study – the works of experts recognized as established thought leaders and practitioners in Excel-VB Solutions development in the real world.

Examples of those whose works have influenced me are Pierre LeClerc, the fatherly gentleman based in Canada, whose approach to Excel-VB programming makes it so easy to rapidly improves one’s self via self-study, using resources he provides.

My encounter with his work, in 2005 changed the way I worked with Excel. He it was who really made me understand how to OPTIMIZE the Excel calculation engine, using it’s powerful spreadsheet functions and features, while enhancing my productivity by incorporating Excel-VB automation – where relevant.

You see, Pierre explains that a competent Excel-VB Solutions Developer will have a real world relevant problem solving mind set  – as different from the world view adopted quite often by people called “Programmers”.

Indeed, most times an Excel-VB developer will have a background in management, which will guide his/her intelligent use of MS Excel and its VBA back end for real world relevant problem solving.

This philosophy has helped me escape the trap that many others fall into, of wanting to CODE the life out  of every problem in an unconscious effort to show how skilled one is in programming.

The authors of Professional Excel Programming – which I call the Excel Bible – agree with this line of thinking. Indeed, in the first part of their book, the actually described 5 categories of Excel Developers – and they named those with the above tendency: “VBA Developer”

At the bottom of this piece is a diagrammatic representation, with notes, of those 5 categories – which reflects LEVELS of Excel-VB proficiency of a user.

I have chosen to base the coaching support I offer my target market on use of this model.

For the market I serve, I’ve found out that most users will most likely fall into Levels 1 and 2. My vision is to help those interested to move up to Level 4 – through the one-on-one experiential coaching I offer as well as the generic coaching I provide via my Excel-VB club.

But one problem I anticipate is that of the VBA developer types of business users and/or those with such a mind set

Excel-VB Solutions Development is NOT about ego tripping. We are not people obsessed with displaying our programming or coding prowess. Instead, we make intelligent use of our coding skills to ENHANCE our work productivity as it relates to our data recording, analysis and report generation for timely decision making.

That’s why I have examples of automated workbook reports (like this one build for the National Distribution Manager of a Large Multinational Telecom Company) that do NOT use a single line of VBA code, and yet cuts down report generation time by over 80% – compared to status quo!

Those who want to learn from me or engage my services must be willing to adopt this perspective, otherwise it would be impractical for us to work together.

A recent enquirer sent me some code he was having problems getting to run normally and asked that I help out. I was due to run my first workshop for my Excel-VB club members at the time, so I told him I’d create a video tutorial based on it later.

As I type this, it’s 3.24 a.m. Monday 22nd March 2016 and I just took my first real look at the code after pasting it into the code window of a new workbook.

What I saw INSTANTLY screamed “VBA Developer” to me.

Why?

Because some of the code sentences showed he was using code in VBA to do things that would have been better handled using Excel’s spreadsheet functions.

Whoever wrote that macro procedure/subroutine did a lot of coding overkill.

It pays to LET EXCEL BE EXCEL, if you want to get a solution that gives the user best results.

With what I’ve seen, I’ve decided I’m going to ask the gentleman to show me the data he wishes to handle, so I can gain better insights into what he wants to do with the code.

Then based on that perspective, I’ll point out the inadequacy of the coding approach adopted and propose an alternative more consistent with best practice.

In order to sell custom Excel-VB software as a profitable business in a socioeconomic environment where it did NOT previously exist (Nigeria), I’ve had to adapt ideas from developers in Europe and America to suit my needs.

The priority I’ve had to pay attention to has been the mental attitude of business users out here who balked repeatedly at any efforts to deliver solutions with a DIY provision.

In other words, they did not want to learn how to do what I’d done for them or how to maintain or improve on it.

Instead, what they wanted was for me to deliver what amounted to a “dummy-proof” range of solutions – that did not even require them to know ANYTHING about using MS Excel!

This is why today, in my promotional messages, for my Excel Heaven brand, I say “If you can use a mobile phone, you can use my custom Excel-VB apps”.

The above experiences have made me realize that users in these parts especially, or those with similar backgrounds to them will best be helped to develop interest in learning Excel-VB automation by using what is called a Case-Study based Experiential Coaching Approach.

Basically, this means that I offer to teach them Excel-VB programming by focusing on using the work they consider important as a basis on which to provide my tutorials, in such a way that at the end of each session they will leave with something they can immediately begin to apply to improve their work related productivity.

This strategy of Experiential Coaching necessarily makes it difficult, if not impossible to provide a one-size-fits-all range of tutorials for learners.

Instead, I have step-by-step video and PDF tutorials meant to introduce every learner to foundational concepts of Excel-VB programming.

These will give him/her the needed sound footing to build up his/her skills in BEST PRACTICE Excel-VB coding.

But to ensure s/he is able to make good progress without losing enthusiasm, I will use information I obtain using my Needs Analysis Questionnaire to identify – in liaison with him/her – key work based tasks that we can use as Case Studies for his/her learning.

Based on what I learn from his/her questionnaire responses, and our interactions as the coaching progresses, I can go on to create a special range of tutorials for him/her to use for home study.

This is my approach, based on the needs of my target market/audience, identified over the past decade.

Click here to learn more about my Home/Self-Study Tutorials used in my One-on-One Experiential Coaching

It is basically a custom solution in which I create learning “content” for YOU based on needs I identify you have. Access to this option requires joining my Inner Circle.

This is different from the arrangement in which I offer general coaching via short weekly tips and tutorials to members of my Excel-VB club (click here to see my members-only private/closed Facebook page for club members).

The required investment for the former (which is $500 USD via my Inner Circle) is different from that for the latter (which is $65 USD per annum – for membership of my Excel-VB club – click here for details).

It goes without saying that the one-on-one coaching option is more intensive than the Excel-VB club alternative. You will need to decide which one you will be best able to cope with – because I WILL CHALLENGE you to stick with agreed milestone targets/dates!

Click here to see the course content for my 4 day Excel-VB Programming Coaching LIVE Workshop

By way of interest, I offer to produce a home study video tutorial version of what I would normally teach during the above mentioned LIVE event – for interested persons – be you a one-on-one learner or member of my Excel-VB club.

But again, since not everyone will have similar needs, the specific examples I will use will vary depending on the individual’s identified needs.

Below: A mind-map showing 5 levels of Excel-VB Solutions Development Competence I offer support to achieve

ExcelVB-Levels - A mind-map showing 5 levels of Excel-VB Solutions Development Competence I offer support to achieve. I came up with this diagram based on categorizations made in Professional Excel Development - the massive Excel-VB programming bible written by 3 of the world's foremost developers i.e. Stephen Bullen, Rob Bovey and John Green.

I came up with this diagram based on categorizations made in Professional Excel Development – the massive Excel-VB programming bible written by 3 of the world’s foremost developers i.e. Stephen Bullen, Rob Bovey and John Green.

Each has delivered high profile commercial Excel-VB software solutions to the world’s largest corporations.

Note that my experiences over the years indicate that majority of business users want something around the Power User level – especially career persons in paid employment in this part of the world – as against what obtains in developed societies.

Having said that, my goal is to use my Excel-VB club platform to gradually encourage more users in and out of paid employment, to over time build their competence to the level of Excel Developer – and possibly beyond i.e. to Professional Excel Developer.

True Story: Responding to last week’s request for Excel-VB coding help from a business user in India

Last week, I published a blog in which I shared details of the above mentioned request I got from an Indian gentleman at about 12:53 p.m. on Tuesday 15th March 2016 (Read it here).

Early this morning, at about 4.30a.m or so, I got up and checked out his code, then wrote in modifications my first instincts led me to use – and they worked.

Then, just as I’d promised the gentleman, I proceeded to record a screen shot demonstration tutorial in which I explained what I’d done, and why. In the video, I gave him my opinion about the intended purpose of the code snippet he’d sent to me, noting the fact that better use of the Excel object model could minimize the need for VBA use for the task in question.

Below are screen shots of the original code he sent, and the modified one I sent back, PLUS email/facebook exchanges we’ve since this morning…

This is the original code snippet he sent me at about 12:53 p.m on Tuesday 15th March 2016 - click to read last week's article about our first conversation

This is the modified code I sent back to him this morning - Monday 21st March 2016 before 5a.m

Above is the lower part of the message I sent him, with my modified code workbook attached. Below is the message I sent shortly after, telling him I’d emailed the explanatory video I promsied to his GMAIL addreess

This is the email I sent him with the modified code workbook and explanatory video attached this p.m

This is the response he sent to me after seeing my modified code module, and test running it successfully - today Monday 21st March 2016 at about 3p.m

Above: Email in which he replied (after seeing my code) expressing satisfaction with what I’d sent him.

Notice in his last email response, above, that he said he looked forward to requesting more of my “help” in the same manner…

And interestingly, he stated that he was sure I would give it…being the “nice sir” that I am of course…hee hee!

Unfortunately, I do NOT do flattery. I do NOT need it.

I also do NOT feel ANY need to prove myself in terms of my Excel-VB coding (or any other) competence.

So, one thing I KNOW will NOT be happening again is ME doing any such thing for him again.

Either he joins one of the countless free forums, or he enrolls for a course online. Or he could join my Excel-VB club.

But even when if he joins my club, I will NOT be doing coding for him. I do NOT code for any of my members. Instead I teach them concepts, tips, techniques they need to know and then guide them to THINK up ways to use what they learn to solve ANY problem they raise for use as a case study.

That’s why I call my approach Experiential Coaching.

Some people believe that if you really know something, the best way to prove it is to TELL the learner. They argue that “using questions” and prompts, like I do suggests I’m not confident or competent or both – and that THAT is why I hide behind that approach.

My response is that I have a library of commercial Excel-VB apps that I’ve been selling to an increasingly global paying audience for over 10 years now. Not only did I build them – and find buyers – ALL by myself, I also provide LIFETIME after sales support 24/7 to ALL my buyers.

And that is ALL the proof I need!

If you’re a business user of Excel in Nigeria/Africa and you represent a group, organization or association of business users, and would like to gain access to the learning solutions I offer with regard to the above, click here to contact me.

SDN Blog

New posts from last week*
Monday:

[Tuesday]:

[Wednesday]:
[Thursday]:
[Friday]:

You Have to Believe In Yourself First, Before Others Can Really Believe in YOU [Maiden Edition of FREE Monthly Workshop for Tayo Solagbade’s MS Excel Heaven Visual Basic Automation Club Members Holds Today – Sat 19th March 2016]

[Sunday]:

Protected: THE FARM CEO (Issue 41): 3 Ways to Profits in Cassava Business, SECRETS TO MAKING MILLIONS IN PLANTAIN FARMING BUSINESS IN NIGERIA, GET LISTED FOR CASSAVA AND YOUR OTHER PRODUCTS TO SELL TO A GLOBAL AUDIENCE

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

 

You Have to Believe In Yourself First, Before Others Can Really Believe in YOU [Maiden Edition of FREE Monthly Workshop for Tayo Solagbade’s MS Excel Heaven Visual Basic Automation Club Members Holds Today – Sat 19th March 2016]

This afternoon I will meet with members of my Excel Heaven Visual Basic Club (and some invited professionals/prospective members), to conduct the MAIDEN edition of the FREE Monthly Workshop for paid club members.

When I conceived this idea in May 2015, of launching a club to teach MS Excel to business users (with a kiddies arm for youths), nothing happened for the rest of the year, despite my efforts to create awareness using ALL resources/channels I had access to.

xlhcluboffer

But, years of experience building my brand based on provision of a previously unknown solution (MS Excel-VB software development) had taught me to resilient!

It’s been like this for me since 2002. I have ALWAYS had to start out by BELIEVING all by myself, until others who needed what I offered EVENTUALLY realized they did!

If you expect people to jump instantly at your offers, or ideas, you are fooling yourself. You have to believe and persist, with creativity and determination, UNTIL they see what you see and begin to believe WITH YOU!

[EXAMPLE 1] Here’s an article I first published online over 10 years ago which proves that I practice what I preach.

Title: Achieve Business Success Using Spreadsheet Data Analysis & Reporting Automation

Data recording without analysis and interpretation is ultimately useless. Such data makes little or no meaning. Don’t keep records for the sake of it. Records only add value when they tell us one or more of the following 5 things:

1). If we are doing well or not;

2). How well – or badly we are doing;

3). When we are doing well – or badly;

4). WHERE we are doing well or badly;

5). And if possible “point to” WHAT – is probably responsible for our performance at any point in time.
All of the above of course happening in a timely manner that enables us take appropriate actions.

The key imperative for most people who handle data is to use it to monitor – and where feasible – control performance i.e. they study/anticipate trends in a way that helps decision making towards ensuring REPRODUCTION of desired results, while minimizing – or eliminating – undesirable ones.

The Excel workbook applications I develop for my clients help them do the foregoing and a lot more.

I am always careful to take into consideration the peculiarities unique to each client’s situation, which many traditional software programmers would be unlikely to cater for – at the same rates that I am able to offer my clients.

But not everyone knows that MS Excel can be used to develop high profile industry level applications that can hold their own against (or even outperform) conventional off-the-shelf software.

Click here to continue reading

[EXAMPLE 2] Here’s a 1 Hour Talk I’ve been offering since 2014

Key Target Audience: CEOs & Corporate Executives, Sales/Marketing Managers, Clubs/Association Presidents etc [Breakout sessions available]

“Everybody knows some Excel, but stop seeing Excel as an office program that everybody MASTERS and that is used to organize numbers in columns and make a few calculations. Excel is the best reporting application on the market and it is fully programmable with its own PROGRAMMING LANGUAGE within called VBA” – Pierre LeClerc PLI Consulting Inc

Attendees will learn proven strategies for:

Click here to continue reading…

 

All you need to succeed is vision, faith, determination, creativity and persistence!

This afternoon I will meet with members of my Excel Heaven Visual Basic Club (and some invited professionals/prospective members), to conduct the MAIDEN edition of the FREE Monthly Workshop for paid club members.

I’ll end by saying this:

If you want to know what it means to practice LIVING with FAITH – take a close look at my “history” in paid and self employment. Better still, take a look at my timeline RIGHT on Facebook!!!

I offer myself as a reference or model, not out of arrogance, but to indicate, especially to people from my part of the world, or anyone who feels s/he has no background upon which to reasonably aspire to innovate and create in a noteworthy manner, that ANYONE can do it.

You need no connections and success is NOT about genetic or heredity.

You don’t need to come from a family of entrepreneurs to succeed as one. You do not need to be the first to be the best.

I am proof of it, as I commence this NEW journey of creating an army of Excel-VB Solutions Developers with smart real world relevant know-how, who will be able to provide time, effort and cost saving business solutions for their employers and/or clients over time.

I’ve been developing high profile, bullet-proof automated spreadsheet apps for over 2 decades.

As an employee in Guinness I gain company wide fame for building custom spreadsheet apps that completely eliminated manual reporting systems in the departments I worked. I did this in my spare time – and I was NOT employed as an Information Technology staff. I was just a brewer/manager with self-taught spreadsheet programming skills.

In 2002, I followed my dream of developing custom spreadsheet software for a living, by quitting my job to become self-employed.

There was NO market for such a solution or service and over a 4 year period I had to create a market for myself.

Today, I have a library of apps I’ve built for clients in varying industries e.g. hotels, hospitals, medical clinics, independent consultants, health and fitness clubs, farm businesses, factories etc. I’ve not only sold my apps locally, but also to clients outside Africa – in places like Canada, Philippines, the UK etc. [See also the links at the bottom of this post for videos and other details]

What I have to offer MS Excel business users/learners – especially in Nigeria/Africa – goes beyond what you will find in ANY books or websites.

The insights I have about creating and SELLING custom Excel-VB solutions in our part of the world (and indeed beyond are drawn from thousands of hours of trying and failing until I found a way that worked.

Below, I offer more information for those willing to accept my guidance – be you corporate multinational or one man operation.

RELATED RESOURCES

Below are some links with information that throws light on potential applications of Excel-VB Automation for Boosting Business Productivity and Profitability

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

Go to http://tinyurl.com/xlvb1hourtalk

I offer the above linked FREE talk to organizations and business groups/associations that meet the terms for providing it.

2. Conversations About Productivity Boosting Excel Visual Basic Automation, True Stories, Enquiries from a business user in India and Nigeria

This is a new article I published yesterday…

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

http://tayosolagbade.com/sdnuggets/achieve-business-success-using-spreadsheet-data-analysis-reporting-automation/

This article offers VERY useful insights for business users like yourself and other members of your profession.

1. LEARN MS EXCEL-VB AUTOMATION FROM ME…IN THE COMFORT OF YOUR HOME!

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

2. Learn more about what you get on the DVD below:

Title: Get My Home Study Excel-VB Programming Video Tutorial DVD

http://excelheaven.tayosolagbade.com/?p=336

3. This page provides a detailed background (including a 9 part slide show presentation) about my Excel-VB Club and Competition:

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

http://excelheaven.tayosolagbade.com/?p=318

4. My Excel-VB Club’s Closed/Private Group on Facebook

Here’s the URL…

https://www.facebook.com/groups/736287616508718/

 

Conversations About Productivity Boosting Excel Visual Basic Automation [True Stories: Enquiries from a business user in India and Nigeria]

[UPDATE: 24th June 2024 – Download PDF Version with offer of download links to the original automated MS Excel Workbook and screenshot video demonstration sent to Pravin. Click HERE to download the PDF now – NO SIGNUP NEEDED]

Conversations---Pravin

Since announcing my FREE workshop Introduction to Excel-VB Automation on Monday, which is to hold tomorrow (Sat 19th Mar 2016) for members of my Excel-VB club, I’ve had some MS Excel business users contact me.

In this article I share screenshots and excerpts s from 2 such exchanges – one with a business user based in India, and another with a Nigerian Farm CEO – with background in corporate management – who is a member of my Cost-Saving Farm Business Ideas Club.

A. At about 12:53 p.m on Tuesday 15th March 2016, I got the message below from an Indian gentleman, requesting my help with getting Excel-VB code he was writing to run – trouble free – for a task he was trying to automate.

Here’s the message:

“Sir right now i got vba code for i have been searching from a gengleman…..but can we set two macro in a single excel sheet… The following code solved my Single problem.

Sub Copy_Paste_Data()

Sheets(“Sheet1”).Range(“A3:N1000”).Copy Destination:=Sheets(“Sheet2”).Range(“A” & Rows.Count).End(xlUp).Offset(1, 0)

End Sub

I shall use the above code when I have to export all all kind of data from A3 to N1000.

But If I don’t want to export the data having no value in column I.

If Column I has no value so that row will not be exported to Sheet2… What I mean to say that if I need all data to export then I shall use the above code and When I need to export data having value in column I then I shall use that code for i am requesting you to make.

So this way my grave problem will be solved……….please send me it to my maild id (removed for privacy)

At about 12:53 p.m on Tuesday 15th March 2016, I got the message below from the gentleman requesting my help with getting Excel-VB code he was writing to run - trouble free - for a task he was trying to automate.

I replied that I would do what he asked on the condition that he agree to let me use him/his “project” as a case study for step-by-step video tutorial I would share with my Excel-VB club members – who pay to learn from me.

He responded by sending a request to join my Excel-VB Club, and posting this follow up message:

It’s your kindness. Thanks for helping me……..Sir I shall eagerly be waiting for your mail with video sir………Thanks a lot again sir..
….

Sir, I got formula as I needed. but as we run that, it export the data
even with value (formula also exported and that looks #REF! ). so only
this problem remains now…….so please help this way now i am just
providing you this code that i recently got from a gentleman….

Sub Copy_Paste_Filter()

With Sheets(“Sheet1”)
.Range(“I3:I1000″).AutoFilter Field:=1, Criteria1:=”<>0”
.Range(“A3:N1000”).Copy Destination:=Sheets(“Sheet2”).Range(“A” & Rows.Count).End(xlUp).Offset(1, 0)
.Range(“I3:I1000”).AutoFilter
End With

End Sub

He responded by sending a request to join my Excel-VB Club, and posting this follow up message:

The above message came in a 4:29a.m – I’d only just gone to bed 1.5 hours before then, after finishing work on a client project.

So, when I saw it in the morning, I wrote back saying(in part):

“… I am just waking up…My priority this morning is to get a client’s boolk manuscript proof reading finished and returned to him…Only after that will I then be able to spend time creating the video tutorial I offered for use as a case study…If you cannot wait for that, I recommend you ask the “gentleman” that is giving you these codes to help you debug it to get it running properly. Alternatively Google to one of many open discussion forums and post your question there.

My Excel Heaven brand does NOT operate in that manner…When I’m done, I will create the promised video and send to you and my club members. “

He replied saying he would wait.

Looking back, I’m glad I was frank with him, because as I type these words, I still have to do a visit to the talk venue his p.m and also review material I’m to use tomorrow!

So, chances are good that I’ll have to create the promised video over the weekend.

One thing is certain though…

This exercise is going to be perfect for use in explaining how range objects can be manipulated using MS Excel-VB coding.

Even more important, this particular case study will serve as an introduction to EFFICIENT coding that executes faster compared to he clumsy code sentences generated by the Macro Recorder (which my club members are starting with)!

B. It’s now confirmed that I’ll be having more than ONE run of my 4 hour FREE talk event tomorrow. Reason: Some members of my Excel-VB club will not be able to make it down to join the main group from 2p.m.

Apart from those wanting to come at a different time (I told them I’d be HAPPY to meet ANY who chose to do so), at least ONE, based outside Lagos will not be able to come down at all.

For him and others like him, the nature of my Excel-VB club makes it possible to STILL learn ALL they need to know. See details below, based on a response I made to a member of my Cost-Saving Farm Business Ideas club, living in Ibadan, who asked about Video tutorials:

See details below, based on a response I made to a member of my Cost-Saving Farm Business Ideas club, living in Ibadan, who asked about Video tutorials:

It so happens that my Excel-VB club is designed to enable business users/busy persons who become members learn from me remotely, with the option of attending the FREE Monthly Workshop (Saturday’s being the maiden one).

Since they signed up, the current members have been receiving downloadable video tutorials taking them though what they need to know.

One member who is based in Port Harcourt, chose to purchase the Home Study video tutorials I’m creating on DVD. After the workshop on Saturday, I will add new videos based on that event’s outcome and send to him via Fedex.

I recommend you also join the club, so you can get the DVD via the 2-in-1 offer I make to new members i.e. pay the membership fee to join the club, in response to an offer I make to you via email, and I will send you the DVD containing the home study step-by-step videos, while you continue, like other members, receiving the online tutorials and tips I send out weekly.

Here are some useful links to give you a better idea of what is on offer:

1. LEARN MS EXCEL-VB AUTOMATION FROM ME…IN THE COMFORT OF YOUR HOME!

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

2. Learn more about what you get on the DVD below:

Title: Get My Home Study Excel-VB Programming Video Tutorial DVD

http://excelheaven.tayosolagbade.com/?p=336

3. This page provides a detailed background (including a 9 part slide show presentation) about my Excel-VB Club and Competition:

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

http://excelheaven.tayosolagbade.com/?p=318

RELATED RESOURCE

1 Hour Talk(No. 5): Proven Strategies for Using MS Excel to Boost Employee and Company Productivity (or go to http://tinyurl.com/xlvb1hourtalk)

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

 

1. Click the link below to download a 9-page MS PowerPoint Slideshow which explains in FULL details what you will be learning – and doing.

http://tayosolagbade.com/uploads/xlhcluboffer.ppsx

How can a “Switchboard” Make Your Life Easier in an MS Excel-VB driven Corporate Data Management/Report Generation System ? [Download A Useful Infographic]

NB: This post is based on excerpts from an update I sent to to my Excel Heaven Visual Basic Automation club members today.

Last week, I mentioned that I would be sending you a:

“…gift you can use in your work i.e. an Excel VB app called the “Switch Board” that you can copy to your PC and with a few entries in the settings table, use to open other files on your PC without needing to search all over for them. The visual basic code will be open so you can view and study it, towards learning how to build one.”

The attached is an annotated diagram, with explanatory notes/comments that I created (based on an original version I found on Pierre LeClerc’s website at the time) in 2008

I used it as a marketing tool to illustrate”how a LOW COST, easy to use/maintain and highly user-friendly Data Management/Report Generation System can be setup for a corporate organization using MS Excel-VB automation.

Note the reference in the diagram to “The Switchboard” as a “Single Screen Workbook With Labeled, Hyper linked Command Buttons”.

It (i.e. “The Switchboard”) enables ANY user click on labeled command buttons to quickly open ANY workbook they wish to use, without having to manually search through folders on the PC or company intranet.

This kind of Data Management/Report Generation System can be easily setup in ANY organization, by a user who has acquired the needed competence.

As members of my Excel-VB club (see our closed/private/paid-members only page here), you will be getting:

1. a zipped folder containing a switchboard linked to other documents shown in this diagram, so you can test drive it and get a feel for how easy it can make your life as a results focused business user.

2. Then I will follow it up with a video showing how to setup the whole system.

3. Most importantly, you will be able to request my support in applying what you learn to boost productivity in YOUR own workplace.

In your service,

Tayo

PS: For details of how to join my Excel-VB Club, read PII 005: You Need Excel-VB Coding Skills to MAKE and SAVE Money [Attend Tayo Solagbade’s FREE 4 Hour “Practical Introduction to MS Excel-VB Automation” Workshop]

[Advice for Smart Parents] You Need to Give Your Kids Real World Relevant Coaching NOW, If They Are to Succeed…In Their Adult Lives!

Here’s my key guiding philosophy as a Best Practice Parenting Practitioner & Advocate:

“If I fail as a parent to my kids, I’ve failed in life. A parent is meant to share his/her experience based know-how in a way that gives kids EQUAL or BETTER preparation (than s/he – the parent – had), to succeed in the real world. Any parent who does NOT do that, has failed…no matter how successful s/he may be in his/her personal life!” – Tayo K. Solagbade

The only parents who MAY disagree with what I say here, will be those benefiting from the problems I highlight in my discussion – and they happen to be the majority in the Nigerian society.

I however have no thoughts to spare for them. They will be rewarded by the creator for failing in their parenting duties to help the kids entrusted to them achieve self-actualization. And when – NOT if – that happens, I will shed no tears on their account.

I call myself a Location Independent Multipreneur because I RARELY need to physically meet clients to serve them

In other words, I do virtually nothing for my clients that I cannot do remotely from any location I choose to be – as long as I have web connectivity.

The major reason I prefer staying in Benin Republic’s Cotonou, as I’ve said in past articles, is that my spreadsheet based estimates clearly tell me that it costs me 3 times LESS to work from there, compared to Nigeria’s Lagos – and it’s also a more conducive sociopolitical environment e.g. I can walk around at 3a.m without fear of getting mugged etc.

But a recent review of my absence from home, especially when I stayed away for over 6 months at a go in my first 2 years in Benin, revealed a parenting problem I knew I would have to address.

When I relocated from Lagos to Cotonou on 1st April 2013, it was to reinvent my brand to fully establish my Web Marketing System in a way that would enable me generate 80% passive income.

Within 6 months to a year, Benin’s steady power supply and conducive socioeconomic situation enabled me do the quality and volume of work that enabled me achieve the critical mass of quality content to attract pre qualified prospects for my products/services.

Today, that system continues to work for me, and I’ve even survived a poaching of the 9 year old domain I started with (spontaneousdevelopment.com), to take it to even higher levels of productivity in terms of buyer recruitment and sales.

The above progress has since made it easier for me to travel with more frequency, away from Benin, and to stay longer periods before going back. My system continues to generate leads for me, regardless of my physical location.

If there was ever a time I needed that advantage, it has been between last year and now.

You see, I discovered that the impact of my prolonged absence as a father, from my kids (I have a soon-to-be 17 year old, who 2 other teenage brothers, along with 2 sisters – 10 and 7 – as well as a 2 year old brother)…was showing up in them via wayward behaviour, and a scary lack of appreciation of what awaited them in the real world of the society they had been born into.

What I saw convinced me I needed to devote deliberate time and effort to COACH and TRAIN them – to develop the right character and more importantly, to develop the SKILLS to function as independent minded, competent income-earning adults in society.

Considering the decay I’ve seen out here, I realize that what sets me apart from the crowd is what I must give my kids: And THAT is my strength of character and versatility in earning income.

That’s why I decided that I would begin staying home longer to coach my kids – especially since my plans to bring the family to join me in Benin was still work in progress.

The Nigerian society has corrupted TOO MANY people I know, for me to make the mistake of NOT giving my kids what they need to RESIST its corrupting influences!

Sadly, Nigeria has too many phony parents raising phony kids! The 2 quotes in the images below confirm what I’ve said above. They are words uttered in a TV show by a guest and a caller just a few days ago.

frisky-tvc

caller-tvc-14thMar2016

My priority are my kids. I will continue to say that wise parents will take time to read my parenting articles – and use the ideas I offer to prepare their kids to emerge as authentic achievers, and role models, that the Creator himself will reckon with.

I’ve now gotten my kids their bank accounts – as they have been starting their micro businesses e.g. my 10 year old daughter and her sister are in their 3rd week making cookies, chin-chin and home made bread.

Flyer - Temi & Oluoma's No-Oven Charcoal Stove Cookies

Here’s the Facebook page I setup for them(click) and which I’ve been challenging them to share their “experiences” and true stories on. This is my way of training them to develop thinking and writing skills while internalizing practical product making and marketing lessons they are learning. :

We have now printed labels for them (see below), and use my impulse sealer to seal the packs. Last weekend I went with her to make her second sale in a residential estate they periodically visit to attend a function.

temi-olu-labels-thb

Some weeks back, I got my soon-to-be 13 year old son to record the stages he went through to build a battery powered toy bike, which he learnt to do from a 3 minute video.

Click here to watch my video recording of the first functional bike he made at his very first attempt just 24 hours after he watched the video.

Click to watch video - Teach Kids to Develop (& Monetize!) Market Relevant Abilities EARLY In Life [VIDEO DEMONSTRATION: After Watching Short DIY Video, 12 Year Old Builds Battery Powered Toy Power bike Using Sticks from Sweets as Frames, a Rotor from Damaged DVD as Engine, Plastic Coke Bottle Covers as Tyres & a Microphone Battery from his Mother's Church As Power Source]

I told him how a small made-in-China toy car that does NOT move was put on sale – for N200 (two hundred naira) – in a neighbourhood shop, and suggested that we explore making painted versions of his for sale to kids, with a a FREE after sales repair guarantee to every buyer.

He bought the idea, and with help from his soon-to-be 15 year old brother, they did a 4 part video recording that we now plan to give out on DVD to kids who attend a practical workshop I want him to conduct, in which he will teach interested kids how to make the bikes themselves.

NB: My 16 year old’s blog on a subject he’s so naturally gifted about is to go LIVE soon. I’ve been guiding him to prepare content for it, and the intention is to build traffic and then monetize in various ways.

Indeed, if you’ve been following my writing a while, you’ll have read MANY past articles of other projects the kids have been exposed to.

In case you don’t know EXPERIENCING or DOING is the best way for human beings of ANY age to learn.

And when you stir up the interest of young minds in doing and especially CREATING original stuff of their own, that they see can add value to others in a way that earns them financial and other rewards, they WILL embrace it.

I am a PARENT first, and an entrepreneur 2nd. I have completely LOST faith in the Nigerian schooling system’s ability (regardless of how “classy” it is!!!) to protect the genius – and build the character – of my child.

Over 90% of the people I see around and interact with, especially in the Nigerian society, continue to behave in DUPLICITOUS (say-one-thing-but-do-another) ways that convince me I MUST COACH my kids to develop the STRENGTH of CHARACTER and skills to defy such 2-faced people!

Like I said in Kukuru Danger (my best practice parenting book), things were NOTHING like this when I was growing up.

Back then we had “societal parenting”: adults in schools, churches and other areas of society acted as parents to every child with fairness and impartiality.

During that period, when a child failed to pass the promotion exams. s/he had to repeat that class, and his/her parents would accept it as necessary. For those who failed their final year exams they had to enroll for “Remedial Classes” run after normal school sessions, or in private tutoring centres.

And then they returned to retake the exams till they passed. The best part was that when you met such a person who had “passed” exams, s/he often was able to demonstrate competence and proficiency to convince one that s/he indeed sat and passed by him/herself.

All of that is gone now. No one repeats for failing anymore. And today, in place of remedial classes/tutoring centres, we now have those that GUARANTEE 7 distinctions, for instance, at first sitting!!

It’s so bad now, and since the majority are doing it, it’s VERY hard for kids with young impressionable minds to see anything wrong with it – especially when those doing it are in such numbers that they gang up to manipulate evaluations systems everywhere to get ahead of those unwilling to cut corners.

I say the above because even well schooled persons from “good” homes are increasingly being revealed to readily compromise their values and/or morals often in a bid to get more without earning it.

A culture of intellectual and physical laziness has overtaken us, today, to the extent that those who display a willingness to earn what they get are actually looked down upon as “fools” – or as NOT smart (in Yoruba: “Awon ti o ja si”) by majority in the Nigerian society!

That’s why I’ve resolved to stay longer with my kids and give them that guidance. Thankfully, being a Location Independent Mulitipreneur affords me the freedom to adopt this parenting strategy.

I see today TOO many people who think spending money on kids equates to parenting properly.

That’s a BIG mistake.

This period of their lives requires the greatest amount of personal attention you can give your kids. Once they leave this phase, your ability to influence them will dramatically diminish!

A Warning: Best practice parenting – of the kind I advocate for adoption here – is NECESSARILY messy!

Yes, I need to end with this warning: nice as the rewards to be reaped may sound, you will need to do a lot of hard, unrelenting work to make it happen!

Don’t expect your kids to just fall and stay in line. There will be lots of mistakes, and they will get discouraged and distracted – but THAT is where your role is critical as a COACHING parent.

You must provide the needed guidance, and inspiration as well as support to keep them focused on getting to the desired end!

One example: This past weekend, my girls, with usual support from their brothers, made a new batch of chin-chin, but unlike last weekend, it did not all go well:

1. They used more flour than was specified in the recipe, because they added excess amount of water. The chin chin came out fine, but we knew our cost per pack would be greater. Meaning lower margin gains. (Yep: I’ve taken them through basic product costing calculations several times).

2. Due to a fault with the generator, the finished chin-chin could not be packed into their N50/pack nylons using the impulse sealer. So we had to keep them in a bowl till the next day (i.e. this past Monday) when the generator was fixed.

I was away from home when the sealing was done, but when I arrived at 9.30p.m, and asked to see the labeled packs, the tray they brought to me had ONLY 5 packs.

When I asked what happened to the remaining chin-chin, all the kids began pointing accusing fingers at one another. Simply put, they’d been eating the chin chin since they were produced, until all that was left could only make 5 small packs – which were even smaller than the ones from the previous Sunday for which we’d used LESS flour!

I was upset, and told my girls I was disappointed in them – then I proceeded to give 2 packs to their 2 year old brother, while I sat down and gobbled up the remaining 3 packs – completing the cycle :-)

But I gave them a pep talk about why letting that happen again would keep them from making sales to grow the money in their bank accounts. I think that got their attention, and I believe we’ll go back to our “winning ways” in the next run.

Like I said this will NOT be easy, but mark my words, dear parent-reader: If you do the hard work now, you will end up with kids you have little or no reason to worry about in your old age!

I have helped other people’s kids discover their purpose and aim for self-actualization over the years(click to read some testimonials).

It goes without saying that I MUST put this gift I have to the benefit of my own offspring!

The funny thing about “coaching” kids as a parent is that it is a slow – invisible – process, and the results will rarely emerge quickly. But if done right, the child will rarely be in doubt as to how s/he “made it”. S/he WILL thank you for your great parenting efforts!

 

PII 005: You Need Excel-VB Coding Skills to MAKE and SAVE Money [Attend Tayo Solagbade’s FREE 4 Hour “Practical Introduction to MS Excel-VB Automation” Workshop]

I have been paid as much as N200, 000 (Two Hundred Thousand Naira) – proof availableto build a single Excel-VB driven spreadsheet application. That same company – a large hospital with over 120 staff – went on to hire me in the course of the year that followed, to build two other apps (a Payslip Generator, and a Cash Office Payments Manager – designed for checking a patient’s payment status).

Late last year I stopped over at the hospital (for the first time in 3 years) when I came in from Cotonou, and they were still using 2 of the 3 apps: Since 2008 i.e. 8 years ago! That, more than anything else, is proof that those 2 apps continue to meet the company’s needs!

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 005: You Need Excel-VB Coding Skills to MAKE and SAVE Money [Attend Tayo Solagbade’s FREE 4 Hour “Practical Introduction to MS Excel-VB Automation” Workshop]

I have been paid as much as N200, 000 (Two Hundred Thousand Naira) – proof availableto build a single Excel-VB driven spreadsheet application. That same company – a large hospital with over 120 staff – went on to hire me in the course of the year that followed, to build two other apps (a Payslip Generator, and a Cash Office Payments Manager – designed for checking a patient’s payment status).

Late last year I stopped over at the hospital (for the first time in 3 years) when I came in from Cotonou, and they were still using 2 of the 3 apps: Since 2008 i.e. 8 years ago! That, more than anything else, is proof that those 2 apps continue to meet the company’s needs!

And all of that happened in Nigeria, NOT in the USA.

Now, I should point out that only a few of my apps have been for financial reporting or accounts. In my part of the world, too many people readily assume Excel is for accounts. WRONG!

Hotels/Restaurants and bars, Construction Engineers/Quantity Surveyors, Database consultants, Health and Fitness Clubs, Medical Hospitals/Clinics, Manufacturing companies, Farm Businesses are just a few that have hired me.

Most wanted their apps to capture routine OPERATIONS data handling and report summaries auto-generation. The decision makers in the organizations signed cheques to pay me, AFTER I showed them what was possible with my demos. I rarely had anything ready to use.

Instead they had often been using MS Excel manually, for routine reporting in formats unique to their businesses. They had tried using conventional off-the-shelf apps, but the peculiarities of their unique needs made it too difficult to customize them enough.

What’s more, the steep learning curve and the need to retrain as staff left made using such conventional off-the-shelf software unattractive for some individuals/businesses.

In one client’s accounts department, I was shown over 100 Excel workbook reports they had generated weekly, for well over a year. But it had become cumbersome generating monthly, quarterly and annual summaries, using the weekly reports.

So, when the accounts manager learnt I could create an app that would have a SINGLE report interface that would use drop menus to enable dynamic generation of the reports weekly, monthly and annually, he instantly bought the idea

For him the savings in time and effort were worth the required investment of money.

If you have routine and repetitive data recording, analysis and report preparation tasks you do manually or using Excel, adopting Excel-VBA Automation can help you GREATLY.

2 options exist: Either identify a competent Excel-VBA resource INSIDE your organization or hire one from outside to do it for you.

Unless your in-house expert is really good, and has enough exposure and experience, it’s always wise to hire an external resource, so your in-house personnel can learn from him/her.

That way, they will be equipped to subsequently maintain or modify/improve whatever application is developed for your company – saving you money that would otherwise be expended in calling in the external resource in future.

According to Pierre Le Clerc, an Excel-VB Solutions Developer whose work has influenced me greatly, Excel is the best reporting application on the market.

I agree. And I have found evidence of it in many forms – including the earlier mentioned fact that many business users, professionals in various fields, make serious use of it for their routine data recording, analysis and report generation.

Data handling – in virtually any form, for virtually any purpose, can be productively subjected to analysis for decision making, using MS Excel – IF the user possesses the required know-how or competence.

But there is a only so much you will be able to do with MS Excel, if you do NOT know how to automate the routine and repetitive aspects of whatever it is you do with it.

It does not matter how many functions you know or how good you are at designing and formatting data entry tables, reporting interfaces etc.

You will eventually get a to a point where integrating intelligent Excel-VB driven automation into your usage of your MS Excel workbooks will dramatically boost your productivity in terms of time, effort and even money you expend.

I say this as one who virtually single-handedly transformed the manual reporting systems in different departments I worked in a corporate multinational manufacturer, over a 7 year period, in my spare time as a brewer/manager, using my self-taught spreadsheet programming skills.

I began with Lotus 1-2-3 macro programming before moving to MS Excel-Visual basic coding (when the company migrated to MS Office from Lotus Smart Suite).

But what I knew while in paid employment pales in comparison to what I’ve since moved on to doing for clients within and outside Africa, as an entrepreneur. I have developed a wide range of customizable applications for individuals and businesses in various industries.

Examples include hospitals, hotels, restaurants/bars, medical clinics, pure (sachet water) factories, business centres, health and fitness clubs, churches, farm businesses (e.g. Ration Formulator, Poultry Farm Manager) and others.

The fact that I continue to make sales to buyers locally and internationally – over a decade after I started this journey confirms that this solution is relevant to the FELT needs of the target market I serve.

In addition, the increasing interest being shown by independent consultants, and career persons in joining my Excel VB club, to access my home study tutorial videos and other resource, is proof that MORE people are waking up to the realization that they NEED Excel-VB programming skills to take their productivity to the next level.

This is why I’ve invited current members of my Excel-VB club to attend the first run of what is to be a monthly FREE 4 Hour Workshop to be conducted by me. It will be holding on 19th March 2016 here in Lagos – Nigeria. The venue will be agreed with my club members, if they choose to invite me over to their preferred location or they will meet with me at the usual venue I use in Lagos.

In case this event interests you, or you’d like to get a copy of my branded auto run DVD (containing home study video tutorials I will be giving to them), read the details on the post below:

Attend Tayo Solagbade’s FREE 4 Hour Practical Introduction to MS Excel-VB Automation Workshop [Get Home Study DVD Video: How to build an automated Cash Book with Bank Reconciliation table, Debtors/Creditors Schedule etc]

Attend Tayo Solagbade's FREE 4 Hour Practical Introduction to MS Excel-VB Automation Workshop [Get Home Study DVD Video: How to build an automated Cash Book with Bank Reconciliation table, Debtors/Creditors Schedule etc]

 

SDN Blog

New posts from last week*
Monday:

PII 004: Get YOUR FREE Copy of Tayo Solagbade’s Quick & Dirty Guide to English Language for French Speakers

 WARNING: This Workbook based guide is NOT a standard language learning resource. I’ve called it a quick and dirty guide because that’s what it is. This workbook assumes you’re willing to spend time sitting behind your PC (and also on your mobile) listening to audiios corresponding to clickable words and phrases, (and pictures that appear […]

[Tuesday]:

Developing Positive Income Earning Competence In Nigeria Is The Key to Eliminating Corruption Amongst Nigerians [Case Study: Aljazeera “Africa Investigates” video report titled “Nigeria’s Baby Farmers”]

If you have not yet watched the Aljazeera “Africa Investigates” video report titled “Nigeria’s Baby Farmers”, starring Ghana’s famous under cover journalist – Anas – and Rosemary an investigative journalist from Nigeria, then click here to watch it now. The revelations of the sickening yet vibrant trade in babies, actively engaged in by hospitals and […]

[Wednesday]:

The Need to Conquer Our Fears to Live in Harmony With Nature’s Gifts [True Story With Photos: The Scared Stray Kitten I Rescued 5 Years Ago Is Now A Mother of Two Lovely Kittens!]

In certain societies, people live in harmony with snakes, and even worship them. In others the mere sight of a baby snake will have everyone taking to their heels. It’s a simple question of familiarity. A child that’s never seen (or been near) a dog before, could get scared, and even burst into tears when […]

[Thursday]:

FREE Talk for Farm CEOs About Best Practice Ways to Avoid Disease Outbreaks & Generate EXTRA Income to Cushion Income Loss!

I continue to write formal FREE talk offers for consideration by farmer groups and organizations. This is in line with what I’ve identified as the need to inform and educate farm CEOs on how to: (a) adopt best practice bio-security measures against disease outbreaks and (b) generate complementary/additional income streams to boost their earnings/cushion the […]

[Friday]:
N/A
[Saturday]:

Your Certificate DOES NOT Define YOU! [Mind Map for my Presentation at Yaba College of Technology’s Annual Semester Entrepreneurial Lecture on 3rd May 2012]

Below: This is the Mind Map I used to deliver my core presentation  as Guest Speaker at Yaba College of Technology’s Annual Semester Entrepreneurial Lecture – held at Grillo Hall, under the auspices of the Centre for Entrepreneurship Development, on 3rd May 2012. My core message was this: Your Certificate DOES NOT Define YOU! Polytechnic […]

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

 

Your Certificate DOES NOT Define YOU! [Mind Map for my Presentation at Yaba College of Technology’s Annual Semester Entrepreneurial Lecture on 3rd May 2012]

Below: This is the Mind Map I used to deliver my core presentation  as Guest Speaker at Yaba College of Technology’s Annual Semester Entrepreneurial Lecture – held at Grillo Hall, under the auspices of the Centre for Entrepreneurship Development, on 3rd May 2012.

My core message was this:

Your Certificate DOES NOT Define YOU! Polytechnic graduates bring badly NEEDED skills to the Nigerian market place. You just need to learn how to effectively trade your skills and knowledge for money. Nigerians NEED you more than you know.

mindmap-OK-2016
A year later I implemented my plan of becoming a Location Independent Multipreneur, and have since used the ideas I shared in my talk to take my brand to a whole new level. Simply put: they WORK!

To request a copy of the Power Presentation, email your Name, Occupation and WhatsApp number to tayo@tksola.com.

Back in 2012, I used www.sdacademy.org to point to www.spontaneousdevelopment.com, which was my flagship domain name at the time. Both URLs have since been dropped.

Today (12th March 2016) www.tayosolagbade.com is my flagship domain and I use the URL forwarding and redirect features of www.discovercotonou.com and www.tksola.com to point to different subdomains on it for solutions I offer.