Finding and Using Data in Global Health

This is the first in a series of videos on how to find and use data in global health. In this video Dr Greg Martin shows you how to download data on HIV, TB and ART and how to use the vLookup function in Excel to extra the data that you're wanting.
Global health (and public health) is truly multidisciplinary and leans on epidemiology, health economics, health policy, statistics, ethics, demography.... the list goes on and on. This KZbin channel is here to provide you with some teaching and information on these topics. I've also posted some videos on how to find work in the global health space and how to raise money or get a grant for your projects.
Please feel free to leave comments and questions - I'll respond to all of them (we'll, I'll try to at least). Feel free to make suggestions as to future content for the channel.
SUPPORT:
------
This channel has a crowd-funding campaign (please support if you find these videos useful).
Here is the link: bit.ly/GH_support
OTHER USEFUL LINKS:
--------
Channel page: bit.ly/GH_channel
Subscribe: bit.ly/GH_subscribe
Google+: bit.ly/GH_Google
Twitter: @drgregmartin
Facebook: bit.ly/GH_facebook
HERE ARE SOME PLAYLISTS
---------------
Finding work in Global Health: bit.ly/GH_working
Epidemiology: bit.ly/GH_epi
Global Health Ethics: bit.ly/GH_ethics
Global Health Facts: bit.ly/GH_facts
WANT CAREER ADVICE?
------------
You can book time with Dr Greg Martin via Google Helpouts to get advice about finding work in the global health space.
Here is the link: bit.ly/GH_career
~-~~-~~~-~~-~
Please watch: "Know how interpret an epidemic curve?"
• Know how to interpret ...
~-~~-~~~-~~-~

[@gregmartin]

*How to find and use data in Global Health* In this video I show you how to download a data set and to use a function in excel called a "vLookup" to extract the parts of the dataset that you're most interested in.... Please remember to like / share / comment and subscribe... Greg

[@deborahbiyi]

This is great Greg! Will be using this trick for my Extended Project Dissertation on the MDG's. Thank you for the video

[@luciafernandezmontoya4316]

Great tricks in Excel! That will save lots of time when mining health data. Looking forward watching future videos.

[@gregmartin]

Thanks Lucía Fernández Montoya I'll definitely post more excel tips and tricks for mining Global Health data soon. Glad you liked it! !

[@MARTINAEFEYINI]

Thanks for sharing! Added to my favorites!

[@KrisRonsin]

I am so excited to try this with my students- we have so much malnutrition data to sift through and analyze, this is going to be exceptionally helpful and will hopefully help us cut down on processing time!

[@gregmartin]

Thanks Kris Ronsin - glad you found it useful. Data can be tricky. I'm going to do a few more of these I think.

[@KrisRonsin]

That would be great- I'm relatively new to working with data, so its been slightly difficult because I generally have to learn AS I encounter a problem. I imagine there are others out there in similar situations- students or otherwise- and having guidance (especially the kind that only takes 10 or 15 minutes) is a huge asset. I'll be looking forward to more data videos on your page. Thanks so much!

[@gregmartin]

Thanks Kris Ronsin - one of the reasons that I'm looking at using excel to analyse global health data is that its software that everyone has access to. Just to let you know, I often use a ***** (Mr Excel)'s KZbin channel when I get stuck (you might find it useful). I'm kinda hoping we can get Bill to feature on this channel sometime and teach us a few tips and tricks for global health data.

[@vaniadelafuentenunez1386]

Very very helpful! Will be great to learn more excel tricks :)

[@gregmartin]

Thanks Vania de la Fuente Núñez glad you liked it. Yes, excel is a useful tool when it comes to quick and easy data analysis.

[@R00567]

awesome video!

[@gregmartin]

Glad you liked it R00567 I'll be doing more videos that "find and use data" - do let me know if there are any areas that you'd like me to cover.