15Oct2014

How to use LOOKUP functions in Excel – by our Excel Expert

The process of looking up specific values in a data set is the most common task in Excel. If your intent is to become an Excel Expert someday then you will need a good understanding of all the lookup formulas available in Microsoft Excel. There are 6 lookup functions in excel: LOOKUP, VLOOKUP, HLOOKUP, (INDEX
  • 15 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Hlookup, Index, Lookup, Match, Offset, Vlookup,
Read more
09Oct2014

Is Wrap text not working in Excel? Read the following blog by Excel Expert.

Is wrap text not working in Excel? The reason is Microsoft Excel cannot wrap merged cells automatically. We need to follow a few steps to make the wrap text work in Excel. Go ahead and read the blog to see how the issue can be resolved. Step 1: Merge the cells and enter the text In this
  • 9 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • Excel Consultant, Excel Expert, Merge cells, Wrap text,
Read more
01Oct2014

How to calculate accrued interest using Microsoft Excel?

ACCRINT To calculate accrued interest, Excel has a function called ACCRINT. Using this function, we can calculate accrued interest for a security paying periodic interest. Go ahead and read through to know how and when the function can be used. ACCRINT function in Excel returns the accrued interest for a security that pays interest on
  • 1 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • accrint, accrued interest,
Read more
01Oct2014

How to lookup a value with multiple criteria in a table?

Ever wondered how to lookup multiple criteria in excel? We will tell how you can do that. Excel provides a function called DGET which lets you to lookup multiple criteria. Let us know more about DGET. DGET DGET function in Microsoft Excel extracts a single value from a column of a list or a database
  • 1 Oct, 2014
  • Excel for Commerce
  • 0 Comments
  • dget, multiple lookup,
Read more