Data Cleaning With Excel-Inconsistent Date Formats

Highlighting Data Based on Cell Value-Conditional Formatting in Microsoft Excel

Highlighting Rows and Columns of Active Cell -Conditional Formatting in Microsoft Excel

Automatic Borders when data is filled in cells-Conditional Formatting in Microsoft Excel

Freeze Panes in Microsoft Excel

Creating a Dependent DropDown List in Microsoft Excel

Creating a Multiple Dependent DropDown List in Microsoft Excel

Data Cleaning with Excel-Delete all Columns where there exists a Blank/Null Values

Data Cleaning with Excel-Delete all Rows where there exists a Blank/Null Values

Adding Zero-0 infront of a Number in Microsoft Excel

Converting Numbers with Text Formats into Number Format in Microsoft Excel

Combine Contents From Multiple Cells into One in Excel

Combine List of Emails into Single Cell in Excel (Technique 2)

Combine list of Emails into One Cell in Excel

Combine a Range of cells into a Single Cell in Excel

Data Cleaning With Excel-Unstack Data from One Column to Multiple Columns-Technique 4

Assigning Grades to Marks Obtained in Microsoft Excel

Calculate Age in Years Microsoft Excel

Calculating Age in Year, Month and Day as of Today in Microsoft Excel

Clipboard Feature for Multiple Copy and Multiple Paste in Microsoft Excel

Color Scales in Microsoft Excel

Data Bars in Microsoft Excel

Fill Function in Microsoft Excel

Filter Cells based on their Cell Color in Microsoft Excel

Filter Cells that Begins with specific Words /Characters in Microsoft Excel