Excel Video Tutorial
312 views | +0 today
Follow
Excel Video Tutorial
Learning excel online
Your new post is loading...
Your new post is loading...
Scooped by Michael Amegashie
Scoop.it!

Interactive Pivot Table Calendar & Chart in Excel!

Interactive Pivot Table Calendar & Chart in Excel! | Excel Video Tutorial | Scoop.it
Can we make a calendar using Pivot Tables?!? Of course we can.
more...
No comment yet.
Scooped by Michael Amegashie
Scoop.it!

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

How to show monthly values & % changes in one pivot table | Excel Video Tutorial | Scoop.it
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:

more...
No comment yet.
Scooped by Michael Amegashie
Scoop.it!

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

Write a formula to check if two dates are in same month? [homework] | Chandoo.org - Learn Microsoft Excel Online | Excel Video Tutorial | Scoop.it
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!

Go ahead and post your answer in comments.

You think that was easy, try this then:
The above formula would be very easy for seasoned Excel pros. So I have 2 additional questions:

Q2. How to find out if n dates (A1:An) are in same month?

Q3. How to find if n dates (A1:An) are in a given date range – start date in B1, end date in B2?

more...
No comment yet.