Category: MS-Office

This category contains the following 56 articles.

How to Add Drop-down List in Excel Cell

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.

Excel Formulas and Functions

Learn about Excel formulas and functions. This basic tutorial on the concepts teaches you how to use formulas and functions like SUM, IF, LOOKUP, INDEX etc.

How to Sort Data in Excel

Learn how to sort data in Excel by text, numbers and date & time. You can also sort by cell color, cell icon, font color etc. It is also possible to sort by custom lists. Sort by row is also possible.