## Excel Video Tutorial Excel vlookup Formula in English । Learn Excel in English with simple example

Excel Video Tutorial Vlookup Formula Excel Formula Vlookup

Excel Video Tutorial Vlookup Formula Excel Formula Vlookup

Highlight Require Data Using Conditional Formatting Conditional Formatting Rules Usage In the MS Excel highlight Selected Data as per multiple conditions using Conditional formatting. First Option available for Highlight Cells rules for Numbers Greater then, Less than, Equal to and for Text option text that contains, for date Next week, Last week … Read more

Ledger Summery Report Introduction- Sometime we need for small project or working in the office Need to Manage data and analysis individual summery with more Details. Sorting in Individual information very long process and its time consuming. In this tutorial we are learning how to make individual summery report using … Read more

Make Mark-Sheet in Excel Make simple dynamic mark sheet in excel Mark sheet Calculation make simple . use formula Min, Max, Average, Percentage, IF IF : =IF(E4<35,”F”,IF(E4<60,”C”,IF(E4<80,”B”,”A”))) Learn If formula in details Click Here Minimum:Type =MIN( then Select Range that entered marks & Close Bracket. =MIN(E4:E9) Maximum: Type … Read more

MS Excel SUMIF Function & SUMIFS Function SUMIF Formula Sumif function use for calculate sum with condition from given data set. We can use Multiple criteria for detailed summery report. For finding cash payment we need range, criteria & sumange. Column C is our range & cash is our Criteria. Text available in Cell F5. … Read more

5 Useful COUNT Formulas in Excel Introduction- Count your Data with different conditions. Separate formula use for particular condition. Numerical value, Text value, Blank Data, Filled Data & Given Criteria wise data any data count using this 5 formulas. COUNT Formula Count formula use for count only numerical value from selected data. In the following … Read more

Make summery Report using Countif & Countifs How to use countif formula in excel Countif Function use for Count given criteria from the large data. If once apply the formula need not update report time to time. Value will update automatic according Data Entry. In the Employee master data Staff Name, Designation & 3 department … Read more

Convert separate text to column Introduction – For the Text convert in to the separate column function mostly use Text to column. It is the very simple Function. Few steps are required. In the given image Employee full name. We are separate first name & Last name in separate column. Steps – Select the Data.follow … Read more

Trim Formula & Paste Special Function Usage of Trim Formula Remove Extra Space from Text using Trim Formula.Between two word some time double space found or Before starting word. Remove space using formula very simple. Steps – In the following Image Name list shown in column C. Here found extra space in the text. For remove … Read more

Searchable List Using Formula Using Excel Formulas – IF, SEARCH, VLOOKUP, IFERROR We Can Search Result with Name or Code. Trace Customer Balance or Any Criteria. Find any result using any searching criteria. Ex. In the following Image looking 1st List is Creditors Balance & second List is Search list for search creditors name & … Read more