How to Create and Run a Macro in Excel
Macro is an important utility of which allows you to start recording of more than one sequentially commands. You can create and…
#Microsoft-Office
215 postsHow 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…
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…
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…
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…
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…