Graphical indicator fields can be used to make it easier for people viewing the project plan, to know the status of a numerical field. Inst...

Lookup functions such as VLOOKUP are some of the most commonly used functions in Excel. They are used to achieve many different Excel task...

Pie charts are used to display data points as a percentage of the whole value. Excel provides a few different variations of pie chart to cho...

Take your hyperlinks to another level with the HYPERLINK function. This function can be used to create conditional hyperlinks that only disp...

While Excel is not able to predict the future, it is a capable of forecasting future values using existing data. Excel provides many funct...