Thursday, August 2, 2018

Bringing US Climate data to Excel is super easy!

You can ge the US climate data from this site.


It has data for all the states, like in this image.


USClimateData

This shows the data for Honolulu.


USClimateData_Honolulu

All you need to do is to highlight the data you want to use in Excel as shown,

Copy it.

Paste it into the first cell of an empty sheet.


Once it is in EXCEL you can use the built-in functionality of charting data.

No comments:

Post a Comment

Encryption and connecting to SQL Server using SSMS

 This post is describes connecting to SQL Server 2022 using the SQL Server Management Studio and the encryption of connection. For installin...