Excel Step By Step Book

Intro
• When you create a workbook by default it comes with 3 sheets and you can add or delete sheets.
• You can create a new workbook by clicking the Microsoft Office Button.
• You can customize the Excel 2007 program window
• You can customize the Quick Access Toolbar for your needs

Creating Workbooks
• When you start Excel it displays a new blank workbook
• You can save your file in different formats
• Once you have created a file you can set up different properties to make your file easier to find
• You can set up the properties by using the prepare button and then the properties button from the Microsoft Office button
• Use custom tab of the advanced properties to type a new property
• Save workbook and work once you are done creating it

Modifying Workbooks
• To display a worksheet click on the worksheet’s tab
• Excel workbooks have three worksheets
• When you create a worksheet Excel gives it a generic name
• Change worksheets name by double- clicking the worksheet’s tab
• Copy one worksheet from another workbook to current workbook
• You can change the worksheet’s location
• Change the tab color of a worksheet
• Delete worksheets
• Hide and unhide worksheets