Last 50 Posts on Chandoo.org
Posted on August 20th, 2024
How to calculate WEEKNUMBER in Month / Quarter / Year with Excel?
[Read this] Excel Howtos { 6 comments }
Posted on July 22nd, 2024
Automatically Format Numbers in Thousands, Millions, Billions in Excel [2 Techniques]
[Read this] Charts and Graphs > Learn Excel { 3 comments }
Posted on July 3rd, 2024
How to compare two Excel sheets using VLOOKUP? [FREE Template]
[Read this] Excel Howtos { 1 comment }
Posted on March 20th, 2024
How to convert test scores to letter grades in Excel?
[Read this] Excel Howtos { 0 comments }
Posted on March 19th, 2024
How to calculate the Gender Pay Gap using Excel Formulas? (Free Calculator Template)
[Read this] Learn Excel > Templates { 0 comments }
Posted on March 14th, 2024
Weighted Average in Excel [Formulas]
[Read this] Learn Excel { 108 comments }
Posted on March 12th, 2024
How to get non-adjacent columns with FILTER function in Excel
[Read this] Excel Howtos { 2 comments }
Posted on March 12th, 2024
What is XLOOKUP and how to use it in Excel?
[Read this] Excel Howtos { 66 comments }
Posted on February 26th, 2024
Get all BOLD text out Excel Cells Automatically
[Read this] Excel Howtos > VBA Macros { 1 comment }
Posted on February 21st, 2024
How to fix SPILL Error in Excel Tables (3 easy solutions)
[Read this] Excel Howtos > Learn Excel { 0 comments }
Posted on February 20th, 2024
Loan Amortization Schedule in Excel – FREE Template
[Read this] Financial Modeling > Learn Excel { 1 comment }
Posted on February 14th, 2024
How-to create Dependent Drop Downs in Excel [Dynamic & Multiple]
[Read this] Excel Howtos > Learn Excel { 0 comments }
Posted on February 11th, 2024
VLOOKUP(), MATCH() and INDEX() – explained in plain English
[Read this] Featured > Learn Excel { 253 comments }
Posted on February 6th, 2024
Beautiful Staff Roster Excel Template [FREE Download]
[Read this] Learn Excel > Templates { 0 comments }
Posted on January 29th, 2024
How to calculate time between two dates in Years, Months & Days [Excel Formula]
[Read this] Excel Howtos > Learn Excel { 2 comments }
Posted on January 15th, 2024
35 shortcuts & tricks to make you an #AWESOME Data Analyst
[Read this] Keyboard Shortcuts > Learn Excel > Pivot Tables & Charts { 13 comments }
Posted on January 7th, 2024
FREE Calendar & Planner Excel Template for 2024
[Read this] Learn Excel > Templates { 19 comments }
Posted on November 10th, 2023
Who went to both USA & UK? [Excel Challenge]
[Read this] Excel Challenges > Learn Excel { 13 comments }
Posted on October 3rd, 2023
Calculating Critical Path using Excel Formulas [Project Management]
[Read this] Learn Excel > Project Management { 11 comments }
Posted on September 26th, 2023
How to make a pivot table when you have data in multiple sheets [Tutorial]
[Read this] Learn Excel > Pivot Tables & Charts > Power Query { 0 comments }
Posted on September 5th, 2023
Python is in Excel! – Here is a complete getting started guide for you
[Read this] Learn Excel > Python { 0 comments }
Posted on August 8th, 2023
Top 10 Accounting KPIs and How to Calculate them in Excel?
[Read this] Financial Modeling > Learn Excel { 1 comment }
Posted on May 23rd, 2023
Make an Impressive Interactive Map Chart in Excel
[Read this] Charts and Graphs { 1 comment }
Posted on May 11th, 2023
How to Create a Dynamic Excel Dashboard in Just 5 Steps
[Read this] Charts and Graphs > Pivot Tables & Charts > Power Pivot { 0 comments }
Posted on April 14th, 2023
Speed up your Excel Formulas [10 Practical Tips]
[Read this] Excel Howtos > Learn Excel { 20 comments }
Posted on April 11th, 2023
A clever technique to simplify your long, nested IF formulas
[Read this] Formula Forensics > Learn Excel { 4 comments }
Posted on March 28th, 2023
Create a beautiful, elegant & interactive to-do list with Excel (FREE Template + Tutorial)
[Read this] Learn Excel > Templates { 0 comments }
Posted on March 21st, 2023
Send Email from Excel with Office Scripts & Power Automate
[Read this] Automation > Learn Excel > Office Scripts > Power Automate { 1 comment }
Posted on March 2nd, 2023
Top AI features in Excel – a round up
[Read this] artificial intelligence > Learn Excel { 0 comments }
Posted on January 30th, 2023
Learn Advanced Excel – 3 Month Roadmap with Resources
[Read this] Learn Excel { 2 comments }
Posted on January 12th, 2023
The Excel Mandelbrot
[Read this] Complex Numbers > Huis > Mandelbrot > Posts by Hui > Random { 0 comments }
Posted on January 2nd, 2023
FREE Calendar & Planner Excel Template for 2023
[Read this] Learn Excel > Templates { 11 comments }
Posted on December 17th, 2022
Range Lookup in Excel – How to lookup the pricing tier? [Formulas]
[Read this] Learn Excel { 147 comments }
Posted on November 25th, 2022
How to connect to a SINGLE file on SharePoint from Power Query (Fix Unable to Connect Error)
[Read this] Learn Excel > Power Query { 9 comments }
Posted on November 19th, 2022
FIFA 2022 World Cup Schedule & Results – Excel [FREE Download]
[Read this] Learn Excel > Templates { 7 comments }
Posted on November 17th, 2022
Filter one table if the value is in another table (Formula Trick)
[Read this] Learn Excel { 3 comments }
Posted on November 14th, 2022
Which Excel Formulas should you learn first?
[Read this] Learn Excel { 0 comments }
Posted on September 6th, 2022
Mortgage Calculator with Extra Payments – Excel Download
[Read this] Learn Excel > Templates { 18 comments }
Posted on August 23rd, 2022
Learn SQL for Data Analysis in one hour
[Read this] Learn Excel > SQL { 22 comments }
Posted on May 24th, 2022
How to learn Python as an “Excel person”?
[Read this] Learn Excel > Python { 6 comments }
Posted on May 19th, 2022
Can you split “The Hangover” expenses? [Excel Homework]
[Read this] Excel Challenges > Excel Howtos { 9 comments }
Posted on April 8th, 2022
What is LAMBDA? 4 Practical examples to REALLY understand it
[Read this] Learn Excel { 8 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 { 99 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