Mobile Number Tracker
Trace Mobile Number Earn Money Online

Category: Excel

This category contains the following 14 articles.
MS Excel Tips Tricks

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-functions-formulas-techwelkin-2

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.

|

Excel Flash Fill: Tutorial and Examples

Learn how to use Flash Fill feature of Microsoft Excel. This article contains tutorial and examples of Excel flash fill in 2013 and later versions.

|

Excel Auto Fill for Faster Data Entry

Using Auto Fill feature of Excel, learn how to quickly enter sequential date series, serial numbers, names of days and months etc. in your worksheet.

|
Selected cell range for sorting.

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.

|

MS Excel: How to Combine Values of Two Cells

New MS Excel users often wonder how they can combine values to two cells in a third cell. Learn how to use concatenate function and ampersand (&) operator to join/combine contents of two or more cells in MS-Excel.

|