How To Find The Quarter Of Year
Accounts finance and marketing people are often concerned with the term “Quarter” in context of their budgeting and marketing assignments.
Using Moving Averages For Forecasting
Sales people often need to estimate the sales of upcoming months. They do it with a handful of techniques that uses both quantitative analysis as well as qualitative judgment.
How To Sum Every Nth Row In Excel
It is not uncommon that we want to sum data on the basis of certain criteria – on the basis of weeks, months, every tenth day and so on.
How To VLOOKUP Data For An Entire Month
Consider a case where you have a table like below and want to fetch the data for a single month.
Latest
-
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 ...
