Automatically Format Numbers in Thousands, Millions, Billions in Excel [2 Techniques]
Ever wanted to automatically format values in thousands, millions or billions in Excel? In this article, let me show you two powerful techniques to do just that.
CP031: Invisibility Tricks – How to make things disappear in Excel?
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
In the 31st session of Chandoo.org podcast, let’s disappear.
What is in this session?
Spreadsheets are complex things. They have outputs, calculation tabs, inputs, VBA code, from controls, charts, pivot tables and occasional picture of hello kitty. But when it comes to making a workbook production ready, you may want to hide away few things so it looks tidy.
That is our topic for this podcast session.
In this podcast, you will learn
- Quick announcements first anniversary of our podcast etc.
- Hiding cells, rows, columns & sheets
- Hiding chart data points
- On/off effect with form controls, conditional formatting
- Making objects, charts, pictures disappear
- Disabling grid-lines, formula bar & headings
- Hiding things in print
Convert fractional Excel time to hours & minutes [Quick tip]
Time for another quick Excel tip.
Lets say the park near your house rents tennis courts by hour. And they charge $10 per hour. At the end of an intense tennis playing week, Linda, the tennis court manager called you up and said you need to pay $78 as rent for that week.
How many hours did you play?
Of course 78/10 = 7.8 hours.
But we all know that 7.8 hours makes no sense.
We also know that 7.8 hours is really 7 hours 48 minutes.
So how to convert 7.8 hrs to 7:48 ?
There are Easter Eggs in this Excel file!!!
Hello Friends…,
It is Easter time again. Every year, we at Chandoo.org celebrate Easter by hunting for eggs (not in the wild, just in the Excel workbooks). This year too I have hidden 30 Excel tips in a workbook. You have to solve 3 puzzles to find them. So what are you waiting for. Go ahead and hunt for them eggs.
Click here to download the Easter eggs file.
I am sure you will enjoy them 🙂
Multiplying 24ft 9inches with 6ft 3inches using Excel
Imagine you are a carpenter and you are tasked with laying wooden floor at Gill Bates’ house. Now Gill B has a very big house and he wants to make sure you do a good job. So instead of asking you to lay the floor for entire house, he asks you to finish flooring in the guest bedroom first. Here are the dimensions of that guest bedroom.
- Width: 6ft 3inches
- Length: 24ft 9inches
- Size of individual wooden floor board: 2ft x 4inches
And here is the big question you are facing.
What?!? the guest bedroom width is only 6ft 3inches?
But over the years of chiseling and polishing you have learned to keep quiet and do your work.
So the real question you have is, How many wooden floor boards should you buy?
Of course, you want to find the answer using Excel. Why else would a carpenter read this blog?
Quick and easy Gantt chart using Excel [templates]
Gantt charts are a very popular way to visually depict project plans. Today, let us learn how to use Excel to make quick & easy Project Plan Gantt Chart.
This is what we will be creating.
Combine pie and xy scatter charts – World Polls chart revisited
Few days ago, we learned how to create a pie+donut combination chart to visualize polls around the world in 2014. It generated quite a bit of interesting discussion (47 comments so far). One of the comments was from Roberto, who along with Kris & Gábor runs The FrankensTeam an online library of advanced Excel tricks, charts and other mind-boggling spreadsheet wizardry.
I really liked Roberto’s comments on the original post and a charting solution he presented. So I asked him if he can do a guest post explaining the technique to our audience. He obliged and here we go.
Over to FrankensTeam.