Introduction

This is for all you excel lovers. I am starting this blog to help thousands of people who wish to know excel indepth. I always faced this challenge when I started excel reporting 7 years back. Today I head the MIS Reporting Team for a Multinational company. All this in 7 yrs. Imagine I did not know anything of excel 7 yrs back .....Its been a long journey....I want to share my learnings with everyone.Also I want to help others to learn excel and help them excel in life.This blog is aplatform for us to meet and help each other

Sunday, November 2, 2008

Exercise 1-1: Opening the Office Menu and Selecting Its Commands

In this exercise, you get familiar with the commands on the Office menu as you practiceopening the Office menu and selecting some of its commands. Make sure that Excel 2007is running and an empty Sheet1 worksheet is active on your computer monitor
1. Highlight the Office Button (by hovering the mouse pointer over it without clickingthe mouse button) and wait until its ScreenTip appears.The ScreenTip shows you an image of the menu and gives you a brief descriptionof its function.
2. Click the Office Button to open its pull-down menu.Note the commands New through Close in the left menu pane. Also note the ExcelOptions and Exit Excel command buttons at the very bottom of the menu.
3. Highlight the Save As command on the Office menu (but don’t click it).Note all the Save a Copy sub-options that now appear in the right menu pane.
4. Now, click the Save As command on the Office menu to select it.Excel opens the Save As dialog box where you can modify the name, location, andtype of Excel workbook file before saving a copy of it.
5. Press the Esc (Escape) key on your keyboard to close the Save As dialog box.
6. Press Alt+F to open the Office menu again, this time from the keyboard.This time, small letters appear on each command as well as on the sub-optionbuttons attached to the Save As and Print commands. These are the access keysthat you can type to select an option rather than clicking its name or button.
7. Type W to display the Print command sub-options, and then type V to select thePrint Preview sub-option.Excel displays an alert dialog box indicating that there’s no data in the Sheet1worksheet to preview. Note the appearance of the dashes in the Excel worksheetdisplay showing where the pages would be divided.
8. Click OK in the alert box and then press Alt+FI to open the Excel Options dialog box.The Excel Options dialog box contains all the options for changing the Excel programand worksheet options.

No comments: