- Find average =AVERAGE(C2:C9)
- Find total =SUM(G2:G12,G16)
- Highest or lowest value =MAX(B3:B8)
- Check if a condition is met =IF(test,if true, if false)
- =SUMIF(range,criteria,sumrange)
Monday, 28 March 2011
What we learnt about Excel
Here are some Excel formula we used in IT today:
Sunday, 27 March 2011
Monday, 21 March 2011
Rules!
- No under lining
- Three colours max
- No centered titles
- Columns
- Use colours from within photos
- Make use of the space you have
- Only send or upload pdf
Subscribe to:
Comments (Atom)