# Weekend Reading: Copy Paste Knowledge Pack

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!

# Best Practice: Always create a Table before creating Pivot Table

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.

# 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.

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

# How to create lots of random text quickly and why?

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 …

# Efficiency Test 4 : Format Word Tables Solution

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!)

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

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.

# Instant calculation with the amazing OneNote Calculator

OneNote has a very nice and handy calculator. Start using it NOW.

# Using Formulas in Word tables

Did you know Word can contain formulas? Yes. It can.

For simple calculations you don’t need to use Excel.

Estimated learning time 5 min

# Amazing OneNote and Excel integration

This feature is so nice and so simple,  I want you to learn it right now.  And trust me, once you know it, there will be no turning back!

Estimated Reading Time Just 2 min