The tutorial below will get you up and running with Excel 2007. It covers data entry, formatting, charting with a secondary axis and customizing the quick access toolbar.
Enjoy!
Wednesday, May 11, 2011
Up and Running With Excel 2007
Microsoft has dramatically changed its Office suite from the 2003 version. At first glance, you may be wondering why; I want the old version back. Though, a few minutes using it, you will realize that it is easier and enhanced with a bevy of new features!
The tutorial below will get you up and running with Excel 2007. It covers data entry, formatting, charting with a secondary axis and customizing the quick access toolbar.
Enjoy!
The tutorial below will get you up and running with Excel 2007. It covers data entry, formatting, charting with a secondary axis and customizing the quick access toolbar.
Enjoy!
Monday, October 22, 2007
Microsoft Office 2007 New Features
With the new release of Office 2007, Microsoft has completely revamped the user-interface and the way we use the application. At first blush, it is very confusing, and may even make you frustrated. In all honesty, it took me some time to get used the new concepts and usability. You no longer have to be a power-user to get the most out of Office, as the design has become very intuitive and friendly.
The first thing that will hit you is that menu bars are gone. They have been replaced by a new term called “Ribbons”. The ribbons are tabs categorized by the features you prominently use. When you start Excel, the ribbons you will see are: Home, Insert, Page Layout, Formulas, Data, Review, View, Developer and Add-Ins.
Contextual-tabs will appear when the functionality is available. Once it is no longer applicable, it disappears. An example of this is would be if you where to insert a picture into your document, a new tab will appear in the ribbon called “Picture Tools”. As you guessed it, the picture tools tab will contain picture related functionality. Once I click or move away from the picture, the picture tools contextual-tab will disappear.
Prior to Office 2007, format modification would be a pain-staking and time-consuming process. First, you would make the change only to undo and try a different option. This process would continue until you found one you liked or just gave up. With the new galleries, this ordeal can finally be put to rest. Galleries are visual representations of the change. This real-time preview enables you to see what the outcome will be before you actually commit the modification.
Tool-tips have been enhanced to not only name the feature, but describe it as well.
The “Office Button”, located to the top left of every window, enables you to quickly see other functionality that you can do with your document. The most common features are Open, Save, Print, Sharing, etc.
To the right of the office button the “Quick Access Toolbar”. This customizable toolbar contains frequently used commands. You can customize it by right clicking on the toolbar and selecting the appropriate command.
A “Mini-Toolbar” becomes visible when you highlight text for formatting. The Mini toolbar helps you work with fonts, font styles, font sizing, alignment, text color, indent levels, and bullet features.
At the bottom right-hand corner of every window will be the various views you’ve come to expect. One nice feature is the zoom level slider. You can easily zoom or zoom out simply by dragging the slider. You can just as easily go back to 100% by clicking on the center point.
If you need to send your 2007 documents to people that use prior versions of Office, make sure you save the document as a 97 - 2003 format, because the new format is saved as .???X (Excel example: XLSX) format.
As you can see, Microsoft has really done a nice job with Office 2007. It is not just a version upgrade, but rather a whole new way of creating compelling documents with total ease. Give it a try. You’ll be glad you did.
The first thing that will hit you is that menu bars are gone. They have been replaced by a new term called “Ribbons”. The ribbons are tabs categorized by the features you prominently use. When you start Excel, the ribbons you will see are: Home, Insert, Page Layout, Formulas, Data, Review, View, Developer and Add-Ins.
Contextual-tabs will appear when the functionality is available. Once it is no longer applicable, it disappears. An example of this is would be if you where to insert a picture into your document, a new tab will appear in the ribbon called “Picture Tools”. As you guessed it, the picture tools tab will contain picture related functionality. Once I click or move away from the picture, the picture tools contextual-tab will disappear.
Prior to Office 2007, format modification would be a pain-staking and time-consuming process. First, you would make the change only to undo and try a different option. This process would continue until you found one you liked or just gave up. With the new galleries, this ordeal can finally be put to rest. Galleries are visual representations of the change. This real-time preview enables you to see what the outcome will be before you actually commit the modification.
Tool-tips have been enhanced to not only name the feature, but describe it as well.
The “Office Button”, located to the top left of every window, enables you to quickly see other functionality that you can do with your document. The most common features are Open, Save, Print, Sharing, etc.
To the right of the office button the “Quick Access Toolbar”. This customizable toolbar contains frequently used commands. You can customize it by right clicking on the toolbar and selecting the appropriate command.
A “Mini-Toolbar” becomes visible when you highlight text for formatting. The Mini toolbar helps you work with fonts, font styles, font sizing, alignment, text color, indent levels, and bullet features.
At the bottom right-hand corner of every window will be the various views you’ve come to expect. One nice feature is the zoom level slider. You can easily zoom or zoom out simply by dragging the slider. You can just as easily go back to 100% by clicking on the center point.
If you need to send your 2007 documents to people that use prior versions of Office, make sure you save the document as a 97 - 2003 format, because the new format is saved as .???X (Excel example: XLSX) format.
As you can see, Microsoft has really done a nice job with Office 2007. It is not just a version upgrade, but rather a whole new way of creating compelling documents with total ease. Give it a try. You’ll be glad you did.
Wednesday, August 29, 2007
How to Use Excel 2003 Keyboard Shortcuts -- Other Keys
Below are the Microsoft Excel 2003 Keyboard Shortcuts for Other Keys:
| Key | Description |
|---|---|
| ARROW KEYS | Move one cell up, down, left, or right in a worksheet. CTRL+ARROW KEY moves to the edge of the current data region (data region: A range of cells that contains data and that is bounded by empty cells or datasheet borders.) in a worksheet. SHIFT+ARROW KEY extends the selection of cells by one cell. CTRL+SHIFT+ARROW KEY extends the selection of cells to the last nonblank cell in the same column or row as the active cell. LEFT ARROW or RIGHT ARROW selects the menu to the left or right when a menu is visible. When a submenu is open, these arrow keys switch between the main menu and the submenu. DOWN ARROW or UP ARROW selects the next or previous command when a menu or submenu is open. In a dialog box, arrow keys move between options in an open drop-down list, or between options in a group of options. ALT+DOWN ARROW opens a selected drop-down list. |
| BACKSPACE | Deletes one character to the left in the Formula Bar. Also clears the content of the active cell. |
| DELETE | Removes the cell contents (data and formulas) from selected cells without affecting cell formats or comments. In cell editing mode, it deletes the character to the right of the insertion point. |
| END | Moves to the cell in the lower-right corner of the window when SCROLL LOCK is turned on. Also selects the last command on the menu when a menu or submenu is visible. CTRL+END moves to the last cell on a worksheet, in the lowest used row of the rightmost used column. CTRL+SHIFT+END extends the selection of cells to the last used cell on the worksheet (lower-right corner). |
| ENTER | Completes a cell entry from the cell or the Formula Bar, and selects the cell below (by default). In a data form, it moves to the first field in the next record. Opens a selected menu (press F10 to activate the menu bar) or performs the action for a selected command. In a dialog box, it performs the action for the default command button in the dialog box (the button with the bold outline, often the OK button). ALT+ENTER starts a new line in the same cell. CTRL+ENTER fills the selected cell range with the current entry. SHIFT+ENTER completes a cell entry and selects the cell above. |
| ESC | Cancels an entry in the cell or Formula Bar. It also closes an open menu or submenu, dialog box, or message window. |
| HOME | Moves to the beginning of a row in a worksheet. Moves to the cell in the upper-left corner of the window when SCROLL LOCK is turned on. Selects the first command on the menu when a menu or submenu is visible. CTRL+HOME moves to the beginning of a worksheet. CTRL+SHIFT+HOME extends the selection of cells to the beginning of the worksheet. |
| PAGE DOWN | Moves one screen down in a worksheet. ALT+PAGE DOWN moves one screen to the right in a worksheet. CTRL+PAGE DOWN moves to the next sheet in a workbook. CTRL+SHIFT+PAGE DOWN selects the current and next sheet in a workbook. |
| PAGE UP | Moves one screen up in a worksheet. ALT+PAGE UP moves one screen to the left in a worksheet. CTRL+PAGE UP moves to the previous sheet in a workbook. CTRL+SHIFT+PAGE UP selects the current and previous sheet in a workbook. |
| SPACEBAR | In a dialog box, performs the action for the selected button, or selects or clears a check box. CTRL+SPACEBAR selects an entire column in a worksheet. SHIFT+SPACEBAR selects an entire row in a worksheet. CTRL+SHIFT+SPACEBAR selects the entire worksheet.
ALT+SPACEBAR displays the Control menu for the Excel window. |
| TAB | Moves one cell to the right in a worksheet. Moves between unlocked cells in a protected worksheet. Moves to the next option or option group in a dialog box. SHIFT+TAB moves to the previous cell in a worksheet or the previous option in a dialog box. CTRL+TAB switches to the next tab in dialog box. CTRL+SHIFT+TAB switches to the previous tab in a dialog box. |
Subscribe to:
Posts (Atom)