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 …
Category: MS Office
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 …
How to mail merge in Microsoft Word – Quick Guide
Mail Merge is a process of using a single data file and creates multiple documents with similar layout and text. Sections of the merged documents are personalized as provided …
Top 7 text functions in excel
Using excel first things which comes to mind is working with numbers but excel can do a lot with text. Excel has several text function to access these use …