Understanding How HYPERLINK Works In Excel

Excel has a built in function to create hyperlinks &...

Understanding how MS Excel Query Works

“Query” in MS Excel has same meaning as ...

An Introduction To Excel Power Map

Our today’s post is about “Power Map&rdq...

Using Pivot Charts For Displaying Data

Conventional charts are mostly used for displaying r...

Using “Calculated Items” For Analyzing A Pivot Table

In our last post, we explored how to use calculated ...

COUNTIF

IF

INDEX

SUM

VLOOKUP