PLU | Loading Data Into Excel (2019 EN)

Discussion in 'Information Technology' started by Kanka, Jul 28, 2019.

Tags:
0/5,
  1. Kanka

    Kanka Well-Known Member Loyal User

    Messages:
    16,037
    Likes Received:
    449
    Trophy Points:
    83
    [​IMG]

    Company: Pluralsight
    Author: Pratheerth Padman
    Full Title: Loading Data Into Excel
    Year: 2019
    Language: English
    Genre: Educational: Information Technology
    Skill Level: Beginner
    Price: -
    -
    Files: MP4 (+ Slides .PDF)
    Time: 00:48:16
    Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 150 kbps
    Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz



    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.


    Lessons:
    1. Course Overview
    01. Course Overview
    2. Creating and Manipulating Workbooks and Worksheets
    02. Module Introduction
    03. Introduction to Excel
    04. Components of Excel
    05. Worksheets and Workbooks
    06. Demo: Performing Basic Operations on Worksheets and Workbooks
    07. Demo: Copying and Moving Worksheets
    08. Summary
    3. Importing Data from Different Sources to Excel
    09. Module Introduction
    10. Loading Data from Text Files
    11. Loading Data from Microsoft Access
    12. Loading Data from SharePoint Lists
    13. Loading Data from Azure SQL Database - Part 1
    14. Loading Data from Azure SQL Database - Part 2
    15. Loading Data from Web-services
    16. Loading Data from PDF
    17. Summary


    -------------
     
    Kanka, Jul 28, 2019
    #1