Microsoft Office has a number of useful keyboard shortcuts to keep your work flowing without requiring an exploration of its menu system. Each shortcut can help you format, manipulate, and otherwise work with your content easily.
Many people are actually using an outdated version of Microsoft Office. This is truly unfortunate because the newest versions of Microsoft Office are faster and much easier to use.
One of the most overlooked features of Microsoft Office is the clipboard feature. The older versions of Office only let you hold one item under the clipboard at a time. But with newer versions of Office, you can put about 24 items under the clipboard. This makes organizing and prioritizing your work much, much easier.
You can even install certain clipboard extender apps that will allow you to store even more items under your clipboard. These apps have been highly reviewed by Microsoft Office users everywhere.
Pretty much any action in the tool bar above can be duplicated on different cells by simply pressing F4. You can use the button in Microsoft Word to automatically copy and paste the last string of words that you wrote without pause. Second is F7. F7 automatically calls out the spelling and grammar check.
Without pressing enter just yet, open a parenthesis so it looks like this: "=sum(." Then click the first box you want the sheet to sum. Then, while holding shift, click the last box you want it to add in. Click "enter" to make it automatically add all of the selected boxes. Instead of clicking the boxes, you can also add the individual cells into the formula by naming them: letter, number (like this: E27). Separate the different boxes with commas to complete the formula.
Third is F11. In excel, F11 creates an automatic bar chart out of the selected cells and opens up the chart options to customize however you would like.
These people would put the machine to much better use than the people who do not know what they are doing on their machine. Another commonly overlooked feature that Office includes is a feature that helps you pull up recently used files.
In older versions of Microsoft Office, you would be able to access recently used files by typing in Alt-F1, and then typing the number of the document you would like to pull up. This feature is not included on newer versions of Office, but there is still an efficient way to access recently used documents.
All you have to do is enter Backstage View, select Recent, and then add a checkbox next to "Quickly access this number of recent documents." You then will enter in the number of recent documents you would like to be able to access.
Fifth and finally is Ctrl + K. This function allows you to add a hyperlink in both Word and Excel. Simply highlight the text or cell that you want to hyperlink elsewhere, and press Ctrl and K. Make your link and hit okay without ever having to use the mouse.
Fill in one cell with a "1" for example. Hover the cursor over the bottom right-most corner of the cell and click on the black cross again. Drag down a couple cells and release the button. The cells will auto populate with the number 1.
With proper Microsoft training in Kuwait, you could easily become a master of the programs. Sign up for additional Microsoft training in Kuwait if you're interested in learning more useful shortcuts.
Many people are actually using an outdated version of Microsoft Office. This is truly unfortunate because the newest versions of Microsoft Office are faster and much easier to use.
One of the most overlooked features of Microsoft Office is the clipboard feature. The older versions of Office only let you hold one item under the clipboard at a time. But with newer versions of Office, you can put about 24 items under the clipboard. This makes organizing and prioritizing your work much, much easier.
You can even install certain clipboard extender apps that will allow you to store even more items under your clipboard. These apps have been highly reviewed by Microsoft Office users everywhere.
Pretty much any action in the tool bar above can be duplicated on different cells by simply pressing F4. You can use the button in Microsoft Word to automatically copy and paste the last string of words that you wrote without pause. Second is F7. F7 automatically calls out the spelling and grammar check.
Without pressing enter just yet, open a parenthesis so it looks like this: "=sum(." Then click the first box you want the sheet to sum. Then, while holding shift, click the last box you want it to add in. Click "enter" to make it automatically add all of the selected boxes. Instead of clicking the boxes, you can also add the individual cells into the formula by naming them: letter, number (like this: E27). Separate the different boxes with commas to complete the formula.
Third is F11. In excel, F11 creates an automatic bar chart out of the selected cells and opens up the chart options to customize however you would like.
These people would put the machine to much better use than the people who do not know what they are doing on their machine. Another commonly overlooked feature that Office includes is a feature that helps you pull up recently used files.
In older versions of Microsoft Office, you would be able to access recently used files by typing in Alt-F1, and then typing the number of the document you would like to pull up. This feature is not included on newer versions of Office, but there is still an efficient way to access recently used documents.
All you have to do is enter Backstage View, select Recent, and then add a checkbox next to "Quickly access this number of recent documents." You then will enter in the number of recent documents you would like to be able to access.
Fifth and finally is Ctrl + K. This function allows you to add a hyperlink in both Word and Excel. Simply highlight the text or cell that you want to hyperlink elsewhere, and press Ctrl and K. Make your link and hit okay without ever having to use the mouse.
Fill in one cell with a "1" for example. Hover the cursor over the bottom right-most corner of the cell and click on the black cross again. Drag down a couple cells and release the button. The cells will auto populate with the number 1.
With proper Microsoft training in Kuwait, you could easily become a master of the programs. Sign up for additional Microsoft training in Kuwait if you're interested in learning more useful shortcuts.
About the Author:
Infocenter training company is simply The House of Certification for many international Learning Partners around the globe. Strategic partnerships and affiliations with the most reputable IT training providers and vendors such as Microsoft, CISCO, Oracle, CompTIA, EC-Council, Adobe, PMI and many more.
No comments:
Post a Comment