Archive for April, 2016

Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition

Published on Apr 28, 2016 in Excel Howtos, hacks, Huis, ideas, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Excel Ninja Edition

Excel Tips, Tricks, Cheats & Hacks – Chandoo.org Excel Ninja Edition
Learn some of the Chandoo.org Excel Ninja’s favorite Excel Tips, Tricks, Cheats & Hacks

Continue »

Earth Venus cosmic dance – Animated chart in Excel

Published on Apr 25, 2016 in Charts and Graphs, VBA Macros
Earth Venus cosmic dance – Animated chart in Excel

Recently I saw an interesting Earth Venus cosmic dance video on Facebook. See the original video below or here.

Although this is not entirely accurate from physics & astronomy perspectives, the dance is a stunning example of patterns that are generated by simple things.

I wanted to recreate this cosmic dance in Excel. How else am I to get my spreadsheet fix on a Saturday?

Here is a quick demo of the final outcome. Read on to learn more about the Earth Venus cosmic dance.

Continue »

Sumerian Voter Problem [IF formula homework]

Published on Apr 22, 2016 in Excel Challenges

Here is a simple IF formula challenge for you. Go ahead and post your answers in the comments section. Can this person vote in Sumeria? Imagine you are the chief election officer in the great country of Sumeria. You have introduced a new eligibility criteria for voters just before the grand presidential elections of 2016. In order […]

Continue »

Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

Published on Apr 21, 2016 in Excel Howtos, hacks, Huis, ideas, Learn Excel, Posts by Hui, Quick Tip
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

Learn some of the Microsoft Excel MVP’s favorite Excel Tips, Tricks, Cheats & Hacks in this post
Excel Tips, Tricks, Cheats & Hacks – Microsoft MVP Edition

Continue »

Figure out slot from given time [quick tip]

Published on Apr 19, 2016 in Excel Howtos, Quick Tip
Figure out slot from given time [quick tip]

Here is an interesting scenario.

Let’s say you are looking at a time, like 9:42 AM and want to know which 15 minute slot it fits into. The answer is 9:30 – 9:45. But how would you get this answer thru Excel formulas?

Continue »

Advanced Interactive Charts using Excel [Master Class]

As announced earlier, here is the first one of our Master Classes. In this one, you will learn how to create advanced interactive charts in Excel by blending pivot tables, slicers, timelines, VBA, conditional formatting and charts. The final outcome is BEAUTIFUL!!! Monthly Master Class – Episode 1 – Trailer Check out a quick trailer of the […]

Continue »

Introducing Chandoo.org Monthly Master Class

Published on Apr 11, 2016 in Training Programs
Introducing Chandoo.org Monthly Master Class

Hi folks,

I have an exciting announcement for you. Starting this month, I will be running a monthly master class on advanced Excel. This is a video class to help advanced users learn creative, powerful ways to use Excel in their day to day work.

What is this Master Class?

The idea is simple. Every month, I will create a lengthy video discussing one of the below topics, specifically targeted at advanced Excel users. As our blog grew, we have a lot of experienced, advanced users and I want to help you achieve more. You will learn,

  • Dashboards
  • Data Analytics
  • Visualizations
  • VBA / Macros
  • Business Modeling
  • Business Intelligence

Each class will be on an different topic with in-depth coverage, creative outputs and awesome techniques. You can sign up for the class that suits your needs.

Continue »

Tell all versions of truth [Dashboard Best Practice]

Here is a simple but effective rule for your next dashboard. Tell all versions of truth. All versions? But there is only one version no? Of course, there is only one version of truth (or data), but you can present that in different ways, thus creating different perspectives, offering different insights. By using an interactive element (slicers […]

Continue »