Course Curriculum

• Analyze & manage data

  Some topics will be repeated so that you can understand and they are important. Visit our Free Knowledge Library. Some UI of the data analysis application may be changed

  • Data analysis & our courses ADL2 Preview
  • Preview data analysis lessons ADL2 Preview
  • Complete guidance of our courses ADL1 Preview
  • Beginner spreadsheet overview & Pemdas ADL2
  • How to know GST and using AI
  • PDF, Image to Sheet using AI ADAL2

• Beginner data rules

  Analyze data with simple & advanced rules. For any general queries email us at skillexperts@anywheregk.in . Some UI of the data analysis application may be changed

  • Data cleaning & management
  • Absolute & relative cell referencing, sum, divide and percentage
  • Transpose, round, round down, round up, m round and ceiling
  • Advanced sort & filter L2
  • Chart, dynamic charts & print L2
  • Data cleaning using AI ADAL2

• Advanced data rules L2

  Analyze data with advanced rules and make KPI. For any general queries email us at skillexperts@anywheregk.in . Some UI of the data analysis application may be changed

  • If and vlookup & advanced vlookup. double if & multisheet rules L2
  • Hlookup & advanced Hlookup L1
  • Index DA L2
  • Match spreadsheet L2 Preview
  • 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 & xlookup Part 1 (ADAL2)
  • Advanced New Arrays & xlookup Part 2 (ADAL2)
  • Customer Lifetime value analytics ADAL2 Preview
  • MIS Advanced Analytics ADAL2
  • How to get data from multiple tables using Vlookup Preview
  • HR employees performance management & analytics using AI
  • 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
  • Data cleaning using AI ADAEL2
  • Data analytics using AI ADAEL1
  • Data analysis exam L2 16 questions10 min
  • Career guidance ADAL2 Preview
  • ADAL2 assignments
  • Interview preparation ADAL2
  • Top Asked Interview Questions Preview
  • Course review and offer ADAL2
  • Affiliate marketing for ADAL2 Preview