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

4 Quick custom number formats for dates!

January 4, 2015| No Comments

Quick custom date formats

 

A while ago I wrote a post on how to use custom formatting in excel. Let’s take a look at some interesting custom formatting codes for dates

Read More

Numbers in Indian Currency Words!

January 1, 2015| 1 Comment

Numbers in words

I have got this request a zillion times: How can I convert a number into Indian Currency? Ok not a zillion times but at least a 100 times 😛 In the pain of those countless minutes spent in manually typing (which is also prone to mistakes) the numbers into words, I hereby present a Macro (VBA Code, which is not mine)! Simple, Quick and Sexy!

Read More

Grouping Feature in Pivot Tables!

December 29, 2014| 2 Comments

Grouping Feature in Pivot

The Grouping feature is a pretty awesome (and incredibly quick) technique to do time series (quarters, years, months or more types of) analysis with a couple of clicks. Also (over the years) I have realized that a lot of people don’t know about this. Nothing better than if you know it, If not then lets take a dive.. Shall we?

Read More

The long lost DATEDIF

December 21, 2014| 1 Comment

Datedif

Somethings just stay evergreen, just like the DATEDIF function! Back in day (days of Excel 2003) it used to be a stud amongst the Date Functions and it has not lost its sheen till date but the newer versions of excel (2007 and above) have stopped giving any help or guidance with this function

Read More

Just for fun! A Reverse Analogue Timer!

December 12, 2014| 3 Comments

Reverse Analogue Timer

The image is moving faster (than actual), just to show a reducing time effect 😛

This is what one can end up doing, with meaningless exploration in Excel! 😆 I created this many weeks back seeing the idea of Speedometer Chart, which I now use in my training programs as an automated clock for playing time bound excel games!!

It is just made up of simple time function formulas, pie and doughnut charts. Go ahead fiddle with it! Here is the downloadable file for you!

Read More
© Goodly