A quick Excel tip for you while on a long bike trip…,
Hi friends,
I have a surprise for you. Between the late night world-cup matches & my reinvigorated thirst for biking, I have difficulty finding time to write a long & detailed article for you. So I thought why not say hello to you and share an Excel tip while I am on a biking trip.
Go ahead and check it out. Its just 4 minutes.
Watch it below or on our YouTube channel.
You can move formula help box with your mouse!!! [quick tip]
One of the most useful features of Excel is formula help box. You know the little yellow box that appears as soon as you start typing a formula in a cell. I use this all the time to understand what the syntax of a particular function is, what parameters to pass etc.
Although I love it, sometimes it does get in the way when writing formulas. Because the help box sits on top of my data, often I find it hard to know which cell to link to.
Solution?!?
Simple. Use your mouse to move away the help box wherever you want.
How to select a random sample from all your data [trick]
The other day, I got a text message (SMS) from one of our readers. It read,
So today, let us learn a very easy trick to select random sample from your data.
Right-click from the keyboard, not the mouse.
Well here’s something I never knew until today…I was watching one of Mike ExcelIsFun Girvin’s great YouTube videos from his great Slaying Excel Dragons series – the one on Excel 2010 Keyboard Shortcuts – when he showed how to do the equivalent of a mouse right click using a key on the keyboard that I’d […]
Quickly combine text in multiple cells using this trick! [Formulas]
Ever wondered how to go from a bunch of cells with text to one big combined text? Like shown above.
Well, there is a simple trick. One of our readers, Grant shared this with us. Read on to learn this.
Countif – Quick Tip
Learn how to Count Text, Blanks and Non-Blank cells with this Countif() Quick Tip
How to find what is in the hidden cells? [quick tip]
You have been there. You are looking at a complex workbook with some hidden rows /columns. You want to know what is in that hidden cells. Alas, the worksheet is protected.
It is like the special coffee machine on top floor reserved for senior executives. You know it is there, but you cannot get to it. Now what?!?
Simple. Follow this process.
(I am talking about hidden cells, not the coffee machine.)