fbpx

Author Archive

Is there a secret code in this data? [Excel Homework]

Published on Mar 27, 2020 in Excel Challenges
Is there a secret code in this data? [Excel Homework]

Are you ready for a fun Excel challenge? Read on then…

You are a nautical transport manifest analyst at New Donk city harbor. But you also have a secret identity. You are a spy for Global Intelligence Organization. As part of routine inspection of cargo details, you came across a list of shipping codes that look suspicious.

Continue »

Number to Words – Excel Formula

Published on Mar 24, 2020 in Excel Howtos, VBA Macros
Number to Words – Excel Formula

Ever wanted to convert numbers to words in Excel? For example, 456,123 becomes four hundred fifty-six thousand one hundred twenty-three.

Microsoft recently introduced LET function to Excel. This allows us to create variables on the fly to use within a formula. I just made a words from number formula using LET function and bit of good old INDEX.

Read on to learn how this all works.

Continue »

A quick personal update

Published on Mar 23, 2020 in blogging, personal
A quick personal update

How are you? I want to say hello and check in with you in these strange and scary times.

Continue »

18 Tips to Make you an Excel Formatting Pro

Published on Mar 19, 2020 in Excel Howtos, Learn Excel
18 Tips to Make you an Excel Formatting Pro

We can take any Excel workbook and format it until Christmas, and we would still not be done. But not many of us have so much of time or energy. So, today, lets talk formatting.

In this, you will learn how to
1) Use tables to format data quickly
2) Change colors of your worksheet in a snap
3) Use cell styles
4) Quickly clone formatting using format painter
5) Clear formats to begin with a clean-slate
6) Formatting shortcuts
7) Formatting options for print
and 8 ) Why you should not go overboard formatting and 10 other tips.

So go ahead and become a formatting pro.

Continue »

How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial

Published on Mar 17, 2020 in Excel Howtos, Templates
How-to create an elegant, fun & useful Excel Tracker – Step by Step Tutorial

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.

Continue »

Advanced Pivot Table Tricks for you

Advanced Pivot Table Tricks for you

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 […]

Continue »

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one

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.

Continue »

Make a random sentence with Excel formulas

Published on Jan 28, 2020 in Learn Excel
Make a random sentence with Excel formulas

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.

Continue »

Free 2020 Calendar Template & Daily Planner

Published on Jan 6, 2020 in Learn Excel, Templates
Free 2020 Calendar Template & Daily Planner

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.

Continue »

Merry Christmas & Happy New Year 2020

Published on Dec 24, 2019 in personal
Merry Christmas & Happy New Year 2020

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.

Continue »

Come and learn from me in London – April 2020

Published on Dec 19, 2019 in Learn Excel, personal
Come and learn from me in London – April 2020

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.

Continue »

Filter as you type [Quick VBA tutorial]

Published on Dec 10, 2019 in VBA Macros
Filter as you type [Quick VBA tutorial]

Filtering a list is a powerful & easy way to analyze data. But filtering requires a lot of clicks & typing. Wouldn’t it be cool if Excel can filter as you type, something like above.

Let’s figure out how to do this using some really simple VBA code.

Continue »

Introduction to Power BI – What is it, how to get it, how to create reports with Power BI and how to publish them?

Published on Nov 8, 2019 in Power BI
Introduction to Power BI – What is it, how to get it, how to create reports with Power BI and how to publish them?

Power BI is a data analytics & visualization software. It is one of the most popular and powerful way to work with complex business data. In this page, you will find a comprehensive guide to start your Power BI journey.

Continue »

Celebrate with spider web chart [Halloween Fun]

Published on Oct 31, 2019 in Charts and Graphs
Celebrate with spider web chart [Halloween Fun]

It’s Halloween time. As adults, we can’t go trick or treating. We can of course dress up in costumes and entertain others. But what about the poor spreadsheets. Don’t they deserve some of this fun too?

Hell yeah! So I made a spider web generator in Excel. Just use it to make a spooky cob web pattern and add it to your report / dashboard / time sheet or whatever else. Surprise your colleagues.

Continue »

Using IRR with Data Tables – Modeling Cash-flow Scenarios in Excel

Published on Oct 16, 2019 in Analytics, Financial Modeling, Learn Excel
Using IRR with Data Tables – Modeling Cash-flow Scenarios in Excel

Do you want to simulate multiple cash-flow scenarios and calculate the rate of return? Then this article is for you. In this page, learn how to,

  • Introduction to IRR & XIRR functions
  • Calculate rate of return from a set of cash-flows with XIRR
  • Simulating purchase or terminal value changes with data tables
  • Apply conditional formatting to visualize the outputs
  • Common issues and challenges faced when using XIRR
Continue »