We start with a simple workbook, to show what’s involved in entering, modifying, and formatting data, and in performing calculations. This includes ways in which Excel helps to minimize the effort. We cover printing, look at Excel Help, and discuss the various file formats associated with Excel. So Let’ Start.
When you launch Excel, you usually start with the Excel window displaying a blank
workbook called “Book1”:
Each workbook opens in its own window, making it easier to switch between workbooks
when you have several open at the same time.
1.Move the mouse over a command icon in one of the groups (e.g. in Alignment, on
the Home tab) to see the command description.
2. Click the down-arrow next to a command (e.g. Merge & Center) to show the list
of related commands. (See Image Below)
3. Click the arrow by the group name (e.g. Alignment) to see the associated dialog
box. (See Image Below)
4. Select other tabs to view other cell formatting options.
The Home tab contains all the commands for basic worksheet activities, in the Clipboard,
Font, Alignment, Number, Styles, Cells, and Editing groups.
By default, Excel provides one array of data (called a worksheet) in the workbook. This is
named “Sheet1”. Click the + button to add “Sheet2”, “Sheet3”, etc. (See Image Below)
These are the theoretical limits for worksheets. For very large numbers of records, a database program may be a more suitable choice.
Each worksheet is the equivalent of a full spreadsheet and has the potential for up to
1,048,576 x 16,384 cells, arranged in rows and columns. The rows are numbered 1, 2, 3
and onward, up to a maximum of 1,048,576. The columns are lettered A to Z, AA to ZZ,
and then AAA to XFD. This gives a maximum of 16,384 columns. The combination gives
a unique reference for each cell, from A1 right up to XFD1048576. Only a very few of
these cells will be visible at any one time, but any part of the worksheet can be displayed
on the screen, which acts as a rectangular “porthole” onto the whole worksheet.
The actual number of cells shown depends on screen resolution, cell size, and display
mode (e.g. with Ribbon minimized or full-screen).
Use the scroll bars to re-position the screen view, or type a cell reference into the name
box, e.g. ZN255. (See Image Below)
One worksheet is usually all you need to create a spreadsheet, but it can sometimes be
convenient to organize the data into several worksheets. See here for other ways to
navigate through the worksheet using arrow keys, scroll functions, and split views.