Course goals
- Find popular commands quickly on the ribbon.
- Learn how to use the File menu (Microsoft Office Backstage view).
- Learn essential tasks such as opening existing workbooks, creating new workbooks, setting up a spreadsheet, formatting, saving, and printing.
Excel 2010 information
- Available Columns:
A through XFD – 16,384 columns - Available Rows:
1 through 1,048,576 - There are over 17 billion cells in each worksheet!!!!
- A cell is the intersection of a column letter and a row number. The cell address can be found in the Name Box just above column A
Workbooks and Worksheets
- Each Excel file is a Workbook containing one or more Worksheets
- Default setting provides you with three worksheets – you can add or remove as needed from there
- Worksheets can also be reordered within the file and renamed – you can also copy or move a worksheet to another workbook (file)
- Several sheets can be used for one project, containing it all in one file, or you can still use one file for each part of a project, depending on your needs.
Basic Editing
- Click a cell to type into it. After typing, press Enter to move down one cell or
press right arrow key to move to the right one cell. - To delete the contents of a cell, select the cell, then press Delete on the
keyboard - To replace something in a cell (or cells), select the cell (or cells), then begin
typing the replacement. Or, you can press Delete on the keyboard before typing
the replacement. - Undo/Repeat the replacement (this works even after the workbook has been
saved)
- Select a cell and choose Cut (to move data) from the Ribbon or choose Copy (to make a
- copy of the data)Click in a new cell and choose Paste from the Ribbon
Remember – there is always more than one way to accomplish a task (usually two or three ways) so find what works for you.