Here are some of the key features of Excel that you need to know for business analytics.

• IF
• VLOOKUP
• PivotTable

The Excel Analysis ToolPak is helpful “Excel Add-In” for doing business analytics with Excel. Loading the ToolPak will add a Data Analysis button to your Data ribbon in Excel.