Last 50 Posts on Chandoo.org
Posted on July 19th, 2018
Calculate travel time and distance between two addresses using Excel + Maps API
[Read this] Excel Howtos { 4 comments }
Posted on July 6th, 2018
Mutual Fund Portfolio Tracker using MS Excel
[Read this] Learn Excel > personal finance > Power Query > technology { 156 comments }
Posted on July 4th, 2018
Play spreadsheet soccer with Excel Penalty Game [VBA]
[Read this] Charts and Graphs > VBA Macros { 2 comments }
Posted on June 27th, 2018
100+ Excel Formula Examples + List
[Read this] Excel Howtos { 42 comments }
Posted on June 20th, 2018
How to use Date & Time values in Excel – a handy guide
[Read this] Excel Howtos > Learn Excel { 86 comments }
Posted on June 13th, 2018
Excel Tables Tutorial & 13 Tips for making you a Data Guru
[Read this] Excel Howtos > Featured > Learn Excel { 131 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 { 207 comments }
Posted on May 24th, 2018
Excel formula showing as text instead of actual result – How to fix the problem
[Read this] Excel Howtos { 316 comments }
Posted on May 23rd, 2018
Distinct count in Excel pivot tables
[Read this] Pivot Tables & Charts { 7 comments }
Posted on May 16th, 2018
Beautiful Budget vs. Actual chart to make your boss love you
[Read this] Charts and Graphs { 17 comments }
Posted on May 2nd, 2018
35 shortcuts & tricks to make you an #AWESOME Data Analyst
[Read this] Keyboard Shortcuts > Learn Excel > Pivot Tables & Charts { 9 comments }
Posted on April 30th, 2018
A trick to Pivot text values
[Read this] Pivot Tables & Charts > Power Query { 2 comments }
Posted on April 26th, 2018
Time series analysis and interactive forecasting in Excel – Sample video from 50 ways course
[Read this] Charts and Graphs { 1 comment }
Posted on April 24th, 2018
Top 5 keyboard shortcuts for Excel Charts
[Read this] Charts and Graphs > Keyboard Shortcuts { 6 comments }
Posted on April 19th, 2018
Create your first interactive chart in Excel with this tutorial
[Read this] Charts and Graphs > Learn Excel > Pivot Tables & Charts { 8 comments }
Posted on April 13th, 2018
Visualizing Commonwealth games performance – Interactive chart
[Read this] Charts and Graphs > Power Query { 2 comments }
Posted on April 11th, 2018
Rescue oddly shaped data – Battle between Formulas, VBA and Power Query
[Read this] Learn Excel > Power Query > VBA Macros { 26 comments }
Posted on March 15th, 2018
Quick tip: Rename headers in pivot table so they are presentable
[Read this] Pivot Tables & Charts { 4 comments }
Posted on March 5th, 2018
One Control Three Cells
[Read this] Excel Howtos > Huis > Posts by Hui { 3 comments }
Posted on March 1st, 2018
Stay on top of money with this awesome household budget spreadsheet [downloads]
[Read this] Learn Excel > Templates { 21 comments }
Posted on February 10th, 2018
vlookup(), MATCH() and INDEX() – explained in plain English [spreadcheats]
[Read this] Featured > Learn Excel { 233 comments }
Posted on January 11th, 2018
This year, become a Very Table Genius
[Read this] Learn Excel { 20 comments }
Posted on January 3rd, 2018
2018 Calendar, daily planner Excel templates [free downloads]
[Read this] Learn Excel { 8 comments }
Posted on December 5th, 2017
5 conditional formatting top tips – Excel basics
[Read this] Excel Howtos > Learn Excel { 17 comments }
Posted on October 20th, 2017
Conditional Rank, the easy way [quick tip]
[Read this] Pivot Tables & Charts { 8 comments }
Posted on October 19th, 2017
Formula Forensics 043: Rankifs or Conditional Rank
[Read this] Formula Forensics > Huis > Posts by Hui { 10 comments }
Posted on October 12th, 2017
How to Distribute Players Between Teams – Evenly
[Read this] Excel Howtos > Huis > Posts by Hui > Solver { 13 comments }
Posted on October 9th, 2017
Conditional Formatting – Chart Data Labels
[Read this] Charts and Graphs > Excel Howtos > hacks > Huis > Posts by Hui { 7 comments }
Posted on October 5th, 2017
Histograms & Pareto charts in Excel – tutorial, tips and downloadable template
[Read this] Charts and Graphs { 4 comments }
Posted on September 18th, 2017
VLOOKUP that fat table with ease [3 quick tips]
[Read this] Learn Excel { 13 comments }
Posted on August 28th, 2017
Copy Paste Visible Cells only (Two more ways to do it)
[Read this] Excel Howtos > Keyboard Shortcuts > Learn Excel { 6 comments }
Posted on August 24th, 2017
Copy & paste visible cells only [Excel Trick]
[Read this] Keyboard Shortcuts > Learn Excel { 18 comments }
Posted on August 17th, 2017
Awesome chart to visualize Salary Increases for 3,500+ people [Tutorial]
[Read this] Charts and Graphs > R programming { 18 comments }
Posted on August 10th, 2017
Employee Performance Panel Charts – Excel vs. R [video]
[Read this] Charts and Graphs > R programming { 15 comments }
Posted on August 1st, 2017
Use File > Info to quickly unprotect multiple worksheets [Quick tips]
[Read this] Excel Howtos { 7 comments }
Posted on July 12th, 2017
Joyplot in Excel
[Read this] Charts and Graphs > Cool Infographics & Data Visualizations { 18 comments }
Posted on July 4th, 2017
How to add a lot of Goal Seeking to a model
[Read this] Huis > Posts by Hui > simulation { 10 comments }
Posted on June 26th, 2017
Rounding time to nearest minute or quarter hour etc. [formulas]
[Read this] Excel Howtos { 22 comments }
Posted on June 15th, 2017
SUMPRODUCT Vs. Power Query on Mt. KauKau
[Read this] Learn Excel > Power Query { 14 comments }
Posted on May 15th, 2017
Start your bar charts from zero – Excel geeks screaming at you from mountain top
[Read this] Charts and Graphs { 24 comments }
Posted on May 2nd, 2017
Selective Sub-totals in Pivot Tables [Quick Tip]
[Read this] Excel Howtos > Pivot Tables & Charts { 7 comments }
Posted on April 26th, 2017
Avoid Hiring Boo-boos with Excel – COUNTIFS for the win [video]
[Read this] Excel Howtos > Learn Excel { 0 comments }
Posted on April 21st, 2017
Relative References in Excel Tables
[Read this] Excel Howtos > Learn Excel { 12 comments }
Posted on April 19th, 2017
Modelling Inventory Run Rate & Cash Flows using Excel
[Read this] Analytics > Charts and Graphs { 9 comments }
Posted on April 5th, 2017
Hide columns one one tab same way as they were in another place [quick tip]
[Read this] Excel Howtos { 7 comments }
Posted on April 3rd, 2017
Sand Pendulums – Lissajous Patterns in Excel
[Read this] Charts and Graphs > VBA Macros { 0 comments }
Posted on March 16th, 2017
Reshaping your data easily – Case study [Pivot tables FTW]
[Read this] Learn Excel > Pivot Tables & Charts { 10 comments }
Posted on March 6th, 2017
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. 
