Tag Archives: Macros

Amount to Words macro

Here is a new year gift for the Indian customers. Converting Amount to Words is always a problem. Many application require it and that code is always written manually, within the application. What is really needed is a comprehensive Excel function. Many people have written lots of Excel functions. But neither of them is specific to India, nor is it comprehensive.

We (Raj and me) had created it in 2005, but I had forgotten to publish it on the blog. We have done good amount of testing – but still you have to use it at your own risk. No guarantees. Read on to download, install and use the Excel function.

Amount to Words banner

Continue reading Amount to Words macro

Split text into words or characters: Macro

In the earlier post, we saw how boring text can be converted into interesting and high-impact slides. The only pending problem was that splitting text into words or characters needed to be done manually. That is a tedious process. Therefore, I wrote a macro to simplify this activity. Read on to find out how to download and use this macro.

Split Text Macro

Continue reading Split text into words or characters: Macro

How to make a picture transparent – Macro

In an earlier article, I had shown a method of making a picture transparent using the Transparency animation. This method shows the transparency only while PRESENTING – not while EDITING. Here is a macro which will help you create a transparent copy of any picture which is transparent during editing as well.

transparent image macro

Continue reading How to make a picture transparent – Macro

Macro to Explode Pivot table by Filter Field Items

Refer to the previous post. We saw how Filter fields can be exploded into individual sheets and files. In this article, I am releasing a macro – which does all the hard work for you. Of course, you must use it at your own risk. The source code is also included for you to view, learn from and modify. Created by Raj Chaudhuri and myself.

PivotFilterExplode macro

Photo credit: Johnson Cameraface / Foter / CC BY-NC-SA

Continue reading Macro to Explode Pivot table by Filter Field Items

Paste as Pivot – New way to use Pivot table data

I created this Paste as Pivot utility (macro) along with Raj Chaudhuri. It helps you in copying cells from Pivot Table and pasting them as GetPivotData functions. You must read this article about GetPivotData in order to understand the background information.

Paste as pivot macro

Estimated reading time 8 min

Continue reading Paste as Pivot – New way to use Pivot table data

New Excel Tool: Scribble a line and generate data (and chart)

This is a utility I created along with Raj Chaudhuri many years back.Use the scribble tool to draw a waveform or shape, the utility will create the data for it.

Excel scribble tool

You can then create a line chart which looks similar to original drawing.
Try it out.

Continue reading New Excel Tool: Scribble a line and generate data (and chart)

Marketing: How to create “Our Customers” Slide in seconds

Any corporate sales presentation usually have a “our customer” slide. Usually creating such a slide is very cumbersome because the logos come in all shapes and sizes. Someone has to spend inordinate amount of time resizing and aligning all the logos – and often, the slide still looks shabby Sad smile Devil … Here is a method which will solve your problem instantly.

how to create our customers slide in seconds by Dr. Nitin Paranjape

Continue reading Marketing: How to create “Our Customers” Slide in seconds