direct tag

There is an Easter Egg in this Power BI report

Its Easter time. At Chandoo.org, I have tradition of publishing Easter Egg hunts since 2009. This is the first time our Easter egg hunt is on Power BI. Changing times, eh? Find the Easter Egg in this report… I have embedded the visual below. Can you find the egg? If you have difficulty seeing the […]

The post There is an Easter Egg in this Power BI report appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

direct tag

direct tag

Source vs. Use of Funds – 14 charting alternatives

Let’s say you manage a fund or charity. You get money from various places and you use that money for various reasons. How do you tell the story of source vs. uses of funds? In this post, let’s review 14 charting options. Source vs. Use of funds – Sample Data for this problem Let’s say […]

The post Source vs. Use of Funds – 14 charting alternatives appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

Top 10 Excel Formulas for any situation

Excel has hundreds of formulas. But as a new learner or user, you may want to just focus on top 10 formulas to get the most out of it. Assuming you already know the basics (check out Beginner Excel page if you are complete newbie), here is a list of top 10 Excel formulas for you.

The post Top 10 Excel Formulas for any situation appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

Create impressive dashboard tiles in Excel

If you want to tell the story of how your business / project / charity / thing is going on, then making a dashboard is the best way to go about it. Dashboards can combine heaps of data, insights and messages in to one concise format that fits on to a desktop or table or mobile screen.

But let’s be honest. Creating them in Excel is a lot of work. Even after spending hours on them, they might still look meh. So, let me share a trick to make your dashboards look snazzy (without compromising on insights per inch).

Create dashboard tiles, something like above.

The post Create impressive dashboard tiles in Excel appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

direct tag

direct tag

Employee Turnover Dashboard – Power BI for HR

Work in HR and use Power BI? You are going to love this extensive, powerful and useful Employee Turnover Dashboard. In this detailed article, learn how to create your own attrition dashboard system with Power BI. Full example workbook, video and sample data included.

The post Employee Turnover Dashboard – Power BI for HR appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

Quickly Change Formulas Using Find / Replace

So you have built that excel report your boss wanted. And you were all eager to use the spreadsheet in your presentation. But in the last minute, your boss asked you to change average sales to total sales figures. You also want to grab an espresso before rushing to the meeting. Now what?

The post Quickly Change Formulas Using Find / Replace appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

Quickly change charts from one to another with this trick

We all change minds. Heck, I just did it with the leading line. I thought something else, but went with what you just read. So why must Excel charts be set in stone? Let’s say you made some charts and want to quickly second guess your selection. How to change Excel chart easily? Sure, you […]

The post Quickly change charts from one to another with this trick appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

Elevator problem – Excel homework

The other day while I was in lift (elevator), it made an alarm like sound and won’t close the doors. Turns out there are one too many people in the lift for it to operate safely. As soon as a couple of people volunteered and stepped out, it started fighting gravity and took us upstairs. […]

The post Elevator problem – Excel homework appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag