Word Main Window | View Function | Enter Text | Navigate Documents | Select Text | Templates | Auto Text| Using Help
Main window | Enter Data | Navigation | Ins Columns & Rows | Del Columns & Rows | Define Range | Sort | Worksheets
Database basics | Database Wizard | Navigation | Switchboard | Enter Data | Modify | Sort | Query | create Report
Main Window | Recurring Appointments | Plan meetings | Create Tasks | Create Folders
Create a New File | Page setup | Help Files | Using Tables | Rows & Columns | Inserting Word Art | Inserting Clip Art | Using Wizards
Main Window | Auto Content | Templates | View Modes | Edit | Add Illustrations | Add Charts| Add Backgrounds
Computer Terminology Explained | Windows XP Tutorial

Tutorials - Microsoft Excel

Using the Excel Window 

Introduction:

When you first open Excel, a blank workbook opens. A workbook is an Excel file, just as a document is a Word file. By default, each workbook file contains three worksheets, which look like an accountant's spreadsheet divided into a grid of columns and rows that intersect to form cells. Surrounding the workbook are tools that you can use to help you enter and work with data that you place in the worksheet cells. Take a few moments and familiarize yourself with the Excel environment. 

Step 1: The Program Window Controls 

The Excel program window opens along with a blank workbook window. Usually, both windows are maximized: The program window fills the entire screen, and the workbook window fills the program window. (When both are maximized, two Restore buttons-one for each window-are displayed in the set of buttons in the top right corner of the window's screen.) If your program window isn't maximized, click its Maximize button. To minimize the program window to a button on the Windows taskbar, click the Minimize button. The program window controls: Thumbnail


 

 

Step 2: View the Title Bar 

Excel's title bar tells you what is in the window. When the workbook window is maximized, it has to share the title bar with the program window, so the title bar contains the names of both the program (Microsoft Excel) and the file. ("Book1" is a temporary name for your file. When you save it for the first time, you can assign a better name. Title bar: Thumbnail

 

 

Step 3: Select from the Menu Bar 

The Excel menu bar contains menus, which in turn contain all the available Excel commands. All the tasks you need to perform are available through menu commands. To use the menu commands, click the menu name to display the menu and then click the command you want. Menu bar: Thumbnail

 

 

 

Step 4: Use the Worksheet Grid

Each cell is identified by its address on the worksheet, also called a cell reference. A cell address consists of the column label and the row number, such as A1. The Name box, located at the far left end of the Formula bar identifies the active cell, as sort of a "you-are-here" marker. Worksheet grid: Thumbnail

 

 

 

 

Step 5: A Look at the Toolbars 

The Standard and Formatting toolbars may share a row onscreen (Standard on the left, Formatting on the right). Both toolbars contain shortcuts for frequently used commands. To activate a toolbar button, click it. To see a button name, hover the mouse pointer over the button for a moment. A ScreenTip appears with the button name. Toolbars


 

 

 

Step 6: View the Formula Bar 

Below the toolbars you'll find the Formula bar where you can build formulas to calculate your worksheet data. Formula bar


 

 

 

Step 7: Use the Scrollbars 

The vertical and horizontal scrollbars allow you to view different portions of your worksheet. Use the arrows on the scrollbars to scroll in the appropriate direction. Drag the scroll box to move your view of the worksheet in larger portions. Scrollbars: Thumbnail


 

 

 

 

 

 

 

 

 

Step 8: View Worksheets 

A tab at the bottom of the workbook window represents each worksheet in a workbook. By default, Excel starts you out with three worksheets in each workbook, but you can add and subtract worksheets as needed. To display a sheet, click its tab. Worksheets: Thumbnail

 

 

About Us | Privacy Policy | Contact Us | ©2004 JB Computers