MS Excel 2016 – Absolute and Relative reference
What is cell reference Cell reference is generally used in formulas where data in different cells are used for purpose of calculations. Excel has two types of references – …
Category: MS Office
How to use Combination Chart in Excel
Combination chart combines one or two types chart in Single chart. Use of this type of chart arises when you are using two different types of data like percentage …
Sum of values between two numbers – SUMIFS – MS Excel
To add number in excel which lies between two number, SUMIFS function of MS can be used. SUMIFS function is used to add data which meets multiple conditions or …
Sum of values between two dates range in Excel
To add data in excel which lies between two dates, SUMIFS function can be used. SUMIFS function is used to add data which meet multiple conditions or criteria. USE …
How to use WEEKDAY function – MS Excel
The WEEKDAY function in excel when used to input value of a date returns a number between 1 and 7 for day on that date. By default 1 refers …