Category Archives: Self-Development

This Scary Future Predicted for Your Car Is Closer to The Present Than You Know

If you like, you can bury your figurative head in the figurative sand, like a figurative (human) Ostrich – the future predicted below is ALREADY here – Tesla is just unveiling it on behalf of many others silently creating it. For those who love (or “worship”?) their cars and similar stuff, many are going to end up with “broken hearts”!
=

“Around 2020, the complete industry will start to be disrupted. You don’t want to own a car anymore. You will call a car with your phone, it will show up at your location and drive you to your destination.

You will not need to park it, you only pay for the driven distance and can be productive while driving. Our kids will never get a driver’s license and will never own a car. It will change the cities, because we will need 90-95% fewer cars for that.

Read the full writeup!

https://www.futureme.org/letter/8469439-email-from-grandpa-about-future-predictions-in-july-2016

VIDEO: 3 Year Old DJ Arch Jnr wins SA’s Got Talent 2015 [Hint: Classic Example of Best Practice Parenting Empowering a Child to Develop His Genius/Talent Early In Life]

This 3 year old started DJing at the age of 1 – according to his Dad.

The smart thinking father knew enough to encourage the little guy to explore his demonstrated passion for churning out danceable beat mixes using a software downloaded from the web.

Today, he’s not only SA’s youngest DJ, who actually accepts invitations to LIVE (25,000 audience) shows, but he’s the 2015 winner of SA’s Got Talent!

That’s what I call best practice parenting.

Watch him win SA’s Got Talent 2015

By way of interest DJ Arch Jnr earned a golden buzzer nomination on his first outing that sent him straight to the semi-final.

1. Watch him perform at the Semi-Finals of SA’s Got Talent 2015

2. Watch his golden buzzer inspiring performance that sent him to the Semi-Finals of SA’s Got Talent 2015

One thing is certain – this young man already knows what he wants to be when he grows up.

[Excel-Heaven Tutorial 04] Extracting, Organizing, Analyzing and Presenting Data: Index/Match Formulas

This is an INDEX/MATCH formula: =INDEX(setingsDBase,MATCH(D9,nfDrinksList,0),2) [See it used in the screenshot below]

It is a powerful time saving formula constructed using 2 different functions – enabling timely and convenient extraction of data from a database while reducing the chances of user entry errors being made during routine data recording of product sales record

Index/Match Formulas are indispensable tools for  organizing data as well as creating reports and analyses.  I have found them most useful for creating reports from spreadsheet databases in which the data to be handled is already summarized.

Indeed, I’ve found them especially useful in  handling data summaries generated using SUMPRODUCT formulas . All my applications make generous use of these functions and most times they meet 80% of my needs. STUDY the formula using the notes provided on this page.

Next week  I will create and send you a step-by-step video demonstration/explanation of how this Index/Match Formula was built

Below: Screenshot of MS Excel worksheet with explanatory notes on how the Index/Match formula I created was used to generate the report shown.

Screenshot of MS Excel worksheet with explanatory notes on how the Index/Match formula I created was used to generate the report shown.

As usual, the workbook – with unprotected worksheets and VBA code modules was emailed to members of my Excel Heaven Visual Basic Automation Club. Click here to request a copy.

 

[PDF] 25 Articles/True Stories On Self-Development, Entrepreneuring & Web Marketing To Help You Succeed More Often: Get this $25 USD ebook FREE!

Quick Take-Away: Click here to fill/submit a request form (scroll to the bottom of the page that opens) to request details of how you can get this $25 USD ebook FREE from me.

It’s always exciting to have people fitting my target audience profile sending me messages that confirm I’m adding tangible/useful value to them. Like this Namibian professional planning to start a 2,500 layer poultry – who found me via my $25 USD ebook (25 Articles/True Stories On Self-Development, Entrepreneuring & Web Marketing To Help You Succeed More Often) a gift copy from his boss:

name = rixxx dxxxx
submit_by = [email removed]
company = Production Metallurgist
address = berg str
city = 189
states = —
country = Namibia
phone = [phone removed]
how_found = I read about your ebook 25 articles on the internet…
interest = Poultry Farming
comments = My boss gave me your ebook on the 25 articles on self-development as a present. However, I am struggling to  contact you in order to get the links in the book to become functional. Can you possibly e-mail me the contact form so that I can send you a copy of the invoice. As it stands, I do not have access to all the articles in the ebook

Below: Screenshot of reply email I sent, with the updated ebook attached.

Click here to read the full email conversation we went on to have…

25articles-denk3

Below: Screenshot of the ebook on sale in my Lulu.com online store

Click here to view this ebook on sale in my Lulu.com online store

This ebook has been on sale for 10 years now. It was my first ever articles compilation ebook and it has been quite popular. People LOVE the contents and the fact that they have my permission to freely reproduce it for their use.

25 Articles/True Stories On Self-Development, Entrepreneuring & Web Marketing To Help You Succeed More Often

Click here to fill/submit a request form (scroll to the bottom of the page that opens) to request details of how you can get this $25 USD ebook FREE from me.

RELATED ARTICLE:

Smart Web Marketing Wins Profitable Farm Business Buyers [Hint: Poultry Farm Business Plan Preparation Service]

 

 

Get Equity Funding for Your Biz Idea in Lagos [&/Or Sponsor a prospective buyer of my products!]

1. This outfit offers a useful funding alternative:

Entrepreneurs – Lagos Angel Network

Thank you for your interest in the Lagos Angel Network. We invite entrepreneurs to learn more about our investment screening process.

The Lagos Angel Network uses VC4A, the global platform for connecting high-growth entrepreneurs and active early-stage investors for managing our investment process. Please register your company with us here.

http://www.lagosangelnetwork.net/entrepreneurs/

Visit the above site to learn more and/or click here to request the audio note I emailed to my subscribers.

2. The invitation below first went to my Club ZEROmembers.

Below is a modified version of the invitation for my Farm Ideas Club Members and other clients.

Consider making a N5K donation to sponsor 1 of the guys listed below.

They’ve expressed great interest in purchasing my products but lack funds. I want to help them by asking interested clients to sponsor them.

A. Name removed [Student]

B. Name removed [Student]

C. Name removed [Startup Farm CEO]

The person you choose will get my Feed Formulation Handbook & Excel-VB Ration Formulation Software for N5k instead of N20.5k.

If you’re interested, just make the payment then let me know who it’s for, and I’ll prepare/send the products, with your name as donor.

Any amount is acceptable, no matter how low – I’ll just add it up till N5k is reached for each person.

But I’ll send the products to all 3 of them for a donation of N10k.

For every person you sponsor with N5k, I’ll give you a discount of N10k on any of my products or services that you want.

[Tutorial 03] Navigating within Spreadsheets + Manipulating Tabulated Data Using VBA Code: Case Study

Below are excerpts from explanatory notes I posted in an example workbook for Tutorial 03 on Navigating within Spreadsheets + Manipulating Tabulated Data Using VBA Code  – under the them: use of NAMED RANGES in MS Excel for Super Spreadsheet Optimisation and Automation | www.excelheaven.biz

This time around, in addition to going further to show a more advanced use of range names in a complex formula, I also show how to use them in VBA code to manipulate large spreadsheet data ranges at once.

This range (D9: D503) is named “nfItemsSold”. I’ve hidden rows 40 to 503 to fit the table into the print-ready format for this tutorial. To display the full table, click on the row header labeled 39 and drag two or more steps downwards to highlight row header labeled 504 or higher, then right-click and cilick UNHIDE on the shortcut menu that appears. Th efull table will be displayed. Note that clicking ANY of the ERASE buttons above will cause ALL entries in the entrie table length to be erased, regardless of whether the rows are hidden or not

xlh03-tutorial16hoct2016

Below: Note how the autocomplete feature is activated as soon as I type the period after the range name definition. In other words, Excel recognises this defined name as an object and readily supplied “properties” for me to choose from. I choose “C learContents” which achieves the effect of erasing the contents of the specified range.

erase-code1

 

erase-code2

I added the last 2 VBA subroutines to enable you see the ERASE code working while the table is fully displayed and also while part of it is hidden. You will find this kind of functiona;ity useful in handling  large spreadsheets.

 

TIP: In addition to the notes and screenshots shown here, my Excel Heaven club members receive the example workbooks with unprotected cells and code modules, so they can study them and modify to test their own ideas. Click here to request a copy for your own use.

You Need Education That Works and Not “Fancy Schooling” Ego Trips [True Story: Pretty Nigerian Lady Earns Living as Self-Taught Carpenter]

Schooling the industrial revolution way is NOT the only way to get an education: Myriad other ways abound – and they don’t take as long, or cost as much – especially in today’s rapidly evolving technology driven world!

The world has changed – and so has the way it learns. Those who want to stay relevant to its needs will need to change with it or go extinct.

The story (reported on the website linked at the end of this article) about a 100% self-taught Pretty Nigerian Lady Carpenter proves it.

The problem is that people who profit from the archaic teaching and learning models from the industrial age, and who are too lazy to THINK up modifications to accommodate this new need of the market they serve, refuse to admit the above stated truth.

Unfortunately, for them, this is a battle they cannot win.

The economics and logistics involved make this alternative way the most viable and appealing for what is increasing majority – especially given the harsh economic realities we all now face!

Little wonder that the young lady interviewed below spoke with such confidence and enthusiasm about how empowered she feels today!

Massive learning opportunities are offered at low to zero cost via the magical power of PC/Mobile and Internet technology today.

It pains me deeply to see people still torturing themselves to pay outrageous fees to get schooling for themselves or give schooling to their loved ones – all so as to “graduate” and wear gowns/collect certificates!

Note that I said “schooling” and NOT “education”.

Authentic education is what people should emerge with after exposure to schooling

But that happens only if the schooling delivers real world relevant content to learners – which does not always happen, especially when it’s done the Industrial revolution way.

The lady carpenter’s story linked below proves that some people are beginning to do what I’ve been doing for a decade for myself, and which I began doing with my kids in 2014.

World class real world relevant education from the best experts worldwide is available at your fingertips via your phone or PC at near zero cost.

Unless your ego needs you to show others that you/your child are learning, this model is perfect!

The lady interviewed below is living the life I and my kids have been living: we use technology as the combined foundation and springboard for learning and pursuit of personal achievement.

For instance, I used the web to learn the skills I use to earn 100% of my income today.

Yes. I am self-taught – and learned all I need for almost nothing from some of the world’s best experts in each area I make money today!

Guess what? I was a down-but-not-out seriously broke struggling startup entrepreneur trying to find a reliable market to serve for profitable pay.

Years of relentless study of the works of competent others, and diligent practice/application of all I learned in as many creative variants as possible in the face of repeated rejection, delays, disappointments and setbacks moulded me into the machine I’ve become today!

Nothing – whether you call it failure or rejection – can move me, or get me down. I’m immune to all that – courtesy of my extensive online studies. This is not bragging. It’s a statement of fact.

My vision is to coach my kids to function like me.

But teaching kids to do this is not easy, and can be quite messy.

However, the results we’re already getting assure me they are getting valuable life changing education already as I expected.

They are getting increasingly adept at using the web to pursue functional (as opposed to popular or fancy) learning in their schooling.

That’s in addition to knowing how toi scour the web to learn practical income generating vocations.

Today, they’ve established reflex proficiency in making trademark no-oven Charcoal Stove baked products and one of them.

This Pretty Nigerian Lady Is A Carpenter And She’s Very Proud Of It. See Photos

This is really encouraging. While the recession is biting Nigerians hard, this young lady is trying to make name and cash for herself by doing what many feel unfit for the womenfolk.

According to the lady simply identified as Olabisi, she learnt carpentry by herself by undergoing online training on Youtube and free online books…

After few months of training, the proud carpenter is now making some sales and pocketing some cool cash In her words;

The beautiful thing is, this journey is revealing to me much more than ever that God is a God of process. Therefore, no pressure!

Whether I succeed or fail is inconsequential, I am open enough to take the risk to fail. No pressure. No quest for instant gratification. No immediate result needed. For me, its all about enjoying the process.

Read her full inspiring story at:
http://www.nationalhelm.net/2016/10/this-pretty-nigerian-lady-is-carpenter.html

Successful People or Great Achievers Are Not All-Knowing! [Hint: Why YOU Must Never Let Anyone, No Matter How Successful, Dismiss Your Authentic Passion Driven Ideas/Dreams]

In case you didn’t know it, YOU owe YOUR car ownership ability TODAY, to the vision, self-belief, determination and persistence of a man who lacked formal schooling.

Not many people know this, but Henry Ford started out working for THE great Thomas Edison as a stark iliterate.

A testimony to the inspirational power that comes from exposure to the right environment can be seen in the fact that one day Ford (as a so called “stark illiterate”) got the idea to build an affordable car for non-wealthy masses.

This development is easy to understand when one considers the fact that Ford’s employer himself had only few months of elementary schooling, having been homeschooled by his mother.

Ford would have accurately concluded, based on Edison’s exploits, that lack of formal schooling (though useful and easily remedied) was not a fatal handicap in pursuit of success.

Ironically however, when he told his famous inventor boss about his idea, the great Edison dismissed it and instead offered him promotion to the position of Supervisor adding that he would be involved in “more important work”.

That last sentence brings me to the core message I want to pass across in this short piece that ends, below, with a link to a full narration about Henry Ford’s life and achievements.

My message is this:

As long as you believe in your dream or idea or vision and you are prepared to diligently/intelligent pursue it with persistence and faith, nothing that any other person, no matter how successful, should make you quit.

I repeat:

Nothing that any other person tells you should make you give up on your dreams. My hard-won experience from 7 years in paid employment plus 14 years (and counting) in self-employment have taught me not all great minds will see what another great minds can see.

This is why, for instance, I personally do NOT like competitions that depend on celebrities to choose people with the best business ideas, musical talents etc.

Fela Anikulapo Kuti continues in death to grow in recognition across the world, as a musical genius.

The truth is however that the kind of music Fela invented is very unlikely to have won him first prize in a reality TV show style event where judges and coaches have the final say.

We all know how contrarian Fela was, even as a young man. Yet those attributes that would have rubbed opinionated celebrity judges and coaches the wrong way in such competitions were the keys to his success in the real world.

This is why I believe the “market” for which an idea, invention or innovation is meant, should have the final say via a system that is free from manipulation.

This message is not just for you/me, but also for your/my kids.

We need to help our kids develop healthy levels of self-esteem based on the experience of doing in key areas of life that relates to nurturing their talents/geniuses towards succeeding in life.

This is important because during that journey, they will periodically come across successful others from whom they may have to learn and also accept advice.

It’s however their ability to know what NOT to learn or accept, no matter how well intentioned it is, that will help them stay on track to success in any area of endeavour.

Successful People or Great Achievers Are Not All-Knowing!

Most of them are aware of this fact, but societal pressures sometimes force them to accept to play roles that suggest the contrary.

If Henry Ford had allowed his respect and admiration for Edison to cloud his reasoning about his “car for the masses” idea, he would never have had the courage to reject Edison”s offer, and instead quit his job to invest all he had in pursuit of his dream.

If he had not done that, the revolution that took place in the automobile industry would not have happened.

Simply put therefore, vision, self-belief, determination and persistence are constant keys to authentic success in life. All other factors are variables in the success equation.

=============
The Henry Ford Story
=============

“I will build a motor car for the great multitude.it will be so low in price that no man will be unable to own one.”-Henry Ford

Henry Ford was nearly 40 when he founded Ford Motor Co. in 1903. At the time, “horseless carriages” were expensive toys available only to a wealthy few.

Yet in just four decades, Ford’s innovative vision of mass production would not only produce the first reliable, affordable “automobile for the masses,” but would also spark a modern industrial revolution.
https://www.entrepreneur.com/article/197524

Get Your Anti Recession Insulator™ Product FREE [Details Inside]

I don’t bother myself with hype in my messages – because it NEVER attracts people with the right mindset to fit into my target audience profile.

That’s why I share experience based true stories, mixed with a sprinkling of verifiable results, that combine to attest to the veracity of my claims.

Such messages have continued to attract authentic serious minded results-focused DOERS and ACTION TAKERS to me!

Yep.

People like the above indicated have often made the best clients for me :-)

For instance, in less than 18 hours of sending yesterday’s email on the above theme to my list (click here to read), I’ve gotten over 15% web form replies to my offer of details about “What You Need to Do, to Get My Recession-Proof Income Generating FREE Product Creation Service.

15% is a hefty response rate.

17% is industry standard for email open alone – so to have 15% taking the step to submit form requests is proof that this message resonates with my audience.

Chances are good that you also want details of how you can get my FREE service.

If YES, read on…

One of the form requests came from a Poultry Layer Farm CEO client based in Kaduna, who wrote as follows in the comments field:

***
comments = It’s always a good idea to diversify ones so source of income
****

And that’s the point I’m making with this initiative: The need to generate Multiple Streams of Income – regardless of what you do as your main vocation or profession!

Below is an excerpt from the full email details message I’ve sent to each web form requester so far:

:

Fill and submit the web form linked at the bottom of the excerpt, to request that I send you the full offer message, complete with JPEG mindmap, PDF report and AMR audio primer you can listen to on your phone or PC.

***Email excerpt starts***

[Title]: Re: Re(Your Web Form Submission): What You Need to Do, to Get my FREE Product-Creation-Service

[Body]: Below I describe 5 forms of Recession-Proof Income Generating Product I can Create at Zero Cost for YOU [In 30 Working Days]

I end by specifying what you need to do, to get this FREE product-creation-service.

[TIP: Before you start reading I need to impress a very important point on you – that products you create and sell using this strategy/approach I recommend, need NOT even have anything to do with the business you run, the day job you do – or indeed what you majored in at school!

Listen to the attached audio clip in which I give a brief explanation using my own real life products as examples]

…Listen to the attached 15 minute audio primer…

Now, with the understanding you’ve gained from listening to my clarification in the audio, reading what follows below should open your inner eyes to a wider range of product creation possibilities for now and into the far future…!

***Email excerpt ends***

Fill and submit the web form linked below to request the full message, complete with the JPEG mindmap, PDF report and AMR audio primer you will begin with.
http://www.tayosolagbade.com/contact.htm

[Tutorial 02] Using Named Ranges for Super Spreadsheet Optimisation and Automation

[NB: These are excerpts from a full tutorial emailed to members of my Excel Heaven Visual Basic Automation Club. They received the MS Excel Workbook example, a Video Demo, as well as an AMR Audio Recording in which I explained the best practice philosoophy that guides my unconventional approach to developing custom spreadsheet automation. Click here to request copies you can download]

In this tutorial I introduce one of the most powerful tools you can use to seriously boost your work related productivity in using MS Excel either as a user or as a VBA solutions developer/programmer.

The  simple database table used in this case study illustrate how NAMED RANGES  can make working with your spreadsheet data  much easier and less stressful/confusing or indeed error prone.

In addition, use of named ranges can help you use VBA coding more efficiently and effectively, to control MS Excel for your custom automation needs.

Below: Screensot showing a named range (nfAge) in the example workbook sent to club members, which defines the range comprising cells A9:A16 inthe spreadsheet table.

formularbar-namebox

Below: Screenshot of the annotated interface for the MS Excel Workbook in which this entire case study was treated.

xlh-tut02-2ndoctober2016

Below: Screenshot of the tutorial demonstration video I created in which I showed the steps for creating named ranges in a duplicate version of the original table shown above.

This has been emailed to members of my Excel-VB club, along with a copy of the MS Excel workbook containing the examples shown.

xlh02-2ndoct2016-video-demo

Click here to request copies of the full tutorial you can download