Introduction to Data Analysis (using Excel)

  • Course level: Beginner  
There are no active Semester Schedule for this course   Pre-registar


Excel is still one of the most usefull applications in data cleaning and analysis. This course designed for beginers, to learn the data analysis techniques through practical sessions in Microsoft Excel.


To work with the different components of the Excel


To load and clean data
To work with Excel formulas
To learn how to work with tables
To learn how to use conditional formatting and styles
To import and export data
To visualize the data using different charts
To know how to choose the right chart for your data
To know how to create macros
To learn how to streamline and analyze data with Excel

Pivot Tables and Pivot Charts

To practice what you learned in a real project


Introduction to data analysis
Creating a Microsoft Excel Workbook and entering data
Formatting Microsoft Excel Worksheets
Using formulas
Conditional formatting techniques
Data Visualization using different types of charts
Developing pivot tables
Creating and editing macros
Importing and exporting data
Practicing the Data cleaning techniques
Final practical project

Registration fee :
€ 490

Target audience

  • IT staff
  • Analytics staff
  • Fresh Graduates
  • Computer Science and IT Students


  • No previous programming skills needed
  • No previous skills in excel
  • needed