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

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

Broadcast Your Presentation !

December 9, 2014| No Comments

Broadcast Your Presentation

Lets assume a typical meeting scenario at office. Senior executives in India have a presentation to deliver to UK clients and to save costs it is happening over a call! Assuming that you have a powerpoint presentation to share with your clients, which can be done in many ways

  • You email it to your clients
  • You upload it to teamviewer or a software

PowerPoint brings you a pretty awesome Broadcast Presentation feature. It runs the presentation online just as you were delivering the presentation live! minus the PHYSICAL YOU! Lets take a dive..

Read More
© Goodly