Nonfiction Media - Excel

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