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

Prevent user from deleting rows or columns in Excel

March 2, 2017| 5 Comments

Prevent user from deleting rows or columns 1

When you are creating a Dashboard or a Report, you may have felt the need to prevent the user from deleting either rows or columns

This is how it should work – When the user tries to delete a row/column, Excel should return an error or shouldn’t let that task happen

Read More

Random Function Tricks in Excel

February 24, 2017| 5 Comments

Random Function Tricks

This post is about the RAND and the RANDBETWEEN functions of Excel and how can we play with these to

  • Generate random Alphabets (+ its variations) or
  • Generate random numbers (+ variations)
  • Generate random names from a ranges
  • Generate random cell addresses
  • Generate random dates

 

There will be a lot more things that you can generate randomly after you read this post. Let’s get going!

Read More

Indian Tech Startups Performance Dashboard

February 16, 2017| 2 Comments

Indian Tech Start Ups Performance Dashboard 1

Recently in a casual web browsing (a.k.a time wasting) session I came across an article on how the Indian Tech Start-Ups are bleeding money. The article also accompanied some basic data on revenues and losses.

Chandeep speaking to himself : “I should try making a cool graph / visualization from it”

 

The next day, a friend of mine was spamming (read sharing on) my facebook wall the same post

Chandeep speaking to himself again : “I should definitely try making a cool graph / visualization from it”

I got to work!

Read More

5 Effortless Methods to Figure Out Duplicate Values in Excel

February 9, 2017| 8 Comments

5 effortless methods to figure out duplicates values in excel featured image

Intro by Chandeep

Today we have a guest in the house. Please welcome, Puneet Gogia from ExcelChamps and he is going to teach us, 5 methods to remove duplicates in Excel.

 

Enters Puneet –

While working with large data sets, duplicate values are always a problem

No matter what, you will always get some duplicate values in your data. But the good news is, in Excel, you can find them, highlight them, and delete them in no time. Today, I will show you 5 effortless methods to figure out duplicates value in Excel.

So let’s get started.

Read More

How to add or remove data labels with a click

February 2, 2017| No Comments

Add or remove data labels with a click

When you create a chart with multiple data points, showing data labels for all the values can make the chart quite cluttered and busy. What you can do instead is add or remove data labels of the chart with a click

Let’s see how can we make this work..

Read More
© Goodly