Find Duplicate values in Excel Tables
Duplicates are cloned values or repeated values in excel and managing those or treating them is pretty easy in excel. There are two…
How To Create Named Ranges in Excel
When dealing with very large files Named range is like a boon to do the calculations and perform different functions by reducing the…
How to do excel trend Analysis
Excel has this amazing feature called Trend analysis which helps the user to identify the trends or projections of data using trend graphs….
How to use the Excel COUNTIFS function
When working with large data to extract the information you need to create a summary report. Countif, sum if are the two basics…
Excel Formulas – Text and Date Functions
What will learn from this post? Think about the data with inconsistent data throughout and you need to perform some analysis on it….
How to link Excel sheets and workbooks
What will learn from this post? You might know Excel has Worksheet, Workbooks, This can be used to join the data from the…