Saturday, 28 September 2013

5 Shortcuts That Make Word And Excel Easier

By Hedrick Lepsch


If you are currently using Microsoft Office, you should feel lucky. Many people throughout the world do not have access to Microsoft Office.

Without proper Microsoft training in Kuwait, it can be a bit difficult to discover those shortcuts on your own. The following is a little training on 5 of the most helpful keyboard shortcuts to make your life easier.

First, Excel is a beast when it comes to formulas. It has the ability to automatically calculate just about any mathematical problem you can imagine.

All you need is (1) data to manipulate, (2) a couple open cells to put formulas into (which is easy with an unlimited number of cells available to you), and (3) a basic knowledge of the formulas available to you. Considering that the first is up to you and the second is given, just learn the basic commands to calculate totals.

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.

Many people do not take the time to read about Microsoft Office before they install it on their computer. They are too eager to get started working on their computer that they neglect to learn about some of the special features that are included with Office.

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.

Say you want to build an excel sheet that lists the dates of each day in a year. That's 365 dates you'd have to manually put in. Luckily for you, Microsoft has already thought of this. Write out the first two days of the year in cells A1 and A2.

You can use it to locate any symbol, word, or phrase that you want to find. With the right manipulation you can even use it for copy fitting purposes.

When you see that cross, click the mouse and drag it down. You'll see that Excel auto-fills the dates of all the cells with days of the year. It'll even include February 29 for leap years. You can also use this tool to populate the same number over and over again.

There are many Microsoft courses in Kuwait that you can take that will help you have to learn how to use Microsoft Office.

These Microsoft courses in Kuwait will help you to learn keystrokes and shortcuts that will help you save time and work and help prevent you from getting carpal tunnel syndrome by using your computer mouse so much.




About the Author:



No comments:

Post a Comment