direct tag

Make funky and creative hand-drawn chart in Excel – Quick tutorial

Charts are great way to tell story about what is going on in your business. But they also feel a bit too impersonal and meh. How about adding your personality to them? I don’t mean making them tall, dark and pretty. I mean using hand-drawing style to make them pop out. Something like above example of hand-drawn chart.

The best thing is, You don’t need to actually draw these charts by hand. We can use a powerful charting trick to get these charts automatically generated (and linked) to your data. Interested? Read on to learn how to create hand-drawn charts in Excel.

The post Make funky and creative hand-drawn chart in Excel – Quick tutorial appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

Top 5 with above average – Power Pivot Trick

Welcome to Power Mondays. Every Monday, learn all about Power BI, Power Query & Power Pivot in full length examples, videos or tips. In this installment, learn how to get top 5 list with a twist.

Let’s say you are analyzing sales data and you want to know who are your top 5 sales persons?

Of course, this is simple, you just create a pivot to see total sales by person and then sort the pivot. First five rows have the answer you need. You can even apply a value filter > top 5 to show only their data.

The post Top 5 with above average – Power Pivot Trick appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

direct tag

direct tag

Announcing Excel School v2.0 – Quick intro and details inside

Do you want to learn Advanced Excel, data analysis, creative charting, dashboard reporting and be productive in Excel? Then you are going to love my Excel School v2.0.

This is the golden age of data. Any rewarding job or entrepreneurship requires good data literacy. We are all expected to understand the relevance of data, how to manage it, how to analyze it, visualize it and tell elegant stories.

This is where Excel School comes in.

The post Announcing Excel School v2.0 – Quick intro and details inside appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

12 Steps to learn Excel and become awesome @ work in 2018

Obviously, everywhere you look this week, you find advice on how to do better this year.

Well, you don’t have to wait for a new year to become awesome at your work, any day is new year for the rest of your life.

So, today I want to share 12 steps to learn Excel and becoming awesome. But first I have a secret to confess…,

I think becoming awesome in Excel useless.

What we really want is, to become awesome in our work. Since we spend a lot of time using Excel (and other office software), knowing how to use these better can have a huge impact on how we do our work.

In that spirit, lets look at 12 steps to learn Excel so you become awesome in your work.

The post 12 Steps to learn Excel and become awesome @ work in 2018 appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

Nest Egg Calculator using Power BI

Welcome to Power Mondays. Every Monday, learn all about Power BI, Power Query & Power Pivot in full length examples, videos or tips. In the first installment, let’s take a look at something we all can related to – Money. 

We all know that Power BI is good for creating awesome visual experiences. Today let me share another fun way to use Power BI – to build a calculator. Learn how to create nest egg calculator in this Power BI parameter example tutorial.

The post Nest Egg Calculator using Power BI appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

Nest Egg Calculator using Power BI

Welcome to Power Mondays. Every Monday, learn all about Power BI, Power Query & Power Pivot in full length examples, videos or tips. In the first installment, let’s take a look at something we all can related to – Money. 

We all know that Power BI is good for creating awesome visual experiences. Today let me share another fun way to use Power BI – to build a calculator. Learn how to create nest egg calculator in this Power BI parameter example tutorial.

The post Nest Egg Calculator using Power BI appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

direct tag

direct tag

Excel School v2.0, blogging schedule, personal life – a quick update

Hi all,

Time for a personal + blog related update. Bring a cup of your favorite brew, sit back, relax and read on. Read about our 2 years in New Zealand, Excel School v2.0 and revised blogging schedule. Catch glimpses of our live in NZ too.

The post Excel School v2.0, blogging schedule, personal life – a quick update appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag

direct tag

How to get percentage of something calculations in Excel Pivot Tables

Ever wondered how to get percentage of another value in Excel pivot tables, like this: In this tip, learn how to create such calculations using Excel pivot tables. Note: this tip is not compatible with older versions of Excel. If you are using Excel 2007 / 2010 / 2013, then please install free Power Pivot […]

The post How to get percentage of something calculations in Excel Pivot Tables appeared first on Chandoo.org – Learn Excel, Power BI & Charting Online.

Continue reading

direct tag