For decades, Macro viruses are a serious problem. Does it mean that Windows, Office and VBA – all Microsoft products – are insecure? Absolutely not. Microsoft gave you the ability
Here is a list of Macros I have written for various Office tools. Usually we feel that any repetitive task requires a macro. That is a wrong concept. Typically, repetitive
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
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
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.
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
Repetitive activity? Record a macro. Right? WRONG! Find out why…
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 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.
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
