Boost your productivity with

Smart Ebooks on
Excel & PowerPoint Presentations




Hi, Welcome to Goodly! My name is Chandeep

Chandeep

I do consulting and training on MS Excel, Business Intelligence Dashboards,
Business Plans / Financial Models and PowerPoint Presentations

I am putting together everything about Excel and PowerPoint Presentations
that I have learnt (and still learning) on this blog

Get started here by following these resources

Infographics Chart in Excel Part 1

March 15, 2016| No Comments

Infographics Chart in Excel
The source of inspiration for this chart came when Shuttershock was charging me for downloading a similar infographic chart. I din’t buy, I am thrifty 😉 It helped me save a couple of bucks and also come up with a way to make an infographic chart in Excel

Let’s do this together! Shall we?

Read More

How to Sum Digits of a Number

March 11, 2016| 2 Comments

How to Sum Digits of a Number

The roots of this blog post come from the following conversation from one of my training sessions

Participant : “Chandeep, the other day I went with my wife to buy a new mobile number. Since my wife is a bit finicky about astrology, she requested the shopkeeper to show us mobile numbers totaling to 9. The shopkeeper, along with his dirty looks sent me a dump of numbers and asked me to do it myself”

Me : I was trying to come up with a formula while he sharing his ordeal of manually totaling up phone numbers

Let’s dedicate this blog post to that lady and to everyone else who needs a total of digits

Read More

Target Charts in Excel – Video Tutorial

March 8, 2016| 7 Comments

Target Charts

With the Indian financial year end approaching, there could not be a better time to talk about target charts.

Although, I can’t help you much with your business targets but I can help you create stunning target charts. I promise they’ll look stunning even if  your targets are not met. And that was a Joke! 😆

Let’s begin with 2 different types of target charts

Read More

How to Re-arrange Data for a Pivot Table

March 4, 2016| 1 Comment

Rearrange data for Pivot Table

If you and I interact on emails, you know that I asked you this question. Nevertheless even if you are a first timer, let me start from the top and explain you the case

Take a look at the data below.

Rearrange data for Pivot Table 1

Nothing much to explain, we have a matrix with

  • Employee Code
  • Level
  • Joining Date
  • And against each employee code we have 24 months of Salary (depending on joining date)

So, if I asked you a question – Tell me the Level wise, salary payout quarter by quarter in the year 2014 and 2015? How would you solve this question

If you are an avid pivot table user you’ll notice 2 things

  1. You can solve this under 30 Seconds
  2. But the problem is that this data is not kept in way, which can be used in a pivot table
Read More

How to extract unique values from a range – 2 Ways

March 1, 2016| 1 Comment

Extract Unique Values 1

Often we need to extract unique values from a range of data. Although to do that there is already a built in Remove Duplicates feature in Excel. But here are 2 more ways to do it

Read More
© Goodly