Here are some tips you can use when utilizing Microsoft Word, PowerPoint, and Excel for school or your business.
Microsoft Office Tips, Tricks, and Techniques
Microsoft Word
Microsoft created the word processor. It was initially made available on October 25, 1983. Microsoft Word is a word processor that enables you to produce documents, reports, letters, and resumes that have a professional appearance. Microsoft Word provides capabilities including text formatting, spell checking, grammar checker, fonts, HTML support, image support, advanced page layout features, and more, in contrast to a plain text editor.
Select Text Quickly
You can triple-click anywhere within a paragraph to select the entire paragraph in Word. Or press the CTRL key and click anywhere within the sentence to select the entire sentence. You can also choose rectangular blocks of text in a Word document, similar to the marquee tool in Photoshop, and apply formatting to the selected area. Hold down the ALT key and drag your mouse to select any rectangular area.
Change the Sentence CASE
Select some text in Word and press Shift+F3 to quickly change the case of the selection. It toggles between UPPERCASE, lowercase, and Camel Case (first letter in the capital) and should come in handy if you’ve accidentally left the CAPS LOCK key on while typing.
Write Anywhere on a Page
Did you know that you can use your Word document as a whiteboard and write your text anywhere on the page? Just double-click wherever you want to type your text and start writing.
Move Text without Copy-Paste
Most people use the Cut-Paste (Ctrl-x Ctrl-v) route to move text from one location to another within a Word document but there’s an alternate way as well. Highlight any block of text, press F2, and then place the cursor at the spot where you wish to move that text. Press Enter and the selection will be moved.
Add Placeholder Text
There’s a Lorem Ipsum generator built inside Word to help you insert filler text anywhere inside the document. Type =rand(p,l) and press Enter to insert the ‘p’ number of paragraphs each having ‘l’ lines. For instance, =rand(3,6) will generate 3 dummy paragraphs with 6 lines each.
Other tips:
1. Ctrl + click selects sentence. Click anywhere in a sentence while holding the Ctrl key down will select the sentence
2. To create a horizontal line type 3 hyphens and then press Enter
3. Pressing backspace while holding the Ctrl key down deletes the preceding word
4. Select some text. Now if you will press Ctrl + Shift + > the font size of the selected text will increase. To decrease the font size use Ctrl + Shift + < combination
5. To quickly create a table type a plus sign (+) then press the Tab key; again type a plus and again press the Tab key; do this as many times as the number of cells you want in your table. Then press Enter. And table shall appear!
6. To add the date, you just press Shift + Alt + D. The same works with time, but there you should press Shift + Alt + T.
Microsoft Excel
Microsoft Corporation created and produces software that enables users to arrange, format, and compute data using formulas utilizing a spreadsheet system divided up by rows and columns.
In 1982, Microsoft began to promote a spreadsheet program under the name Multiplan. On CP/M systems, Multiplan rose to fame, but Lotus 1-2-3 overtook it on MS-DOS platforms. On September 30, 1985, Microsoft launched the first version of Excel for the Macintosh, and in November 1987, Microsoft released Windows version 2.05 (to coincide with the Macintosh version 2.2).
1. ALT+ Inserts a SUM formula.
2. CTRL+TAB Switches between open Excel windows.
3. F2 Edits the active cell and positions the insertion point at the end of the cell contents. It also moves the insertion point into the Formula Bar when editing in a cell is turned off.
4. F7 Runs Spell Check on the entire worksheet if only one cell is selected, otherwise Spell Check the selected range. You can also spell-check multiple sheets by grouping them first.
5. AutoFill a Series or Formulas – Double Click on the + symbol on the bottom right of a cell adjacent to the range you want to fill. E.g. “Monday Tuesday 1 2 3 4 a b c d January February march”
6. Delete blank cells in a row or column – Highlight the column or row containing cells you want to delete. Press CTRL+G to open the Go To Dialog Box > Special > Blanks. Delete cells, rows, or columns.
7. Synchronous Scrolling – want to compare two workbooks and have them both scroll at the same time? With two workbooks open: For Excel 2003 > Window > Compare Side by Side > Synchronous Scrolling For Excel 2007+ > View tab of the ribbon > View side by side > Synchronous Scrolling.
8. You can lock your worksheet. Review -> Protect Worksheet.
9. Find the number of days between two dates – Enter your dates in this formula inside double quotes ="20/6/2011"-"28/10/2006" Result = 1696
10. Speedily Move and Copy Data in Cells. If you want to move one column of data in a spreadsheet, the fast way is to choose it and move the pointer to the border, after it turns to a crossed arrow icon, drag to move the column freely. What if you want to copy the data? You can press the Ctrl button before you drag to move; the new column will copy all the selected data.
Microsoft PowerPoint
The presentation program included in the Microsoft Office package is PowerPoint 2010. Forethought Inc. developed PowerPoint, which was originally called "Presenter." On May 22, 1990, Microsoft's version of PowerPoint had its public debut. One of the most popular slide-based presentation software options today, PowerPoint, is helpful in the development of the slide-based presentation structure. Microsoft has also made the PowerPoint mobile application available for use with Apple and Android mobile operating systems.
1. Start a presentation from the beginning – F5
2. Perform the next animation or advance to the next slide - N, ENTER, PAGE DOWN, RIGHT ARROW, DOWN ARROW, or SPACEBAR.
3. Perform the previous animation or return to the previous slide - P, PAGE UP, LEFT ARROW, UP ARROW, or BACKSPACE.
4. Go to slide number - number+ENTER.
5. Change the pointer to a pen - CTRL+P.
6. Change the pointer to an arrow - CTRL+A.
7. Change the pointer to an eraser - CTRL+E.
8. Use the Presenter View.
No comments:
Post a Comment