How to sort left to right in Excel (quick tip)
Imagine you are in a life sustaining planet named Pearth, in another galaxy. One day you got to work, fired up Excel (hey, what else would you use? Excel is the best data software in any galaxy 🙂 ) and started working.
You came across a dataset that need sorting, but left to right – horizontally.
Now what? Do you turn your monitor sideways?
VLOOKUP multiple matches – trick
We all know that VLOOKUP can find first match and return the results. But what if you want all the matches? Use this simple trick instead.
Top 10 Excel Formulas for any situation
Excel has hundreds of formulas. But as a new learner or user, you may want to just focus on top 10 formulas to get the most out of it. Assuming you already know the basics (check out Beginner Excel page if you are complete newbie), here is a list of top 10 Excel formulas for you.
Quickly Change Formulas Using Find / Replace
So you have built that excel report your boss wanted. And you were all eager to use the spreadsheet in your presentation. But in the last minute, your boss asked you to change average sales to total sales figures. You also want to grab an espresso before rushing to the meeting. Now what?
Lenient lookup [Advanced Formula Trick]
We all know VLOOKUP (or INDEX+MATCH) as an indispensable tool in our Excel toolbox. But what if you want the lookups to be a little gentler, nicer and relaxed?
Let’s say you want to lookup the amount $330.50 against a list of payments. There is no exact match, but if we look 50 cents in either direction, then we can find a match. Here is a demo of what I mean.
Unfortunately, you can’t convince VLOOKUP to act nice.
Hey VLOOKUP, I know you are awesome and all, but can you cut me some slack here?
VLOOKUP is tough, reliable and has a cold heart. Or is it?
In this post, let’s learn how to do lenient lookups.
Announcing Excel School v2.0 – Quick intro and details inside
Do you want to learn Advanced Excel, data analysis, creative charting, dashboard reporting and be productive in Excel? Then you are going to love my Excel School v2.0.
This is the golden age of data. Any rewarding job or entrepreneurship requires good data literacy. We are all expected to understand the relevance of data, how to manage it, how to analyze it, visualize it and tell elegant stories.
This is where Excel School comes in.
12 Steps to learn Excel and become awesome @ work in 2018
Obviously, everywhere you look this week, you find advice on how to do better this year.
Well, you don’t have to wait for a new year to become awesome at your work, any day is new year for the rest of your life.
So, today I want to share 12 steps to learn Excel and becoming awesome. But first I have a secret to confess…,
I think becoming awesome in Excel useless.
What we really want is, to become awesome in our work. Since we spend a lot of time using Excel (and other office software), knowing how to use these better can have a huge impact on how we do our work.
In that spirit, lets look at 12 steps to learn Excel so you become awesome in your work.