When you’re reading an email message in Outlook, often you will realize that you need to create a task in relation to that email’s contents. To do this, with the email open on the screen, click the Message tab and click the Follow up icon.
From the list select a task date for managing that email task. If you click Custom, you can select an appropriate flag for the email such as Follow Up, Forward or Reply and set the Start Date and Due Date for completing the task. Enable the Reminder checkbox and you can set a reminder time for the task. Click Ok to enter the email as a task.
In earlier versions of PowerPoint you could select the size for a Grow/Shrink animation. In PowerPoint 2010 it seems these features are more limited – that’s not the case but to make them more useful you need to know how the animations can be configured.
On a slide with a full size image on it, click the Animations tab and select the Grow/Shrink animation – it is an Emphasis effect.
If you select Effect Options you will see that you can select Both so the animation grows in both directions. Now select Larger or Huge. In most cases, Larger will be sufficient but notice that it appears as if you can only choose Larger or Huge as bigger sizes and that there is nothing in between these two settings. This is where you can get misled.
Click the Animation Pane icon to display the Animation pane. Right click the entry for your image in the Animation Pane and choose Effect options. See that the Size is set to 150 % but you can set it to any value of your choice using the Custom option.
For example, set it to 75%. Here too you can add Smooth Start and Smooth End to the effect and a Bounce to the end of it.
In most cases, you’ll want your animation to start immediately the slide appears so click the Timing tab, set the Start option to After Previous. Set the Duration value to your choice of speed and click Ok.
It’s best to test your animations using the slideshow preview rather than the animation pane.
Here are five cool tips, tricks and keystrokes to help your day go faster in Excel:
Display cell formulas and not results
If you want to see the cell in your worksheet display formulas rather than the results of those formulas then you can do it one of two ways.
Use the keyboard shortcut Ctrl + ~ to toggle formula display on and off
You can also use Formulas > Show Formulas
Start a new line
When you need to add a line break to a cell to start a new line of text press Alt + Enter in the cell. If you just want to wrap a long piece of text in a cell right click the cell and choose Format > Alignment tab > Wrap Text.
Copy the contents of the cell above
To copy the contents of the cell above into the current cell press Control + ‘.
Moving around super fast and super smart
To move from one sheet in a workbook to the next (or in reverse), press Control + PgDn and Control + PgUp. To move to the next open workbook press Control + Tab or Control + Shift + Tab.
Super quick mouse free SUM formula
Skip taking the mouse to your Ribbon to add a SUM function and do it with a simple keystroke instead. Type Alt + = and Excel adds the SUM function automatically to the current cell. Doesn’t get much easier than that!