Microsoft Excel

1
Microsoft Excel

• Learning by Trial and Error

2
Topics

• Creating formulas, including information from
  other worksheets, and using interactive cells
• Creating multiple worksheets that are similar
• Creating charts and graphs
• Absolute and relative references

3
Creating formulas

• Golden Rule
• Have all worksheets that you will be referencing
  open
• Excel has limited cell space visually, and you
  can inadvertently truncate formulas simply by
  referencing closed worksheets
• Understand Interactive Cells
• Understand Absolute and Relative Cells

4
Interactive Cells

• C2 Uses the value in C2
• Sheet2!B2 Uses the value in B2 on Sheet 2
• Asset-Liability Subtracts a cell named
  Liability from a cell named Asset

5
Absolute and Relative References

• Absolute reference identifies a specific
  location (A1)
• Relative reference identifies a position of a
  cell (A1)
• Relative references adjust when copies
• Absolute references remain the same
• New formulas use relative references, be sure to
  change before you copy

6
Creating multiple worksheets

• Paste Special First
• Copy remains, so Paste text next
• Paste Special may still be best option
• Search and replace

7
Charts and Graphs

• Set up an easy chart/graph
• Adjust for presentation view
• Adjust for complex data

8
Summary

• Know what you want to do, then figure out how
• Use Excel Help usually pretty good
• Keep all origination and destination worksheets
  open when developing formulas
• Start simple so you can check the results
• Find a user resource experience has taught
  someone else so dont reinvent the wheel

9

• THANKS FOR ATTENDING!
• Roberta Johnson
• Computing and Network Serivces
• rjohnson_at_ksu.edu
• 532-4928