Weekend Reading: Copy Paste: Knowledge Pack

image 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

Continue reading

Posted in Office | Tagged , , | Leave a comment

Best Practice: Always create a Table before creating Pivot Table

image 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

Posted in Analytics, Excel, Uncategorized | Tagged , , , | 2 Comments

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

image 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

Posted in Charts, Excel, Macros, Uncategorized, Utility, VBA | Tagged , , , , | 1 Comment

How to create lots of text quickly and why?

image This is an interesting feature of Word since its earliest version.It allows you to generate random text – and lots of it.

Who needs random text and why?

Read on to find out …

Estimated reading time 7 min

Continue reading

Posted in PowerPoint, Word | Tagged , | 1 Comment

Word: Efficiency Test 2 – Solved

Please read the earlier article Word: Efficiency Test 2. The challenge was to perform table formatting tasks 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

Posted in Efficiency Test, Tables, Word | Tagged , , | Leave a comment

Word: Efficiency Test 2

The first Word Efficiency test was very popular. So here is another one. This time we talk about commonly required table formatting. If you don’t know the efficient method, you will waste a lot of time. If you know the right way, it takes few seconds. Continue reading

Posted in Efficiency Test, Word | Tagged , | 4 Comments

How vs. Why: the right approach to teaching and learning

image In our busy lifestyle, we are always looking for Tips and Tricks.That is called HOW approach – which is spoon feeding.I prefer the WHY approach – which creates knowledge.

Read on to find out the difference.

Estimated reading time 10 min

Continue reading

Posted in Concepts, Find, Word | Tagged , , | Leave a comment