Excel for Business - Winter Semester 2018/2019

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

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


Course runs from 16.10. to 11.12.2018
Every Tuesday or Wednesday from 15:45 to 17:15
Total course length is 9 sessions (13.5 hours)
Instructor: Miloš Ulman ulman@pef.czu.cz
Price: 2350 CZK

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

If you are interested please register and make your payment before 23rd October 2018.

You will receive the payment instructions in a confirmation email.

 

Tuesdays 15:45 - 17:15 room C14: Register

Wednesday 15:45 - 17:15 room C18: Register

 

Information and photos from the inaugural run of the course is here: https://cendai.pef.czu.cz/inaugural-run-of-the-course-excel-for-business-concluded

Contact

Secretariat

Melanie Suchá
+420 22438 2364
sucha@pef.czu.cz
s_kit@pef.czu.cz
Office: E342

Address

Kamýcká 129
165 00
Praha - Suchdol
+420 22438 2364
s_kit@pef.czu.cz