202R0/4 Number Formats MS Excel

MS Excel is a tool for managing data, really numerical data, such as sales figures or weather data! All these different types of number come in different formats and we must choose the right one or the maths calculations wont work correctly

  • whole or decimal numbers
  • percentages
  • currency
  • date and times
  • etc

Tip: working percentages and dates/times really does need practise!

VIDEOCONTENT

https://www.youtube.com/watch?v=fjyOG7Ls7BA

Download Exercise Spreadsheet   (Bad Lama backup challenge)

Supporting Worksheet

 

You need to be logged in to view the rest of the content. Please . Not a Member? Join Us