fbpx

All articles with 'videos' Tag

How to extract common values in two tables? – Power Query Tip

Published on Aug 19, 2019 in Power Query
How to extract common values in two tables? – Power Query Tip

We, humans like to compare. Whether we are on Facebook or workbook, we want to compare. So how do you compare two tables and extract common values? Simple, use Excel Power Query. It can merge (a la join) tables and give you the common values.

Continue »

VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01

Published on Aug 15, 2019 in Interview Questions, Learn Excel
VLOOKUP or INDEX+MATCH? – Excel Interview Question – 01

This is part of our Excel Interview Questions series.

VLOOKUP or INDEX+MATCH? When you should use each function and why?

This is such a great question to ask in interviews. So in my first installment of Excel interview questions, let me answer it.

Continue »

How-to highlight maximum value in Excel charts? [Quick tip]

Published on Aug 7, 2019 in Charts and Graphs
How-to highlight maximum value in Excel charts? [Quick tip]

Ever wanted to highlight maximum value in charts? Then this tip is for you.

Continue »

Pivot Tables from large data-sets – 5 examples

Published on Aug 2, 2019 in Pivot Tables & Charts
Pivot Tables from large data-sets – 5 examples

Let’s say you are starting at a large dataset with multiple columns. You need to make a pivot report from it for a client or manager. How would you go about it?

Continue »

How to conditionally format visuals in Power BI?

Published on Jul 30, 2019 in Power BI
How to conditionally format visuals in Power BI?

Do you know that you can apply conditional formatting rules to visuals in Power BI? In this post, let’s learn how to conditionally format visuals in Power BI. Something like this:

Continue »

Make info-graphics with shape fill technique [Charting Tip]

Published on Jul 11, 2019 in Charts and Graphs
Make info-graphics with shape fill technique [Charting Tip]

This is a quick, fun and elegant way to make impressive charts. You can easily create info-graphic style charts in Excel using shape fill technique. Something like this:

Continue »

Should finance people learn Power BI?

Published on Jun 14, 2019 in Financial Modeling, Power BI
Should finance people learn Power BI?

I recently went to Sydney to conduct some training programs on Advanced Excel and Power BI. While I was there, I met my good friend Danielle, who runs Plum Solutions, a financial modeling consultancy & training company. We got talking about various things and the topic eventually turned to “finance people and Power BI”. We […]

Continue »

How to trace precedents in Excel formulas? [tip+music from Prague]

Published on May 22, 2019 in Excel Howtos
How to trace precedents in Excel formulas? [tip+music from Prague]

Here is a very useful and almost secret Excel tip for you. Imagine you are looking at a big, complex workbook with lots of calculations. You want to understand where everything is pointing to and how the workbook is set up.

You can use trace precedents in Excel to do this. Read this tip to learn how it works.

Continue »

How to fake “Key influencers chart” in Excel?

Published on May 1, 2019 in Charts and Graphs
How to fake “Key influencers  chart” in Excel?

Recently, Microsoft Power BI introduced a very useful visualization, called key influencers visualization. As the name suggests, this is a chart of key parameters that effect a measure or outcome.

For example, you have customer satisfaction rating as a measure. Now you want to know which aspects of your data impact the ratings most? You can create the key influencer visual and Power BI finds all the top ranking influencers (using rules and machine learning).

But can we make it in Excel?

Let’s see…

Continue »

VLOOKUP multiple matches – trick

Published on Apr 16, 2019 in Excel Howtos, Learn Excel
VLOOKUP multiple matches – trick

We all know that VLOOKUP can find first match and return the results. But what if you want all the matches? Use this simple trick instead.

Continue »

Top 10 Excel Formulas for any situation

Published on Mar 27, 2019 in Learn Excel
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.

Continue »

Employee Turnover Dashboard – Power BI for HR

Published on Mar 8, 2019 in Power BI, Power Pivot, Power Query
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.

Continue »

Leave entitlement vs. usage analysis with Power Query

Published on Sep 24, 2018 in Excel Challenges, Power Query
Leave entitlement vs. usage analysis with Power Query

Last Friday, I asked you to analyze “sick leave entitlement vs. usage” data and answer homework questions. We got several interesting responses to that. Today, let me share a quick video highlighting how to analyze such data with Power Query.

This is part of our Power Mondays series, where every Monday you will learn something new & useful about Power BI, Power Query and Power Pivot.

Continue »

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

Published on Aug 16, 2018 in Charts and Graphs
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.

Continue »

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

Published on Aug 8, 2018 in Learn Excel
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.

Continue »