# Last 50 Posts on Chandoo.org

Posted on September 30th, 2016

## Check if a range has all numbers from 1 to n [Homework]

Posted on September 28th, 2016

## Mapping Spread of Obesity [Chart Critique and Alternatives]

[Read this] Charts and Graphs > Cool Infographics & Data Visualizations { 6 comments }
Posted on September 20th, 2016

## Visualizing target vs. actual progress – Biker on a hill chart

[Read this] Charts and Graphs > Cool Infographics & Data Visualizations { 26 comments }
Posted on September 15th, 2016

## Stacked Bar/Column Chart with Indicator Arrows – Advanced

[Read this] Charts and Graphs > Excel Howtos > Huis > Posts by Hui { 11 comments }
Posted on September 14th, 2016

## Formula Forensics No. 041 – Convert a Roman Numeral to a Number

[Read this] Excel Howtos > Formula Forensics > Huis > Posts by Hui { 6 comments }
Posted on September 12th, 2016

## Stacked Bar and Indicator Arrow Chart – Tutorial

[Read this] Charts and Graphs > Excel Howtos > Huis > Posts by Hui { 20 comments }
Posted on September 7th, 2016

## Announcing 50 ways to analyze data course to make you an awesome analyst – We are open

Posted on September 5th, 2016

## 18 ways to turn analysis projects into a nightmare

Posted on September 1st, 2016

## Hourly Goals Chart with Conditional Formatting

[Read this] Charts and Graphs > Excel Howtos > Huis > Posts by Hui { 11 comments }
Posted on August 30th, 2016

## Visualizing Financial Metrics – 30 Alternatives

Posted on August 26th, 2016

## PSA: Don’t let auto correct spoil your party

Posted on August 24th, 2016

## Analyzing 300,000 calls for help [case study]

[Read this] Analytics > Learn Excel > Pivot Tables & Charts > Power Pivot { 6 comments }
Posted on August 10th, 2016

## Excel Links – Getting used to life in Windy Wellington Edition

Posted on August 3rd, 2016

## Correlation vs. Causation [Charting Chatter]

Posted on August 2nd, 2016

## Add any number of days, months or years to a date with this simple trick

Posted on August 1st, 2016

## 5 Shortcuts for you, one for every weekday [Awesome August]

Posted on July 27th, 2016

## Introduction to Forecasting in Excel 2016 [Charts & Visual Analysis]

Posted on July 21st, 2016

## How to get Maps in to Excel charts & dashboards [Master Class]

[Read this] 3D Maps (Power Maps) > Charts and Graphs > Master Class { 11 comments }
Posted on July 19th, 2016

## Find out how many times a value is present in a cell [formulas]

Posted on July 13th, 2016

## On / Off conditional formatting with this simple trick

Posted on June 24th, 2016

## How to visualize multiple variables over several years? [Contest]

[Read this] Charts and Graphs > Excel Challenges { 15 comments }
Posted on June 21st, 2016

## Teach coding to your kids with this maze game [VBA]

Posted on June 10th, 2016

## What is the sum of values excluding items on stop list? [home work]

Posted on June 8th, 2016

## Sum up neither “A” nor “B” values – How to use DSUM function in Excel [video]

Posted on June 2nd, 2016

## Generating sequence numbers from cluster values [VLOOKUP to the rescue]

Posted on May 31st, 2016

Posted on May 26th, 2016

## Fish Eye Effect for highlighting selection – Is it effective? [Advanced Charting]

Posted on May 19th, 2016

## Excel Tips, Tricks, Cheats & Hacks – Readers Edition

[Read this] Excel Howtos > hacks > Huis > ideas > Learn Excel > Posts by Hui > Quick Tip { 14 comments }
Posted on May 18th, 2016

## SUMPRODUCT – Beginner to Advanced [Master Class]

Posted on May 13th, 2016

## How many ‘Friday the 13th’s are in this year? [Formula fun + challenge]

Posted on May 12th, 2016

## Excel Tips, Tricks, Cheats & Hacks – Readers Edition Prequel

[Read this] Excel Howtos > hacks > Huis > Posts by Hui > Quick Tip { 16 comments }
Posted on May 11th, 2016

## Apply Conditional Formatting using Slicers

[Read this] Cool Infographics & Data Visualizations > Excel Howtos > hacks > Huis > Pivot Tables & Charts > Posts by Hui { 11 comments }
Posted on May 5th, 2016

## Excel Tips, Tricks, Cheats & Hacks – Notable Excel Websites (Non-MVP) Edition

[Read this] Excel Howtos > excel links > hacks > Huis > Learn Excel > Posts by Hui { 11 comments }
Posted on April 28th, 2016

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

[Read this] Excel Howtos > hacks > Huis > ideas > Posts by Hui > Quick Tip { 19 comments }
Posted on April 25th, 2016

## Earth Venus cosmic dance – Animated chart in Excel

[Read this] Charts and Graphs > VBA Macros { 3 comments }
Posted on April 21st, 2016

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

[Read this] Excel Howtos > hacks > Huis > ideas > Learn Excel > Posts by Hui > Quick Tip { 17 comments }
Posted on April 19th, 2016

## Figure out slot from given time [quick tip]

Posted on April 14th, 2016

## Advanced Interactive Charts using Excel [Master Class]

[Read this] Charts and Graphs > Cool Infographics & Data Visualizations > Master Class > Pivot Tables & Charts > VBA Macros { 34 comments }
Posted on April 6th, 2016

## Tell all versions of truth [Dashboard Best Practice]

[Read this] Charts and Graphs > Cool Infographics & Data Visualizations { 1 comment }
Posted on March 31st, 2016

## CP054: Top 10 Pivot Table Tricks for YOU

[Read this] Chandoo.org Podcast Sessions > Pivot Tables & Charts { 5 comments }
Posted on March 30th, 2016

## A slicer that doesn’t slice [Pivot Table Tricks]

[Read this] Pivot Tables & Charts > Power Pivot { 2 comments }
Posted on March 22nd, 2016

## These icons are so pretty, can I get them in green? [conditional formatting trick]

Posted on March 17th, 2016

## How to create animated charts in Power Point [VBA]

[Read this] Charts and Graphs > Office Tips { 15 comments }
Posted on March 8th, 2016

## Unpivot and then pivot for clarity (case study)

[Read this] Pivot Tables & Charts > Power Query { 13 comments }
Posted on March 2nd, 2016

## “How Trump happened” in Excel [visualizations]

[Read this] Cool Infographics & Data Visualizations > VBA Macros { 15 comments }
Posted on February 26th, 2016

## Autosum many ranges quickly with Multi-select & ALT= [quick tip]

Posted on February 24th, 2016

## Please join 50 ways to analyze data course to become an awesome analyst

[Read this] Charts and Graphs > Learn Excel > Training Programs { 4 comments }
Posted on February 23rd, 2016

## Analyzing half a million complaints – Customer Satisfaction Scorecard [Part 3 of 3]

[Read this] Charts and Graphs > Cool Infographics & Data Visualizations > Learn Excel { 11 comments }
Posted on February 18th, 2016

## Analyzing half a million customer complaints – Regional Trends [Part 2 of 3]

[Read this] 3D Maps (Power Maps) > Charts and Graphs > Cool Infographics & Data Visualizations { 3 comments }
Posted on February 16th, 2016