Excel new features

Here are some of the new features in Excel:

Excel 2019

  1. New formulas and functions: Excel 2019 introduces several new formulas and functions, including:
    • IFS (Immediate If-Then-Else) function
    • MAXIFS and MINIFS functions
    • FILTER function
    • XLOOKUP function
  2. Dynamic arrays: Excel 2019 introduces dynamic arrays, which allow you to create arrays that can change size and shape based on the data.
  3. New chart types: Excel 2019 introduces several new chart types, including:
    • Waterfall charts
    • Treemap charts
    • Sunburst charts
  4. Improved data analysis: Excel 2019 includes several new data analysis features, including:
    • Improved data modeling
    • Enhanced data visualization
    • New data analysis tools, such as the "Data Analysis" pane
  5. Enhanced collaboration: Excel 2019 includes several new collaboration features, including:
    • Real-time co-authoring
    • Improved commenting and feedback
    • New collaboration tools, such as the "Collaboration" pane

Excel 2020

  1. New formulas and functions: Excel 2020 introduces several new formulas and functions, including:
    • LET function
    • IFS function
    • XLOOKUP function
    • FILTER function
  2. Dynamic arrays: Excel 2020 builds on the dynamic arrays introduced in Excel 2019, allowing you to create more complex and flexible arrays.
  3. Improved data analysis: Excel 2020 includes several new data analysis features, including:
    • Improved data modeling
    • Enhanced data visualization
    • New data analysis tools, such as the "Data Analysis" pane
  4. Enhanced collaboration: Excel 2020 includes several new collaboration features, including:
    • Real-time co-authoring
    • Improved commenting and feedback
    • New collaboration tools, such as the "Collaboration" pane
  5. New accessibility features: Excel 2020 includes several new accessibility features, including:
    • Improved screen reader support
    • Enhanced keyboard navigation
    • New accessibility options, such as the "Accessibility" pane

Excel 2021

  1. New formulas and functions: Excel 2021 introduces several new formulas and functions, including:
    • LET function
    • IFS function
    • XLOOKUP function
    • FILTER function
    • XMATCH function
  2. Dynamic arrays: Excel 2021 builds on the dynamic arrays introduced in Excel 2019 and 2020, allowing you to create more complex and flexible arrays.
  3. Improved data analysis: Excel 2021 includes several new data analysis features, including:
    • Improved data modeling
    • Enhanced data visualization
    • New data analysis tools, such as the "Data Analysis" pane
  4. Enhanced collaboration: Excel 2021 includes several new collaboration features, including:
    • Real-time co-authoring
    • Improved commenting and feedback
    • New collaboration tools, such as the "Collaboration" pane
  5. New AI-powered features: Excel 2021 includes several new AI-powered features, including:
    • AI-powered forecasting
    • AI-powered data analysis
    • AI-powered suggestions for formulas and functions

Excel 2022

  1. New formulas and functions: Excel 2022 introduces several new formulas and functions, including:
    • LET function
    • IFS function
    • XLOOKUP function
    • FILTER function
    • XMATCH function
    • SWITCH function
  2. Dynamic arrays: Excel 2022 builds on the dynamic arrays introduced in Excel 2019, 2020, and 2021, allowing you to create more complex and flexible arrays.
  3. Improved data analysis: Excel 2022 includes several new data analysis features, including:
    • Improved data modeling
    • Enhanced data visualization
    • New data analysis tools, such as the "Data Analysis" pane
  4. Enhanced collaboration: Excel 2022 includes several new collaboration features, including:
    • Real-time co-authoring
    • Improved commenting and feedback
    • New collaboration tools, such as the "Collaboration" pane
  5. New AI-powered features: Excel 2022 includes several new AI-powered features, including:
    • AI-powered forecasting
    • AI-powered data analysis
    • AI-powered suggestions for formulas and functions
    • AI-powered data visualization

Note that these are just some of the new features in each version of Excel, and there may be other features that are not listed here.