How to Copy Formatting only using Fill Handle in Excel
Fill handle is an important tool of Excel which allows you to copy or generate series. You can also copy formatting only…
#Excel
189 postsHow 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…
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…
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…
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…
How to use Index Match function in Excel
Index Match function allows you to search specific value from right to left and return exact value . This function also reduce…
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…
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…
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…