Excel Tips and Tricks

Some Excel Tips and Tricks:

• Group cells together by giving them a name - easier to apply actions on all of them
• Link Cells together (changing data in one cell affects the other) by: Copy, use Paste + Options
• Split Worksheet by dragging the split box (top of the vertical scroll bar or right end of the horizontal scroll bar) to desired position
• Use $ for retaining a row / column / cell name in a formula. Eg: $A1 (retain column A) or A$1 (retain row 1) or $A$1 (retain cell A1)
• Use Freeze Panes option (under Windows in Menu Bar) when needed
• Use Auto Formatting and Conditional Formatting (under Format in Menu Bar)
• In Charts, right click on plotted points and select "Add Trend line" to see the slope
• Use Array aka CSE (Ctr+Shft+Enter) Formulae: Eg:Sum(A2:A8 * C2:C8) = A2*C2 + A3*C3 + ... + A8:C8

Shortcuts:

Ctr + ~	Formula Auditing
Alt + Enter	Insert newline
Ctr + ;	Current Date
Ctr + Space	Select Column
Shft + Space	Select Row
Ctr + Shft+ ;	Current Time
F7	Spellcheck selected text
Shft + F3	Excel Formula Window

---