Excel 2016 new features

Excel 2016 introduced several new features that enhanced its functionality and user experience. Here are some of the key new features:

  1. Tell Me: A new feature that allows users to quickly find and access specific features and functions in Excel. Users can type what they're looking for in the "Tell Me" box, and Excel will provide a list of relevant options.
  2. Smart Lookup: A feature that allows users to quickly look up information from the web or other sources within Excel. Users can select a cell, right-click, and choose "Smart Lookup" to access relevant information.
  3. Flash Fill: A feature that allows users to quickly fill in a series of cells with data by selecting a cell and using the "Flash Fill" button.
  4. Power Query: A new data manipulation tool that allows users to easily connect to external data sources, transform data, and load it into Excel.
  5. Power Pivot: A new data analysis tool that allows users to create complex data models and perform advanced data analysis.
  6. Power BI Integration: Excel 2016 allows users to easily integrate with Power BI, a business analytics service by Microsoft, to create interactive dashboards and reports.
  7. New Chart Types: Excel 2016 introduced several new chart types, including:
    • Waterfall charts
    • Treemap charts
    • Sunburst charts
    • Histogram charts
  8. Improved Conditional Formatting: Excel 2016 introduced new conditional formatting options, including:
    • New formatting rules
    • Improved formatting options for dates and times
    • Ability to format cells based on multiple conditions
  9. Improved PivotTables: Excel 2016 introduced several new features for PivotTables, including:
    • Improved filtering options
    • Ability to create custom calculations
    • Improved performance
  10. Improved Collaboration: Excel 2016 introduced several new features to improve collaboration, including:
    • Real-time co-authoring
    • Improved commenting and feedback tools
    • Ability to share workbooks with others
  11. Improved Accessibility: Excel 2016 introduced several new features to improve accessibility, including:
    • Improved screen reader support
    • Ability to use keyboard shortcuts
    • Improved font and color options
  12. New Add-ins: Excel 2016 introduced several new add-ins, including:
    • Power Map
    • Power View
    • Power Query

These are just a few of the many new features and improvements introduced in Excel 2016.