Microsoft Excel Boot Camp (Part 5): Data validation and Formulae - PDF of Slideshow
SKU:
A$8.00
A$8.00
per item
This PDF contains the slides from the 5th part of the Boot Camp series about Microsoft Excel (see www.itandcoffee.com.au/microsoft365-classes for more details about these Boot Camps).
In part 5 of the Microsoft Excel Boot Camp, we focus in this part on using Formulae in your workbook – looking at some of the more common formulae that relate to data in a single worksheet, and across multiple worksheets.
We also look at how to set up data validations, which can help with data entry and consistency – setting up a ‘pick list’ of values and how this can ensure entered data is limited to this list.
