Excel Tutorials
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
Excel Tutorials
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
Excel Tutorials
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
Excel Tutorials
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
Excel Tutorials
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
Excel Tutorials
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