Course Description:
Learn Excel from the comfort of your office or home.
Excel 2019 makes creating map charts simple. Use a map chart to compare values and show categories across geographical regions. With the Geography feature you can convert data to a geography data type and add properties relevant to your data to display in a map chart. With the Stock feature you can create a Stock Table which adds properties relevant to the stocks listed. Use the stock table to create a stock chart.
This two-hour Live Instructor-led course will explore the new Maps and Charts features in Excel 2019 and give you the tools to visualize your data. This course is good for anyone that needs to create Maps of data or wants to discover 2019 features.
Prerequisites
This class is using features that are part of Excel 2019. It is recommended that you have Excel 2019, Microsoft 365 or will be moving to this version soon.
Course Outline:
- Create Stock Charts
- Create Geography Charts
- Create a Number Map Chart
- Modify the Map Chart
- Create a Category Map Chart
- Create a Map Chart by State, County and Postal Code
- Use Quick Analysis button to create Charts
- Create Number Map Charts using SUMIF