How to Use Text to Columns to Separate Data in a Single Column
Text to column in Excel is an important feature. This option allows you how to use text to columns to separate data in a single column.
Microsoft-Office
What is Difference between SUMIF and SUMIFS Function
SUMIF and SUMIFS function are used for conditionally sum of given range. SUMIF is used for single condition while SUMIFS is used for multiple criteria.
Advanced VLookup trick with Data Validation in Excel
If you have any complex criteria then you can use VLookup trick with Data validation. It allows you to search value as per given condition.
How to Sum or Count cells based on background color in Excel
This guide allows you how to get sum or count cells based on background color. It not only easier but also reduce your manually working time.
Quick Methods to Insert a Table in Microsoft Word Active Document
You can insert, add, resize, delete the table as per your need. You can use given methods to Insert a Table in Microsoft Word active document
How to use latest Quick Analysis feature in Excel
Quick Analysis feature allows you to analyze your selected range of cells but also prepare chart, conditional formatting and many more.
Quick way to Delete blank cells using sort command in MicroSoft Excel
There a lot of blank cells found in active worksheet and if you want to remove them use quick way to Delete blank cells using sort command in MicroSoft Excel.
How to insert symbols and special characters in Excel
Symbols is a mark used for an object while special characters is a selection of punctuation. You can easily insert symbols and special characters in Excel.
How to split full name into First and Last name in Excel
You have full name in a single column of active worksheet, read this which provide quick ways to split full name into First and Last name in Excel.
How to add diagonal line on active cell in Microsoft Excel
If you want to give attractive look or then you have to use diagonal line. It helps you to add diagonal line on active cell in Microsoft Excel.