CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects

Backlinkseller

CP006: How to be a better analyst? – Road map for getting better at Data Analysis & Improving your career prospects
Zum Original Blog Chandoo.org

In the 6th session of Chandoo.org podcast, we focus on making you a better analyst.

How to become a better analyst - Learn the road map to become better at data analysis and improving your career prospects - Chandoo.org podcast - Session 006

Before we proceed in to the session, let me remind you:

Subscribe to Chandoo.org Podcast

Do you know that you can subscribe and receive latest episodes of our podcast right to your ears? Use one of the below links to get started.

Modeling tiles in a room using Excel Conditional Formatting

Backlinkseller

Modeling tiles in a room using Excel Conditional Formatting
Zum Original Blog Chandoo.org

Last week we learned how to answer questions like, “How many tiles in a room?” using Excel. We learned about CONVERT function and fraction number format settings in Excel.

But why stop at calculation? We can even model a room full of tiles, thanks to Excel’s grid nature.

So today, we will learn how to create a room layout like this using Excel:

Demo of Tiles in a room Excel model

If you like the demo, read on to learn.

Step 1: Set up input cells

Inputs for room & tiles model in ExcelTo model tiles in a room, we need 4 inputs. Lets call them by below names.

  • room.length
  • room.width
  • tile.length
  • tile.width

Step 2: Calculate number of tiles required

The basic formula for calculating total tiles required is this:

=ROUNDUP((room.length*room.width)/(tile.length*tile.width), 0)

There are Easter Eggs in this Excel file!!!

Backlinkseller

There are Easter Eggs in this Excel file!!!
Zum Original Blog Chandoo.org

Hello Friends…,

Happy Easter 2012

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 :)

If you are in mood for more adventure, hunt for the Easter eggs from past  2013, 2012, 2011, 2010 & 2009.

And yeah, its not too late to discover the Hidden Angry Formulas game in Excel (2007 and above)

Easter Egg photo from tillwe.

Zum Original Blog
Autor: Chandoo

CP005: Introduction to Form Controls – an interview with Debra Dalgleish

Backlinkseller

CP005: Introduction to Form Controls – an interview with Debra Dalgleish
Zum Original Blog Chandoo.org

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.

CP005: Introduction to Form controls - an interview with Debra Dalgleish

Before we proceed in to the session, let me remind you:

Get new episodes automatically!

That is right. Chandoo.org uses latest & most magical software. That means, whenever a podcast goes live, an army of magical fairies carry the sound-waves and bring them right to your mobile phone or tablet. And all you have to do is subscribe.

Multiplying 24ft 9inches with 6ft 3inches using Excel


Multiplying 24ft 9inches with 6ft 3inches using Excel
Zum Original Blog Chandoo.org

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?

Excel for iPad – Demo & Introduction [video]

Excel for iPad – Demo & Introduction
Zum Original Blog Chandoo.org

Recently Microsoft has launched Excel app for iPad. Being an Excel addict, I could hardly wait to test it. And here is the result.

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.

Excel for iPad - Demo & Introduction to it

What do you need to use it?

  1. An iPad (duh!)
  2. Free Microsoft Excel for iPad app
  3. Optional Microsoft Office 365 subscription (if you want to create or edit files)

Introduction & Demo of Excel for iPad

To help you understand how the Excel for iPad app works and what it can do, I created a short video. Watch it below

Visualize state to state migration data and you could win an iPad or Galaxy Tab [Datavis Contest 2014]

Visualize state to state migration data and you could win an iPad or Galaxy Tab [Datavis Contest 2014]
Zum Original Blog Chandoo.org

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.

State to State migration contest - Prizes

If all of this sounds tempting, read on.

The contest

  1. Download dataset for the contest [mirror]
  2. Analyze the data and create a dashboard or set of charts (see rules below)
  3. Submit your workbook by 20th of April (Friday), 2014.
  4. If readers at chandoo.org and our panel of judges love your work, you get one of the cool prizes.

Hui’s Calendar Tool (as Borrowed from Chandoo)

Hui’s Calendar Tool (as Borrowed from Chandoo)
Zum Original Blog Chandoo.org

In January a friend asked me to assist with a small Excel assignment.

Her company wanted to add a Calendar control to a worksheet so that people could interactively select a date. I have never understood why people like this as nothing is quicker than typing a date as 7/4/14 and letting excel sort it out. But hey, that’s what the client wants.

The issue was that it had to work in every version of Excel from Excel 2002/XP to Excel 2013.

As anybody who has used the Calendar controls in Excel VBA Knows, they rarely work between versions and often require VBA references to be added/changed and DLL’s downloaded to make them work.

This model had to be able to be opened across all the Excel versions from Excel 2002/XP to Excel 13 and even transferred from one version to another regularly.

Hui’s Calendar Tool

Hui’s Calendar Tool
Zum Original Blog Chandoo.org

In January a friend asked me to assist with a small Excel assignment.

The company wanted to add a Calendar control to a worksheet so that people could interactively select a date. I have never understood why people like this as nothing is quicker than typing a date as 3/4/14 and letting excel sort it out. But hey, that’s what the client wants.

The issue was that it had to work in every version of Excel from Excel 2002/XP to Excel 2013.

As anybody who has used the Calendar controls in Excel VBA Knows, they rarely work between versions and often require VBA references to be added/changed and DLL’s downloaded to make them work.

This model had to be able to be opened across all the Excel versions from Excel 2002/XP to Excel 13 and even transferred from one version to another regularly.

CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them

CP004: Can I Pie Chart in Public? Discussion about Pie charts, their merits and drawbacks, when to use & when to avoid them
Zum Original Blog Chandoo.org

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.

CP004: Can I Pie Chart in public? - Discussion about merits & drawbacks of Pie charts, whether you should use them or avoid.

Before we proceed in to the session, let me remind you:

Get new episodes automatically!

That is right. Chandoo.org uses latest & most magical software. That means, whenever I push the publish button, an army of unicorns & fairies carry the sound-waves and bring them right to your mobile phone or tablet. And all you have to do is subscribe.