 |
 |
 |
 |
 |
 |
 |
|
 |
|
|
|
|
|
-
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
Cycles you through open programs and windows Cycles you backward through the same list Close the current program or window Open the Start Menu 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
To enter the current date To enter the current time in a document, To insert the current page number in a document Selecting Techniques
I-beam Selection Methods
Double click CTRL + click Drag Click - Shift/Click Triple click Selection Bar Selecting Methods
Click Double-click Drag CTRL + click Triple Click Microsoft PowerPoint Tips and Tricks
Keyboard shortcuts for working in PowerPoint’s Outline viewIf 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 EnterDisplaying 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 boxType 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.TOP
Monroe Business Associates, LLC
35 Corporate Drive, Suite 1095, Trumbull, CT 06611
Phone (203) 452-8390
E-Mail: train@monroebusiness.com
