Company: Pluralsight Author: Carlos Gutierrez Full Title: Charting Data With Excel Year: 2019 Language: English Genre: Educational: Spreadsheets Skill Level: Beginner Price: - - Files: MP4 (+ Exercise Files, Subtitles .SRT, Slides .PDF) Time: 01:39:13 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 250 kbps Audio: AAC at 96 Kbps, 2 channels, 48.0 KHz It is often difficult to read and understand complex data by looking at a big table of numbers. Using Excel's rich charting tools, you will learn how to transform data into compelling visuals and uncover the important insights. Data is an increasingly important part of our organizations, and it's critical that you learn how to effectively communicate and visualize this information. In this course, Charting Data with Excel, you will gain the ability to work with several fundamental components of Excel's charting tools. First, you will learn how to create and change charts. Next, you will discover how to work with multiple data series. Finally, you will explore how to enhance your charts with features like trendlines and secondary axes. When you are finished with this course, you will have the skills and knowledge of Excel charts needed to build a dashboard full of interesting visuals for your data. Lessons: 1. Course Overview 01. Course Overview 2. Choosing, Creating, and Changing Chart Types 02. Introduction and Module Overview 03. Bar Chart 04. Column Chart 05. Line Chart 06. Area Chart 07. Pie Chart 08. Summary 3. Enhancing the Column Chart with Data Series 09. Introduction 10. Clustered Column Chart 11. Demo: Clustered Column Chart 12. Stacked Column Chart 13. Demo: Stacked Column Chart 14. 100% Stacked Column Chart 15. Demo: 100% Stacked Column Chart 16. Column Chart Comparison 17. Summary 4. Extracting Insights from the Line Chart 18. Introduction 19. Secondary Axis 20. Demo: Secondary Axis & Combo Chart 21. Linear Trendline 22. Demo: Linear Trendline 23. Additional Trendline Options 24. Demo: Moving Average Trendline 25. Summary 5. Exploring Specialized Visuals for Categorical Data 26. Introduction 27. Funnel Chart 28. Waterfall Chart 29. Radar Chart 30. Hierarchical Charts 31. Box and Whisker Chart 32. Stock Chart 33. Summary 6. Exploring Specialized Visuals for Continuous Data 34. Introduction 35. Histogram 36. Scatter and Bubble Chart 37. Map 38. Summary 7. Continue Learning Excel 39. Key Concepts 40. References Our members see more. Join us! ------------- Our members see more. Join us!