Perform Year over Year Analysis with a Pivot Table

If you're familiar with Pivot Table, it's a great analysis tool. One common type of analysis is to compare the year over year (or month over month) change or growth of items. Maybe it the comparison of the actual number value or you could want the percentage change. One option is to have your data in the pivot table ready and make the calculations outside of the table (e.g., in the next column). But if you do it that way and make changes in the Pivot Table, the outside cell calculation could not work because they might be reference different cells now. This video will look at a simple data set of car sales and see how to compare the difference and percent differences over two years and make comparisons by date (months) and even by the car make to emphasis the flexibility of Pivot Table when you make changes. You don't need to calculate the change outside of the Pivot; instead let Excel do it for you. Then all you need to to it to plug your final table into a report or presentation.

Quick Charts, Totals or Conditional Formats with Quick Analysis Tool

If you're having trouble thinking about what kind of chart, formatting or calculation to help analyze your data, you can get some idea or insight from Excel by using the Quick Analysis Tool. It can give you a sample of the kind of visuals or formatting that can be applied to your dat

Create a Geo Map Chart - Google Sheets

If you've got data to map, you might want to using the geo chart maps in Google Sheets. As long as you have some type of value that can be mapped like city, state or country, you can assign colors or markers to your data on a geographic map. All you need are two columns; one for the locale and the other to represent some quantitative value. The catch is that there are just to geo map options to use in Google sheets. Also you can't map latitude and longitude. However there is a workaround to that which involves some script (don't worry it's a copy/paste) and later on I'll even so you how to incorporate google sheet data with the google maps application.