Excel for data analysis

Course presentation

Target Group

Entrepreneurs, managers, marketing and sales staff, management assistants, analysts, accountants, and anyone who wants to gain advanced skills in working with Excel data and using it to make better decisions in their company.

individual-program-modules-and-their-scope

1. Introduction to data analysis in Excel and overview of basic functions – 6 hours
2. Working with tables, sorting and filtering data – 6 hours
3. Advanced formulas, contingency tables and charts – 10 hours
4. Data Analysis using Power Query and Power Pivot – 8 hours
5. Visualizing results and creating reports – 6 hours
6. Practical examples and case studies from real practice – 6 hours

Total course schedule: https://drive.google.com/file/d/1YhRW6XicJ_NbhZTiujlaKf303HCj-g8b/view?usp=sharing

Requirements-for-participant-inclusion

• Completed secondary education with a high school diploma
• Basic computer literacy
• Recommended: proficiency with the Internet, email, office tools (Word, Excel) and an interest in new technologies

Sign-up for a course via this form.

Graduate Profile

The graduate of this course will be able to efficiently process and analyze data in Excel, use advanced functions, contingency tables, Power Query and Power Pivot, visualize results, and create insightful reports to support decision making in the company.

Learning-methods

• Example using presentations
• Group work and discussion
• Practical demonstrations and case studies
• Final individual exercise (depending on module)

Technical, material and space security

The training takes place in a training room The Spot with a capacity of min. 8 persons. The room is equipped with:

• Projector or interactive whiteboard
• PC/laptop for the lecturer
• Wi-Fi connection
• Flipchart or whiteboard

Method of payment and billing:

• After your application has been confirmed, a back invoice will be emailed to you.
• Invoice contains all payment details including variable symbol and account number.
• The course must be paid by bank transfer no later than 5 working days before the start of the course.
• On receipt of payment, we will issue and send you a direct tax invoice (proof of payment).

Payment can only be made on the basis of an invoice, no cash or card payment on the spot.

On request payment can be arranged in two instalments.

Terms & Conditions

• Free cancellation of participation is possible no later than 7 calendar days prior to the start of the course.
• In case of cancellation 6 to 1 day prior to the course, a service fee of 50% of the course price will be charged.
• Not attending a course without notification is considered a binding booking – course fee is non-refundable.

Money-back:

• In case of a justified cancellation (early cancellation, insufficient number of participants, cancellation of the course by the organizer), the entire amount paid will be refunded back to your account within 7 working days of receiving written notification or decision of cancellation.
• In the event of a partial cancellation, the relevant percentage of the price will be refunded according to the above terms and conditions.

Change of date or participation:

• In case of serious reasons it is possible by agreement:
  • reschedule participation to another date, or
  • transfer the application to another person (substitute).

General Terms and Conditions

Link to GTC– https://drive.google.com/file/d/18JHjbL1Xw94sBaDDE-PrMObiwXZpAB4W/view?usp=sharing

Lecturers

• Mgr. Andrej Krchňavý
• Ing. Adam Krchňavy

Sign-up for a course via this form.