Course Curriculum
-
Analyze & manage data
Some topics will be repeated so that you can understand and they are important.
-
Beginner data rules
Analyze data with simple & advanced rules. For any general queries email us at skillexperts@anywheregk.in
-
Advanced data rules L2
Analyze data with advanced rules and make KPI. For any general queries email us at skillexperts@anywheregk.in
- If and vlookup & advanced vlookup. double if & multisheet rules L2
- Hlookup & advanced Hlookup L1
- Index DA L2
- Match spreadsheet L2
- Match & reconcile with advanced conditional formatting L2
- Dynamic vlookup & charts
- Advanced Pivot Table Part 1 (L2)
- Advanced Pivot Table Part 2 (L2)
- Advanced New Arrays Part 1 (ADAL2)
- Advanced New Arrays Part 2 (ADAL2)
- Customer Lifetime value analytics ADAL2
- MIS Advanced Analytics ADAL2
- How to get data from multiple tables using Vlookup
- Google sheets advanced overview ADAL2
- Google sheets advanced Importrange & hyperlinks
- Googl sheet advanced Statistical rules & Advanced Filter
- Pivot table & analytics ADAL2 (Real example)
- Financial KPI ADAL2
- ADAL2 assignments
- Top Asked Interview Questions
- Interview preparation ADAL2
- Data analysis exam L2
- Course review and offer ADAL2