RETRIEVE GEOGRAPHY DATA IN EXCEL - City, State, and Country

preview_player
Показать описание
If you know the U.S. ZIP codes, state, or country, Excel will pull information based on the data.
Excel can retrieve city, county, and state from a ZIP code. It can get GDP, population, capital city, and other demographics from any country.

Data Types are new in Excel 365. This video covers the Geography Data Types. The video on Stock Prices is below.

__________

BOOK AN APPOINTMENT WITH ME

Book a coaching or tutoring appointment with Jeff Mankin

__________

LEARN MORE

Please Like, Comment, and Subscribe to support our channel.

ACCOUNTING BASICS

EXCEL BASICS

FINANCE BASICS

INTERMEDIATE ACCOUNTING

__________

BOOKS I RECOMMEND

__________

SAY HI ON SOCIAL

__________

MY GEAR

__________

ABOUT ME
__________

DISCLAIMERS & DISCLOSURES

This content is for education and entertainment purposes only. Finally Learn LLC does not provide accounting, tax, financial planning, or investment advice. The information is being presented without consideration of the investment objectives, risk tolerance, or financial circumstances of any specific investor and might not be suitable for all investors. Past performance is not indicative of future results. All investing involves risk, including the possible loss of principal.

#finallylearn #jeffmankin

Рекомендации по теме
Комментарии
Автор

That’s very interesting that it goes so in depth.

cornap
Автор

Hey there! Thank you for all your videos, they're a huge help. I have a huge problem though...I put in some zips, but when I click to add information, I can't find how to incorporate the state associated with that zip. It provides me many different options, but no state nor state abbreviation. What am I doing wrong...?

joelgoedken
Автор

How about to get the nationality. Example: I type the Country and it populates another column named as Race-Group, if type Mexico or Brazil, etc then Hispanic, if typed or imported the data as Vietnam, then Vietnamese, if China than Chinese, etc. In the meantime, I have to use xlookup or vlookup to get the nationalities to avoid typing. Spare your hands. A lot people breaking their hands doing unnecessary repetitive data.

tutsecret
Автор

Can you generate the zip codes in Excel with the full address?

sherylrob