| Assistant | Provides an AI-powered assistant inside Excel to help users understand data, generate content, create formulas, and perform common spreadsheet tasks more easily. |
| Generate Formula | Helps users generate Excel formulas from natural language descriptions, reducing the need to manually write complex formulas. |
| Quick Table | Quickly creates structured tables based on user requirements or extracts data from other files to generate organized tables, helping users prepare worksheets and summarize information more efficiently. |
| Conditional Format | Applies conditional formatting rules to highlight important values, trends, duplicates, exceptions, or cells that meet specific conditions. |
| Advanced Filter | Filters data using more flexible criteria, helping users quickly find matching records, extract specific rows, or narrow down large datasets. |
| Advanced Sort | Sorts data by one or multiple columns with advanced rules, including custom sorting orders and natural-language sorting instructions. |
| Smart Pivot | Helps users summarize and analyze data more easily by creating pivot-style reports or data summaries with less manual setup. |
| Data Validation | Creates or manages data validation rules to control input, build dropdown lists, and keep worksheet data accurate and consistent. |
| Text Processing | Provides tools for cleaning, editing, extracting, and transforming text values in selected cells without using complicated formulas. |
| Format | Helps users quickly adjust cell formats, improve worksheet appearance, and standardize the layout of selected ranges. |
| Extract Information | Extracts useful information such as names, addresses, emails, keywords, numbers, or custom data from text strings. |
