Complete Beginner's Guide to Excel

Harvesting data is easy, but formatting data can be tricky. Learn more methods to copy and paste website data into Microsoft Excel spreadsheets.

In this lesson, learn to parse data from a company website in Microsoft Excel, turning data anomalies and glitchy formatting into a clean Excel spreadsheet.

In this lesson, learn about using web scraping software to ease data collection from the web—a great tool for both business people and researchers!

If you only use Microsoft Excel to keep records, you’re missing out on some seriously cool features! Learn how to freeze frames, sort and filter data, and more.

Learn a whole new way of looking at spreadsheet data: the pivot table! Todd McLeod shows how to generate pivot tables in Microsoft Excel workbooks.