11Nov2014

How to apply Conditional formatting in Excel?

Conditional formatting in Excel is used to highlight a cell or value/text in the cell, when certain conditions are met. Conditional Formatting can quickly spot trends and patterns in your data with bars, colors and icons by visually highlights important values. Conditional formatting is based on the cell rules we amend. We can do a
  • 11 Nov, 2014
  • Excel for Commerce
  • 0 Comments
  • Conditional formatting in Excel, Excel Consultant, Excel Expert,
Read more
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
<< Newer Posts