fbpx

All articles with 'videos' Tag

Excel Dynamic Array Functions – What are they, how to use them, Examples and FAQs

Published on Apr 6, 2020 in Learn Excel
Excel Dynamic Array Functions – What are they, how to use them, Examples and FAQs

Excel Dynamic Array Functions are a true game changer. These newly introduced DA functions can filter, sort, remove duplicates and do much more. The output of these functions can go to a range of cells. Hence the name – dynamic array functions.

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 »

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 »

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 »

Impress with Tornado Charts in Excel

Published on Oct 7, 2019 in Charts and Graphs, Pivot Tables & Charts
Impress with Tornado Charts in Excel

It’s tornado season. Don’t freak out, I am talking about Excel tornado charts. Use them to visualize age and gender-wise KPIs. Here is a quick demo of interactive tornado chart made in Excel. Watch it and read on to learn how to make your own tornado in a spreadsheet.

Continue »

Excel Basics: How to add drop down list to validate data

Published on Sep 27, 2019 in Learn Excel
Excel Basics: How to add drop down list to validate data

Validating your data as you type can prevent any surprises when you are doing analysis / follow-up on the data. Thankfully, excel has the right tools to do it. Excel drop down list can assist you in picking up a value from a valid list to enter in a cell. Here is a short how-to […]

Continue »

Zelda Stamina Wheel Chart

Published on Sep 25, 2019 in Charts and Graphs
Zelda Stamina Wheel Chart

I have been playing Zelda: Breath of the wild a lot these days and I LOVE the game. Considered one of the BEST video games all time, BOTW is beautifully designed and offers a lot of entertainment. Don’t freak out yet, Chandoo.org hasn’t suddenly branched into a video gaming blog. Instead, I am here to talk about Stamina Wheel Chart.

Continue »

How can you analyze 1mn+ rows data – Excel Interview Question – 02

How can you analyze 1mn+ rows data – Excel Interview Question – 02

As part of our Excel Interview Questions series, today let’s look at another interesting challenge. How can you analyze more than 1 million rows data in Excel?

You may know that Excel has a physical limit of 1 million rows (well, its 1,048,576 rows). But that doesn’t mean you can’t analyze more than a million rows in Excel.

The trick is to use Data Model.

Continue »