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
  • Free Lesson. PDF to spreadsheets ADL2 Preview

• 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

• 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 Part 1 (ADAL2)
  • Advanced New Arrays Part 2 (ADAL2)
  • Customer Lifetime value analytics ADAL2 Preview
  • MIS Advanced Analytics ADAL2
  • How to get data from multiple tables using Vlookup Preview
  • 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 analysis exam L2 16 questions10 min
  • Career guidance ADAL2 Preview
  • Power query ADAL2
  • Data cleaning using AI ADAEL2
  • Data analytics using AI ADAEL1
  • ADAL2 assignments
  • Interview preparation ADAL2
  • Top Asked Interview Questions Preview
  • Course review and offer ADAL2
  • Affiliate marketing for ADAL2 Preview