Load Data into Microsoft Excel
Enhance your data skills today by learning to analyze external data in Microsoft Excel. This course will teach you how to load data from various external sources into Microsoft Excel, including flat files (CSV, text), databases, and online sources.
What you'll learn
Microsoft Excel is a popular tool for data analysis, and it's essential to know how to load data from external sources.
In this course, Load Data into Microsoft Excel, you'll enhance your data analysis skills by learning to load data from various sources, including CSV files, text files, databases, and web sources. Additionally, you'll learn how to keep the data updated with automatic refreshes.
When you're finished with this course, you'll have a better understanding of how to load and manage data in Excel from external and online resources.
Table of contents
About the author
Jared Westover is a Microsoft Certified Solutions Expert in Data Management and Analytics. When he started his education, he didn’t consider any other field than computers. Jared has been working with technology for over 15 years. He focuses on SQL Server and finding ways to tell inspiring stories with raw data. Technology became his first love while working on a Tandy back in the ’80s. Undertaking an epic quest, Jared wanted nothing more than to design video games using C. Working with data giv... more