Brief Introduction
Turn complex data into meaningful visualization to gain insights by creating perfect charts and histogramsDescription
A lot of us who work with data know how to make charts, but don't know how to make effective visualizations that send a clear, efficient, and truthful message. Many of us don't realize what makes charts speak and how to remove noise and focus only on what's important.
This course takes a different approach, focusing instead on various data science tools, typical workflows in data projects, algorithms, and the math behind data science. You will work on presenting and communicating with data using visual media such as charts, plots, and histograms with real-world datasets. By working with the four most popular chart types, you will dissect each of them at a microscopic level while using interesting real-world datasets with practical examples in Excel. The aim of the course is to show you where charts work and where they don't and what makes these charts easier to understand.
By the end of the course, you will have learned how to implement the principles of effective visual communication using Excel.
About the Author
Nikita Barsukov is a software developer and data scientist with 10 years' experience in the industry. He is a self-taught data scientist, who learned early on that it is often messaging, insight and data storytelling that is important in data science, not technology or software. He went through a traditional data science path at the beginning of his career—for example, learning R and machine learning algorithms using online courses. Then he also quickly grasped the value in visual data storytelling, using charts as a mode to communicate and tell something. He lives in Copenhagen, Denmark with his beautiful wife and three awesome sons.
Requirements
- Requirements
- Technical requirements. Technical requirements for this course are straightforward: * Modern browser capable of playing videos online * Microsoft Excel 365 with all the latest updates. Course does rely on a particular update viersion. Any version after 1711 (Jan 2018) is sufficient. Course was prepared using Office version 1803. * Operating system: Windows 10 with latest updates. Course is based on Windows version of Excel. Practical demos should be similar to Office on Mac, however we did not verify that functionality showing in this course is exactly the same on Office for MAC. Course was prepared on Windows 10 April 2018 update.
- Required skills. Basic familiarity with Excel is required. You should be able to start Excel, enter data, etc. You should also be familiar with following concepts: * Autofill, * Paste special
- Additional materials. Excel files used for practical demonstrations in this course are available freely on GitHub.
The Advanced Real Estate Pro Forma Modeling Master Class
- 4.7
-
![]()
![]()
![]()
![]()
![]()
The Complete Guide To Creating An Institutional-Quality Commercial Real Estate Pro Forma Model From Scratch In Excel This course is perfect for you if:...
Microsoft Office; Excel, Word & PowerPoint 2019 - Beginners
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn the essentials of Microsoft Office in this 3-course bundle for Office 355 or Office 2019 users. **This course includes practice exercises and LIFETIME access**...
Ultimate Microsoft Visio 2013 and 2016 Two-Course Bundle
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Master Microsoft Visio 2013 & 2016 to Create Incredible Flowcharts and Diagrams Microsoft Visio 2013 and 2016 Two-Course Bundle With Visio, Microsoft’s dedicated diagramming platform, you can...
Microsoft Excel - Beginner to Advanced
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Learn by doing in small, easy to understand I Excel with this A-Z MS Excel Course. Microsoft Excel 2010, 2013, 2019...
