Data Analysis in Excel

Data Analysis in Excel

  • Date de début 09 août 2021
  • Durée 4 hours
  • Lieu Distance Learning
  • Langue Anglais
  • Prix HT 350.00 
S'inscrire

Contexte de la formation

Data Analysis in excel is for everyone who would like to step up his/her excel skill to an advanced level. 

Objectifs

After this digital training, you will understand the various crucial  data analysis functions available in Excel.

Programme de la formation

  • 09 Aug 2021 to 13 Aug 2021  
  • Monday to Friday, during 1 week from 12:00 pm to 12:45 pm

This training will help you to understand the various data analysis functions available in Excel. You will begin with how to apply the functions to sort and filter data on your excel spreadsheet. Next, you will continue to manage your data with conditional formatting and data validation. Then, you will create pivot tables and pivot charts in Excel for data visualization. Finally, you will use the data analysis operations to perform regression, sampling, descriptive statistics, etc. to successfully complete your data analysis with excel.

  • Course Content:
    • Introduction to excel
    • Sorting and Filtering data in Excel
    • Conditional formatting and data validation
    • Pivot tables, charts, and dashboards
    • Complete Data analysis with excel spreadsheet

Intervenants

Organised by Competence Center
Jaruwan MESIT, Ph.D. Project Manager
+352 26 15 92 42 | jaruwan.mesit@competence.lu

Partager cette formation sur :