Difference between revisions of "Nonfiction Media - Excel"
From Help Wiki
m (Created page with '== Excel Workshop == ===The Environment=== * Menu, toolbar * Workbook/worksheet ** Creating, moving renaming worksheets * Rows | columns | cells ===Modifying the Worksheet=== …') |
(No difference)
|
Revision as of 11:43, 3 February 2011
Contents
Excel Workshop
The Environment
- Menu, toolbar
- Workbook/worksheet
- Creating, moving renaming worksheets
- Rows | columns | cells
Modifying the Worksheet
- Inserting a row/column
- Resizing rows/columns
- Menu > Tools > Customize > Customize Toolbars/menus
- Column Headers, page headers
- Split View
Cell Formatting
- Text
- Numbers, (decimals, scientific notation)
- Formulas (the formula bar) View > Formula bar
- Borders and shading
Adding, Selecting and Moving data
- Creating a series
- Different cursors for different operations
- Keyboard Shortcuts (control-shift-arrow, control home, control end)
Sorting data
- What to Sort and Not to Sort
- Rows vs. Columns
- Ascending/descending
Formulas
- Functions: Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure.
- Arguments: Values that a function uses to perform operations or calculations Common arguments Include numeric values, text, cell references, etc.
- Operators: +-/*
- Cell Referencing: Absolute vs. Relative
Printing
- Page Break view
- File > Page Setup
- Repeat headers across multiple pages
- Gridlines
