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:

1. Basic of excel Excel Function

   • Advance Excel Pratice file:

2. Lookup & functions Lookup

https://1drv.ms/x/c/8cde32f38b783a7a/EZ6eynUCjmFCrlA68pgYsHkBpu3LO5XnOzSP14CNtcfHtQ?e=s7CPJw">

3. Conditional formating

4. Data validation

5. Sorting and filtering

6. Data analysis using toolpak

Dashboard

• SalesDashboad

• D Mart

• Sales Superstore Sample: Sales Performance Dashboard

document writing in ms word google docs

ppt presentation templates