Learn how to create a drop-down list in MS Excel using comma separated values, cell values and named range. Drop-down lists help us in maintaining data integrity and faster data entry. If you can, you must use these lists as it is easy to set them up and once done, drop-down lists are very useful.
Learn what is cell referencing in Excel. Learn the difference between absolute, relative and mixed cell references in Excel 2007, 2010, 2013, 2016.
Learn how to use conditional formatting in MS-Excel. You can highlight cells with blank and duplicate values and also according to the values present in the cell.