CSULB Home  •   MyCSULB  •   BeachBoard  •   Library  •   E-mail  •   Directory  

 

Suggested Study Topic: Excel

  • BASICS
    • Enter data
    • Enter labels
    • Copy
    • Paste
    • Paste Special
    • Working with multiple sheets
  • DATA MANIPULATION
    • Formulas
      • Entering fomulas
      • Copy a formula with relative and absolute cell references
      • Calculation with dates
    • Functions
      • Financial: PMT, FV
      • Statistical: Average, Max, Min, Count, CountA
      • Logical: IF
      • Date/Time: NOW
    • Sort and Filtering
      • Sorting with multiple fields
      • Filtering with AND and OR conditions
    • Subtotaling data
  • FORMATTING
    • Row height and column width
    • Format cells
    • Freeze column/rows when viewing
    • Repeat print column/rows
  • CHARTS
    • Create chart: Pie, Line, Bar, Column