Virtual Course of Advanced Excel II and SAP

curs virtual

The registration period for Advanced Excel II courses is open until April 11 and for SAP until April 22. The first course costs 20 euros and the second 30 euros. The corresponding form must be completed and submitted

 

03/04/2024

These courses want to deepen the knowledge of the most widely used tool in the business world with Excel and introduce the basics with SAP. A certificate of attendance will be given to each course.

To enroll in the course, you must complete the corresponding form. However, the payment will be made by deposit or transfer to the La Caixa account ES72 2100 5000 5102 0032 0181. Very important: You must indicate your first and last name when making the payment and attach the proof of payment to the Registration Form.

Click on the link to access the registration of the Excel Course or the SAP Course.

Calendar and Syllabus

Advanced Excel course

  • Dates: April 15 and 18
  • 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 Excel Solver to minimize cost functions.
  • Financial calculations
  • Advanced use of graphics
  •  Complete view of formulas: arrays, indirections, etc.
  • Combination of Tables
  • Add components to the Excel sheet: drop-down boxes, buttons.
  • Goal calculation
  • Data validation
  • Immobilize panels

SAP Virtual Course: 

  • Dates: April 24, 25 and 29
  • Teacher: Xavier Verge, full professor at the Faculty of Economics and Business.
  • 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 €30. The activity is an initiative of the job placement action plan of the Faculty of Economics and Business.

Targets:

  • Understand how companies manage business transactions with the support of information management tools based on ICT (Information and Communications Technologies).
  • Visualize the automations that can be realized with the digital treatment of business processes and the benefits in terms of management control and information reliability that can be obtained and that justify high investments in both time and money

Program:

     Introduction to ERPs

  • What is an ERP?
  • ERPS and other corporate Management systems
  • Basic characteristics Unique BBDD and Process Orientation
  • Type of Data
  • Customization and implementation
  • Cloud & ERP's
  • ERP Vendors

Who is SAP?

  • Evolution of SAP ERP over time
  • Main modules
  • Process automation and improvement
  • Application ecosystem 

Examples of processes with SAP S4/HANA

  • Navigation in SAP
  • Process example (hands on key practice)

Don't miss the opportunity!