Excel for Business - Summer Semester 2017/2018 - CZ

The Department of Information Technologies and the Centre for Data Analytics and Intelligence (CENDAI) brings you a new course Excel for Business designed exclusively for students of English programmes at FEM CULS.

This course will help you to become more efficient in analysing your data for projects or thesis. All skills and knowledge that you learn will be also very useful at work in variety of companies and are highly appreciated at job interviews.

Topics:

  • Review of basics
  • Effective data analysis with pivot tables
  • Search functions (VLOOKUP, MATCH, INDEX)
  • Advanced charts
  • Conditional formatting
  • Using Form Controls
  • Financial calculations
  • Basic statistical functions
  • Data imports
  • Layout and format features


Basic information about the course:

Start: 19.2. - 23.4.2018

Time: Mondays from 15:45 to 17:15 (room D326) or Tuesdays 15:45 - 17:15 (room C17)

Course length: 9 sessions (13.5 hours)

Instructor: Miloš Ulman

Price: 1950 CZK*

*the price is already discounted for FEM CULS students

At the end of the course, participants completing the course successfully will receive a certificate.

If you are interested please register by 16th February 2018 here: https://goo.gl/forms/rSqE3k4Yz03pYoK22

Should you have any questions, please contact Mr. Miloš Ulman at ulman@pef.czu.cz.