Category Archives: Career Development

Build & Sell Your Own Excel Software: FREE Workshop Introduction to Excel-VB Automation [For ICAN/ATS Tuition Centres and Other Business Users] – Tayo Solagbade’s Excel Heaven Visual Basic Club

Last Wednesday (25th May 2016), I had a 1 hour meeting with the CEO and other team members of an ICAN/ATS tuition centre in Ojodu-Lagos, and they indicated interest in having me facilitate 2 runs of my workshop for their students.

The title is to be: Build & Sell Your Own Excel Software [Introduction to Excel-VB Automation]

They asked about the fees and I explained that the centre simply needs to pay the $65 USD annual membership fee and that will entitle all students enrolled with them to access my online tutorials and workshops FREE (but once a student is no longer enrolled in the centre s/he will not be allowed access and wiil have to join the club by making payment independently, if s/he wishes to continue).

This afternoon I sent them the PDF invoice, since the CEO had told me they would like it to hold in the first 2 or 3 weekends in June.

If/when they pay the club membership, I’ll send invitations to all my existing club members, to attend, if they’re interested.

But you don’t have to be an accountant or a student in an ICAN/ATS Tuition Centre to access my ExcelVB club or workshop

Of course you don’t. And that’s why I’m writing this blog announcement.

The truth is every serious minded user of MS Excel who wishes to maximise his/her productivity NEEDS to learn how to use ExcelVB programming to automate most of what s/he does in MS Excel.

Now, there’s a wrong mindset many business users seem to adopt when they hear me say “MS Excel Programming”.

Quite often they conclude they will need some kind of serious formal IT certification level training as a prerequsite for automating their work in MS Excel.

Nothing could be further from the truth.

You see VIsual Basic for Application is a programming language developed mainly for use by USERS who want to intelligently use automation to boost their output to the next level of productivity.

In essence ExcelVB is a coding language you and I (I.e ANY motivated user) can learn to use to get Excel to do what we want and how we want it.

As with most other things in life, ExcelVB programming cannot be mastered overnight.

But it is fairly intuitive, and with diligent persistence any user can develop proficiency in it, to extent that s/he can build and sell branded, robust custom software for clients at various levels.

How can I be so sure?

Well that’s because I’ve been building commercial quality spreadsheet software for over 2 decades for business users in various fields, and industries.

I did it for over 5 of the 7 years I worked in Guinness Nigeria, where at a point I learned through the corporate grapevine that I was being called “Super Brewer” by colleagues.

This was probably due to the fact that they knew:

1. the apps I developed were formally adopted for brewery level reporting, having replaced manual reporting systems in the departments I worked.

2. I did all that work in my spare time, when I was off duty from shifts or after close of work (after I got promoted to 9 to 5 senior positions)

3. I did not have any IT training or background in programming or software development. All I hold till this day is a 2nd Class Upper Division Honours B.Sc degree in Agricultural Extension Services

As you can see from the above, I began just like any other person who knew nothing about IT, but had a data handling and report generating PROBLEM that badly needed solving!

If I could develop myself through self-study to the point that I now sell my apps to international buyers, then so can you.

And that’s why I launched my ExcelVB club and offer membership to you, including free weekly tutorials (downloadable videos/PDFs) and monthly LIVE workshops.

Interested? Click here to send me a message?

If you run a tuition centre, do your students a favour and signup your centre so they can all get FREE access.

Indeed you will be able to attract more student enrollments by informing them that they’ll gain FREE access to the club tutorial through your centre!

Call me on +234-803-302-1263 or +229-66-122-136 for details.

Related

Signup for Tayo Solagbade’s One-on-One MS Excel Heaven™ Visual Basic Coaching Program & Finish With Your Own Custom Excel-VB App You Can Use at Work and/or Sell to Clients!

Become a SUPER Accountant, Engineer, Marketer, Insurance Broker or Spreadsheet Business User: FREE Workshop Introduction to Excel-VB Automation – Tayo Solagbade’s Excel Heaven Visual Basic Club

Do you routinely use MS Excel spreadsheets to get your work done, but sometimes wish you could do so FASTER, with LESS effort and in LESS time?

If YES, what I have tell you below has to do with an opportunity that can change your life forever – and I mean that literally!

Over the past 13 years, I have worked closely with seasoned Chartered Accountants/Auditors especially and in some cases Quantity Surveyors, to develop applications for their companies using MS Excel.

What I noticed was that many of these professionals were good with MS Excel, but they lacked my ability to program Excel

I believe that by helping these kinds of professionals learn to program MS Excel for their purposes, they will spawn a new brred of skilled professionals that will expand the market I have created for spreadsheet solutions out here.

Are you an Accountant/Auditor, Engineer/Quantity Surveyor, Marketer or Insurance Broker, who uses MS Excel spreadsheets for routine data handling and report generation?

Or let me ask: Does your work require you to carry out elaborate data collection and analysis for formal report generation purposes.

Do you routinely use MS Excel spreadsheets to get your work done, but sometimes wish you could do so FASTER, with LESS effort and in LESS time?

Your spreadsheet needs to be laid out according to certain rules, to make preparation of reports and subsequent automation effective and efficient. There are so many powerful ways to setup/use spreadsheets to make your work easier – even without VBA code driven automation.

If you belong to any of the groups I have described above, you are very likely to be at least an average or intermediate level user of MS Excel.

Indeed it is possible you are widely considered an “expert” by those you work or relate with, because very often, you solve other people’s problems using your spreadsheet skills.

That’s why my offer of personal, confidential coaching in MS Excel Automation using Visual Basic is likely to be a NATURAL progression to the NEXT HIGHER level of competence that will appeal to you.

Believe me when I tell you that what I can TEACH you to do with MS Excel is nothing like anything you may have done in the area of using MS Excel, or indeed in automating it.

GET STARTED: Fill and submit this form on my website to request details of how to get started

Remember that acquiring this new competence can effectively help you earn more recognition, respect and INCOME from others.

With my help that seeming dream become a reailty for you, IF you let me help you.

Fill and submit this form (click now) on my website to request details of how to get started.

Call me on +234-803-302-1263 or +229-66-122-136 for details.

Related

1. Signup for Tayo Solagbade’s One-on-One MS Excel Heaven™ Visual Basic Coaching Program & Finish With Your Own Custom Excel-VB App You Can Use at Work and/or Sell to Clients!

2. Visit the page below to watch a video introduction to my ExcelVB club

http://tayosolagbade.com/sdnuggets/welcome-to-my-ms-excel-heaven-visual-basic-automation-club-introductory-videos-you-need-to-watch/

PII 016: How Long Should Good, Lasting Change to Prosperity Take to Implement in a Badly Abused, Nearly Crippled Socio-Economic Entity? [Real Life Case Study of a Struggling Multinational Manufacturer That Turned Its Fortunes Around vs Prospects for a Nation’s Economic Revival]

We all have a right to voice our opinions on any issue, but we also have a responsibility to make such contributions from well informed and objective perspectives.

What you’re about to read is a true personal story. The education and information I offer through this article can help many – if they keep an open mind.

You see, most of us have known the manufacturing multinational the story below is about, for most of our lives.

Most of us drink their products without sparing a thought for how they keep their operations running profitably to pay salaries and declare dividends to shareholders. This, despite their having to deal with the erratic and harsh climate in Nigeria’s socio-economic environment – that we all complain about!

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

How Long Should Good, Lasting Change to Prosperity Take to Implement in a Badly Abused, Nearly Crippled Socio-Economic Entity? [Real Life Case Study of a Struggling Multinational Manufacturer That Turned Its Fortunes Around vs Prospects for a Nation’s Economic Revival]

We all have a right to voice our opinions on any issue, but we also have a responsibility to make such contributions from well informed and objective perspectives.

What you’re about to read is a true personal story. The education and information I offer through this article can help many – if they keep an open mind.

You see, most of us have known the manufacturing multinational the story below is about, for most of our lives.

Most of us drink their products without sparing a thought for how they keep their operations running profitably to pay salaries and declare dividends to shareholders. This, despite their having to deal with the erratic and harsh climate in Nigeria’s socio-economic environment – that we all complain about!

Despite all that goes wrong in Nigeria, companies like this one I served in continue to forge ahead, doing what they do.

Few of us however ever stop to wonder:

How do they do it, when our governments struggle? How do they recover when things go wrong for them?

I have been a part of those processes in such companies, and that is why I know we can all learn a lot from those who run those organisations and keep them going for decades like they do.

In the rest of this piece, I share my insights based a true story from the first 4 years of my stay (between the ages of 24 and 28) in that company.

If you keep an open mind, I guarantee you will come away with useful insights.

I once had the unique privilege of participating in a major change implementation process involving turning around the fortunes of the Nigerian arm of multinational socio-economic entity run by European expatriates in collaboration with Nigerian colleagues.

That experience is what equips me to see what most others miss (or simply refuse to see). It gives me an advantage of a superior perspective.

For that reason I feel obligated to share my insights, with reference ti a bigger socio-economic entity like Nigeria, especially in light of the uninformed conclusions I see many drawing, in a bid to assess the current government after its first year in office.

I was recruited as a Graduate Management Trainee (Technical Function) in October 1994 along with 11 others.

The organisation was limping badly – operationally and financially, following the devastating ban on wheat importation, and as a result of poor management, that had necessitated appointment of the new leadership that welcomed us.

They told us we were to be trained as a new generation of managers, in the drive to get the company fully back on its feet, to achieve improved output and profits over time.

The changes that had to implemented were varied, harsh, and sometimes not popular. Cost cutting was commonplace, and in production it manifested in form of frequent Variable Cost Reduction trials.

To implement needed changes, the parent company had sent in “PH” (his initials) – a reputed no nonesense turnaround specialist with an intimidating track record of getting desired results.

Sources in the grapevine had it that he’d risen through the ranks, right from the shop floor, and so knew the business inside out. He wasted no time in asserting himself, and soon began pushing belt tightening Best Practice initiatives requiring smart repair and maintenance of decades old machines considered spent, with a view to producing output rivalling that from new plants!

Some old (Nigerian) hands in senior positions kicked against the proposed changes and new philosophy openly and behind closed doors.

PH and his team took note but kept pushing. We the new breed were soon inducted, trained and redeployed to different sites.

Periodic restructuring, retrenching and retraining of other staff also happened as time went on.

PH left at a point I cannot recall, but not before the needed initial strategic changes had been set in motion. People willing to ACCEPT the new ways of doing things had been retained, while those assessed to be unwilling or unable to adjust, had been let go.

I’ll never forget the phrase “a lean and fit organisation”.

That phrase was drummed repeatedly into our heads. That was what the new company envisioned was to evolve into.

By 1998, a new workplace philosophy and culture had been entrenched, and many of us had been assigned key roles to play – some (like me) getting trained by the company’s corporate Best Practice Champions to facilitate workplace organisation changes in our breweries.

Around this period, the desired results had began to emerge in form of consistently improved outputs and sales.

The Variable Costs Reduction initiatives enabled us evolve ways to lower operating costs without losing output or damaging product quality.

The result was that profit margins grew without the company needing to raise selling prices. I saw this happen and it excited me greatly. This is why today I keep telling my Farm CEO clients to find ways to increase their profits without raising prices, as a means of mitigating the harsh impact of the rising input prices they face.

At a point, we had done so well – with those same old machines previously considered “spent” – that money made from sales had been enough to purchase a brand new bottling line, reportedly one of the fastest in Africa at the time!

Suddenly, all those wise “senior managers with many years on the job” who’d complained about the futility and needless hardship of producing with such old, leaky and rickety machines looked silly – on hindsight!

At least to me they did, because I’d been opportuned to witness the BEFORE and AFTER realities of the “changes” that had been implemented during the 2 to 4 year period that had passed!

I went on to play more active roles in influencing many more positive workplace changes (using my self-taught spreadsheet automation skills) by drawing inspiration from what I’d witnessed and participated in with regard to improving production operations in the company.

What I knew gave me the conviction to push my ideas, initiatives and solutions forward, even when supposedly wiser/more experienced senior colleagues scoffed or raised objections often to preserve the status quo.

I kept pushing knowing that I could over time develop my approach or strategy in a way that would deliver results they would welcome.

Guess what?

I did!

In fact, by the time I quit the company to go into self-employment building and selling custom spreadsheet apps for a living (as I’ve been doing for 14 years now), I’d gained companywide recognition for using my spreadsheet automation skills to develop apps that replaced paper based data handling and report generation in the departments I worked. Click here to read details in my resume.

So much so, that other departmental and sectional heads approached me to help them develop similar solutions for use by their team members.

Over 4 of the custom apps I built were adopted for formal brewery level reporting. The best part of my story was that I did all that in my spare time while still working full time in the company as a brewer/manager.

I got no extra pay, neither was I given time off from work (I should add that it never occurred to me to ask, because I enjoyed doing it)!

As a result, I tended to literally live in the brewery – leaving late (sometimes past midnight) and arriving early (often before 5a.m).

So you see, I had it tough during those early “change” years in that company, but the results that I saw accrue to the company and to us, the individuals in it, (though they took 2 to 4 years to arrive), taught me that real lasting change from a bad socio-economic situation to one that is close to the ideal one desires, will often not happen quickly or without prolonged pains/hardship.

To think otherwise would be foolhardy.

What matters is having the right leadership driving the change.

The decision makers in the company I worked for ensured that happened, and success came as a result.

Now, coming back to Nigeria…

I believe Nigerians chose the right leader – in Muhammadu Buhari, during the last (2015) presidential elections – to drive the needed change.

However, compared to the company I worked for, Nigeria is a much larger socio economic entity.

At the risk of stating the obvious, it is an entire country with multiple nationalities of people numbering a quarter of a billion people!

In addition, Nigeria has suffered myriad forms of abuse at the hands of a series of leaders.

On top of that she has detractors (actively working to create difficult conditions for progressive governance), who unlike the CEO of my company, the nation’s president cannot simply layoff or ask to “leave”!

All of the above, and more, make any suggestion that Nigeria’s fortunes should have improved within one year of a new leadership in power, too much of an irresponsible joke.

It took the company I worked in close to 4 solid years to regain any semblance of the stability it desired, despite the times not being as harsh as they are today.

This is why I believe that to expect Nigeria to get back on its feet faster, or to judge the new government incompetent after only one year in office, following extensive bastardisation of the nation’s resources that happened before it took over, makes no sense whatsoever.

As far as I’m concerned, I only expect to begin seeing tangible fruits of this new government’s current labours from 2 full years after it has been in power.

And I’ll only be prepared to pass any form of judgement on their performance at the end of their 4th year in office.

So times are hard, but they are the result of preceding years of mismanagement which this new government has to start with. Like it happened with the company I worked for, tough decisions and changes will have to be taken, made and endured by everyone involved.

Complaining and blaming the current crop of leaders will not help matters. Instead we must join our hearts and hands to support this new team to succeed – for all our sakes!

SDN Blog

New posts from last week*

Monday:

 

[Tuesday]:

[Wednesday]:

[Thursday]:

[Friday]:

Evaluating and improving Your Poultry Layers Farm Performance – Useful Resource URLs (Based on Real Life Correspondence With a Farm CEO)

[Saturday]:

Common Sense Evaluation of ROI from Your Social Media Marketing (Hint: A Busy “EMPS” Driven Facebook or Twitter Page is No Guarantee of Sales)

 

 

[Sunday]:

Protected: Selling Your ExcelVB Solutions – Example of Promotional Strategy: Boost Hospital/Clinics Records Management Using Smart ExcelVB Automation [Hint: Custom MS Excel-VB app built for a Lagos-Nigeria based Medical Clinic]

 

Protected: THE FARM CEO (Issue 47): Meet “IFAMA” – the International Food and Agribusiness Management Association, Mission, Vision and Strategic Plan, Purpose and Mission of IFAMA Regional Chapters, International Food and Agribusiness Management Review

 

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

 

[Recommended] 5 Alternative Ways To Charge A Mobile Without Electricity [Hint: Why I’m Offering a Solar and Electricity Rechargeable Power Bank Gift to clients who signup for my Web Marketing/BOPMS offers]

Sometimes having a power bank is not enough, because it will periodically need recharging, and if you cannot find an electric power source, your mobile phones will not get charged from it: you’ll be stuck with a dead power bank and mobile,

Lack of regular electricity in Nigeria makes the above scenario a persistent reality, making mockery of people’s efforts to invest in electricity dependent power banks.

In a bid to find a solution, I purchased and have been using a Solar Rechargeable Power Bank for a while now, which can also be recharged using public power supply as well as inside a car.

As you can imagine, my frequent traveling lifestyle makes this kind of multi featured power bank attractive to me.

The good thing is that when I’m recharging this power bank using solar energy, I am still able to connect and charge my Blackberry from its 2A outlet USB port. It’s so effective!

This device has so impressed me with its performance, that I’ve decided to buy and give it out to clients who signup for my WMS and/or BOPMS promo offers.

Why?

Because they will need their phones powered up as long as possible for use in the projects they sign up for.

For those without solar chargers, who find themselves without access to electricity, this recommended article linked below offers 5 alternative ways to charge mobile devices without electricity.

http://trak.in/tags/business/2014/08/07/5-alternative-charge-mobile-without-electricity/.

Why Schools Need to Teach Emotional Intelligence [Hint: Your Success In Life – Academic Ability Matters LESS Than Your Emotional Intelligence]

Do you want to excel at what you do in life? If YES, it might interest you to know that your academic prowess and credentials pale in significance when compared to the Emotional Intelligence you possess.

 

I recently read <a href=”http://www.success.com/article/why-you-need-emotional-intelligence-to-succeed”>Why You Need Emotional Intelligence to Succeed</a> (click to read) by Travis Bradberry on Success.com, and the contents resonated greatly with me based on my own knowledge and experiences on the subject over the past decade.

 

In this article I share some tips based on my study and application of this concept, since my mother gave me a copy of Daniel Goleman’s groundbreaking bestseller omn the subject as a birthday gift in 2005.

 

1. EI is not set at birth (unlike academic intelligence’s IQ), and as such can be improved via conscious effort.

 

In other words, EI can be taught and learned – but mostly, in my experience, by doing – not in the classroom.

 

2. EI has several dimensions, and people who demonstrate the greatest degree of EI are often those able to achieve mastery in majority of those dimensions.

 

I discuss two of those dimensions that I consider most critical in the rest of this article.

 

<h3>A. Delayed gratification</h3>

 

The ability tp put off or delay satisfying certain secondary needs in order to dedicate one’s time, efforts and resources to achieve a valued goal(s) is often a pointer to a person’s degree of EI.

 

A survey done of a group of kids in school required them to choose between getting a gift instantl for carrying out an assigned task, and waiting several weeks to get a bigger but unspecified reward.

 

Most of the kids chose to “cash in” immediately. Years later when all the kids had left school, and become working adults, the researcher found that those who had chosen to wait longer to get rewarded were doing siginificantly better in life than those who had not.

 

Historical evidence confirms the accuracy of the above findings, as we often hear successful people recount how they had to deny themselves certain pleasures and also sacrifice many wants and needs, until they reached their goals.

 

<h3>B. Persistence</h3>

 

The ability to commit oneself to long term pursuit of a valued goal in the face of discouragement and deprivation is another strong indicator of a person’s degree of EI.

 

I happen to believe too many people that many people lack this particular quality, and most who do often also lack the earlier mentioned ability to delay gratification.

 

In other words, they are inter related.

 

The ability to persist involves carrying on with the chosen task(s) in pursuit of one’s set goal(s), regardless of the difficulties one may encounter in doing so.

 

<b>What I find often happens with most people is that they assume – often unconsciously – that they have a say in how long they will need to persist before they succeed. </b>

 

Most will not admit it when asked, but they betray the fact that they think so in the way they react to prolonged adversity.

 

<b>The truth is that it is NOT up to any of us to decide how long it should take, or how hard or difficult it will be to arrive at success.</b>

 

There are universal laws guiding achievement and they are applied impartially, but in consonance with the abilities/capacity of each person. As a result no one ever gets tested beyond his/her inborn ability to cope with the challenge visited on him/her.

 

<i>Therefore if you find yourself confronted with adversity in any form, no matter how intimidating, KNOW that the Creator allowed it to reach you because He KNOWS that He has put in you what it takes to beat it.</i>

 

Be inspired by that knowledge – and take action based on it to defeat any adversity that comes your way.

 

<h3>Anyone can LEARN to develop and use these abiliities, on his/her own, or with the help of a competent other e.g teacher, coach or mentor.</h3>

 

What’s more, the learning can happen at any age, and during any phase of life.

 

The implication therefore is that a child can be helped to develop these abilities (and others making up EI) so that s/he arrives adulthood adequately equipped to deal with the inevitable facets of adversity s/he will pass through, such as delays, disappointments, setback and outright failures (aka temporary defeat).

 

Daniel Goleman in his book “Emotional Imtelligence” recommended that educational institiutions incorporate teachings desinged to inculcate the various dimensions of this meta ability into learners, so they can enter the real world better rounded, and more capable of succeeding in life an any area of endeavour they choose to venture.

 

I agree 100%

 

<h3>The 2 abilities discussed above have helped many otherwise ordinary, relatively ungifted persons achieve truly extraordinary feats in various areas of endeavour. </h3>

 

<I>So many unschooled or poorly schooled persons have climbed to unprecedented heights of achievement by making use of them.</i>

 

Well known examples include Thomas Alva Edison and Henry Ford.

 

But if you look around in your own society I’m sure you will find more familiar examples. In my country Nigeria for example, the case of Shina Peters the Afro Juju music maestro comes to mind.

 

At age 8 he quit school and followed his passion for playing music by working as a house boy for Chief Ebenezer Obey – among other difficult roles, just to achieve his dream.

 

Today he is recognized as the inventor of his own genre of music and posesses wealth that enables him provide gainful employment to many who are much better schooied than he is!

 

Many other examples abound. Any persons who take the pains to learn and appy EI in their daily lives will end up as role models or examples for others to emulate or refer to.

 

<h3>Related Articles</h3>

 

1. <a href=”http://ezinearticles.com/?What-Being-Emotionally-Intelligent-Does-Not-Mean&id=864816″>What Being Emotionally Intelligent Does Not Mean</a>

 

2. <a href=”http://excelheaven.tayosolagbade.com/?p=269″>Become A Habitual Peak Performer – Learn How To Get Into Flow …</a>

 

3. <a href=”http://tayosolagbade.com/sdnuggets/are-you-a-social-chameleon-read-this-to-find-out/”>Are You A Social Chameleon? (Read This To Find Out </a>

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

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

 

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

 

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

 

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

 

 

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

 

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

 

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

 

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

 

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

 

 

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

 

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

 

<H3>4. Jeffery Gitomer on Youtube

</H3>

 

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

 

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

 

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

 

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

 

====

Sennanchie3 years ago

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

=====

 

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

 

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

 

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

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

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

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

That’s just common sense!

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

SCROLL DOWN TO READ FULL ISSUE

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

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

Logo - Tayo Solagbade's Self-Development Academy


NB: This PI Squared newsletter will be published weekly, on Mondays, in place of the Speaking/Web Marketing IDEAS newsletter, starting from today – 15th February 2016.
I’m reinventing my Monday newsletter content and theme, to accommodate my vision of serving the growing audience of serious minded individuals and organizations reaching out to me, with information, education. news and research findings designed to help them do what they do better.

**********

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

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

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

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

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

That’s just common sense!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

The answers to the above are obvious!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

tks-sympo

Another True Story (Coming soon):

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Here are some excerpts you will find instructive…

Burn all your bridges behind you!

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

Leave yourself no possible way of retreat:

Cut all sources of retreat:

You have to win or perish:

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

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

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

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

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

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

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

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

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

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

SDN Blog

New posts from last week*

Monday:

 

[Tuesday]:

[Wednesday]:

[Thursday]:

[Friday]:

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

[Saturday]:

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

 

 

[Sunday]:

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

 

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

 

Tayo K. Solagbade*

Self-Development/Performance Improvement Specialist

*Creator of the Mastering Adversity for Perpetual Success Achievement Coaching Program

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

http://www.tayosolagbade.com

Tayo K. Solagbade is a Location Independent Performance Improvement

Specialist and Multipreneur (i.e. a highly versatile/multi-skilled entrepreneur), with a bias for delivering Best Practice solutions to Farm Businesses and others.

Since 2002, he has earned multiple streams of income providing individuals and organizations with personal development training and coaching, custom MS Excel-VB solutions, web marketing systems/web hosting, freelance writing services, and best practice extension support services (for farm business owners).

Tayo is the author of the Self-Development (SD) Bible™ and the popular Livestock Feed Formulation Handbook. He is also the developer of its accompanying Excel-VB driven Ration Formulator™ and the Poultry Farm Manager™ software.

He has delivered talks/papers to audiences in various groups and organizations, including the Centre for Management Development, University of Lagos, Christ Baptist Church, Volunteer Corps, Tantalisers Fast Foods and others.

In May 2012 he was the Guest Speaker at the Centre for Entrepreneurship Development’s Annual Semester Entrepreneurial Lecture at Yaba College of Technology in Lagos.

On 1st April 2013, Tayo (who reads, write and speaks the French language) relocated to Cotonou, Benin Republic to begin slowly traveling across the West African region.

His key purpose is to deliver talks, seminars

and workshops on his key areas of focus and interest to interested audiences (Email tayo at tksola dot com for details).

In a previous life, before leaving to become self-employed, Tayo served for seven years (October 1994 to December 2001) as a high performing manager in Guinness Nigeria. He rose from Shift Brewer to Training & Technical Development Manager, and later acted in senior roles as Production Manager and Technical Manager.

In addition to constantly challenging the status quo and influencing positive work changes, he built a reputation for using self-taught spreadsheet programming skills (starting with Lotus 1-2-3, and later moving to Excel Visual Basic) – in his spare time – to develop Automated Spreadsheet Applications to computerize manual report generation processes in the departments he worked. Over four(4) of his applications were adopted for brewery level reporting.

Tayo holds a B.Sc degree in Agricultural Extension Services from the University of Ibadan, Nigeria, having graduated top of his class – with Second Class Upper Division honors – in 1992. He is an Associate Member of the UK Institute & Guild of Brewing, a 1997 National Finalist of the Nigerian Institute of Management’s(NIM) Young Managers’ competition, a Certified Psychometric Test Administrator for Psytech UK, innovator of Spontaneous Coaching for Self-Development™ (SCfS-D™), and Founder of the Self-Development Academy (SDAc).

When he’s not amazing clients with his superhuman skills (wink), Tayo works as the creative force behind his Daily Self-Development Nuggets blog – on which he also publishes The Farm CEO Weekly Newspaper (sent via email to paid subscribers) and his Weekly Performance Improvement IDEAS newsletter.

You can connect with him on Twitter @tksola.com and Facebook.

Visit Tayo Solagbade Dot Com, to download over over 10 performance improvement resources to boost your personal and work related productivity.

====
[IMPORTANT NOTE:====

On 4th May 2014, Tayo’s 9 year old domain (Spontaneousdevelopment dot com), which hosted his website, was taken over by Aplus.net.

Within a few days however, Tayo used his advanced self-taught web development skills to build a SUPERIOR “reincarnation” of it the website http://www.tayosolagbade.com.

But updates are still ongoing to URLs bearing the old domain name in most of the over 1,000 web pages, and blog posts

he’s published.

If you experience any difficulties finding a page or document, email Tayo at tksola dot com.

Click “Tayo, What Happened to

SpontaneousDevelopmentDotCom ?” to read a detailed narrative about how the above event occurred :-))

Here’s an article Tayo wrote, to inspire others to defy adversity, and bounce back to even greater reckoning at what they do EVERY time:

Succeed by Emerging from Adversity Like a Phoenix

(TayoSolagbade.com launches extra Hosting plan with FREE Web Marketing!)

And he wrote the one below, to explain why losing a domain name, no matter how old, NO LONGER determines your online success or otherwise:

A Proven Strategy to Find Profitable Buyers Regardless of Your Domain Name
==================

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

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

 

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

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

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

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

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

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

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

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

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

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

I did not want to work that way.

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

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

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

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

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

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

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

You can do so with my help.

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

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

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

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

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

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

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

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

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

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

Here are simple tips to guide you:

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

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

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

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

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

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

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

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

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

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

RELATED

  1. Welcome to my MS Excel Heaven Visual Basic Automation Club [Introductory Videos You Need to Watch]
  2. Signup for Tayo Solagbade’s One-on-One MS Excel Heaven™ Visual Basic Coaching Program & Finish With Your Own Custom Excel-VB App You Can Use at Work and/or Sell to Clients!