Excel has several built-in tools with most using AI technology to help users maximize the use of the software. These tools are:
Flash Fill: automatically fills in data based on patterns and examples you provide.
Smart Lookup: uses Bing to search the web for more information about selected text or data.
Quick Analysis: provides a quick way to apply charts, tables, and other data analysis tools to your data.
Power Query: allows you to connect to and transform data from various sources, such as databases and web services.
Power Pivot: enables you to create pivot tables and pivot charts from multiple data sources.
Power View: allows you to create interactive data visualizations and explore your data in new ways.
Power Map: provides a 3D visualization tool for mapping data and discovering insights.
Power BI: connects to various data sources and allows you to create interactive dashboards and reports.