wd

Learning Excel is like renovating your house….getting your house renovated is a challenging task, where most people go wrong is finding the right builders. When judging the costs, the instinct is always to go for the cheaper option but often this ends up being the costliest. Mistakes, poor estimation and work that subsequently needs to be repaired just costts a lot more in the long term. It’s precisely the case when it comes to improving your Excel skills. The courses out there are jsut not great when it comes to preapring the average Professional. I spend a great deal of my writing about my journey, my career, my salary. Not many people do that, give you that transparency, why do i do that? is it to show off? Nope, it’s to qualify myself. The truest qualifications are not actual qualifications, they are the time you have spent in actual companies, solving problems. My course is not the cheapest option avaialable in the short term. but I don’t work with short term thinkers so I’m not trying to attract those kinds of people. You can get cheap courses on the internet, I’ll even tell you the cheapest courses you can find are on udemy, I don’t even mind telling you that, you can go and take a look for yourself….All other courses are VERY VERY expenisve in the long term. My courses gets you the rigth skills in 6 weeks, it tells you how to market those skills and get a better job. I encourage you to move on, that’s why companies are terrified of my courses, I have turned down offers of selling licenses to companies, I do this for you, for the people. I do this because I am preparing people for the future, the gig based economy, so there sould be no discussion about skills without a discussion of how to sell and market those skills. NO ONE else does that, why don’t they do that because they were courses written by people who obsessively got better skills without any concept of how you translate those skills in to salary…so they encourage you to get good at everything…but the truth is you only bneed to get good at a few things but you have to go deep

Let’s talk about demonstrable skills. The biggest fear that people have is losing their jobs or they have anxiety about changing jobs. It’s about risk but let me telly ou one factor that people don’t talk about often but is actually a mjor route cause of the anxeity. It’s demonstrable skills.Many roles are difficult to make demonstrable. These are not considerations people tell you when you are younger, they are not considerations that you are told at university. The best educations comes from immersion, nothing even comes close, then shadowing good people, then being mentored by good people who have done what you are trying to do (find niche mentors,not a one size fits all mentor)…..then miles behind is reading and reading needs to be done because it takes years for the lessons fo reading to manifest themselves in your everyday being. The whole hierarchy is about how long it takes for you to undergo a transformation and immerson will give you the quickest transformation. I have nothing but disdain for anything that requires you to get permission, like from an insitution for a degree. It’s fine for medecine or work iwhich is heavily regulated like lawbut everything is in a non urgent spectrum of ‘keep going until it does what we want it to do’….Going back to what I was saying, skills are everything, skills solve problems. A lot of your fears on moving on could be curbed by knowing you have powerful value add skills. It’s part of the reason I had little fear, there certainly were other factors on risk mitigation but on the whole, the confidence that comes with knowing you have a powerful skills is huge, confidence motivates us to get in to a better situation.
—–
What Fried Chicken has in common with Excel…sadly, I love fried chicken, it’s been the reason I need to go on ‘dieting stints’. But I want to address something today and that is a lot of professionals think it’s too much to learna new skills later in life, in your 30’s, 40’s etc, well colonel snaders was 60 years old! Also, for those who think its too late to start one of my students William Anglacer is almost retired.

——-29/7/16

Earn and Excel
Who is Sohail?
Free Excel Formulas Book
Blog
Home / writing dump
writing dump

Hieararchy of operating
Run the business, make the decisions to ensure the machine operates correctly
Top level strategy and decision, some top and tail from below
execute top level strategy/decisions by emplying teams to do so, some top and tail from below
lead team with one or few key focuses, some top and tail from below
execute work with one or few key focuses
Support all the way up
In order to climb you need to think at least 1 to 3 levels above you and be directly empathetic (in your work) to1 to 3 leels above. If you are at the execute work stage (which most people are), then you need to find ways to help above directly, create work > get visibility (to not usurp) etc. Getting visiblitly is very very important…but if you are obsessive about doing the low level work and living in your spreadsheets without being conecrned about what effect they have and how the help above and getting in that conversation, you won’t ever move forward

Real Excel advice for professionals
Tips, tips, everyone is bombarded with ‘tips’, havin tip after tip does nothing but clutter your brain
what you’ll get with me is excel advice and career advice. My excel skills played a massive role in getting me to a 6f salary
I don’t bother with Tables, they can be good, but I just don’t
Sparklines look pretty but if you’re a professional like an accountant/pmo , analyst, you don’t need it, it’s overkill
Why overly pretty outputs make you look pretty sill (senior people who are concerned about business problems don’t care about your pretty charts, if they do, they will get fired at some point because they possess a personality that doesn’t lend itself to leadership i.e. they’re worried about the wrong things…good leaders need the rigth amount…of coruse, it needs to be neat but most importantly it needs to be useful..i’ll talk more about usefulness (s.o.s…create a narrative with your report, understand your audience and create for them…this is a big problem when somone comes along and just wants to show off their excel skills…guess what it’s like asking a harlem globetrotter to join the la lakers…sure they’ll do some fancy moves but when it comes to playing the game, they’ll be ouyt of their depth…you’ll look like all style and no substance
I don’t teach everything, in fact I spend a great deal of time teaching you what to avoid! If you want to become a genius at every aspect of excel , I’m not your guy. If you want to learn the right things in excel to cruch your professional career, go far and get a much bigger salary in the process. I’m your guy.
charts, you don’t all the charts. When I see someone’s workbook with all inds of bubble, donut, surface blah blah, I cringe, I cringe hard like someone’s kicked me where the sun doesn’t shine. You know why because this person has comitted a few crimes and it’s often managmeent consutlants who will be guilty. the crimes are 1.you are not able to articulate something in simple terms so you are using a fairly complicated chart. 2. you are violating the no.1 law of being a good professional ‘dumb things down for people’, even for other professionals. Some people don’t want to dumb things down because they hate anyone who doesn’t get it, sadly those people don’t ‘get it’, other people won’t dumb things down because it makes them look smart, well they’re not playing the game, so they are anything but smart, they’re what i call ‘nostalgia smart’: Nostalgia smart are people who go A’s in school, did will at university, intellectual top dogs, their self worth is wrapped largely in the persona and reputation they have crafted over many years of being smart, they must leave the smartest facebook comemnts, they will engage in debates and discussions with others to prove their intelligence. Those are heavily deluded people, they are playing the wrong game, they are squandering their intelligene, it’s like a professional footballer who injured themselves showing off 9it’s ahppened), it’s a waste. If you don’t dumb things down, you are lacking empathy and self awareness and it will make you look like a smartas or leaders will dismiss you as someone who doesn’t get it. of course i can say this as someone who was the master of bubble donut plum monkey micro graphs, what did it get me a very dismissive ‘that’s nice son’ which is why i hate it when excel ‘experts’ tell you what you need to be a dashboard master…you don’t…In the course, i’ll keep you form preventing such mistakes and telly ou what it is you actually should be focused on…remember kids, Excel ‘tips’ are dangerous. Excel advice should come wrapped i useful career’business context , so it has a purpose

what are excel jobs? Is ther such a thing and if so why should you care. Yes there are and it’s important because these roles allow you to create time and they often lead to bigger more fruitful careers
Should senior execs know excel? What level is excel good for knowing? If you are senior and you have a small team excel will help you because you don’t have to articulate thoughts in your head, you can control the model. If you have a big team, you need to ensure there are at least a few solid excel whizzes on the team, get them used to taking instruction from you. A CFO of a big org doesn’t have to play with Excel but a CFO of a small org does
What I would do differently
Talk about the philospohy of overlearning from sales page

Pretty Excel Charts and pretty silly
I was 28 years old and working in Banking Operations at the Royal bank of Scotland, one of the biggest Banks in the world. We had some executives coming from the US and they wanted to discuss the progress of projects my team was on. This was my time to shine so I told my manager, let me pull something together, so I spent a week, mostly in my spare time on creating a Dashboard. I wanted this to be the baddest mo fo of a dashboard ever seen, I reasearched and foun a way to do some microcharts (sparklines), some dynamic moving graphics and more functionality. I mean this thing was bonafide bada$$, I was happy and the boss didn’t have much time to review it. Now eventually, when our US execs came in, I managed to get 15 minutes of their time and when i first showed them, I’ll never forget the reaction of the most senior of them. He smiled in amusement. He looked at it and smiled in amusement, he said okay, thanks then changed the topic. I felt like the time I was 7 years old and told Samantha Jackson, I loved her and wanted to marry her, she laughed and then told the whole classs wo proceeded to laugh at me. So what went wrong? Ultimately it comes down to this : senior people who are concerned about business problems don’t care about your pretty charts, if they do, they will get fired at some point because they possess a personality that doesn’t lend itself to leadership i.e. they’re worried about the wrong things…good leaders need the rigth amount of information to help make good decisions, they care about not being distracted from making the wrong decisions. Make your charts neat but NOT fancy, they need to be useful. That particular executive laughed because he’s trying to run a business, he exepcts people around him to get that and support his ability to do that. So when I rocked up with a jackson Pollock of a chart, i just looked like a child trying to impress the big kids, I looked amateur and in that split second the executive lost all respect for me. Some people, some Excel ‘experts’ will say, there’s nothign wrong with making your charts a little fancy. Don’t listen to them, they don’t work in the real world. In the real world, you need to give the impression that the work you do adds value, not wastes time. In a corporate environmnet, you will NEVER go wrong with simple, basic Dashboards and reports. Now there’s other things your repotts and dashboards MUST do that will ensure you are taken very seriously as someone who ‘gets’ it. register on to the course and I cover that in Week 2 of my Z2EG course


All things being equal the winner is
one of the most annoying phrases we use in our lives is ‘all things being equal’. Case in point, someone was debating me recently on my stance on MBA’s and certifications and he said that phrase, all things being equal, the person with the better education will get the job. This person is a few years younger than me and has not hired before. I have been hiring team members for years and been a part of hiring senior execs too and I can tell you, never has the ‘phrase all things being equal been uttered’ because nothing is equal…and if all things are equal, it’s the person with the most fitting personality that will win. A degree tells me some very generic information about a person such as how good they were at getting in to a university, how good they were at passing exams, these cannot be directly used in a role. The role goes to the person who can make an impact from day 1, someone who has actual real world skills, in the analystical world, Excel skills are king but why are they king
How to master Pivot Tables in under one minute
this should link to the podcasst of me talking about it
Everything you need to learn about Sparklines and other cool charts
Your walking to work, all pumped up and excited, you can hear salsa music playing in your head, you’re going to go in to work and do some cool charts, some sxy sparklines, some donuts charts…maybe you go a bit crazy and work out how to use a radar chart..wooo yeah!
*stop music*
No, I’m here to spoil your fun.
yo’re tring a little too hard and that will hurt your rep
Pivot Tables
Don’t make the tool control the way you work, you control Excel to make your work easier, let me show you how
The Vlookup
The number one problem with people whoa re nt great at Excel isn’t their lack of skill with formulas functions, its about how data is stored…(analogy of foundations)
IF you use this formula you are doing something very wrong
The Hllokup was inented by Excel as a way to give people another way to do something. They invented a function thinking they solved a problem but for professionals they created a problem, they shopuld encourage people to store their data proerly then they won’t use hlookup. But microsoft is always tryingt o add to the number of formulas because its a selling point. i am the anti, lets add stuff, learn everything guy…the most improtant book i’ve read in the last 10 yeaars is clled the paradox of choice and in it scwarz breaks down we we as individialas and collectiely are massively hurt from having too much choice. Did you notice my formulas book was attemplting to remvoe a lot of choice, I have boileddown the 27 most important formulas. Imagine what i have done in my course, I have removed so mauch nonsense and i can do that for two reasons, 1. im expereicned and 2. Common sense from mistakes
BBC average salary based on degree. Don#t compare yourself to the average, if you are below it it will depress you, if you are above it it wll make yyou feel comfortable in tough times. As for education, I’ll never forget the day I got my degree from university, it was the day my education started. University is one of the worst places to get education because you learn no real skills, you learn generic theory (apart from medecine)
—-
mba
My position onMBAs has bchanged since i recorded that first video. First of all, the education in an MBA is generic, it simply won’t help you directly and barely indirectly. There simply is no substitute for being in an organisation, understanding it’s probelms nad helping senior people out. When you do an MBA you are doing it for you, That is extremely bad choice,. The way I teach people to sell themselves is all about other people, its about empathy, when you do an MBa, you’re saying look at me for the wrong reasons, you want to say ‘look at me ‘ for the right reasons, that is as a problem solver. The way you do that is to go in to organisations and solve problems, get results, …that’s what senior execs care about, that’s what keeps them up, not whether their next hire has an mBA…there is an interesting things ahppening in the uK since university fees were raised, some major organisations are beginiing to acceptpeople with no degrees for internships and apprenticehips…I worked with siuch people and they are bright and getting recognised…/secondly, i cannot stad anly longer people who say they are doing the deree to open up doors. I really cannot stand that reason, it makes me agnry, because you are essentially saying I am going to throw money at the problem, you are not getting to the root of the organisations. and you are robbing yourself of the opportunity to devlop relationship buidling skills, that will hurt you. you can’t hide behind that. what will you do when you get the MBA and none of your doors open for you, because it happens a lot? are you going to throw more money…..need another one called what is education? and why universities and scools provide the worst education
—-what are excel jobs? Is ther such a thing and if so why should you care. Yes there are and it’s important because these roles allow you to create time and they often lead to bigger more fruitful careers
Should senior execs know excel? What level is excel good for knowing? If you are senior and you have a small team excel will help you because you don’t have to articulate thoughts in your head, you can control the model. If you have a big team, you need to ensure there are at least a few solid excel whizzes on the team, get them used to taking instruction from you. A CFO of a big org doesn’t have to play with Excel but a CFO of a small org does
What I would do differently
Talk about the philospohy of overlearning from sales page
5 days to look like an excel genius – how you wing it, tell people you’ll get back to them (double hit on controlling hteir expectations)
I often take my mentors for a coffee, so when you get the course, it’s like buying me a small cup of tea everyday for almost a year, for the guidance, strategies and skills that you get in the course, that will result in significantly increasing your salary, it really is not much
——-
A look in to my life, how I spend. Everything is average and below, I’m not money obsessed. I’m obsessed only by self improvement. Part of that is to live below your means, for one you will be satisfied easier (doberman dan youtube vid). Also, more importantly when you want to make some moves in life, you want to take some risk, if you are plagued with questions about your next bit of income then you will remain in the same place. Most importantly, when you have a cushion financially, then you have a very different psychology. It’s why I tell people NEVER ever apply for jobs when you need them, don’t dig the well when you are thirsty. apply for roles when you don’t need them, you will manouvre with an air f confidence, you will have zero desperation and frankly you will be an attractive prospect. I do this always. It makes all the difference…living below your means is a big part of that. I simply DO NOT care what anyone thinkgs of me, you don’t like me? that’s your problem, i’m getting on with things and that goes with spending your money on fast cars or wahtever toys. Your consumptuion habits will hurt you in many ways
———

Use Time saved to not add more things on our plate but to improve existing things. Mainly spend time with LoB and reduce the learning curve for them, that will contribute much more to progress on the plan overall.
10 things to say to manage your boss: be positive and keep them positive ie reporting is not needed, don’t say thank god, never take your eye off the ball and admit things are a drain on you

Personality and productivity : When the boss comes over to gie you something , follow this process: note it down, if it makes sense to you, prioritise accordingly, if not, ask boss when it should be done

Hieararchy of operating
Run the business, make the decisions to ensure the machine operates correctly
Top level strategy and decision, some top and tail from below
execute top level strategy/decisions by emplying teams to do so, some top and tail from below
lead team with one or few key focuses, some top and tail from below
execute work with one or few key focuses
Support all the way up
In order to climb you need to think at least 1 to 3 levels above you and be directly empathetic (in your work) to1 to 3 leels above. If you are at the execute work stage (which most people are), then you need to find ways to help above directly, create work > get visibility (to not usurp) etc. Getting visiblitly is very very important…but if you are obsessive about doing the low level work and living in your spreadsheets without being conecrned about what effect they have and how the help above and getting in that conversation, you won’t ever move forward
——-
All things being equal the winner is
one of the most annoying phrases we use in our lives is ‘all things being equal’. Case in point, someone was debating me recently on my stance on MBA’s and certifications and he said that phrase, all things being equal, the person with the better education will get the job. This person is a few years younger than me and has not hired before. I have been hiring team members for years and been a part of hiring senior execs too and I can tell you, never has the ‘phrase all things being equal been uttered’ because nothing is equal…and if all things are equal, it’s the person with actual skills who wins. A degree tells me some very generic information about a person such as how good they were at getting in to a university, how good they were at passing exams, these cannot be directly used in a role. The role goes to the person who can make an impact from day 1, someone who has actual real world skills, in the analystical world, Excel skills are king but why are they king
How to master Pivot Tables in under one minute
this should link to the podcasst of me talking about it
Everything you need to learn about Sparklines and other cool charts
Your walking to work, all pumped up and excited, you can hear salsa music playing in your head, you’re going to go in to work and do some cool charts, some sxy sparklines, some donuts charts…maybe you go a bit crazy and work out how to use a radar chart..wooo yeah!
*stop music*
No, I’m here to spoil your fun.
yo’re tring a little too hard and that will hurt your rep
Pivot Tables
Don’t make the tool control the way you work, you control Excel to make your work easier, let me show you how
The Vlookup
The number one problem with people whoa re nt great at Excel isn’t their lack of skill with formulas functions, its about how data is stored…(analogy of foundations)
IF you use this formula you are doing something very wrong
The Hllokup was inented by Excel as a way to give people another way to do something. They invented a function thinking they solved a problem but for professionals they created a problem, they shopuld encourage people to store their data proerly then they won’t use hlookup. But microsoft is always tryingt o add to the number of formulas because its a selling point. i am the anti, lets add stuff, learn everything guy…the most improtant book i’ve read in the last 10 yeaars is clled the paradox of choice and in it scwarz breaks down we we as individialas and collectiely are massively hurt from having too much choice. Did you notice my formulas book was attemplting to remvoe a lot of choice, I have boileddown the 27 most important formulas. Imagine what i have done in my course, I have removed so mauch nonsense and i can do that for two reasons, 1. im expereicned and 2. Common sense from mistakes
——
BBC average salary based on degree. Don#t compare yourself to the average, if you are below it it will depress you, if you are above it it wll make yyou feel comfortable in tough times. As for education, I’ll never forget the day I got my degree from university, it was the day my education started. University is one of the worst places to get education because you learn no real skills, you learn generic theory (apart from medecine)
—–
Powerpivot…The job of a company is to add lots of features to their software and make it more competitive….just because a feature is there it doesn’t mean you use it…It took me years to lean what you do need and what you don’t need if you’re an analytical professional controller etc and I teach that in the course…
The NOT learn part is so important because it quickly gets you to the doing part rather than the learning part…In life your learning is infinite and it doesn t end…In excel it absolutely ends. .that’s that she point of my book it boils things down to 27 formulas 10 of which are very imprint and 2 are super crucial
——–

The RIGHT Excel skills are like an appreciating asset, they will provide you value for years and years, even if you get to senior ranks. When you are senior you will have junior and mid level employees to do most of the Excel monkeying for you.
But, there will be many instances where you can’t delegate tasks:
1. You can’t because the information/data is too sensitive
2. It’s actually far quicker to do it yourself rathe than to explain it
3. You want to automate something, save time and use that time for your own evil purposes!
Now recall my sentence ‘if you get to senior ranks’, well, that ‘if’ becomes a ‘when’ under my guidance
It starts with getting your Excel skills in order, then when you are doing that, I will show you how to start becoming senior, command respect and of course earn salary.
But.
Let’s work on our foundation first.
Get those all important Excel skills first.
 ——-
Why Googling hurts your Excel development
Last week I got the following Voicemail from my mother
‘Sohail, come quickly, I think I have got cancer….’
What…The…
I immediately, rang my mother asking what’s going.
Well, turns out she had a few symptoms, she decided to google it and being in her late 50’s, she put two and two and got five, then she concluded that she might have cancer.
She didn’t have cancer.
She had an upset stomach, heart burn and a few things that just happened together.
Nice mum. Nice.
Three of my closest friends are doctors and they are constantly telling me that the worst thing to happen to the medical profession is of course Google.
Google of course is wonderful, but people fail to see the major fallacy of google. People end up wasting far too much time on Google, going down endless rabbit holes of information they are chasing. It ends in time that you won’t get back, that’s all it does.
When it comes to Exce, google is no different. Of course, you can google anything on the subject of Excel BUT this isa very tactical way to work. People think they are saving money by googling but they are not, it is costing them something much more than money. Its costing them time.
When you invest in a good coruse in Excel it will give you some structured learning and improe your ability increase your understanding on how best to use Excel.
I always tell my students, by all means use Excel and then your googling will be quick and efficient. It will be focused.
Now, it may shock you to learn that even the King Kong of Excel, yours trul still uses google when it comes to Excel! What?! How can this be?! Why would I teach people to learn Excel but use Google myself?
I’ll explain.
I can do everything I need to in Excel. Everything and I teach people do that too.
But.
I Sometimes, I know it will take 15-20 mins to do some VBA or write a complex formula, I will rather quickly google it and tweak it and the sum total of that is 5 mins, so I have saved myself 10-15 mins. Whcich is valuable.
I can do that because I put the time in and got the right Excel skills.
People who don’t put that initial investment and learn Excel in a structured way, will spend a lot longer and they will do so every time. Think of all those minutes wasted, those minutes over a career add up to hours, days, weeks and months.
That is a poor way of thinking. It’s a cost mindset ‘why should I pay for a course, when I can learn for free online?’ I hear from these people.
They are the same people googling month after month, year after year, not getting any better, still wasting the same amount of time, wasting the small window of opprotnity on advancing their career, earning the same salary, working at the same junior/mid level.
They are people who will drive an extra 30 mins to save £5 on grocery shopping.
They don’t value time, time is the most important commodity, it’s the only you have you won’t get back. Why would you waste it?
Why? It doesn’t make sense to me.
If that’s you, then I want you to shift your thinking immediately. Right this second damit!
Shift it to an investment mindset.
Learning the right Excel skills in a structured manner will be an appreciating asset for you, they will pay off for years and years., they will make you get things done quicker, so you have more time.
More of the most important commodity
Invest in yur skills and ge a structured approach to learning Excel.
Now the question begs, whee can I learn. Well if you are not a professional, then there are many courses to find. But if you are a professional, then NOTHING else even comes close to my course. NOTHING.
I have the confidence of saying that because I am still eliving , breathing my actual professional career, I am a senior executive in Banking and I know, what level of Excel you need and NO more.
My course is a teeny tiny bit more expensive then others out there.
Why is that?
Because, you are getting my decade+ of experience in using Excel in the biggest and best organisations.
What you are investing in is a teacher who will get you to Excel masery in 6 weeks including advanced VBA/ MNacors by leaving out things you DON’T need to know.
All other courses teach you everything because they know nothing about what it takes to be a great professional. Excel is just component of being a great professional, you should not spend too much time and over learnit.
Meet me on the inside of the course and master your Excel skills
——
The Excel operator in life
Analogy about less is more or subtraction
I’ve talked about productivity a lot. Excel is a productivity tool as categorised by Microsoft. But I’m goijng to share with you right now, the most important aspect of productivity I practice the older I get, in one word
Subtration
Subtracting things from life is the most important thing you can do.
Look at all your pririties, be absolutely brutal with whqa’ts important , rop out the one’s that are not important
Now, this is what I did with the Excel book. Excel has well over 350 formulas and I ripped out over 300 of them and said, here you , these 27 formulas are all you need 80-90% of the time.

The other 10-20% just don’t matter, they are too low priority to waste time learningthings you only need for a small fraction of your efforts.
Now my formula for productivity and success as a junior to mid level professional became this:
Subtraction + Excel skills
That got me very very far.
I haad mentors to help me subtract, then I used my advanced Excel skills to automate and save time.
So I had lots of time, then I would focus on developing myself in other ways more important to being a professional, like I learned project management, and now I am a senior project management professional in investment banking.
It doesn’t pay too badly.
My entire course uses the principle of subtraction to get you to excel mastery in 6 weeks.
I can do that because my career working many jobs taught me what to is important and what isn’t in Excel.
Register and I’m your mantor.
Why would you not register?
I’ll tell you why
Please don’t register if you are allergic to hard work, focus and a greater salary.
Those are my expectations of my students.
Btw the course is all pre-recorded but students get priority access to ask me questions about Excel or even career and I share only life changing info with them

—-
“Yes, een a super time challenged dude like me likes to chill and watch some TV a few time a week, it’s a destressor and that’s important. So, I’m making my way through show ‘Better Call Saul’ on Netflix. It’s the prequel to Breaking Bad and if you wain’t heard of Breaking Bad well…go watch it and thank me later.
The show is about Jimmy McGill, who is played to utter perfection by Bob Odenkirk. Jimmy is an ex-conman who has somehow become a lawyer and the show follows him on the twistts and turns his law career takes. Now, a cyncial person would suggest he’s there’s no difference between a lawyer and a conman anyway (It’s okay we can slag them off they don’t use Excel so they’re not one of us.
So, why am i bigging up Jimmy and this show, apart from being a masterful drama that is worth your time , Jimmy’s story has unfolded almost identical to the way mine has.Lemme break it down for ya…
Jimmy was forced out of his old town as he pee’d off too many people…I was kicked out of university
Jimmy got a job in the mail room of a law firm…i got a small low paying job as a business analyst
Jimmy worked his bee-hind off to study around his admin job and become a lawyer…i studied Excel in my spare time amongst many other skills
Jimmy’s older borther who did things by the book, constantly held him back for not….I was consistently toldy by other people, other voices to manage my expectations, don’t get oo ambitous, take risks
Jimmy used his conman skills in a positive way to take on a major corporation and help his law firm…I used my Excel skills to save my bosses millions in having to buy big powerful reporting solutions

A big part of of why Jimmy is amazing is because of the atitude he cultivated and it’s the same thing you get with me. A big part of why my students get skils and the ability to capitalise from those skills is my attitude. My attitude rubs of on you. You are the sum of the five people closest to you. Make me one of those five people and good things will happen to you. Register today, don’t wait for things to hapepn to you, register for zero to excel guru today/VBA for professionals”
“in a former life, I was a national level athlete. Now if you google it you won’t find much because that was well over 15 years ago when dinosaurs roamed the earth and the words ‘face’ and ‘book’ would never be found in the same sentence.
Anyways, I was ‘aight’ , nothing special at the national level but evenutally i stopped competing because life and work took different directions plus my event was not the sexy 100m but the very unsexy ‘shot put’, so it weren’t going to pay the bills. I needed a new plan. I got there in the end.
Anyhoo…
One thing I do to this day is train. I train heavy and hard. I lift weights, I sprint, do some easy cardio, some yoga like flexibility work and I do it often.
I am lucky that I fell in love with training, it happened at an early age, when I was 13 i began doing martial arts, running, pressups etc and seeing my body becoming stronger and fitter was an increbile experience and when I started lifting weights at 16, my development went to another level. I taught myself something very valuable. You have the pwoer to change your body, your mind, your situation. The older you get, the more negative talk whether it’s other people’s or your own bad experiences from realtionships in your life will keep you down. But having experienced so many self empowering moments in my life from becoming stronger. So many emails i get i get start with ‘should I’ or ‘do you think I shoul..’ which is fine, i get it, people want guidance, but you need to make sure you are going to do something with this. If it’s Excel skills, NOTHING empowers you better in that way then my course.”
“what does Hip Hop have to do Excel/VBA…’Why can’t you listen to nice music like the bee Gees, Rafi or Elton John’? When she could hear Hip Hop blaring from my room. Yes, friends, I am a senior Banking Professional and I listen to Hip Hop, still even as a grown up with kids. I love it as much as life itself. Now i love a lot of other stuff too, but my wife and I gree up in inner city less impoverished areas around London in the 90’s and Hip Hop was therapy for people like us. Also, I ama contrarian, i don’t care for authority or pemission and Hip Hop reflects that attitude. Instead of writing 100,000 words on why I love Hip Hop, today, i’m gonna give you a quick lyric from one of the greatest, Jay-Z. it’s a line from ‘Diamonds from Sierra Leone’, one he did with another genius Kanye West(and if you think Kanye isn’t a genius let me know and I’ll tell you why you’re beyond mistaken).
‘I’m not a businessman, I’m a business man’
I still get chills when I hear or rea those 8 words because they are so pwoerful.
What Jay is saying here is that he’s not jsut a businessman with his music, entertainment, fashion, sports management etc but those companies are extensions of him.People want to do business with Jay-Z, people trust ay-Z, if it’s got his name attached to it, it will do well.
In my career book, I wrote that every person in the corporate world needs to operate like a business, the ‘You’ business. You need to have a reputation as a go to person. 4 times in my career, I have had very senior executives create jobs for me, when they were discussing these roles in the budget planning with other senior execs, they would say ‘we need a Sohail type of person to do this’. THat’s branding my friend. Be known for something, your reputation will precede you. And let it evolve. I used to be the ‘Excel’ guy when I was younger because well, ‘i know a thing or two about Excel’ then i became the ‘Get project’s delivered guy’, now I’m the ‘leave it with me, it’s as good as done’ guy. reputation and branding gives confidence to senior decison makers, the same way Jay gives confidence to other execs who want to do business with him or cinsumers who want to buy his products. Analysts, accountatns, controllers, PMOs etc. You all need to at some point be ‘the Excel guy/girl’. speaking of music, I sound like a broken record, but register for my course at this link and get the right Excel skills from someone who knows what he’s doing.”
“How to be an expert at the hlookup formula….q from Ravikumar…’sir, can you please teach me about HLOOKUp formula?’
Sure Ravikumar, sure I can. Please get comfrtable and get your pen and notepad ready as I teach you evrything about hlookup and there’s even a bonus piece of advice today that will surely help you…
First of all, Hlookup is a stupid formula. don’t use it. if you use it or are considering using it, then you have a lot to learn. Mainly basics about manaign your data. EVERYONE wheterh analyst, accountant,, controler pmo blah blah needs to follow the same rule s when managing data…all covered in my course. Hlookup ends up in sheets which combine storing data plus givnig an output, sheets shouldn’t have a dual purpose like that, its inefficient unless its jsut a quick one off analysis or chart for some ad hoc request…
You see there are Excel skills and there are the correct ways professionals should be using Excel to make life a lot easier…both of which i cover in my course
okay how about some bonus advice Ravikumar…are you ready…pay attention…this will change your life in great ways…
Don’t call me ‘sir’, don’t start sentences off with ‘sir’. i get it it’s an indian culture respect thing. but it ain’t doing you favours when you communiate in the global world…The british empire lost it’s stranglehold over india decades ago so there’s no more evil british (i’m british btw) officers who need to be addressed with ‘sir’ anymore. When you call people ‘sir’ you put them on a pedestal, they can only look down at you. Talk to people the way you want them to talk to you. End your subservience. Now. And project confidence, you’ll get better jobs, more respect, more money and more blah blah blah
Well, that was fun and remember, my course is chock full of practical life advice like that when it comes to using Excel to become a professional baadaarse.

“I had some interesting responses after telliing off Ravikumar for ‘yes sir, no sire , 3 bags full of formulas sir. The most interesting one came from a nigerian lady, called Funmi. I love Nigerians btw, i grew up with lots of them in London, they combine being respectful, hard working and badasses as well as they do, they take investing in themselves v.seriosuly, i know, many of my students are Nigerians…Anyways, Funmi asked me this ‘Are you real? You say you’re an Executive but you use strange words, some colourful language (I don’t care for bad laungauge), is this how you talk at work?….I laughed for many microseconds and wrote back, here’s my response to Funmi.
Funmi, you may baulk and ‘not care’ for some of my language and writing style but nknow this, I’m a senior exec in banking, this is how i talk, in meetings. I’m a fun dude, opiniated but fun, this is how i talk and other execs love being in meetings with me because i lighten the atmosphere and keep thigns from getting boring. Now here’s the big but…i am never disruptive, i don’t make a joke for the sake of being funny, I never take the meeting away from the agenda UNLESS it gets heated in which case if i feel the need to diffuse, i will diffuse. Do some Maths for me Funmeee…We spend 8-10 hours a day at work, that’s a huuuge chunk of your time and your life and that of othe people, you need to make it bearable, for you and for others. Try it, people want to be around you, execs want to be around you. Now go and register for my course if your Excel abilities are less than stellar because pleasant to be around + good value adding skills like Excel will get you very very very far…and then have some Fun on me, Funmi.
P.S. on Funmis q on whether I’m a real person..yes I am very real, if my linkedin profile ain’t good enough for you then if you’re in canary wharf in Londond, i’ll buy you a cofee!
ZTEG”

————-

29/7
How to Automate a Profit and Loss Statement—
Talk about all the autoamations…
You are 6 weeks aware from this..
Automate:
the production of a monthly P & L report
a milestone chart
a gannt chart in powerpoint
a resource management tool

Even if youa re at the beginner level..in 6 weeks your skill,s if you put the commitment to spend 3 to 5 hours a week, follow all of my material intently then you are a mere 6 weeks away from absolutely transforming your self.

What my students get is more than skills, it’s compelte confidence of knowing they have the skills, knowing they are more productive

—–

How to use Excel to crush a job interview

Over the last few days, there has been a very specific running theme on a reason for improving Excel.

Having previously talked about the #1 reason to learn Excel (speed up your work by automating), I’m firmly on the #2, to develop possibly the most marketable skill an Analyst, Accountant, Controller, PMO etc can have.

These are the two reasons to learn Excel, believe me when I tell you that EVERY other reason is not compelling enough…it really isn’t!

But I want to learn Pivots, V-Lookups, Autofiltering, Macros….blah, blah, blah! Knowing those things are a bi-product of learning Excel…correctly.

They shouldn’t be your focus.

So now that I have told you this, you can just go away and learn Excel, right? Get a book? Get a cheapie course online somewhere? Go on a two day course taught by someone who hasn’t had much recent experience in the real world?

Go for it…but, I don’t recommend it.

In fact, scrap that!…Don’t go for it!

I’m going in mentor mode and like yo’ mamma did when you walked in to the house with dirty shoes, I’m gonna put my foot down. Don’t go for it!

Give yourself the best chance in your career. There’s a really easy way to do that…

Surround yourself with the RIGHT people, people like yours truly.

My entire course is focused on getting you to master the #1 and #2 reasons learn Excel.

I don’t ask you what you wish to learn. I have broken down everything I have learned in 10+ years working not in the same old company, but 9 companies as an independent consultant. And 9 big global corporations (Feel free to check out my LinkedIn profile).

When you work in numerous Analytical/Financial/Project based roles in nine companies, you learn a thing or two about what works and what twerks!

Recently, I had

Hotline Bling twerking plus Excel skills will land you a Drake-like job

Hotline Bling has been one of the biggest videos of this year, there’s something in it for everyone. Partly those amazing synth beats, the beautifully shot video, partly the mega charismatic talents of Drake and partly, ahem, ladies who twerk, if you like that sort of thing, as a married man, I possibly couldn’t comment 😉

A few people would find this kind of video abhorrent, but let’s see why

Don’t mess with time tested realities and truths.

People are visual, in a competitive world, you need to capture attention.

If you are an Analyst, Controller, PMO, Accountant etc and you rock up to an interview and do ‘the usual stuff’ that everyone else does, you will fit nicely in with the rest of the candidates interviewing.

DON’T FIT IN!

Don’t ever fit in.

I teach all my students to STAND OUT.

Yes there are a lot of things you need to get right in an interview (all of which I cover in my Selling You course) but one surefire way of standing out is to demonstrate a piece of
This is all about how we are visual creatures, the more visual, the more compelling.
When you rock up to an interview and show an impressive piece of Automation, it’s like watching Beyonce Twerk, the hiring manager won’t be able to take his or her eyes off.

Whether or not you like Beyonce and Twerking (don’t tell me you don’t!)

Use your Excel skills to go viral and get a job

I teach people two major topics: How to sell themselves and How to get great Excel Skills

The intersection of that


Use this principle of wealth building to your excel/career??

Cool story about asset (ramit used Seinfeld, maybe I can talk about friends or summit – syndication)

I’ve talked over the last few days about strategic vs tactical and why it’s a game cahngers
You need to leverage your time.
Leverage is what seperates an Asset from …
**Email about how good automation is an asset
Good automation is an asset, it can be tweaked and re-used
In 2011, I built a monster piece of automation , which collated lots of data from over 250 areas in the bank I worked in, collated it and did an analysis.
That piece of Automation, I used again and again on subsequent projects (albeit scaled down)
That paiece of automation, I used to demonstrate at two interviews over the next two years and landed me very lucrative contract work.
That is the definition of an asset, I built something and have used it again and again

Think long and hard when you spend time on an activity, think about future proofing work.

A big part of why I avoid Pivot Tables is they require more maintenance than setting up a bunch of formulas. A lesson I learned from years and years of using Excel on major projects.

As I am carrying out some work, whether building a report, a template, writing a project plan, writing a CV or whatever, I am constantly thinking, what can I do to this to prevent this from being a one off piece of work.

Because, the time I am spending on doing the work, I will never get back.

So make it count.

Are you crazy? – Ryan Levesque email
About parting with Money to invest in a course

Why I refuse give corporate discounts for my Excel course

I do it for the people.
Corps are psycopaths.
If you’re thinking why on earth am I telling you to work ina corp if I am anti corp

As per BenS/Mergers Inq
Takeaway close.
Why you shouldn’t sign up – closing email
Please don’t sign up for the course!
I’m about to close up and and I wanted to explain why it might not be a good idea for you to sign up for the course…
*…build up a transformation, make them visualise it*
One of my students Ahmed Karim recently got a £13K uplift in salary on the back of doing my courses. Another Student Isabel landed a big contract at a major bank. These are just a few examples.
What they did was to apply themselves consistently
consistency

The single most important psychological breakthrough of my life

Thought I’d start your day with a little bit of life hcanging psychology

I spoke to a guy who was upset that he tripped up and looked like a bit of a fool at a party.

Here’s what I told him

You have been enslaved by the thought of what that woman thinks about you. Guess what, in 2 minutes she will be gone for your life,never to return but your assumption on what she thought of you will remain with you for days, maybe weeks.

Do this for me…don’t care about it, she’s gone, it means nothing know.

Now do this exercise, imagine if she didn’t go and you had to see her everyday

You are a salve to the idea that this person may or may not have laughed at you.

Are you going to remain a slave when a simple choice not care would emancipate you.

So why am I talking about all this.

Many people, live their lives because they don’t want others to think ‘badly of them’,
“it will reflect badly on me”
People don’t want to break social contracts.
The thing about social contracts is that they should all be broken and they all have been, they.

Do me afavour: The next time you are faced with a decision, no matter how small and you are reasoning your way to a decision . If your decision is impacted because of what so and so may think, do it, don’t care.

These are blockers.

Last week, I decided to treat myself to a haircut and a shave from a very ‘classy’place.
As I was getting this done, a young guy, very brash walked in and was loudly talking to the salesgirl who was trying to sell her perfumes, he was showing interest and then asked, so if I get this ‘what else are you going to give me for free?’ In the UK, it’s considered not very classy to do that,especially loudly. I could sense the atmosphere in the shop, people were rolling their eyes and judgint his young man for his attitude, but he was a lovely nice guy, he just broke a social contract.
You know what, he walked out of the shop with a product and lots or free things, not a care in the world. The people who juded him, continued to limit their lives by choices, he was free from all that. Free to win.

The irony of big decisions: where will I live, what car will I buy, who will I marry?
Those are not important decisions.
Not even close.

The biggest decions in your life go like this:
Shall I hit the gym?
Shall Iahve 1 or 2 sugars in my latte?
I can sleep a little less, I’ll make up for it with a coffee
Shall I do this tomorrow becaue it’s not that important
I’ve got 10 mins, shall I get my head around the SUMIF formula or shall I check pinterest
This girl on twitter si annoying me, I’m going to spend 10 mins writng some tweets to make her look silly..or I’ll read to my kids

Those decisions are habit forming ones.

You are your habits.

I have some really good habits, that have helped me to progress tremendously in my career and my life

But, sadly, Ihave some really bad habits that have impacted my life negatively, I have developed some health problems from overworking, I have been on the verge of splitting from seh

All those good habits, and bad habits came from small decisions, I took on a daily, hourly and minute by minute basis.

—–21dec emails
Subject: Why most planning is dangerous

Planning is dangerous, futile and a waste.

Bear in mind, I’m a senior project manager and I get paid to plan and manage multi million pound projects in huge projects.

But those are organisational projects, with budgets and lots of people involved so you need to co-ordinate and plan.

But, by yourself? Career planning? That’s crazy.
Don’t get me wrong, you need a general direction and that direction should be upwards: More salary and a better position.

The biggest problem with palnning (your career) are these

The types of professionals I deal with Analysts, Accountants, Controllers,

I have found the less I ‘plan’ in my personal career, the more I progress.
Be a man/woman with no plan. Instead have rules, let me share some of the rules that made me progress

Rule#1
When you walk in to a meeting, people should look to you for direction
Take ownership of high visibility work that will benefit senior people
Command authority

The broken psychology of Excel professionals

You know, I have a lot of experience of working with Analysts, Accountants, Controllers, Project Managers, Management Consultants etc.

During my 12 year career, I’ve either worked directly in those roles; I’ve worked with those professionals and have managed them too.

Now, I hate to paint every one with the same brush but there is a commonality with all these professionals, who happen to work with Excel. None of them are revenue generators i.e. their roles don’t involve making money, but an element of their roles involves saving money, finding efficiencies, doing things more effectively.

That trait makes such professionals very analytical (especially the analysts, duh!). In case you don’t know, I am a recovering analyst. Analysts look to find the right answers; they will spend a long time doing so. The problem with spending too much time finding the right answers is that you are not spending time executing.

I coined something called the Analysing – Mobilising spectrum. You are somewhere between analysing (thinking about doing something) and actually doing it. Which do you think gets results?

Mobilising, 100% of the time.

“But Sohail, that’s all well and good but how do I know what to do without thinking about it?”

First of all, place the book ‘Blink’ by Malcolm Gladwell in your reading list. Gladwell skilfully makes the case that decisions based on limited information are mostly as good as or better than carefully considered and researched decisions.

Even better is to reach out to someone more qualified than you to ask for advice, a mentor figure if you will.

Here’s a rule that I ABSOLUTELY live by, any time you are overcome with a feeling that you need to delay or deliberate a decision make a call there or then. Either do it or eliminate it and never think about it again.

Shades of grey are bad (unless they’re the 50 kind *creepy wink*)

Your ability to quickly boil things down to a yes or no will do wonders for your personal and professional life.

peers

This concept is something I teach early on to professionals I mentor and it still gets met with fear….”Bu what if I make the wrong decision”

The worst decision is the one that doesn’t get made

Now, that’s the kind of rationale that helped me to master Excel, progress professionally far beyond my peers and build a bullet proof career. It’s also why the way I teach Excel and the particular subjects I teach are THE BEST for professionals.

Subject: Why I am a low class Excel jrk

, you brag about your salary you keep saying you are the best Excel teacher, you are quite arrogant, you have no class – Spencer

Spencer, you nearly hurt my feelings but lucky for me I don’t have a heart (something you left off your list). Let me address your troll concerns

Point#1 I don’t brag about salary, I never have. I talk about salary as a means to qualify myself as a suitable person to teach professionals. I earn close to £200K and that is a bi-product of me taking the right kind of action in my career, learning the right skills like Excel. If you are going to give up your time, it should be to someone who has achieved considerable success so you can get similar results.

Point#2 Let’s get one thing straight my claim is that my way of teaching is best for professionals who use Excel, if you are a not an analyst, accountant, controller PMO, management consultant etc. I would rather you don’t look at my material. I have learned in my 10+ years of using Excel what works and MORE IMPORTANTLY what is a waste of time. I have learned how to use Excel to get job interviews, how to make Excel get you a job offer, how to make Excel open career doors for you. This goes far beyond teaching Pivot Tables and Pretty Charts.

The title of best Excel teacher was given to me by my first batch of students who were getting promotions and salary raises, like Ahmed who got a £13K uplift, like Isabel who got a near £100K contract, like Mike who got £17.5K more as a senior controller. There are countless more examples.

Other Excel teachers give you options. I don’t do that. I didn’t work 100 hour weeks, been in high pressure situations where I almost got fired, got high blood pressure, argued with C-Level executives, fought my way from working class to a £200K salary only to give people options.

Options are for the weak, for the safe and for the politically correct when I teach professionals, whether Excel or give career advice, I am experienced and qualified enough to get straight to the point of works. So Spencer, before I delete you from my list, I want you to know that is the difference between low class arrogance and being highly qualified

Unlike my buddy Spencer, join me in the course