Enable the Data Analysis Toolpak add-in for advanced statistical analysis. This tool provides access to functions like Regression, ANOVA, and Descriptive Statistics.

These days, you can still use macros in Excel, but you need to enable the macro feature to do so. Here's how to enable (and disable) macros.