I started this blog with articles about Copy Paste. Now this is article no 307.This knowledge pack contains 19 articles. I strongly recommend that everyone should go through these articles. It is a life changing experience!
Estimated reading time 40 min
Pivot Table is based upon the current block of data.Sooner or later you are going to update the data.
Creating a table eliminates the need for refreshing the new range manually.
Estimated reading time 4 min.
Continue reading Best Practice: Always create a Table before creating Pivot Table
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.
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)
This is an interesting feature of Word since its earliest version. It allows you to generate random text – and lots of it.
You’d probably be asking yourself: Who needs random text and why?
Read on to find out …
Estimated reading time 7 min
Continue reading How to create lots of random text quickly and why?
Please read the earlier article Efficiency Test 4: Word. The challenge was to format Word tables in the most optimal way.
Here is the solution. You need a total of 10 clicks.
Reading time 10 min. (Why 10 minutes to understand 10 clicks? Because you are not just learning where to click. You are learning how to communicate with Word in a language it understands!)
Continue reading Efficiency Test 4 : Format Word Tables Solution