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.