Advanced Excel Training Courses
advance excel courses

Microsoft Excel Training Shortcuts: You Should Know About These!

Everybody is using Microsoft Excel for work, school or for many other purposes. Indeed, it is considered to be a "must have" application for those people who're mainly using the computer for their work to become more productive and for them to be more efficient. This short Microsoft Excel training lesson will teach everybody how to use the shortcut keys. If you're familiar with Microsoft Word, then definitely you'll find it easier to operate Excel as soon as you already know what the shortcut keys are, and here they are:

Enter – This is one of the simplest shortcut keys. When entering a data into a cell, pressing "Enter" will complete that action and will proceed to the next row. You don't have to manually press the arrow down key since "Enter" alone will do that.excel training

Tab – This is somehow similar to the "Enter" function, but instead of going to the next row, pressing "Tab" will complete your action and it will go to the next column on your right. Again, there is no need to press "Enter" and manually use the right and up keys to go to the cell that you prefer.

Shift + Tab – If you want to complete a cell and move to the left cell (instead of going to the right), pressing Shift + Tab will help you do that action easily.

F2 – Whenever you have an existing text or data into a cell, and you want to add up to that entry, pressing "F2" will bring you to the formula bar, and it will automatically place the insertion point towards the end of that line. All that you have to do is to click on the cell that you want to edit, press F2 and you can edit that active cell.

Alt + Enter – In most Microsoft Excel training courses, you'll see this being used most often. Whenever you wanted to insert a new line into a text or entry, but you wanted it to be in the same cell, pressing "Alt + Enter" will do the trick.

Shift F7 – There will be times that you need to edit some words and find the right words for it. You don't have to open a separate dictionary for that. Instead, press Shift F7 and Microsoft Excel will show you the default Thesaurus that is already incorporated along with the program.

They say that Microsoft Excel is actually more of a keyboard program. You will be faster and there are better chances that your entries will be more accurate if you make use of these keyboard shortcuts instead of using the traditional mouse, click, highlight tricks. Although there is nothing wrong with it, you'll notice that most Microsoft Excel training programs would discuss these basic shortcut keys. There are many others and they may seem pretty overwhelming. But as soon as you know how to use them pretty well, everything will be easier and faster for you.

There are online Microsoft Excel training courses available for you. These courses will not just teach you the shortcut keys. These will teach you more advanced lessons and more topics that will make you more productive will be covered.

<< Back to Articles

Home | Testimonials | Terms & Conditions | Contact Us | Courses | Excel manuals | Sitemap | Articles |