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=== …') |
m (→Modifying the Worksheet) |
||
| (7 intermediate revisions by the same user not shown) | |||
| Line 3: | Line 3: | ||
===The Environment=== | ===The Environment=== | ||
| − | * Menu, toolbar | + | * Menu, toolbar, formatting palette |
* Workbook/worksheet | * Workbook/worksheet | ||
** Creating, moving renaming worksheets | ** Creating, moving renaming worksheets | ||
| − | * Rows | columns | cells | + | * Selecting Rows | columns | cells |
===Modifying the Worksheet=== | ===Modifying the Worksheet=== | ||
| − | * Inserting a row/column | + | * Inserting a row/column: '''Insert > Row ...''' |
| − | * Resizing rows/columns | + | * Resizing rows/columns: |
| − | * | + | **mouse over column/row header and drag border to resize |
| + | **or select row/colum and right click to set width or height | ||
| + | * The more you work with Excel you may want to customize the toolbar for those commands you use frequently: '''View > Customize Toolbars/menus''' | ||
* Column Headers, page headers | * Column Headers, page headers | ||
| − | * Split View | + | * Split View - '''Window > Split''' |
===Cell Formatting=== | ===Cell Formatting=== | ||
| Line 26: | Line 28: | ||
* Creating a series | * Creating a series | ||
| − | * Different cursors for different operations | + | * Different cursors for different operations: hand, plus sign, double-headed arrow |
| − | * Keyboard Shortcuts ( | + | * Keyboard Shortcuts (control home, control end) |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
===Formulas=== | ===Formulas=== | ||
| − | + | *AutoSum - a quick and easy way to add cells | |
* Functions: Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. | * 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. | * Arguments: Values that a function uses to perform operations or calculations Common arguments Include numeric values, text, cell references, etc. | ||
* Operators: +-/* | * Operators: +-/* | ||
| − | |||
===Printing=== | ===Printing=== | ||
| − | * Page | + | * '''Views''': Normal and Page Layout |
| − | * File > Page Setup | + | * '''File > Page Setup''' |
| − | ** | + | ** '''> Sheet''' to repeat headers across multiple pages |
| − | ** Gridlines | + | ** add Gridlines |
| + | |||
| + | ===Other tools for creating spreadsheets=== | ||
| + | *[http://docs.google.com/ Google Docs] | ||
| + | *[http://www.libreoffice.org/ Libre Office] | ||
| + | *[http://www.openoffice.org/ OpenOffice] | ||
[[category:2010-2011]] | [[category:2010-2011]] | ||
| + | [[category:2012-2013]] | ||
Latest revision as of 11:53, 8 April 2013
Contents
Excel Workshop
The Environment
- Menu, toolbar, formatting palette
- Workbook/worksheet
- Creating, moving renaming worksheets
- Selecting Rows | columns | cells
Modifying the Worksheet
- Inserting a row/column: Insert > Row ...
- Resizing rows/columns:
- mouse over column/row header and drag border to resize
- or select row/colum and right click to set width or height
- The more you work with Excel you may want to customize the toolbar for those commands you use frequently: View > Customize Toolbars/menus
- Column Headers, page headers
- Split View - Window > Split
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: hand, plus sign, double-headed arrow
- Keyboard Shortcuts (control home, control end)
Formulas
- AutoSum - a quick and easy way to add cells
- 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: +-/*
Printing
- Views: Normal and Page Layout
- File > Page Setup
- > Sheet to repeat headers across multiple pages
- add Gridlines
