How to convert standard date mm-dd-yyyy format into mm/dd/ format
By default Excel used MM-DD-YYYY format during filling the dates. Excel allows you to quickly convert standard date mm-dd-yyyy format into mm/dd/…
#Microsoft-Office
215 postsGuide to print selected range of cells in MS Excel
If large database and want to print any required area then you must read this article how to print selected range of…
MS Excel tips rapidly erase blank cells from excel
best tips and tricks available of Microsoft Excel. Kindly read quick and easy way of MS Excel tips rapidly erase blank cells…
How to use SUMPRODUCT Function in MS Excel
SUMPRODUCT Function in MS Excel is an important math and Trig function.used to return sum of the product of corresponding range or…
Slicers in Excel used to Filter PivotTable Data
Slicers in Excel is a command which is used to quickly analyze, filter or summarize active PivotTable data to get better business…
Create and Use Sparklines in Excel to Show Data Trends
You can create and use Sparklines in Excel to show numerical data trends. Sparklines are tiny charts shows numerical data in graphical…
PivotTables in Excel Used to Analyze, Summarize Worksheet Data
PivotTables in Excel is a powerful tool which allows you to get summary of large worksheet data for analysis purpose to take…
How to Return Multiple Items with VLookup in Excel
VLookup in Excel is an important lookup function placed in lookup and reference category. It allows you to return multiple items with…
Use Sumproduct function to find duplicates across all columns in Excel
Sumproduct function is used to find duplicates across all columns in Excel. It can multiplies ranges or arrays together and returns the…
How to using logical AND function in Excel
AND function in Excel allows you to check multiple conditions and return TRUE if all given conditions evaluated to True.