PLU | Summarizing And Organizing Data In Excel (2019 EN)

Discussion in 'Information Technology' started by Kanka, Nov 22, 2019.

Tags:
0/5,
  1. Kanka

    Kanka Well-Known Member Loyal User

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

    Company: Pluralsight
    Author: Ben Howard
    Full Title: Summarizing And Organizing Data In Excel
    Year: 2019
    Language: English
    Genre: Educational: Spreadsheets
    Skill Level: Beginner
    Price: -
    -
    Files: MP4 (+ Exercise Files, Subtitles .SRT, Slides .PDF)
    Time: 01:02:37
    Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 300 kbps
    Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz



    A practical and pragmatic course exploring the features of Excel that allow you to organize, summarize, analyze, and visualize large amounts of data. Quickly learn how to turn data into insightful and powerful tables and charts.

    Microsoft Excel is the world’s foremost desktop application for storing, organizing, and manipulating data. This course teaches you how you can use the features of Excel to quickly organize, summarize, analyze, and visualize data so that you can understand your data and gain meaningful insights into it. First, you will learn how to order and group the data so that related items appear together. Then, you will discover how to apply totals and sub-totals to it. Finally, you will explore how to visualize the data using Conditional Formatting and Sparklines. By the end of the course, you will have the skills and knowledge to understand and visualize your own data in Excel.


    Lessons:
    1. Course Overview
    01. Course Overview
    2. Grouping Data and Outlining Your Data
    02. Why Summarize and Outline Your Data?
    03. Introduction to Grouping and Outlining
    04. Demo: Creating Groups and Outlines
    05. Demo: Removing Groups and Outlines
    3. Inserting Totals and Subtotals
    06. Introduction to Totals and Subtotals
    07. Demo: Quick Analysis Tool
    08. Looking Deeper into Totals and Subtotals
    09. Demo: Subtotals and Totals
    4. Applying Conditional Formatting
    10. Introduction to Conditional Formatting
    11. Demo: Conditional Formatting with the Quick Analysis Tool
    12. Demo: Advanced Conditional Formatting
    5. Inserting Sparklines
    13. Introduction to Sparklines
    14. Demo: Sparklines
    15. Demo: Advanced Sparklines
    6. Exploring Other Excel Capabilities
    16. Exploring Other Excel Capabilities


    -------------
     
    Kanka, Nov 22, 2019
    #1