Today I came across a very inspiring article based on the life of a man who dared to dream and attempt the unattempted. Fortunately, the article is long enough to share part of it with you and show you the link to read the entire article.

Below is the part I got out for you.

Few people have changed this world to the magnitude that Walt Disney has. He proves that circumstance and education do not dictate what you can become. His life lessons serve as excellent reminders for young entrepreneurs.

1. You must be a salesman.

“I’d say it’s been my biggest problem all my life… it’s money. It takes a lot of money to make these dreams come true.” – Walt Disney

Sales gets a bad reputation, but make no mistake, selling is the most important skill you can master. And as Walt said, dreams take money and money comes from selling. Walt believed in himself and his dreams and could therefore convince others to believe in him too. Halfway through making Snow White, Disney ran out of money to finish the film that was termed “Disney’s Folly.” Even his own family begged him to give it up, but Disney was undeterred. He personally traveled to different producers and showed them the raw footage and convinced them to finish financing the film. Snow White became an instant success and ushered in the Golden Age of Animation. To finance attractions at Disneyland, he persuaded the television studios to finance building the park in exchange for original Disney programming. Guess what the programming was? It was basically an advertisement for Disneyland! This genius plan not only financed the park, but by the time it opened there were millions who couldn’t wait to go! It proved to be one of the most successful media campaigns ever done and it helped grow Disneyland into the international destination it remains today.

2. Leadership is inspiration, innovation and focus.

“You can design and create, and build the most wonderful place in the world. But it takes people to make the dream a reality”. -Walt Disney

The key to Walt Disney’s leadership is that he was an incredible storyteller. It’s one thing to tell your employees to do something, it’s another to inspire them to action. Walt would tell them a story. He would go into extreme detail and make it come alive for them. He would inspire his workers and make them a part of that story and as a result he would get more from them. When he was first pitching his animators on the story of Snow White, he went through the entire story, acting out the characters, even doing their different voices and movements. Walt had a unique ability to hire people more talented than he was and to focus and coordinate their attention towards a common goal. He admitted that he was a terrible animator. So he hired the best he could afford and focused on innovating the company. He also knew his workers. He knew what they were capable of and didn’t accept anything less than their best. He may not have been quick to compliment, but he was always clear about what he visualized and expected.

3. Always be constantly improving.

“Whenever I go on a ride, I’m always thinking of what’s wrong with the thing and how it can be improved”. -Walt Disney

Walt believed in the future. He insisted that Steamboat Willie have the sound synced and recorded, unheard of for a cartoon at that time. Before Snow White, there was no such thing as a feature length animated film. After it became a huge success and literally changed the film industry, it led to the success of several more beloved Disney classics like Cinderella, Alice in Wonderland and Fantasia. Walt Disney could have rested on his laurels, but that wasn’t his style. Instead, he completely switched gears and set out to build an amusement park where parents and children could have fun together. Once Disneyland opened, Walt would walk around the park, personally testing all the rides, noticing if anything was out of place and asking the guests their opinions. If he noticed something was wrong, he would personally see that it was fixed. As his animators could attest, good enough was never good enough for Walt Disney...

You can read the entire article on Lifehack

Remember my post on how I got introduced to forex trading last month. Since then I have been reading a lot about Forex and just recently took a webinar training by a forex guru based in the US. And now I can say I understand the basics of forex trading. And it is not as complicated as some people make it.

image: tradefxplus.com

Forex is simply what the Mallams at Broad street, Eko Hotel, Federal Palace Hotel and non-Mallams at Airport Hotel do. They buy and sell dollars, euros, pounds and naira. They will buy dollar from you at 177 naira and sell that same dollar to someone else for 180 naira. They make their money from the difference in the price they buy (bid price) and the price they sell at (ask price). This difference is called the spread. Then, the Mallam can decide to not sell any dollar today because he has heard that the dollar is rising swiftly against the niara. So he holds on to the dollar till the next day or two days after, when dollar is trading at a much higher rate to the naira. He makes a profit if truly the dollar rises as he expected or he makes a loss if he predicted wrongly.

You, as an online forex trader, will mostly do one of what the mallam does: you will buy and sell based on expectations of exchange rate movement rather than the spread. It's your online broker who will make money from the difference between the bid and the ask (the spread). And this is where everything can become complex. How can you correctly predict the exchange rate movement?

To answer that question, there are two types of online forex traders. The one who relies on technical signals and the one who relies on fundamental analysis. The technical signals guy uses complex calculations like the Fibonacci sequence and software tools to determine when to buy and when to sell. He pays no attention to the underlying economic principles that explain why a country's currency will fall or rise in value against another country's currency.  But the fundamental analysis guy is someone, like me, who cares very little about signals and the candlestick shapes, he pays all his attention to the macro-economics of the countries he is trading their currency and make theory backed decisions.

To supplement my indepth reading of The Economist news magazine. I have a daily google alert for all the currencies I trade, I also have a Flipboard channel for them and I daily read The Economist Expresso. I only trade when I am sure that I know what the fundamentals are saying about the movement of a currency pair. 

For example, the Japanese government recently did a massive round of quantitative easing. They went on a bond-buying spree to artificially pump more money into the economy. And by economic principles this should lead to inflation and lower value of the Japanese yen compared to the currency of another country that hasn't made any drastic monetary policy. So on the news of this, I bought the USD/Yen pair. As expected, the dollar rose against the Yen so much that the Finance minister of Japan had to comment that the fall in the Yen was more than expected. I made money. (Though small because I put in a small amount in my Forex account, but big percentage-wise).

Again, from following the news of Euro economy and the reluctance of the ECB to do the obvious. Last week, upon the news of how the Euro economy is faring I was sure the dollar would rise against the Euro. I immediately sold the Euro/USD pair. At first, the market went against me but I didn't care. My fundamental analysis was spotless, and so I held on. After about 4 days, the market began moving in the direction I predicted and I have another nice profit from that transaction. 

I also bought the EUR/Yen pair. Currently the market is against me on it. But I know that it will have to someday move in the direction I predicted. The Japanese economy is experiencing a recession. The Euro currency economy is growing and slightly better than expected. Following the fundamentals, until the ECB does a quantitative easing, the Yen will not permanently rise against the Euro and should fall over time.

Finally, as sound as my explanations sound. Economics is like a Y-shaped fork. It always leads to more than one possible outcome, sometimes opposite outcomes. Just like the Japanese quantitative easing led to recession instead of economic boom while it led to economic boom in the US. That's why it is said that you can lay all the economists in the world end to end and they still wouldn't reach a conclusion. Due to my unprofessional knowledge of international economics, even my analysis can be incorrect. Then when they are correct, they may still not lead to the expected outcome. But in everything, having a consistent strategy matters more than being error-proof. I can't be oscillating between technical analysis and fundamental analysis. I stick to one. And more importantly, I trade with the money I can afford to lose. And be always on top of the global finance news.

I strongly believe that no matter how much you earn at your current job, as long as it's a job you hope to go beyond someday or you can be fired from, then you should have a side hustle. Have a little something you work on on weekends that might someday become big enough to provide an income large enough to live on.

image: laniletter.com

And the reasons are:

1. It's dangerous to have only one income stream. Having a side hustle is one of the best ways of getting an additional income source. 
2. There is no better way to try out your business idea than doing it as a side hustle while you still have a dependable monthly paycheck. 
3. It is the best way to work on what you really have passion for, no matter how financially boring it may look. Maybe you have a huge passion for gardening, but you don't plan to quit your current career to become a gardener. You can still go ahead and do on a commercial level what you really enjoy even though you don't see a career in it. You will be doing it for the fun of it and to spice up your life. Think of the inspiration you will cause when your clients find out that you are a bank manager during the week.
4. It's the only way to acquire certain skills. There are some skills you can't acquire by reading or thinking about them. You just have to learn them by doing. If you hope to become a motivational speaker someday, then doing it as a side hustle now is the only way to acquire the speaking skill you need. Same with fashion designing, photography and programming. To become good at them, you need to do them. I got the courage to go on my own from having done Excel consulting as a side hustle for over a year. I learned to trust my own competence and, at the same time, improve it.
5. It can become your big break. I once stumbled on the story of how Elizade came into existence. Chief Michael Ade Ojo, the founder, was selling cars as a side hustle. Then one day he decided to test the waters, he took at month's (or so) leave at work and put that entire month into his side hustle. At the end of the month he found out that he had made multiples of his monthly salary (I think about same as what his salary gets him in a year). So rather than resume from his leave, he simply put in his resignation and started Elizade. His side hustle led to his big break.
6. Jim Rohn, a personal development guru, once said, "Earning $5000 a month is fine, but making an extra income of $2000 is superfine. Profits are better than wages." He also said, "Formal education will make you a living; self-education will make you a fortune." And we all know that you get self-education by hustling and not by taking company sponsored training. There is a special joy in earning N100,000 without the support of a system that earning N300,000 from an established system doesn't give.
7. And best of all, having a side hustle makes transitions in your life easier. Nothing (death apart) can abruptly stop your life. Not being fired from a job. Not having your salary halved. Not having to relocate and find a new job. And you can more easily make life enhancing decisions. Like quitting a terrible job. Or relocating to a better place without fear of losing all incomes.

For me, turning something as small as a Microsoft Excel knowledge into a side hustle has completely changed my life. Three years ago if I was told I would become a full-time independent consultant I would think of all those technical stuffs I had expensive certifications in (Oracle and Cisco) and my then current industry (Telecoms). Not in a million different thoughts would Excel have surfaced. So you never can tell which side hustle would turn out to be your main hustle. And forever change your life.

I have been invited to give a talk on Entrepreneurship at a youth program organized by a Church in Ogba, Lagos. It's this Saturday.

image: drshrand.com

I will like your suggestions on what I should talk more about. I'm meant to talk for 45mins and have a 15mins Q&A session. And I've been thinking hard about how to structure my talk and what to focus more on. I won't be projecting any presentation slides and don't want to make the talk in anywhere academic-like. I want to make it conversational and deep, with lots of real stories. So I want your suggestions, based on your knowledge of me, on what theme I should focus on and how I should structure the talk.

As much as I love to share my knowledge and stories, I avoid giving talks. I don't know enough neither am I someone enough to confidently talk to people about anything other than my faith and MS Excel. Being a professional speaker often requires you put up an air of superiority and overhype your successes. It forces you to see yourself in an unnatural light. It comes with the high risk of one doing no more than just talking up and down, here and there. 

It's the main reason I am no longer focusing on conducting Excel training. I keep saying almost the same thing, explaining the same features and answering almost the same questions. It makes me feel like I know all there is about Excel. And it makes the few projects I have done look like multitudes. I don't feel challenged or forced to learn something new or solve some tough strange business problems.

The real joy I get from what I do is when I take on a project that I have not done something similar to before and I am forced to think creatively and work hard from morning till the next morning. I prefer getting stuck at an Excel program code than getting praised during a training session (which happens all the time).

Luckily, this talk is a unique one. I was selected based on the recommendation of a friend who believed in me more than I believe in myself. And it's not a recurrent one. And this is one of the moments I have been training for since 2011 when I joined Toastmasters. Also my experience of conducting professional/technical training since 2009 (when I was working as a CCNA instructor) will be of immense benefit. It taught me the power of illustrating with things around and telling good stories. I had wonderful ways of explaining how a router works and the different OSI reference model layers. I always got great ratings and excellent feedback. So I am going to combine my award winning Toastmasters speech crafting expertise and educative professional training skill to deliver a great talk.

As a Toastmaster, what makes a great speech is more of feedback and rehearsals before the main speech day. And that is why I am seeking your feedback and suggestions. If you were to be part of the audience what would you prefer I talk more on and how would you expect I string together everything. 

Thanks!

No one is perfect. No one has only good sides and no bad sides. No matter how innocent looking and soft minded a person is, s/he will have a poisonous side. And I think it's perfectly normal. It's what makes us human: our imperfections. It's great to aim at perfection. Trying to limit the damage your bad side causes. But the one thing you shouldn't do is to fake perfection. Never fake who you are not. Be you.

image: theentrepreneurwithin.org

If you give the people I have had close dealings with, either as former colleagues at work or former classmates at school, a questionnaire asking them to write what they consider as the poisonous part of me, you will get one very clear answer: "Michael doesn't keep in touch."

In secondary school, university and at every place I have worked I have had very close friends. I bond with the few I connect with extremely well. But when I leave it all ends. I don't keep in touch. It has led to the death of several promising/potential relationships. It's my own biggest imperfection. I have tried to change it with little success. I have tried to fake being perfect, it was a hell of a work. I have prayed about it. I have thought hard and long about it. All I achieved was to discover how deeply rooted in it I am, that it's part of what makes me me. And that it's not with everyone I completely detach, amazingly, there have been a few people whom I have loosely kept in touch with.

I find it hard to get too attached to anything or anyone. And it's partly because I put my entire self into whatever I commit to. I envy people who are members of different social clubs or organizations and not get tied down by anyone. In 2011 I joined Toastmasters without any ambition, just wanted to be more social and outgoing. Now it's almost a part-time job. I have, without intending and even trying not to, become so entangled in the club administrative affairs that I even don't fix business dealings or Excel training on meeting days. I have been trying really hard to become less involved in the club, but somehow my nature of doing my best at whatever I do is causing me more troubles.

Even while at university, I was active at the university chapel. Took everything very seriously: from the Sunday school to vigil. In the beginning I looked like someone doing a silent campaign for church leadership roles but after a while it became obvious that it was who I was. I don't know how to do things half-halfheartedly. I either don't do a thing or I put my entire self into it. But then it makes me break off completely from whatever I am not actively doing. Since leaving the university I have not being in touch with the chapel and almost everyone I was very close to there.

Now I save myself unnecessary troubles. Rather than fake who I am not or kill myself trying to fix my imperfections, I simply try not to get involved in anything I don't want to put myself wholeheartedly into. And I don't try to fake keeping in touch, it's exhausting and not me. Life is more about discovering the real you and letting it shine through rather than defining who you should be and forcing yourself into a mould that is not meant for you.

This month is the 8th month of going on my own, as my own boss. And looking back I am much different from whom I was 8 months ago. Being an entrepreneur is remolding me, surprisingly, structurally more than financially.

It has made me more bullish. More willing to take a chance. And less reluctant to try something new.

image: entrepreneur.com

I am also now more comfortable with facing my troubles immediately. Before, when something goes wrong in my life or at work, I think a lot about it and sleep a lot, hoping the situation would have improved  when I wake up. I no longer act that way. Last month I had lots of troubles and I had to tackle them immediately or they were only going to get bigger. Still I couldn't meet the deadline for filing my monthly VAT payment. Rather than feel zapped of energy and retreat when faced with big troubles, I now suddenly feel infused with lots of energy and run around more when I have issues to resolve or troubles to face.

I am also, now, more long term oriented. There is no more assured monthly paycheck. There is a proposal I have been pushing with a team that took me on as a technical partner, it's now 6 months and nothing very concrete yet. I am now less concerned with my bank account balance, it competes with the weather. I just make sure I am doing my best and delivering very high quality job. I'm now a company and easy profit shouldn't be my ultimate aim in my first year of operation.

I remember last year, I was learning a lot of things I wasn't sure how I would apply them in my professional or personal life. Now I can't seem to have enough time to learn the things I need to know for my professional life. Everyday now feels very short, like there are now fewer minutes in each hour. I have also managed to learn a lot in these 8 months than I have learned in any one year. I am now a proficient MySQL database administrator and on course to becoming a web app developer. And that is not to mention how my Excel competence has skyrocketed due to the various projects I have worked on and training classes I have conducted.

Finally, I no longer feel intimidated by the success of anyone else. Before I used to do a quick mental evaluation of anyone earning more than me and reach one of the following conclusions: they work in a higher paying company or they have spent more years in the corporate world. Now I'm too busy reaching my own goals that I no longer do such mental comparisons.

Being an entrepreneur is shaping me into a more responsible, highly motivated, always working and happier person.

Alibaba is the world's biggest eCommerce site. Think of a Jumia.com that is servicing the whole world and selling almost everything.

For over a year now I have had my services listed on Alibaba, unfortunately, I haven't gotten any serious foreign buyer. Also, I haven't made any purchase on the site. Until yesterday. This week I should be receiving my order of an FM Transmitter. In Nigerian English: my own radio station equipment. 

I plan to someday have a radio station that plays only music. Good music. 22 hours a day, 7 days a week (the missing 2 hours are the total advert play time). So yesterday I decided to start small and in a fun way. I went on Alibaba Express and ordered a portable stereo FM Transmitter that comes with all I need to start a home radio station. Or office radio station. But what I really intend to use it for is to start a bus radio station. For a weird reason I enjoy taking public transport than driving to anywhere (except meeting a big potential client). And if you've been a long time reader of my blog, you would have come across a couple of my posts where I mention that I hate listening to our radio stations. Well, when you are in a danfo or cab you wouldn't want to tell the driver to switch off his radio because you don't like all the radio stations. 

My biggest intention of getting this portable FM transmitter is that I am going to set up a radio station right in the bus and make it transmit at the frequency of the radio station the driver is listening to. I might even make it transmit the conversations in the bus. Or I make it transmit my favorite songs. Then I will make sure the driver freaks out when he changes the station because I will keep overwriting any new station he tunes to. And the other fun part is that the other cars on the road will be hearing everything we are discussing in the car or my favourite music, for as far as half a kilometer radius. That's the possibility of over 1000 cars on the Third Mainland bridge at 6pm on a weekday! Then I can do my own voice over broadcasts. Make a shoutout to a friend in the same traffic after telling him to tune to Cool FM.

Traffic time will no longer be just reading time for me but also fun time. The FM transmitter complete gadget is just a little bigger than those old Nokia phones with antenna. It has a battery that can last for hours (4 to 10 hours depending on how far I want the signal to go). And it has a mic I can speak into to do voice over and an audio in cable to connect to my phone. And I'm going to be as creative as possible.

Whenever you are in a traffic on Third Mainland bridge or Lekki or Oshodi -- Ikeja, Whatsapp me on 08063125227 or send me an SMS. If I am nearby you can gladly request for the station I should jam and the song you want to hear, and also a shoutout too. And if you have an audio recording you would want me to play at a particular time in a particular traffic, then mail me. If it will cost me a lot of stress I am going to bill you for it.

The greatest reward a job can pay you is to help you become who you've always wanted to be. It's never the money you get but who you become by it. And there is only one way to achieving that: get a job you are passionate about.

And to encourage you I've compiled the following great quotes.

"You've got to find what you love. And that is as true for work as it is for lovers. Your work is going to fill a large part of your life, and the only way to be truly satisfied is to do what you believe is great work. And the only way to do great work is to love what you do. If you haven’t found it yet, keep looking. Don’t settle. As with all matters of the heart, you’ll know when you find it. And, like any great relationship, it just gets better and better as the years roll on. So keep looking until you find it." Steve Jobs

"There comes a time when you ought to start doing what you want. Take a job that you love. You will jump out of bed in the morning. I think you are out of your mind if you keep taking jobs that you don't like because you think it will look good on your resume." Warren Buffett

“Just don’t give up trying to do what you really want to do. Where there’s love and inspiration, I don’t think you can go wrong.” Ella Fitzgerald

"Your work is to discover your work and then with all your heart to give yourself to it." 
 Buddha

"A man is a success if he gets up in the morning and gets to bed at night, and in between he does what he wants to do." Bob Dylan

"If you don’t wake up in the morning excited to pick up where you left your work yesterday, you haven’t found your calling yet." Mike Wallace

"If you don’t build your dream. Someone will hire you to help build theirs." Tony Gaskins.

"Forget the risk and take the fall, if it’s what you want, then it’s worth the fall." Anonymous

"Wanting to be someone else is a waste of the person you are." Marilyn Monroe

"Go where you are celebrated — not tolerated. If they can't see the real value of you, it's time for a new start." Anonymous

“The two most important days in your life are the day you are born and the day you find out why.” Mark Twain

"It is never too late to be what you might have been." George Eliot

"There is no passion to be found in playing small — in settling for a life that is less than you are capable of living." Nelson Mandela

"Too many of us are not living our dreams because we are living our fears." Les Brown

Yesterday I came across an excellent article on LinkedIn and I have decided that it would be great to share it -- actually, part of it -- on my blog today. It's by Liz Ryan and the full article can be read here. 

Liz Ryan's Human WorkPlace company

Stupid Attendance Policies
Salaried people don't need attendance policies. That's why they're on salary. If you're still dinging people for getting to work ten minutes late when they commonly stay an hour late every day, you don't deserve them on your team.

Stupid Frequent-Flyer Policies
Business travel is a grind. It takes years off your life. It's not easy being on the road and leaving your life behind. Your employees earn every frequent-flyer mile their business travel entitles them to. Those miles are theirs, not their employer's.

Any company stingy enough to steal its employees' frequent-flyer miles is not an employer that can grow your flame or take you to the next step on your path. Get them to change that Scrooge-y policy, or run away.


Stupid Dress Code Rules
We write dress code policies because we'd die of embarrassment having to talk to an employee face-to-face about his or her excessively club-by or beach-y attire. Too bad for us. We're managers, and sticky human topics are part of the job.

Get rid of the insultingly detailed dress code policy and simply remind your employees to dress for business.

You can add "If you're on the fence about whether or not to wear a particular ensemble or article of clothing to work, err on the side of caution and don't wear it."

Bell Curve Performance Reviews
Performance reviews in general are a bureaucratic waste of time, but the ones that force managers to fit their teammates into pre-set slots on a Bell Curve are disgusting and unworthy of the brilliant people on your staff.

If you truly don't trust your managers to hire wonderful employees, why did you make them managers? Bell curve performance reviews only encourage the hiring and retention of so-so employees, or worse. Get rid of them in 2015 and celebrate your team's briliiance!

Stupid Bereavement-Leave Policies
There are still employers that require their employees to bring in funeral notices in order to be eligible for a few days' paid bereavement leave. That's shocking and horrifying.

No doubt some employee way back would falsify a family death to get some time off, and ever since then the company has been writing its policies to prevent such a fraud from re-occurring.

That's idiotic, and heartless. It's never smart to write policies directed toward people you wish you hadn't hired. Trust your employees, and they'll trust you back.

Stupid Approvals for Everything
We'd expect any employer to require approval from higher-ups before you're allowed to spend a lot of money or hire someone new. We'd expect some required approval before you launch a project or put someone on probation.

Do we really need a manager's written approval for an employee to replace his ID badge?

We have taken nearly all the latitude away from the talented adults we hire. That's stupid and a waste of shareholder's money. More bureaucracy only slows us down.

Can we trust the people we chose to join our team to do simple things like order a new stapler without requiring a manager's written permission? If not, can we call ourselves leaders?

Stupid Disciplinary Rules
The idea of discipline comes from the military. We don't think that it would ever be appropriate to put our kids' piano teacher or our plumber on probation, so why would we do that to the employees on our teams? The idea of progressive discipline makes no sense in the Knowledge Economy we operate in now.

We are all adults. If someone goofs up, we can have a conversation about it. We can figure out where things broke down. If we don't trust a person to represent our brand, what good will probation or a written warning do?

Don't listen to people who say "We have to do this stupid stuff in order to fire people if they don't improve." That's completely false. I was a Fortune 500 HR SVP and I'm an expert witness in employment matters now. Anyone who sighs "We're forced to follow these old rules" is either lying to himself, to you, or both.

Stupid Feedback Mechanisms
Employee Engagement is a crock and a slap in the face to your teammates, most of whom would be happy to tell you to your face what your company is doing right and wrong. All you have to do is walk up to them and ask them, face to face, and listen to what they have to say.

Annual employee engagement surveys are a weenie's answer to the question "How are we doing, and how's the team?"

Do you ask your wife to fill out a survey and tell you how you're doing as a husband? She'd have a sharp answer for you if you proposed that approach.

Why should the valued collaborators you work with see things any differently? Lose the engagement survey and make it easy for your teammates to tell you what's working and what isn't, in the moment.

Stupid Hiring Processes
It's easy to fill job openings when you do these three things:

Write job descriptions in English or your local language rather than corporate zombiespeak.
Treat job applicants like valued collaborators rather than interchangeable machine parts or pieces of meat.
Make the interview process fast and friendly, and remember that job candidates need to be sold as vigorously as your customers do.
It's hard to fill job openings when you use Black Hole applicant-tracking systems to screen resumes by means of keyword searching.

That's the world's worst way to hire people. Any employer that complains about talent shortages is barking up the wrong tree. Humanize your recruiting process and watch the talented people flow in!

Stupid Forced Ranking
Forced ranking, sometimes call Stack Ranking, is a process of lining up your employees and comparing them to one another, Best to Worst. It's easily the stupidest idea corporate and institutional weenies have ever come up with.

You can't stay and work for a company that treats like you like a two-by-four stacked up against other pieces of lumber, not when there are wonderful organizations that could use your help!

Your teammates deserve better. People are unique and whole in themselves. There is nothing to compare between one person and another -- thank goodness! Smart employers have always known this. Any organization that doesn't get it doesn't deserve your talents. Get on your path and find the people who do!


Don't forget to read the entire article on LinkedIn Pulse.

As much as possible I try to limit my use of VBA/Macros. Macros require the user enabling the macro to work, doesn't work on tablet and phone versions of Excel (even on Windows RT) and can be broken when run on a Mac version of Excel. 

I find that it takes some fun creativity to do complex tasks purely with Excel formulas than building a macro. And there is the added advantage that formulas auto-calculate, out-of-the-box, and gracefully while macros have to be programmed to run whenever particular cells are updated.

I have made lots of dynamic dashboards using purely formulas, but often a weird mix of IFERROR, INDEX, MATCH, INDIRECT, AND, OR, IF, TEXT, SUMIFS, COUNTIFS, LOOKUP, ROW, COLUMN and RANK.EQ.

Today I will be sharing with you the combination I use in sorting and picking the top records from a list somewhere else. And it always monitors that list and updates to consistently give the top records always. The combination is very simple, uses RANK.EQ, INDIRECT and MATCH.

So lets see how it works. 

I have made a sample table (downloadable) for illustration.

And I would like to show in another sheet or entirely new worksheet the top 3 sales by sales amount. Ordinarily, I would have to sort the list by sales amount in descending order and copy out the top 3 records. It would work but it won't be dynamic. When the records change, my top 3 list will still be showing for the old list. Showing non-current values.

We will now attempt to do this entirely by formulas -- from the sorting to the picking of the top 3 records and it will always show the top 3 records even when the list records are changed.

Step 1:
Do a ranking of the records by the sales amount in descending order using RANK.EQ. As shown below, for the first record, BBQ Chicken, the formula entered is =RANK.EQ(C3,$C$3:$C$18,0)

Step 2:
On the sheet we intend to display the top 3 records, we type out the fields.

Step 3:
We'll use INDIRECT and MATCH to pick the values with ranks 1, 2 and 3, as they represent the top 3 records.

Let's examine the formula used to pick the first record and it's Pizza Type field: =INDIRECT("'All Sales'!A"&MATCH(1,'All Sales'!$D$1:$D$18,0))

INDIRECT("'All Sales'!A" tells Excel to reference a Sheet named 'All Sales'! and the column A. This is actually the sheet with all the sales records and the column A is the Pizza Type field. Next is to figure out the row to pick, the row that corresponds to the highest sales amount record. Rank 1 record.

MATCH(1,'All Sales'!$D$1:$D$18,0) tells Excel to give us the row position of the record that has 1 in column D. Column D holds the ranking. So we are asking Excel for the row of the record with rank 1. For this particular list the row is 7 (Chicken Feast).

 =INDIRECT("'All Sales'!A"&MATCH(1,'All Sales'!$D$1:$D$18,0)) evaluates to  =INDIRECT("'All Sales'!A"&7) and finally, ='All Sales'!A7 (cell A7 in sheet 'All Sales')

Now you should be able to figure out how the formulas in the other cells work.

And that's how you pick the top records from any list. And it's dynamic.

Let's change the sales amount for BBQ Chicken, from N620,000 to N1,620,000 and go check if our Top 3 table has updated to reflect the change we just made.

Yes! Our Top 3 table is now showing BBQ Chicken as the topmost record.

Don't forget to download the practice file here. 

Now you can do one more useful task with Excel. Congrats!