learn excel

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,

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

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

8 min read 2022-11-14 20:28:59

Let’s face it. You already know the SUMs & COUNTs of Excel. But what should you learn next? There are more than 400 functions in

4 min read 2022-09-06 15:09:00

Recently we moved houses. And with the house move, came a brand new mortgage. But as a self-employed person with variable income, I find