Loading Data into Excel
Offered By: Pluralsight
Course Description
Overview
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.
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.
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.
Syllabus
- Course Overview 1min
- Creating and Manipulating Workbooks and Worksheets 18mins
- Importing Data from Different Sources to Excel 27mins
Taught by
Pratheerth Padman
Related Courses
Introduction to Computational Finance and Financial EconometricsUniversity of Washington via Coursera Excel 2010
Miríadax The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard