Excel Tips and Tutorials

How to Insert Cent Symbol In Excel

 

Some may think it is a very simple thing to insert a Cent symbol (¢) in Excel. It is easy if only you know it.

Using Hyperlink () With Vlookup () To Jump To A Specific Cell

Excel model can be as simple as adding up two values in cell or so complicated to cover multiple sheets or even multiple workbooks

Basic Tax Rate Calculation

MS Excel has been used in many diversified areas; one of them is accounts and finance.

Two Way Lookup With Vlookup

We came across situation we have to look for values both horizontally and vertically.

Retriving Quotation Rates For Two Parties With Excel

When using Excel for Procurement, it is common to use it for making quotations. 

SUMPRODUCT Function In Excel

SUMPRODUCT is yet another function that comes to rescue, whether we want to validate a criteria or want to sum against a list of requirements

Using COUNTIF To Count!

COUNTIF() family of functions is amongst the most frequency used family of functions in Excel.

Total Count  : 191