AI-Powered Excel Assistant
Analyze workbook structure, find errors, compare files.
File > Options > Add-ins > COM Add-ins > Inquire
Save different view settings (filters, hidden rows, zoom levels).
View > Custom Views > Add
Type formulas using column names with structured references:
=SUM(Sales[Amount])Select data and click the lightning bolt icon for instant:
Create interactive elements without VBA.
Developer > Insert > Form Controls
Import and clean data from virtually any source.
Data > Get Data
Automatic time-series forecasting built into Excel.
Data > Forecast Sheet
AI-powered data analysis suggestions.
Home > Ideas
Sum across multiple sheets:
=SUM(Sheet1:Sheet12!A1)Get stock and geography data directly:
=STOCKHISTORY("MSFT")Explore these hidden features to unlock Excel's full potential.
Create perfectly formatted printed reports from Excel. Master page setup, print areas, headers, footers, and scaling options.
Unlock hidden Excel features that most users overlook. From the Inquire add-in to custom views, discover powerful tools.
Maximize efficiency with Excel time-saving tips. From templates to quick shortcuts, learn to accomplish more in less time.