This repo on Data Analytics In Excel will help to understand the various crucial functions available in Excel, such as vlookup, hlookup, sumif/s, counif/s, iferror and others. Finally, you will see how to use the Data Analysis Toolpak to perform various data analysis operations such as:
- Basic of excel
- Lookup & functions
- Conditional formating
- Data validation
- Sorting and filtering
- Data analysis using toolpak