Two new chart types, Funnel Chart and Map Chart, are available in Excel 2019.<\/p>\n
Map Chart<\/strong><\/h3>\nExcel 2019 includes a new map chart type. Map charts leverage Bing maps to render location- based visualizations. You can\u00a0create a map chart\u00a0<\/strong>to compare values and show categories across geographical regions. Use it when you have geographical regions in your data, like countries\/regions, states, counties or postal codes. All you need to provide are location indicators (country names, Cities, etc), and then Excel does the rest.<\/p>\nMap charts are remarkably flexible, allowing you create a chart based on province names, county names, cities, and even ZIP codes. As long as Bing can recognize the values that you are using to identify geography, your chart will render seamlessly.<\/p>\n
<\/p>\n
![\"Map](\"https:\/\/i0.wp.com\/www.pmvision.ca\/global\/wp-content\/uploads\/2018\/10\/Map-Charts.jpg?resize=1024%2C454\" "\\"Map")
<\/a>Map Charts in Microsoft Excel 2019<\/strong><\/p><\/div>\n\n <\/p>\n
Double-clicking the map will active the Format Data Series task pane , exposing a handful of unique formatting options. These options allow you to change the projection (flat or curved map), the area (show all locations or just those that have data), and the series color (apply color banding based on values).<\/p>\n
<\/h4>\nFunnel charts<\/strong><\/h3>\nFunnel charts<\/strong>\u00a0show values across multiple stages in a process. For example, you could use a funnel chart to show the number of sales prospects at each stage in a sales pipeline. Typically, the values decrease gradually, allowing the bars to resemble a funnel.<\/p>\n <\/p>\n<\/div>\n
![\"Funnel](\"https:\/\/i0.wp.com\/www.pmvision.ca\/global\/wp-content\/uploads\/2018\/10\/A-Funnel-chart-in-Excel-2019.jpg?resize=721%2C362\")
<\/a>Funnel charts in Excel 2019<\/p><\/div>\n
<\/p>\n
<\/h2>\nEnhanced AutoComplete<\/strong><\/span><\/h2>\nWhen you start typing a function name, AutoComplete will show you a list of functions that start with what you typed. In Excel 2019, AutoComplete tries to give you a better list. If you type =Day, you no longer just get DAY and DAYS360. Now you also get NETWORKDAYS, TODAY, and many more.<\/p>\n
Power Query and Power Pivot<\/strong><\/span><\/h2>\nExcel 2019 adds many new minor features including several new connectors, new filter options, and new transform options.<\/p>\n
Learn Microsoft Excel 2019 Fundamentals in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/strong><\/a><\/p>\nLearn Microsoft Excel 2019 Intermediate Level in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/a> <\/strong><\/p>\nLearn Microsoft Excel 2019 Advanced Level in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/a> <\/strong><\/p><\/blockquote>\n<\/h2>\nNo CSV warnings<\/strong><\/span><\/h2>\nExcel 2019 will no longer warn you that you\u2019ll lose features if you save as a CSV file.<\/p>\n
Icons<\/strong><\/span><\/h2>\nThe Insert tab in Excel 2019 contains an Icons control with many premade icons for you to use.SVG images<\/strong><\/p>\nSVG images<\/strong><\/span><\/h2>\nIn Excel 2019, you can insert Scalable Vector Graphic (SVG) images and even convert them into shapes.<\/p>\n
Deselect cells<\/strong><\/span><\/h2>\nIf you\u2019ve ever selected multiple cells by holding down the Ctrl key and you accidentally selected too many, you\u2019ll appreciate this new feature. Instead of starting over, you can Ctrl+click a selected cell to deselect it.<\/p>\n
PivotTable layout<\/span>
\n<\/strong><\/h2>\nYou can save your preferred PivotTable settings as a default layout, and all new PivotTables you create will automatically have those settings.<\/p>\n
New functions<\/strong><\/span><\/h2>\nCONCAT<\/b><\/p>\n
This new function is like CONCATENATE, but better. First of all, it’s shorter and easier to type. But it also supports range references, in addition to cell references. Learn more about\u00a0CONCAT.<\/p>\n
IFS<\/b><\/p>\n
With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else “catch all” if none of the conditions are met. Learn more about\u00a0IFS.<\/p>\n
MAXIFS<\/b><\/p>\n
This function returns the largest number in a range, that meets a single or multiple criteria.<\/p>\n
MINIFS<\/b><\/p>\n
This function is similar to MAXIFS, but it returns the smallest number in a range, that meets a single or multiple criteria.<\/p>\n
SWITCH<\/b><\/p>\n
This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the “else” is returned.<\/p>\n
TEXTJOIN<\/b><\/p>\n
This function combines text from multiple ranges, and each item is separated by a delimiter that you specify.<\/p>\n
<\/p>\n
Related Microsoft Excel Training Courses<\/strong><\/span><\/h2>\nTake Microsoft Excel 2019 Fundamentals Training Courses in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/strong><\/a><\/p>\nTake Microsoft Excel 2019 Intermediate Level Training Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/a> <\/strong><\/p>\nTake Microsoft Excel 2019 Advanced Level Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/a> <\/strong><\/p>\nMicrosoft Excel 2019 Tables, Pivot Tables and Conditional Formatting<\/strong><\/a><\/p>\nMicrosoft Excel 2019 | Data Analysis with Pivot Tables<\/strong><\/a><\/p>\nMicrosoft Excel 2019 | Using Formulas for Financial Analysis<\/strong><\/a><\/p>\n
Map charts are remarkably flexible, allowing you create a chart based on province names, county names, cities, and even ZIP codes. As long as Bing can recognize the values that you are using to identify geography, your chart will render seamlessly.<\/p>\n
<\/p>\n
![\"Map](\"https:\/\/i0.wp.com\/www.pmvision.ca\/global\/wp-content\/uploads\/2018\/10\/Map-Charts.jpg\" "\\"Map")
<\/a>Map Charts in Microsoft Excel 2019<\/strong><\/p><\/div>\n <\/p>\n Double-clicking the map will active the Format Data Series task pane , exposing a handful of unique formatting options. These options allow you to change the projection (flat or curved map), the area (show all locations or just those that have data), and the series color (apply color banding based on values).<\/p>\n Funnel charts<\/strong>\u00a0show values across multiple stages in a process. For example, you could use a funnel chart to show the number of sales prospects at each stage in a sales pipeline. Typically, the values decrease gradually, allowing the bars to resemble a funnel.<\/p>\n <\/p>\n<\/div>\n Funnel charts in Excel 2019<\/p><\/div>\n <\/p>\n When you start typing a function name, AutoComplete will show you a list of functions that start with what you typed. In Excel 2019, AutoComplete tries to give you a better list. If you type =Day, you no longer just get DAY and DAYS360. Now you also get NETWORKDAYS, TODAY, and many more.<\/p>\n Excel 2019 adds many new minor features including several new connectors, new filter options, and new transform options.<\/p>\n Learn Microsoft Excel 2019 Fundamentals in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/strong><\/a><\/p>\n Learn Microsoft Excel 2019 Intermediate Level in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/a> <\/strong><\/p>\n Learn Microsoft Excel 2019 Advanced Level in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/a> <\/strong><\/p><\/blockquote>\n Excel 2019 will no longer warn you that you\u2019ll lose features if you save as a CSV file.<\/p>\n The Insert tab in Excel 2019 contains an Icons control with many premade icons for you to use.SVG images<\/strong><\/p>\n In Excel 2019, you can insert Scalable Vector Graphic (SVG) images and even convert them into shapes.<\/p>\n If you\u2019ve ever selected multiple cells by holding down the Ctrl key and you accidentally selected too many, you\u2019ll appreciate this new feature. Instead of starting over, you can Ctrl+click a selected cell to deselect it.<\/p>\n You can save your preferred PivotTable settings as a default layout, and all new PivotTables you create will automatically have those settings.<\/p>\n CONCAT<\/b><\/p>\n This new function is like CONCATENATE, but better. First of all, it’s shorter and easier to type. But it also supports range references, in addition to cell references. Learn more about\u00a0CONCAT.<\/p>\n IFS<\/b><\/p>\n With this function, conditions are tested in the order that you specify. If passed, the result is returned. You can also specify an else “catch all” if none of the conditions are met. Learn more about\u00a0IFS.<\/p>\n MAXIFS<\/b><\/p>\n This function returns the largest number in a range, that meets a single or multiple criteria.<\/p>\n MINIFS<\/b><\/p>\n This function is similar to MAXIFS, but it returns the smallest number in a range, that meets a single or multiple criteria.<\/p>\n SWITCH<\/b><\/p>\n This function evaluates an expression against a list of values in order, and returns the first matching result. If no results match, the “else” is returned.<\/p>\n TEXTJOIN<\/b><\/p>\n This function combines text from multiple ranges, and each item is separated by a delimiter that you specify.<\/p>\n <\/p>\n Take Microsoft Excel 2019 Fundamentals Training Courses in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/strong><\/a><\/p>\n Take Microsoft Excel 2019 Intermediate Level Training Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/a> <\/strong><\/p>\n Take Microsoft Excel 2019 Advanced Level Classes in Toronto, Mississauga, Scarborough , Montreal & Ottawa<\/a> <\/strong><\/p>\n Microsoft Excel 2019 Tables, Pivot Tables and Conditional Formatting<\/strong><\/a><\/p>\n Microsoft Excel 2019 | Data Analysis with Pivot Tables<\/strong><\/a><\/p>\n Microsoft Excel 2019 | Using Formulas for Financial Analysis<\/strong><\/a><\/p>\n<\/h4>\n
Funnel charts<\/strong><\/h3>\n
<\/a><\/h2>\n
Enhanced AutoComplete<\/strong><\/span><\/h2>\n
Power Query and Power Pivot<\/strong><\/span><\/h2>\n
<\/h2>\n
No CSV warnings<\/strong><\/span><\/h2>\n
Icons<\/strong><\/span><\/h2>\n
SVG images<\/strong><\/span><\/h2>\n
Deselect cells<\/strong><\/span><\/h2>\n
PivotTable layout<\/span>
\n<\/strong><\/h2>\nNew functions<\/strong><\/span><\/h2>\n
Related Microsoft Excel Training Courses<\/strong><\/span><\/h2>\n