Learn where you can find PST file of your MS-Outlook email client. You can easily find and change the location of the PST file. This tutorial will take you through the required steps.
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.