Exploring Excel 2016 and 2019 (Part 3)

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

Getting Started with Excel 2016 and 2019 (Part 3)

In the previous articles Exploring Excel 2016 and 2019 (Parts 1 and 2), readers have joined Mytour in understanding how to use basic features in Excel 2016 and 2019, from the Ribbon bar to new chart types, ... . In the following article below, Mytour will highlight the new features exclusive to Excel 2019.

Excel 2019 introduces additional features and new functions. To delve into the details of these features and functions, readers can refer to the article Exploring Excel 2016 and 2019 (Part 3) presented by Mytour below.

Exploring Excel 2016 and 2019 (Part 3)

Getting Started with Excel 2016 and 2019 (Part 3)

1. New Features on Excel 2019

Microsoft has added some exciting new features to Excel 2019, notably including 2 new types of charts.

- Funnel Chart:

Funnel chart is useful when you want to display values at various stages in a process. Basically, values in the funnel chart decrease at each stage, so the bars in the chart are arranged to resemble a funnel shape.

When creating a funnel chart for data, we use one column for stages throughout the process and another column for values at each stage. To create the chart, first select the data, then choose Insert => Recommended Charts => All Charts => Funnel.

- Map Chart:

Use Map Chart to compare data between different geographical areas, such as countries, regions, states, counties, or postal codes. Excel will automatically recognize the regions and create a visual map of the data.

To create a Map Chart, first select the data you want to chart, then choose Insert =>Maps =>Map Chart. Note that in some cases, Excel may encounter errors when creating the map. If an error occurs, you may need to add one or more columns with detailed location information.

2. New Functions in Excel 2019

Excel 2019 introduces 6 new Excel functions, making calculations easier. Among them, the TEXTJOIN and CONCAT functions allow users to combine text strings from ranges of cells, with or without a delimiter to separate each item, such as a comma. Use the IFS and SWITCH functions to specify a series of conditions. Finally, the MAXIFS and MINIFS functions help filter and calculate data in various ways more easily.

3. Excel 2016 and 2019 Shortcuts

To save time and execute commands, insert formulas, functions faster, improve work efficiency, ... the quickest solution is to use Excel shortcuts.

Readers can refer to the article Excel Shortcuts, all versions 2003, 2007, 2010, 2016, 2013 on Mytour to explore the list of the most basic Excel shortcuts.

So the article Getting Familiar with Excel 2016 and 2019 (Part 3) above has just covered some new features in Excel 2019 and how to use these features as well as basic Excel shortcuts. In addition, if you have any questions or need clarification, readers can leave their comments below the article.

Review

- Introduction to Excel 2016 and 2019 Part 1
- Introduction to Excel 2016 and 2019 Part 2

Frequently Asked Questions

What are the new chart types introduced in Excel 2019 and how do they work?

Excel 2019 introduces two new chart types: the Funnel Chart and the Map Chart. The Funnel Chart visually represents values decreasing at various stages in a process, while the Map Chart compares data across geographical areas. To create a Funnel Chart, select your data, go to Insert, then choose Recommended Charts and select Funnel. For a Map Chart, select your data, go to Insert, and choose Maps followed by Map Chart.

How can I use the new functions available in Excel 2019 to improve my calculations?

Excel 2019 introduces six new functions, including TEXTJOIN and CONCAT for combining text strings with or without delimiters. The IFS and SWITCH functions allow for multiple conditions in calculations. Additionally, MAXIFS and MINIFS help filter and calculate data efficiently. By using these functions, you can enhance your data manipulation and streamline your calculation processes.

What is the significance of using shortcuts in Excel 2016 and 2019?

Using shortcuts in Excel 2016 and 2019 significantly enhances efficiency by saving time on executing commands and inserting formulas. Familiarizing yourself with Excel shortcuts allows for quicker navigation and operation, improving overall productivity. For a comprehensive list of shortcuts, readers can refer to articles dedicated to Excel shortcuts across all versions.

Can you explain the process of creating a Funnel Chart in Excel 2019?

To create a Funnel Chart in Excel 2019, first select the data representing the stages and values. Then navigate to the Insert tab, click on Recommended Charts, and choose Funnel. This chart type will effectively display the decreasing values at each stage of your process, visually resembling a funnel.

How does the Map Chart function work in Excel 2019 for geographical data representation?

The Map Chart function in Excel 2019 allows users to visualize data across different geographical areas, like countries or states. To use it, select your data and go to the Insert tab, then click on Maps and choose Map Chart. Excel will automatically recognize regions and create a visual representation, although it may require additional location details for accuracy.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]