There are several functions can do data referencing: LOOKUP, VLOOKUP, HLOOKUP, MATCH, INDEX, and OFFSET. VLOOKUP and HLOOKUP are partly covered in this article (VLOOKUP and HLOOKUP functions). OFFSET function is covered in another article (Dynamic Referencing for Excel). This article primarily focuses on...
The graphical functions in Microsoft Office may not be as robust as many other commercial graphical software, but they are more than adequate to create impressive graphics if you know how to use them. Your imagination is your limit. The graphical functions are available in...
Gain the edge and take your Microsoft Excel skills to the next level. Learn the necessary skills to supercharge your workflow with powerful formulas and functions.