PAC | Data Visualization In Excel: All Excel Charts And Graphs (2020 EN)

Discussion in 'Information Technology' started by Kanka, Mar 28, 2020.

Tags:
0/5,
  1. Kanka

    Kanka Well-Known Member Loyal User

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

    Company: Packt Publishing
    Author: Start-Tech Academy
    Full Title: Data Visualization In Excel: All Excel Charts And Graphs
    Year: 2020
    Language: English
    Genre: Educational: Software
    Skill Level: -
    Price: €26.99
    -
    Files: MP4 (+ Code Files)
    Time: 03:54:27
    Video: AVC, 1364 x 768 (1.776) at 30.000 fps, 550 kbps
    Audio: AAC at 318 Kbps, 2 channels, 48.0



    Over 25 Excel charts and graphs to help you get to grips with data visualization in Microsoft Excel 2007- 2019.

    Excel charts enable spreadsheet administrators to create visualizations of data sets. By highlighting a set of data within an Excel spreadsheet and feeding it into the charting tool, you can easily create different types of charts to display data graphically.

    While most courses only cover how to draw different types of charts in Excel, this course is carefully designed to help you learn the most used chart types in the business environment, including new types such as sunburst, treemap, and waterfall charts. With this course, not only will you become familiar with the elements of charts but also be able to implement them in your work with the help of relevant business examples. Once you have grasped the charting tools, you’ll also learn how to highlight your message and avoid clutter so that your message is conveyed clearly.

    By the end of this course, you’ll be equipped with the skills to create impressive charts that express the value of numbers and make it easier to understand trends and comparisons.


    Learn:
    ✓ Create more than 25 types of charts in Excel
    ✓ Become familiar with all the elements of charts in Excel
    ✓ Get to grips with using powerful tools such as pivot tables and pivot charts
    ✓ Master newly introduced chart types such as sunburst, treemap, and waterfall chart
    ✓ Find out how you can create cool infographics to represent data
    ✓ Explore techniques to communicate a clear and concise message through your charts

    Features:
    ✓ Explore the most used Excel charts in the business environment
    ✓ Learn all about charts with this concise course over the weekend
    ✓ Discover business-related examples and case studies


    Lessons:
    1. Introduction and basics
    01. Welcome to the Course!
    02. Why are charts used?
    03. Categories of messages that can be conveyed
    04. Elements of charts
    05. The Easy way of creating charts
    2. Most important Charts and Best practices
    06. Bar and column charts
    07. Formatting charts
    08. Best Practices: Bar Chart
    09. Line Charts
    10. Avoiding the Spaghetti plot
    11. Area Charts
    12. Pie and Doughnut Charts
    13. Why we should avoid Pie charts!
    14. Scatter plot or XY chart
    15. Frequency Distribution and Histograms
    16. Waterfall charts
    17. Hierarchy Charts: Sunburst and Treemap
    18. Combination charts
    19. Highlighting chart message
    20. Eliminating Distractions from the Graph
    21. Avoiding clutter
    3. Pivot charts
    22. Pivot Charts
    23. Pivot Table Basics
    4. Less used charts
    24. Stock charts
    25. Radar charts
    26. Surface charts
    27. Heatmaps
    5. Sparklines
    28. Mini charts: Sparklines
    6. Infographics using Excel charts
    29. Creative Infographic 1
    30. Creative Infographic 2


    -------------
     
    Kanka, Mar 28, 2020
    #1