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.
I am sure you will enjoy themContinue »
In the 5th session of Chandoo.org podcast, we are going to demystify form controls.
I am very happy and excited to interview my good friend, fellow Excel MVP, author, blogger and virtual mentor – Debra Dalgleish about this topic.
In this podcast, you will learn,
- What are form controls
- When you would use them?
- Example form control – Combo box
- How form controls differ from active-x controls
- How to enable form controls in your Excel?
- Various important form controls
- Special bonus & how to obtain it
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?Continue »
Recently Microsoft has launched Excel app for iPad. Being an Excel addict, I could hardly wait to test it. And this is what we get.
Excel App for iPad – What is it?
Several years after iPad launch, Microsoft finally created apps for Word, Power Point, One Note & Excel. The Excel app is a miniature version of Excel on your iPad. It is capable of displaying almost all Excel workbooks with ease. You can even create your own workbooks using the app.Continue »
Time for another dashboard contest. Sit straight, set aside your appointments and get number-crunching.
Analyze state to state migration data between 2012 & 2010 and present your results in a dashboard (or charts) and you could walk away with glory, fame & and an iPad.
If all of this sounds tempting, read on.
- Download dataset for the contest [mirror]
- Analyze the data and create a dashboard or set of charts (see rules below)
- Submit your workbook by 20th of April (Sunday), 2014.
- If readers at chandoo.org and our panel of judges love your work, you get one of the cool prizes.
Today we take a look at an exercise in how to develop a simple Calendar selection tool for your worksheets without using complex VBA Calendar Controls.Continue »
In the 4th session of Chandoo.org podcast, lets talk about Pie charts.
Pie charts evoke strong opinions among analysts & managers. Some people love them and can’t have enough of them in reports. Others despise them and go to any lengths to avoid them. And that is why we are going to talk about them in this session.
You will learn,
- Special, secret transmission from guest stars
- What is a pie chart?
- Why they work? 2 reasons
- Why they don’t work ? 4 reasons
- Cousins & siblings of Pie charts
- Donut charts
- Gauge charts (speedometer)
- 3D pies
- Area charts
- Bubble charts
- 4 Situations when making a pie chart is ok
- Alternatives to Pie charts
- Mistakes you should avoid
- About the resources