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


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]

Backlinkseller

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.

VBA Serenity

VBA Serenity
Zum Original Blog Chandoo.org

Greetings and salutations, my fellow VBA-fearin’ congregation. Evangelizin’ Jeff here, spreading the good word about everlastin’ VBA serenity. You may remember me from mah preeeevious sermons such as Tables, PivotTables, and Macros: music to your ears and Big trouble in little spreadsheet. Well today, I’m going to praise the work of a high-yah pow-wah.

Jon Peltier monkOur most pious Brother Jon Peltier (who’s fine presence is to mah left) broke his vow of silence over at the PeltierTech monastery to make a most inspirin’ observation during his recent confession Highlight a Specific Data Label in an Excel Chart:

Because I’ve been doing a lot of coding lately, my first thought was an approach using VBA. Then of course I came to my senses, and worked out a non-programmatic approach.

If possible, it’s usually advantageous not to rely on VBA for such tasks.

Tables, PivotTables, and Macros: music to your ears

Tables, PivotTables, and Macros: music to your ears
Zum Original Blog Chandoo.org

Howdy folks. Jeff Weir here again. You may remember me from posts such as What would James Bond have in his Personal Macro Workbook and my now infamous music review. Today – and this truly will be music to some ears – we’re going to concentrate more on the former and less on the latter.

Today we’re going to talk about that mystical place where hard tasks just disappear into thin air. Where is that place, I hear you ask? (I have supernatural powers). In that famed triangle of folk-law, of course:
Chandoo_Tables, PivotTables, and Macros_Bermuda

No, not that one. Stop jumping to conclusions and pay attention, will you! This one:

Chandoo_Tables, PivotTables, and Macros_triangle

CP003: Business Intelligence for Masses – Interview with Mike Alexander

CP003: Business Intelligence for Masses – Interview with Mike Alexander
Zum Original Blog Chandoo.org

In the third session of Chandoo.org podcast, we are going to get BI curious. ;)

Not that kind you silly, We are talking about Business Intelligence, Big Data, Power Pivot & other Power BI family members.

CP003: Business Intelligence (BI) for masses - Interview with Mike Alexander - Chandoo.org Podcast

First some good news: We hit #1 on iTunes in our category

That is right. Around 14th of March, we hit #1 in our category of podcasts. Yay!!!

Chandoo.org Podcast - become awesome in analysis, charting, dashboards & VBA is at #1 position on iTunes

Please take a minute to subscribe to our podcast: