Ep 5. Creating Sparklines and Mapping Data

Creating Sparklines and Mapping Data is an episode in the third season of Microsoft Excel 2016 - Training. In this episode, viewers will learn about two powerful visualization tools in Excel: sparklines and mapping.

The episode will begin with an explanation of what sparklines are and how they differ from regular charts. Sparklines are small, simple charts that are designed to be embedded within cells. They are ideal for showing trends over time or comparing values across different categories. Viewers will learn how to create sparklines in Excel, including line sparklines, column sparklines, and win/loss sparklines. They will also learn how to format their sparklines and customize their appearance.

After covering sparklines, the episode will move on to mapping data in Excel. Mapping data is an excellent way to visualize geographic information and spot trends or patterns that may not be immediately apparent in standard charts or graphs. The episode will cover how to create maps in Excel using the built-in Power Map tool. Viewers will learn how to import data into Power Map, customize the appearance of their map, and filter their data based on different criteria.

Throughout the episode, viewers will also learn some best practices and tips for working with Excel. For example, they will learn how to use keyboard shortcuts to speed up their workflow, use Excel's built-in templates to save time, and automate repetitive tasks using macros. By the end of the episode, viewers should feel comfortable creating sparklines and mapping data in Excel, as well as using some time-saving Excel tips and tricks.

Overall, Creating Sparklines and Mapping Data is a valuable episode for anyone who wants to improve their Excel skills. Whether you need to visualize data for work, school, or personal projects, sparklines and maps are powerful tools that can help you better understand your data and make more informed decisions. And with Excel's powerful features and capabilities, you'll be able to create beautiful, informative visualizations in no time.