Data visualization is becoming an increasingly important skill in an age driven by big data. Visualizations must not only make data easy to understand, but also tell a story and provide context. Excel is not the only tool in this category, but it is an excellent choice, especially if your data is stored there. Excel offers many tools to create visualizations, including charts. The chart options are continually improving and increasing in number, so newer versions include sunburst charts, waterfall charts, and map charts. Excel's flexibility is what makes it stand out. We can create our own animated custom charts to tell the right story with our data.
We will be exploring Excel's vast array of visualization tools over five weeks using case studies and practical examples as seen through Rohan, an environment analyst. Rohan must create visualizations that show trends, forecasts as well as breakdowns and comparisons of a wide range of environmental data sets. Rohan is not content with using the standard chart types. He wants to use conditional formats and sparklines as well as specialised charts. He can even create animated charts and infographics. He may also need to prepare data using pivot tables in order to drill down to answer specific questions. We will help him accomplish all of this, and then present the final visualizations in reports and dashboards using tools such as slicers and macros to automate and interactivity. These are the topics that we will be covering: Week 1: Dynamic visualizations using conditional formatting, custom numbers formatting, sparklines, and macros Week 3: Charting techniques to tell the right story Week 4: Summarizing and filtering data using pivot tables and pivot charts Week 5, creating interactive Excel dashboards. This course is part of our Specialization in Data Analytics and Visualization. Excel Fundamentals for Data Analysis is the first course. It covers data preparation and cleaning, but also teaches you some of the prerequisites for this course, such as tables and named ranges, as well as text, lookup, and logical functions. We recommend that you take the first course, or have some experience with these topics to get the most from this course. This course focuses on Data Visualization in Excel. Join us for this exciting journey.
