This session will introduce you to the module organization, structure and assessments. You will be exposed to the time commitments you will need to make and the skills you will develop through the duration of the module. Furthermore, you will get an understanding of the importance of data analysis and exploration in Excel as well as knowledge in to the common structure of a spreadsheet (rows and columns) and its basic element (cell).

In this session, you will be introduced to the different types of files in a computer and how they can be distinguished by the file extension, focusing on the Excel file type. Moreover, you will learn how data can be collected nowadays as well as how to import data into Excel from other external sources.

In this session, you will play the role of a data analyst to analyse and explore data related to employees of a company. Given the dataset and the requirements provided by your client, you will learn how to decompose the requirements and identify key goals to succeed.

In this session, you will be introduced to formulas in Excel as the main way of manipulating and extending the original data within the spreadsheet. You will learn how to define equations in a formula using the supported mathematical operators. Moreover, you will be introduced to the copy/paste formula context to automatically copy a given formula to subsequent cells. In addition, you will learn how to use some date-related and logical functions available in Excel.

In this session, you will learn how to summarize your findings after analysing and exploring the data within the case study. Moreover, you will have to submit the spreadsheet containing your analysis during the last session of this week.

In this session, you will play the role of a data analyst to analyse and explore data related to political risk of worldwide countries. Given the dataset and the requirements provided by your client, you will learn how to decompose the requirements and identify key goals to succeed.

In this session, you will be introduced to the use of some conditional and equality functions available in Excel as way of automatically comparing parts of your data and performing different actions according to a specified condition.

In this session, you will learn how to summarize your findings after analysing and exploring the data within the case study. Moreover, you will have to submit the spreadsheet containing your analysis during the last session of this week.

In this session, you will play the role of a data analyst to analyse and explore data related to product sales. Given the dataset and the requirements provided by your client, you will learn how to decompose the requirements and identify key goals to succeed.

In this session, you will learn how to use some math-related functions available in Excel. Moreover, you will be introduced to the concept of nested formulas as a more complex way of combining equations and/or functions within the same formula.

In this session, you will learn how to summarize your findings after analysing and exploring the data within the case study. Moreover, you will have to submit the spreadsheet containing your analysis during the last session of this week.

In this session, you will be introduced to statistics and several measures to describe the central tendency of a variable. The mean, median and mode will be introduced as different measures for this purpose depending on the type of the given variable. Moreover, you will learn how a variable can be classified into different types.

In this session, you will be introduced to statistics and several measures to describe the central tendency of a variable. The mean, median and mode will be introduced as different measures for this purpose depending on the type of the given variable. Moreover, you will learn how a variable can be classified into different types.

In this session, we will carry out a practical exercise that will serve as a review of the material covered in class and you will have the opportunity to solve your doubts to deepen your knowledge.

Find the link to the recorded classes folder.