|I discovered something which I have been wondering for – for a long time.And the answer was so obvious…
How to draw a reverse diagram?
Estimated reading time 3 min
This is a quick post. But it is extremely useful. Once I learnt this, I laughed at myself for not noticing it and applying it for God knows how many years …
Read on to find out how you can use this instantly. Works primarily with PowerPoint… Allows you to mix two images with just a drag action.
Office Mix is a powerful yet free add-in from Microsoft. It works with PowerPoint and helps you convert the presentation to a narrated, annotated teaching content complete with Quiz and sharing links.
It is an evolution from the powerful (yet unknown) Record Narration feature. In this article we will explore how to use Office Mix.
Yes. Mouse is a LEARNING device. Of course, originally it was intended to be a navigation tool – it still is. But if you use it smartly, you can learn a lot about the software you are using.
There are two ways to do this. Observe the mouse cursor and Right click.
Observe the mouse cursor and learn
The cursor shape changes often. It changes for a purpose. It is trying to tell you that its behavior has changed. The question is that are you noticing it?
The idea is simple – notice the change in cursor shape and try to find out what changed. That is how you learn. We do notice some of these shapes like the pointing hand and the four headed arrow. But there are more.
Here are some very useful examples of how observing the cursor shape helps you learn new things.
Pivot Table drag drop
In case of classic mode (blue border) Pivot Tables, the drag drop area shrinks when the data is small. We often end up dragging a field and dropping it in the wrong area. View this 10 second video to learn from the smart mouse cursor. (No audio)
Selecting single cell in a table
While editing long tables, it is often necessary to select a single cell. If the cell contains lot of data and it spills over to more than one page, selecting it becomes very difficult.
Watch this 12 second video to know how easy this activity becomes if you observe the mouse cursor. (No audio)
Tweaking complex animation requires you to adjust the order of animation, timing and duration. This is usually done by repeatedly opening the Effect Options – Timing dialog.
If you observe the mouse cursor in the animation pane entries, the delay, duration and start position can be adjusted very easily. Watch this 10 second video to learn how.
The power of Right Click
Usually, right clicking on any object or area reveals a menu. This menu is very special. It helps you learn a tool or software quickly and easily.
What is so special about it? This menu shows options which are guaranteed to be relevant in the context of the place you right clicked on. That is why, it is called “Context Menu”.
The options shown in the context menu may be available inside the traditional menus as well. But these options may be scattered across different tabs and toolbars. Right click menu consolidates relevant options and shows these in one place.
Therefore, you simply have to right click on every object, notice each option, think a little about it, try it out if the meaning is not obvious… and you start learning immediately.
This is a simple but very powerful technique. Try this for a few days and let me know the feedback.
Important areas to right click in…
Right click at various places within the table to discover more features.
Right click within Tables and Pivot Tables (Row and Data area separately) to learn about many new features. Pivot Table Data area has an option called Show Values As… which is the most powerful feature of Pivot Table.
Right Click whenever the cursor shape changes
Finally, let us put both items together. When cursor shape changes – its behavior changes – its context changes … therefore, the right click menu also changes.
Changing cursor is inviting you to explore more by opening the right click menu … accept the invitation and learn more.
This article assumes that you are a right handed person, if you are a left handed person, you have to use the other mouse button (secondary mouse button).
Drag and drop performs most popular action
When you drag and drop items, the most commonly expected logical action happens. For example, when you drag a file from one folder and drop it into another folder, it is moved.
That is called the DEFAULT ACTION.
Another example is… when you drag a number from the corner of the cell, it automatically adds further numbers.
This is a good thing in most cases. But if you don’t like the default or standard action, then you have a problem. To solve this issue, there is RIGHT DRAG DROP.
Press the RIGHT mouse button while dragging
That is called Right Drag (Drop). So what is the big deal? What benefits do you get?
Right Drag Drop shows you all the actions available
Here is what happens if you right drag drop a file… The item in bold tells you what is the default action.
Right drag a number in Excel
Right drag a shape in PowerPoint
Right drag a mail from Inbox and drop it into Task folder
The list is endless…