| Microsoft Windows
Tips and
Tricks |
Selecting Multiple Files
Multiple adjacent files can be selected in Explorer or My Computer by clicking dragging
a box around them with your mouse.
Keyboard shortcuts with the
Microsoft Natural Keyboard
Deleting Files without Moving them
to the Recycle Bin
1. Select the files to be deleted.
2. Hold the Shift key and press Delete.
More Keyboard Shortcuts
| Microsoft Word Tips and Tricks |
A
Shortcut For Increasing And Decreasing Font Size
Highlight
the text and press the [Ctrl] and ] keys until the text is large enough.
Each time you press this key combination, Word will enlarge the text by
one point. To make the text smaller, highlight it and press the [Ctrl] and
[ keys until the text is the size you want.
[Alt][Shift]
shortcuts
Selecting
Techniques
I-beam Selection Methods
Selection
Bar Selecting Methods
| Microsoft PowerPoint Tips and Tricks |
Keyboard
shortcuts for working in PowerPoint’s Outline view
If you work
in Outline view, your hands are probably on the keyboard more than on
the mouse. Here are a few keyboard shortcuts you can use in Outline view
to avoid using your mouse. You can use the shortcuts to promote and
demote paragraphs and to move selected paragraphs up and down in Slide
view too.
Slide
Transitions Messages
|
Positive,
Moving Forward Message |
Choose
any transition that contains Right or Up in the name. |
| Negative,
Moving Backward Message |
Choose
any transition that contains Left or Down in the name. |
| Quick
Pace Message |
Choose
either Cut or Cut Through Black |
A
trick to move charts from Excel to PowerPoint
There
are many ways to move data from one application to another, but if that
data is a chart, there is a simple way that many users don't utilize.
For example, if you've created a chart in Microsoft Excel, a quick and
simple way to place that chart on a slide is to use the drag-and-drop
method. Simply select the object you want to move, in this case the
Excel chart, and drag it into the PowerPoint document window. You can
also use this technique with any application that supports OLE.
Nudging Objects
| Arrow
Keys |
Select
the object and use the arrow key
(1
1/12th of an inch) |
| CTRL
+Arrow |
Move
1 pixel at a time |
Working with Objects
1. To change an objects shape, choose Change AutoShape from the Draw menu.
2. To resize an object, choose Scale from the Objects menu, enter percentage, and click
okay.
To Quickly Rearrange Your Slides
1. Click the Titles Only button so your slide titles are showing in the outline.
2. Drag the titles to reorder your slides.
3. When finished, click the Titles Only button to turn it off so that all your body text
shows.
Duplicating Your Current Slide
Layout
1. Hold down the Shift key as you click the New Slide button on the standard toolbar or
the New Slide button on the Common Tasks toolbar. This can be used while in Slide
view or Slide Sorter view.
| Microsoft Excel Tips and Tricks |
Despite its title, the Currency button on the
Formatting toolbar actually assigns the Accounting format to a selected
range of cells. This format
differs from the traditional Currency format in that it aligns the
currency symbols and decimal points in a column, making it easier to
analyze lots of values.
Function Key
Shortcuts
Bullets in Excel
-- A Handy Workaround
To allow Excel to treat the numbers as numbers and
still have them bulleted:
- Insert
a bullet symbol into a Word document.
- Copy
and paste the bullet into the cells directly to the left of your
numbers in your Excel document.
- When
you right-align the bulleted cells, it places the bullets against
the numbers so it looks just like a bulleted list.
Add a column of
numbers quickly without using the Autosum button.
1.
Make sure you’re in the correct cell where you want your answer.
2.
Press the Alt key and the = (equals) sign after that.
3.
Simply press Enter and it’ll automatically sum up the column.
Add a column of
numbers
1. Select the cell where you want your answer.
2. Press the ALT key and the = sign.
3. Press Enter
Displaying Formulas
1. Press the CTRL + ` key (top left key on most keyboards) to toggle the show formula
in cell option on.
2. Press the CTRL + ` key again to toggle the show formula in cell option off.
Creating or Editing Notes
1. Select the cell you either wish to add or edit a note.
2. Press SHIFT + F2 and the Note dialog box will show.
3. Add or edit your note and press OK.
4. The note is visible with a red dot in the cell. If you drag your mouse on the cell the
note will show.
Show Degree Symbol
To make a number show the degree symbol
1. Type the number followed by "O" (letter).
2. Select the "O".
3. Select Cells from the Format menu.
4. Select the superscript check box
Type a Number to a Power
1. Type the number immediately follow by a space.
2. Type the power number
3. Select the power number.
4. Select Cells from the Format menu.
5. Select the superscript check box.
Monroe Business Associates, LLC
35 Corporate Drive, Suite 1095, Trumbull, CT 06611
Phone (203) 452-8390
E-Mail: train@monroebusiness.com