Chandoo.org – Learn Excel, Power BI & Charting Online

5 min read 2023-04-14 12:59:18

Speed up your Excel Formulas [10 Practical Tips]

Excel formulas acting slow? Today lets talk about optimizing & speeding up Excel formulas. Use these tips & ideas to super-charge your

3 min read 2023-04-11 14:44:00

Recently I optimized a pretty long nested IF formula using a simple but elegant trick. I made it 80% shorter! In this article, let me

3 min read 2023-03-28 13:45:00

In this hands-on tutorial learn how to create a simple, elegant and functional to-do list to track your projects and

4 min read 2023-03-21 13:49:00

Do you have an Excel report or graphs that need to be emailed to various people every month? We can use Excel automation features to do

4 min read 2023-03-02 11:29:07

Gone are the days when Excel is all about manual intelligence. Now a days, we can summon the powers of artificial

7 min read 2023-01-30 11:14:57

Learn Advanced Excel in 3 Months Roadmap with Resources Chandoo January 30,

8 min read 2023-01-12 09:34:58

Background I have always had a fascination with Mandelbrots, since I was introduced to them in High School in the late 1970’s. With the advent of

2 min read 2023-01-02 11:55:00

Here is a fabulous New Year gift to you. A free 2023 Calendar & Activity planner made entirely in Excel. This dynamic calendar workbook lets

2 min read 2022-12-20 02:53:03

Hi everyone… Let me start by wishing you all a very happy holiday season and stellar start to 2023. Here is our annual holiday card. [pictured left

3 min read 2022-12-18 02:29:36

Here is a really tricky problem. Recently I was given a data set like this (shown below) and asked to find the position of lookup value

2 min read 2022-11-25 12:55:10

I have been working with SharePoint a lot these days. A LOT!!! One thing that frustrates me all the time is that there is no easy way to connect to a

3 min read 2022-11-20 03:34:57

It is the Soccer WORLD CUP time !!! Here is an Excel Workbook to keep track of the schedule, results, group standings and more. Download it

3 min read 2022-11-20 03:34:57

It is the Soccer WORLD CUP time !!! Here is an Excel Workbook to keep track of the schedule, results, group standings and more. Download it

2 min read 2022-11-18 05:20:00

Time for a quick but very handy Excel FORMULA trick. You have two tables. ORDERS & PRODUCTS. You want to see all the orders if the product name

2 min read 2022-11-18 05:20:00

Time for a quick but very handy Excel FORMULA trick. You have two tables. ORDERS & PRODUCTS. You want to see all the orders if the product name