Excel Video Tutorial
312 views | +0 today

# Excel Video Tutorial

Learning excel online
 Scooped by Michael Amegashie

## Interactive Pivot Table Calendar & Chart in Excel!

Can we make a calendar using Pivot Tables?!? Of course we can.
No comment yet.
 Scooped by Michael Amegashie

## How to show monthly values & % changes in one pivot table

Pivot tables are great help when analyzing lots of data. One of the common questions managers & analysts ask (when looking at monthly sales data for example) is, How is the monthly performance of our teams (or regions, products etc.)?

Performance eh?!? How to measure it?
There are many ways to measure performance. For our monthly sales data, we can measure performance by comparing,

Sales with targets
This month value with previous month value
This month value with same month last year value
One person’s sale with rest of team etc.
One of the most common ways to measure performance in situations like this is to see how this months value has changed compared to previous month.

How to show monthly values & % changes in pivot?
Do you know that with just a few clicks, we can add % changes to our pivot? Follow these steps:

1. Create a pivot report with months & sales persons (or months & products, months & regions etc.)

2. Add Net sales (or any other metric) to value field area of pivot report

3. Now, add net sales once again to value field area

That is right. You can add same metric more than once to pivot table value field area.

At this point, our report looks like this:

No comment yet.
 Scooped by Michael Amegashie

## Write a formula to check if two dates are in same month? [homework] | Chandoo.org - Learn Microsoft Excel Online

Its Home work time folks. Sharpen your Excel pencils and get cracking. Find out if 2 dates are in same month Lets say you have 2 dates in A1, A2. Q1. What formula tells us if both of them are in same month?

Find out if 2 dates are in same month
Lets say you have 2 dates in A1, A2.

Q1. What formula tells us if both of them are in same month?

Both dates must be in same month & year!