Do you want to create a simple, elegant and useful tracker using Excel? You can make trackers with features like tables, data validation rules and conditional formatting. In this page, I will explain the process for creating an Excel tracker.

Excel Pivot tables make data analysis and visualization easy. With the help of these advanced pivot table skills, you can create powerful data analytics and reports.   New to Pivot Tables? If you are new to Pivot Tables, check out this excellent introduction to Pivot Tables page. × Dismiss alert Table of Contents #1 – One Slicer, Two […]

Excel pivot tables are very useful and powerful feature of MS Excel. They are used to summarize, analyze, explore and present your data. In plain English, it means, you can take the sales data with columns like salesman, region and product-wise revenues and use pivot tables to quickly find out how products are performing in each region.

In this tutorial, we will learn what is a pivot table and how to make a pivot table using excel.

Ever wanted to make a random sentence or text? You can use Excel formulas to make totally random sentences. This is a great way to generate test data or dummy data-sets.

Happy New Year to all our readers. Let’s kick start 2020 with an awesome calendar, daily planner and monthly calendar template. Please visit the post page to download the 2020 Calendar Excel Template.

Hello readers,

On behalf of my family, our staff, volunteers & well-wishers, Let me wish you a very happy Christmas & prosperous new year 2020. Here is a small holiday card from Chandoo.org HQ. This year, we have a new addition to our family – Excel, bichon-poodle puppy has been with us for a little over one month and already became a big part of our lives.

Hello readers, I have an exciting announcement for you.

I will be presenting at two events at London in April 2020. Please consider this my personal invitation and join me for Excel + Power BI fun.