Loading Data into Excel

In this course, you'll go from being introduced to Microsoft Excel and its components to discovering how to load data into excel from 6 different types/sources. It is the first in a series that is designed to help you achieve mastery over Excel.
Course info
Level
Beginner
Updated
Jun 25, 2019
Duration
48m
Table of contents
Description
Course info
Level
Beginner
Updated
Jun 25, 2019
Duration
48m
Description

This is the first course on the Microsoft Excel Data Manipulation, Presentation, and Analysis path and as such this assumes no technical knowledge about excel. First, you'll start by getting introduced to excel itself. Next, you'll discover what worksheets and workbooks are and how to manipulate them by moving and copying them around. Then, you'll move on to the meat of the course – importing data from various sources into excel. Finally, you'll be given a brief introduction to these sources and the data usually found within and then go through the steps of loading the data into excel. When you're finished with the course, you'll have a primary knowledge about Microsoft Excel and its components and how to load data into Excel from various sources.

About the author
About the author

Pratheerth is a freelance Data Scientist who has entered the field after an eclectic mix of educational and work experiences.

More from the author
Recording and Managing Excel Macros
Beginner
32m
Sep 23, 2019
Formatting Excel Worksheets and Cells
Intermediate
1h 28m
Sep 6, 2019
More courses by Pratheerth Padman
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hey everyone. My name is Pratheerth Padman, and welcome to my course, Loading Data into Excel. Currently, I'm a freelance data scientist. I used to work in manufacturing, but because of my love for all things data, I completely pivoted to data science. When I first got properly introduced to Microsoft Excel, I was truly awestruck at the capabilities of this piece of software. From creating a simple expense tracker to taking care of highly-complex data analysis, the range of what Excel can do is staggering. In this first course of the Excel series, you'll learn to import and load data from different sources into Excel. Some of the major topics that we'll cover include introduction to Excel, components of Excel worksheets and workbooks, and loading data from various sources into Excel. By the end of this course, you'll know how to import and load data into Excel from six different sources. There isn't a particular prerequisite before beginning the course, though some fundamental knowledge about data analytics would be helpful. I hope you'll join me on this journey to learn the basics of loading data from different sources into Microsoft Excel with the Loading Data into Excel course at Pluralsight.