How to calculate YOY growth in Excel Pivot Table
Estimated reading time 3 min. Works with ALL versions of Excel. The data is a list of sales transactions, two columns – amount and date. We have 5000 transactions over
Estimated reading time 3 min. Works with ALL versions of Excel. The data is a list of sales transactions, two columns – amount and date. We have 5000 transactions over
OneDrive has a sync (like all other cloud providers). Sync creates a local copy on your PC, Laptop or Mobile phone for selected files or folders. The local copy can
Here is something I learnt yesterday at Wellington. I was conducting a session on Outlook for a team of EA and PAs for Government of NZ. I showed them the
I am back at my favorite place – New Zealand. This week, I will conduct sessions for over 20 customers across Wellington and Auckland. New Zealand has always been the
This is a frequent frustration. You copy some data which contains hidden rows and columns. You blindly assume only the visible cells will be pasted. But when you paste it,
Power Pivot Data Model adds database like features to Excel. Power Pivot allows you to handle millions of rows of data, from multiple data sources and lightening fast analysis. It
Yes. You read it right. Don’t just open Outlook. Do it smartly. Usually, we need three windows open: Tasks, Calendar and Inbox. By default, it will open the Inbox. No
Here is a quick listing of the key differences from a usage point of view. It will help you choose the right type based upon the analytical objectives.
You are working with an external agency on a project. There is a simple to-do list to be executed. There are three people involved. We want to keep track of
Yes. You use Pivot Tables everyday. Now it is time to find out the real power and nuances. 5.5 hours video, exercises, samples, Q&A.
Learn Power BI using the concepts you already know in Excel. Fast transition, in-depth coverage and immediately usable.
