Microsoft Excel is one of the most useful tools in the Microsoft Office package. It is simple to manage, and incredibly easy to master, once you figure out all the little Ins and Outs of the program.
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.
First up is the "F4" button. In Excel, F4 is a function to repeat the last action you took in a different cell. For example, say you're working your way through a financial statement and want to mark any instances of when you went over budget in red. Where you would normally have to move your mouse up to the coloring tool at the top of the page, you can simply press F4 instead.
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.
If you select a cell and press the "=" sign and the first letter of a function you're looking for, you will be given a drop down menu to select a function. For the time being, type in "sum" until the word appears highlighted in the box.
Instead of having to go through the menu system, you can hit F7 in most versions of Word and Excel and pull up the checker instantaneously. It makes for a quick, standard shortcut to get what you know you want quickly.
People can sometimes waste a lot of money on a machine that they are not using to its full capacity. This is truly a shame, because there are people in the world who would love to have a nice machine like that, but they cannot afford it.
It's a useful function for displaying statistics in an easy-to-read format. In Word, F11 is less helpful. It is wonderful for helping you with fields. With F11, you can move to the next field.
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.
Highlight them both and hover your cursor over the bottom right-most corner of the highlighted boxes. Your cursor should change into a black cross.
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.
There are many Microsoft courses in Kuwait that you can take that will help you have to learn how to use Microsoft Office.
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.
First up is the "F4" button. In Excel, F4 is a function to repeat the last action you took in a different cell. For example, say you're working your way through a financial statement and want to mark any instances of when you went over budget in red. Where you would normally have to move your mouse up to the coloring tool at the top of the page, you can simply press F4 instead.
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.
If you select a cell and press the "=" sign and the first letter of a function you're looking for, you will be given a drop down menu to select a function. For the time being, type in "sum" until the word appears highlighted in the box.
Instead of having to go through the menu system, you can hit F7 in most versions of Word and Excel and pull up the checker instantaneously. It makes for a quick, standard shortcut to get what you know you want quickly.
People can sometimes waste a lot of money on a machine that they are not using to its full capacity. This is truly a shame, because there are people in the world who would love to have a nice machine like that, but they cannot afford it.
It's a useful function for displaying statistics in an easy-to-read format. In Word, F11 is less helpful. It is wonderful for helping you with fields. With F11, you can move to the next field.
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.
Highlight them both and hover your cursor over the bottom right-most corner of the highlighted boxes. Your cursor should change into a black cross.
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.
There are many Microsoft courses in Kuwait that you can take that will help you have to learn how to use Microsoft Office.
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 world. Strategic partnerships and affiliations with the most respectable IT training providers and vendors such as Microsoft, CISCO, Oracle, CompTIA, EC-Council, Adobe, PMI and many more.
No comments:
Post a Comment