Advanced Excel I and Python Virtual Course

Cartell

The registration period is open for Advanced Excel courses until November 5 and Python Programming until November 13. Each course costs 20 euros and it is necessary to complete and send the corresponding form

30/10/2023

These courses aim to deepen the knowledge of the most widely used tool in the business world with Excel and introduce the fundamentals of programming with Python, one of the most used programming languages ​​in Business Intelligence and other areas of application in the company. A certificate of attendance will be given in each course.

To register for the course, it is necessary to complete the corresponding form. However, payment will be made by deposit or transfer to the CaixaBank account ES72 2100 5000 5102 0032 0181 (remember to enter your name when making the payment so that you can identify yourself).

Click on the link to access the registration for the Excel Course or the Python Course.


Calendar and Agenda
Advanced Excel Course

- Dates: November 7 and 8,
- Teacher: Vicenç Soler, associate professor at the UAB School of Engineering.
- Schedule: The course will be distributed in two online sessions of 2 hours each, from 1:30 p.m. to 3:30 p.m.
- It has limited places and has a total cost of €20. The activity is an initiative of the job placement action plan of the Faculty of Economics and Business.

Contents:

- Use of the dollar
- Creating merged cells
- Conditional format
- Filters and subtotals: with tables, automatic and with formulas (BD)
- Dynamic tables
- dynamic graphics
- Conditionals and cell search in tables
- File merge.
- Use of the Excel Solver to minimize cost functions.
- Introduction to Macros in Excel

Python programming course

- Dates: November 15 and 22,
- Teacher: Vicenç Soler, associate professor at the UAB School of Engineering.
- Schedule: The course will be distributed in two online sessions of 2 hours each, from 1:30 p.m. to 3:30 p.m.
- It has limited places and has a total cost of €20. The activity is an initiative of the job placement action plan of the Faculty of Economics and Business.

Contents (no prior programming knowledge required):

Part I: Python Programming

- Basics of programming: variables, instructions, functions.
- Conditionals: if..les
- Loops: 'for' and 'while' statements
- Definition of functions
- Data structures: lists, dictionaries, tuples.
Part II: Applications in Data Analysis:

- Read data files
- Work with and select data sets
- Use methods in Python to analyze data.
- Show graphs and results.
Do not lose this chance!