· Prepare Daily report upload data from server dump to google sheet by using advance excel formula
· Prepare Revenue Dashboards with PnL, Incentives and Target setting for field staff
· Uploading data from server dump to Dashboard
· The above system works on below mentioned formulas in different combinations
· Should be able to use ChatGPT so he can generate combinations of formulas as and when required
1. COUNTUNIQUEIFS,
2. All count formulas COUNTIFS,
3. IMPORTRANGE,
4. LEFT,
5. Mid,
6. Concatenate,
7. LET(,Filter,NOT, ISBLANK,VSTACK)
8. Query,
9. ArrayFormula,
10. IFERROR,
11. Xlookup,
12. Vlookup,
13. Hlookup,
14. Ifs,
15. Sumifs,
16. Average with different combinations
17. Unique.