Course Curriculum

• Analyze & manage data

  Some topics will be repeated so that you can understand and they are important.

  • Data analysis & our courses L1 Preview
  • Preview data analyis lessons L1 Preview
  • Beginner spreadsheet overview & Pemdas L1

• Beginner data rules

  Analyze data with simple & advanced rules

  • Data cleaning & sorting L1
  • Absolute,relative cell referencing, sum, divide, percentage L1
  • Transpose, all round rules & filter beginner L1
  • Freeze panes & advanced date L1 Preview
  • Concatenate, flash fill, sort & filter, advanced filter & advanced conditional formatting
  • Dynamic charts & print L1

• Advanced data rules

  Analyze data with advanced rules

  • If and vlookup & advanced vlookup. double if & multisheet rules L1
  • Hlookup & advanced Hlookup L1
  • Index DA
  • Match spreadsheet L1 Preview
  • Match & reconcile
  • MIS Advanced L1
  • ADAL1 assignments
  • Career guidance ADAL1 Preview
  • Comparison with other websites ADAL1 Preview
  • Data analysis exam L1 10 questions10 min
  • Course review, suggestions and offer ADAL1