Thursday, June 24, 2021

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

Tuesday, June 22, 2021

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.

Sunday, June 20, 2021

Use the Excel XLOOKUP Function

The XLOOKUP function is an Office 365 function that is sure to replace the other lookup functions like VLOOKUP, INDEX/MATCH, or HLOOKUP. It's so much more versatile and take the similar argument structure as the other functions and more. You can do various lookup variations like looking up to the left or looking up values from a bottoms up approach...and all this with just one function.