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
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:
* Menu > Tools > Customize > Customize Toolbars/menus
+
**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

Revision as of 10:02, 22 February 2011

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

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