Last 50 Posts on Chandoo.org
Posted on May 24th, 2022
How to learn Python as an “Excel person”?
[Read this] Learn Excel > Python { 4 comments }
Posted on May 19th, 2022
Can you split “The Hangover” expenses? [Excel Homework]
[Read this] Excel Challenges > Excel Howtos { 5 comments }
Posted on April 8th, 2022
What is LAMBDA? 4 Practical examples to REALLY understand it
[Read this] Learn Excel { 5 comments }
Posted on January 5th, 2022
FREE 2022 Calendar & Monthly Planner Printable Template
[Read this] Learn Excel > Templates { 6 comments }
Posted on December 9th, 2021
How to write complex Excel formulas (hint: it’s a lot like LEGO)
[Read this] Excel Howtos > Learn Excel { 3 comments }
Posted on August 2nd, 2021
Sorting values in Olympic Medal Table style [Quick Tip]
[Read this] Excel Howtos { 29 comments }
Posted on July 28th, 2021
How to use Date & Time values in Excel – 10 + 3 tips
[Read this] Excel Howtos > Learn Excel { 98 comments }
Posted on June 14th, 2021
6 Essential TEXT functions in Excel with 6 Everyday Examples
[Read this] Learn Excel { 11 comments }
Posted on June 10th, 2021
How to create a fully interactive Project Dashboard with Excel – Tutorial
[Read this] Charts and Graphs > Learn Excel > Project Management { 14 comments }
Posted on April 14th, 2021
Extract data from PDF to Excel – Step by Step Tutorial
[Read this] Learn Excel > Power Query { 7 comments }
Posted on March 31st, 2021
10 Advanced IF formula tricks you must know
[Read this] Learn Excel { 13 comments }
Posted on March 17th, 2021
What is XLOOKUP? 13 formula examples to really understand it
[Read this] Excel Howtos { 59 comments }
Posted on March 3rd, 2021
How to embed Excel files, calculators on your website? – Step by step instructions
[Read this] Learn Excel > Templates { 4 comments }
Posted on February 23rd, 2021
Dynamic Arrays Live Masterclass – Replay
[Read this] Learn Excel { 12 comments }
Posted on February 15th, 2021
5 Simple & Useful Conditional Formatting Tricks
[Read this] Learn Excel { 8 comments }
Posted on December 16th, 2020
Image Lookup – How-to show dynamic picture in a cell [Excel Trick]
[Read this] Learn Excel { 11 comments }
Posted on November 17th, 2020
9 Box grid for talent mapping – HR for Excel – Template & Explanation
[Read this] Charts and Graphs > Learn Excel { 22 comments }
Posted on October 1st, 2020
6 Must Know Line Chart variations for Data Analysis
[Read this] Charts and Graphs { 1 comment }
Posted on September 23rd, 2020
Two-level Data Validation [Excel Trick]
[Read this] Excel Howtos > Learn Excel { 5 comments }
Posted on September 3rd, 2020
Excel formula to convert calendar format to table
[Read this] Learn Excel { 6 comments }
Posted on July 29th, 2020
Project Plan – Gantt Chart with drill-down capability [Templates]
[Read this] Learn Excel > Templates { 3 comments }
Posted on July 16th, 2020
How to make stream graphs in Excel?
[Read this] Charts and Graphs { 0 comments }
Posted on July 6th, 2020
These Pivot Table tricks massively save your time
[Read this] Learn Excel > Pivot Tables & Charts { 5 comments }
Posted on June 18th, 2020
Top 10 Excel formulas for IT people
[Read this] Learn Excel > Project Management { 9 comments }
Posted on June 12th, 2020
Lookup last non blank value – Excel Challenge
[Read this] Excel Challenges > Learn Excel { 22 comments }
Posted on June 9th, 2020
Excel TEXTJOIN Function – What is it, how to use it & 3 advanced examples
[Read this] Learn Excel { 2 comments }
Posted on June 2nd, 2020
How to make an Interactive Chart Slider Thingy
[Read this] Charts and Graphs > Cool Infographics & Data Visualizations { 13 comments }
Posted on May 18th, 2020
Highlight due dates in Excel – Show items due, overdue and completed in different colors
[Read this] Excel Howtos > Learn Excel { 45 comments }
Posted on May 12th, 2020
How to show positive / negative colors in area charts? [Quick tip]
[Read this] Charts and Graphs > Excel Howtos { 4 comments }
Posted on May 8th, 2020
6 Best charts to show % progress against goal
[Read this] Charts and Graphs > Learn Excel { 46 comments }
Posted on April 28th, 2020
Easy Website Metrics Dashboard with Excel
[Read this] Charts and Graphs > Learn Excel > Templates { 1 comment }
Posted on April 23rd, 2020
What are Excel Sparklines & How to use them? 5 Secret Tips
[Read this] Charts and Graphs { 61 comments }
Posted on April 11th, 2020
Excel Dynamic Array Functions – What are they, how to use them, Examples and FAQs
[Read this] Learn Excel { 9 comments }
Posted on April 10th, 2020
There are 20 Easter Eggs in this Workbook
[Read this] Excel Challenges > Learn Excel { 29 comments }
Posted on March 24th, 2020
Number to Words – Excel Formula
[Read this] Excel Howtos > VBA Macros { 5 comments }
Posted on March 19th, 2020
18 Tips to Make you an Excel Formatting Pro
[Read this] Excel Howtos > Learn Excel { 30 comments }
Posted on March 17th, 2020
How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial
[Read this] Excel Howtos > Templates { 2 comments }
Posted on February 27th, 2020
Advanced Pivot Table Tricks for you
[Read this] Cool Infographics & Data Visualizations > Pivot Tables & Charts > Power Pivot > Power Query { 8 comments }
Posted on February 4th, 2020
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
[Read this] Excel Howtos > Featured > Learn Excel > Pivot Tables & Charts { 159 comments }
Posted on January 28th, 2020
Make a random sentence with Excel formulas
[Read this] Learn Excel { 3 comments }
Posted on January 6th, 2020
Free 2020 Calendar Template & Daily Planner
[Read this] Learn Excel > Templates { 6 comments }
Posted on December 19th, 2019
Come and learn from me in London – April 2020
[Read this] Learn Excel > personal { 1 comment }
Posted on December 10th, 2019
Filter as you type [Quick VBA tutorial]
[Read this] VBA Macros { 94 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 { 3 comments }
Posted on October 7th, 2019
Impress with Tornado Charts in Excel
[Read this] Charts and Graphs > Pivot Tables & Charts { 1 comment }
Posted on September 27th, 2019
Excel Basics: How to add drop down list to validate data
[Read this] Learn Excel { 43 comments }
Posted on September 25th, 2019
Zelda Stamina Wheel Chart
[Read this] Charts and Graphs { 2 comments }
Posted on September 19th, 2019