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
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 Efficiency Test 4: Word table formatting
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 How vs. Why: the right approach to teaching and learning
OneNote has a very nice and handy calculator. Start using it NOW.
Estimated Reading Time 3 min
Continue reading Instant calculation with the amazing OneNote Calculator
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
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