Menu
Last 50 Posts on Chandoo.org
Posted on December 10th, 2019
Filter as you type [Quick VBA tutorial]
[Read this] VBA Macros { 79 comments }
Posted on October 31st, 2019
Celebrate with spider web chart [Halloween Fun]
[Read this] Charts and Graphs { 2 comments }
Posted on October 16th, 2019
Using IRR with Data Tables – Modeling Cash-flow Scenarios in Excel
[Read this] Analytics > Financial Modeling > Learn Excel { 0 comments }
Posted on October 7th, 2019
Impress with Tornado Charts in Excel
[Read this] Charts and Graphs > Pivot Tables & Charts { 0 comments }
Posted on September 27th, 2019
Excel Basics: How to add drop down list to validate data
[Read this] Learn Excel { 42 comments }
Posted on September 25th, 2019
Zelda Stamina Wheel Chart
[Read this] Charts and Graphs { 2 comments }
Posted on September 19th, 2019
Weighted Average in Excel [Formulas]
[Read this] Learn Excel { 108 comments }
Posted on September 17th, 2019
How can you analyze 1mn+ rows data – Excel Interview Question – 02
[Read this] Excel Howtos > Interview Questions > Power Pivot > Power Query { 1 comment }
Posted on September 12th, 2019
#awesome trick – Extract word by position using FILTERXML()
[Read this] Excel Howtos > Learn Excel { 6 comments }
Posted on September 10th, 2019
Show difference between cells in status bar – VBA Example
[Read this] Excel Howtos > VBA Macros { 1 comment }
Posted on September 5th, 2019
What is XLOOKUP? 13 formula examples to really understand it
[Read this] Excel Howtos { 22 comments }
Posted on August 28th, 2019
Free Excel Risk Map Template
[Read this] Charts and Graphs > Project Management { 6 comments }
Posted on August 15th, 2019
VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01
[Read this] Interview Questions > Learn Excel { 23 comments }
Posted on August 7th, 2019
How-to highlight maximum value in Excel charts? [Quick tip]
[Read this] Charts and Graphs { 4 comments }
Posted on August 6th, 2019
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
[Read this] Excel Howtos > Featured > Learn Excel > Pivot Tables & Charts { 157 comments }
Posted on August 2nd, 2019
Pivot Tables from large data-sets – 5 examples
[Read this] Pivot Tables & Charts { 2 comments }
Posted on July 19th, 2019
Tour de France – Distance & Pace over time – Radial Charts
[Read this] Charts and Graphs > Cool Infographics & Data Visualizations { 1 comment }
Posted on July 11th, 2019
Make info-graphics with shape fill technique [Charting Tip]
[Read this] Charts and Graphs { 9 comments }
Posted on July 2nd, 2019
How to predict cricket scores [Excel + Machine Learning]
[Read this] Analytics > Charts and Graphs > Learn Excel { 14 comments }
Posted on May 22nd, 2019
How to trace precedents in Excel formulas? [tip+music from Prague]
[Read this] Excel Howtos { 3 comments }
Posted on May 16th, 2019
Circular Arc – Doughnut Charts
[Read this] Charts and Graphs > Excel Howtos > Huis > Posts by Hui { 0 comments }
Posted on May 9th, 2019
5 simple rules for making awesome column charts
[Read this] Charts and Graphs { 37 comments }
Posted on May 1st, 2019
How to fake “Key influencers chart” in Excel?
[Read this] Charts and Graphs { 5 comments }
Posted on April 26th, 2019
How to sort left to right in Excel (quick tip)
[Read this] Learn Excel { 2 comments }
Posted on April 16th, 2019
VLOOKUP multiple matches – trick
[Read this] Excel Howtos > Learn Excel { 5 comments }
Posted on April 10th, 2019
Source vs. Use of Funds – 14 charting alternatives
[Read this] Charts and Graphs { 0 comments }
Posted on March 27th, 2019
Top 10 Excel Formulas for any situation
[Read this] Learn Excel { 7 comments }
Posted on March 20th, 2019
Create impressive dashboard tiles in Excel
[Read this] Charts and Graphs > Cool Infographics & Data Visualizations { 12 comments }
Posted on February 28th, 2019
Quickly Change Formulas Using Find / Replace
[Read this] Learn Excel { 37 comments }
Posted on February 5th, 2019
Quickly change charts from one to another with this trick
[Read this] Charts and Graphs > Quick Tip { 1 comment }
Posted on October 23rd, 2018
Hui’s World ! – An Excel Project of Global Scale.
[Read this] 3D Maps (non Power Maps) > Excel Howtos > Huis > Posts by Hui { 26 comments }
Posted on September 13th, 2018
Lenient lookup [Advanced Formula Trick]
[Read this] Excel Howtos > Learn Excel { 7 comments }
Posted on August 28th, 2018
Performing Maths in Microsoft Word (In an Excel Blog)
[Read this] Excel Howtos > Huis > Posts by Hui > Word { 0 comments }
Posted on August 16th, 2018
Make funky and creative hand-drawn chart in Excel – Quick tutorial
[Read this] Charts and Graphs { 4 comments }
Posted on August 8th, 2018
Announcing Excel School v2.0 – Quick intro and details inside
[Read this] Learn Excel { 33 comments }
Posted on August 7th, 2018
12 Steps to learn Excel and become awesome @ work in 2018
[Read this] Learn Excel { 14 comments }
Posted on August 1st, 2018
How to get percentage of something calculations in Excel Pivot Tables
[Read this] Pivot Tables & Charts > Power Pivot { 5 comments }
Posted on July 27th, 2018
Top 5 HR Analytics Examples – Free Video Masterclass
[Read this] Learn Excel > Master Class > Power Query { 22 comments }
Posted on July 19th, 2018
Calculate travel time and distance between two addresses using Excel + Maps API
[Read this] Excel Howtos { 46 comments }
Posted on July 6th, 2018
Mutual Fund Portfolio Tracker using MS Excel
[Read this] Learn Excel > personal finance > Power Query > technology { 190 comments }
Posted on July 4th, 2018
Play spreadsheet soccer with Excel Penalty Game [VBA]
[Read this] Charts and Graphs > VBA Macros { 5 comments }
Posted on June 27th, 2018
100+ Excel Formula Examples + List
[Read this] Excel Howtos { 55 comments }
Posted on June 20th, 2018
How to use Date & Time values in Excel – a handy guide
[Read this] Excel Howtos > Learn Excel { 90 comments }
Posted on June 13th, 2018
Excel Tables Tutorial & 13 Tips for making you a Data Guru
[Read this] Excel Howtos > Featured > Learn Excel { 132 comments }
Posted on June 11th, 2018
Best Excel Books & Power BI Books – 2018
[Read this] Learn Excel > Power BI > Power Pivot > Power Query { 6 comments }
Posted on May 25th, 2018
Introduction to Excel SUMIFS Formula
[Read this] Learn Excel { 211 comments }
Posted on May 24th, 2018
Excel formula showing as text instead of actual result – How to fix the problem
[Read this] Excel Howtos { 323 comments }
Posted on May 23rd, 2018
Distinct count in Excel pivot tables
[Read this] Pivot Tables & Charts { 14 comments }
Posted on May 16th, 2018
At Chandoo.org, I have one goal, "to make you awesome in excel and charting". This blog is started in 2007 and today has 350+ articles and tutorials on using excel, making better charts. 
