Home >Tips >Excel cost calculations kalmstrom.com site map icon Site map  

Calculate, compare and visualize costs in Excel 2013

An Excel tutorial by Peter Kalmstrom

Excel iconThe possibility to tell Excel to calculate is a crucial feature and the most important reason to use it. Another reason for Excel's popularity is that you can visualize data in charts.

In the demo below Peter Kalmstrom calculates the costs for different kinds of flooring materials and shows the result in a graph.

Excel sheet

While setting up the comparison between flooring materials Peter gives many useful tips. He shows how to:
  • Set number format
  • Create a multiply formula
  • Name an array of cells
  • Create a vertical lookup formula
  • Use the AutoSum button
  • Copy format
  • Create a data validation rule
  • Create a pivot chart

Excel pivot chart



Peter uses Excel 2013 for his demo, but most of what he shows can be done in earlier versions of Excel too. If you use SharePoint 2010, Peter's demo on holiday calculations might be on interest.