Tag Archives: Utility

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)

Zoom Knowledge Pack for High Impact Demos and Presentations

I wrote many articles recently about using ZOOM while presenting. I originally thought I will write only one article, but ended up writing 6.

This Zoom KNOWLEDGE PACK will guide you to the right article, depending upon what you need.

Continue reading Zoom Knowledge Pack for High Impact Demos and Presentations

What did I learn today: Preview Full Screen in Windows Magnifier

I wrote three articles about zooming in while showing technical / software demos. I covered the Windows Magnifier (core features and detailed features) and ZoomIt tool.

I learnt a very useful which I myself had not discovered for so many years. Here it is…
Continue reading What did I learn today: Preview Full Screen in Windows Magnifier