Microsoft Excel 2016 training video on Data Validation, which is data that has to be met within a certain condition, or criteria you set, or it cannot be entered into a cell. In other words, you can control a user's input to a degree that will result in more accurate data entry by locking, or blocking certain ranges or types of data into a cell. To validate the entered data. …
17th Nov 2017
Access 2016 training video on how to set criteria for your query including: text, numbers, dates, blank, empty fields.
14th Oct 2017
Excel 2016 tutorial on how to add, average or count up a range of cells in a column (field) of records in a list or database, based upon the criteria you specify in a mini or sub database using the DSUM, DAVERAGE and DCOUNT functions in this Excel 2016 training video. …
24th Aug 2017