Microsoft is bringing its AI directly into Excel formulas with the Copilot function. It is designed to automatically analyze, categorize and summarize data.

Built-in functions, available from within Excel or from the Data Analysis Toolpak add-in, are a good option if you are new to financial modeling.