Collect, Extract and Use Online Data Quickly and More Easily
4.6 (27 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,421 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Collect, Extract and Use Online Data Quickly and More Easily to your Wishlist.

Add to Wishlist

Collect, Extract and Use Online Data Quickly and More Easily

Learn data extraction tools and techniques to get information from websites & other sources into useable, useful formats
4.6 (27 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
2,421 students enrolled
Created by Kathleen Farley
Last updated 8/2016
English
Current price: $10 Original price: $60 Discount: 83% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 1.5 hours on-demand video
  • 3 Articles
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • In this course, we'll walk through a series of handy data extraction tips and tricks
  • We'll use real-world examples to learn how to create screenshots and print-friendly PDFs, pull data out of images using optical character recognition (OCR), extract tabular and non-tabular data from webpages, and automate online data retrieval tasks
  • By the end of this course, you'll be able to use a variety of data extraction tools with confidence, so you can save time and be more effective!
View Curriculum
Requirements
  • A computer (Windows, Mac, or Linux) with Internet access
  • Any modern web browser (Chrome, Firefox, Internet Explorer, Opera, or Safari)
  • Any spreadsheet software, such as Microsoft Excel, LibreOffice, or OpenOffice
  • Some basic computer skills (cutting and pasting text, saving files into folders)
  • Some rudimentary spreadsheet skills (data entry, formatting)
  • A desire to learn!
Description
Want to learn how to QUICKLY extract data from websites and other sources into useable, useful formats?
  • Save time and resources by learning these helpful data extraction tools and techniques!

In this course, we'll review a variety of data extraction methods in a series of short tutorials aimed at beginner and intermediate-level computer users.

By the end of this course, you'll be able to use these tools and techniques with confidence, so you can get the data you need more quickly and with less effort!

HOW IS THIS COURSE DIFFERENT?

My name is Kathleen, and I've been teaching technology to beginners under the moniker Robobunnyattack! since 2009. I believe that with the right approach, anyone can learn anything.

  • My goal in this course is to help you learn how to easily collect and extract data from websites and other sources into useable, useful formats.

In this course, we'll walk through a series of helpful and practical data extraction tools and techniques. As we work together, I'll explain WHICH tools to use WHEN, so you can learn more quickly and with more confidence.

As we review several real-world examples, we'll cover:

  • How to create full-page screenshots and print-friendly PDFs from ANY website
  • Using free OCR (Optical Character Recognition) tools to extract text out of scanned documents and other images
  • How to QUICKLY extract useful information out of webpages and into your spreadsheet
  • Strategies for converting hard-to-extract web data into organized tables
  • How to automate online data retrieval tasks and other processes WITHOUT writing a single line of code!

By the end of this course, you'll be able to use a variety of data extraction tools with confidence, so you can save time and be more productive!

Here's just a sample of what my (awesome!) students have to say about this course:

"WOW — A definite favorite. Really helpful tools and tips to get information off your computer that is usable and more easily accessed. I'm incredibly grateful." —Kathleen B.

"This course opened lots of opportunity. I usually use desktop software or [web browser] plugins to do data extraction and this course added lots of knowledge. Recommended." —Arif N.

"Kathleen is brilliant teacher. She made this course so simple to follow. I loved the IFTTT method." —Sukh B.

"This is a really cool course. Everything is easy to understand and to follow." —Bronwyn W.

WHAT'S INCLUDED?

  • This course includes lifetime access to over 1½ hours of step-by-step videos.
  • You'll also get supplementary text lectures and links to helpful resources.

HOW LONG WILL IT TAKE ME?

  • This completely depends on your availability and learning preference. You can work through all the video lectures in one afternoon, or pace yourself over several days or weeks — it's up to you!

WHAT IF THIS COURSE ISN'T FOR ME?

  • This course comes with an unconditional 30-day Udemy-backed guarantee. Try out this course for 30 days and see for yourself if these data extraction tools are right for you. If you're not 100% satisfied with this course, simply request a full refund within 30 days — no conditions, no questions asked!

I'm confident you'll LOVE this course, and I'm excited to help you learn. Enrol now and you can start using these data extraction tricks to save time and effort today!

—Kathleen Farley (aka Robobunnyattack!)

Who is the target audience?
  • Beginner and intermediate-level computer users
  • Knowledge workers seeking to strengthen their data management skills
  • Learners of all ages who want to REALLY understand how to work more effectively with data –– not just memorize a series of steps!
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 13 Lectures Collapse All 13 Lectures 01:30:55
+
Introduction
1 Lecture 01:25

In this course, we'll walk through a series of handy data extraction tips and tricks. Here's what the course will cover, and what you'll need to get started.


Preview 01:25
+
Screenshots and print-friendly PDFs
3 Lectures 18:40

This tutorial screencast explains how to take a screenshot of an entire webpage (not just the visible part on your computer screen).


Preview 07:35

Here's another method of taking screenshots of entire webpages.


How to take a screenshot of an entire webpage (part 2)
04:11

This tutorial screencast demonstrates how to convert any webpage to a print-friendly PDF.

How to convert any webpage to a print-friendly PDF
06:54
+
Optical Character Recognition (OCR)
2 Lectures 19:02

This tutorial screencast demonstrates how to extract text from images using Google Drive.


How to extract text from images using Google Drive
05:49

This tutorial screencast demonstrates how to extract tabular data and other text from an image file using onlineOCR.net, a free online optical character recognition service.

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.


How to extract tabular data and other text from an image using onlineOCR.net
13:13
+
Extracting tabular data from webpages
3 Lectures 22:10

This tutorial screencast demonstrates how to paste without formatting on a Mac or a PC.


How to paste without formatting on a Mac or a PC
04:24

This tutorial screencast demonstrates how to extract tabular data from a web page into a spreadsheet.

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.



How to extract tabular data from a web page into a spreadsheet
10:11

This tutorial screencast demonstrates how to extract tabular data from a web page into LibreOffice using "Link to External Data".

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.


Preview 07:35
+
Extracting non-tabular data from webpages
1 Lecture 09:49

This tutorial screencast explains how to extract structured data from a webpage using TheWebMiner's "Get By Sample" online tool for web data extraction. In this screencast, I demo how to extract a list of Canadian record stores that carry indie music and export that list into a CSV file.

I use LibreOffice in this tutorial, but you could use any spreadsheet application such as Microsoft Excel or OpenOffice.


How to extract structured data from a webpage using TheWebMiner
09:49
+
Automating data retrieval
1 Lecture 19:02

This tutorial screencast explains how to automate data retrieval into a Google spreadsheet using IFTTT, an online service that allows you to connect triggers to actions.


Preview 19:02
+
Conclusion
2 Lectures 01:13

Wow, you did it! Let's review everything we covered.


Course review
00:27

This bonus lecture provides additional resources and links to my other courses on Udemy so you can continue your learning.

Bonus Lecture: Additional Resources
00:45
About the Instructor
Kathleen Farley
4.7 Average rating
567 Reviews
12,176 Students
9 Courses
aka Robobunnyattack! + co-founder of Audiohackr

Kathleen Farley is a computer geek, teacher, learner, vinyl junkie, hockey fan, and recovering non-profit executive. Occasionally she breaks (and fixes) computers. Not necessarily in that order.

The Montreal-born technologist trained as an audio engineer before moving to Hamilton, Canada in 2007. She now runs Maisonneuve Music, a Hamilton-based independent record label.

Kathleen teaches technology and management skills at a music industry school in Toronto, Canada. She's also the co-founder of Audiohackr, a startup that helps indie musicians, producers, and DIY labels make the most of technology.

Kathleen produces technology training videos under the moniker Robobunnyattack!