• English
  • Polski

EXPO Katowice S.A.

Excel in the company standard level

spreadsheet-marketing-budget-report-file-concept

Excel in the company standard level

Participants take an active part in the classes throughout the course, performing a number of practical exercises.

The Excel workshop in the Company, which has been organized for many years, enjoys unflagging popularity among participants and is highly rated both in terms of its substantive level and accessible teaching techniques. The workshop program is constantly modified and adapted to the changing market needs.

Target group

The workshop is intended for people for whom a computer is a tool in their daily work. We recommend them to employees of financial departments, offices, secretaries, assistants, employees of human resources, sales and production departments. We also recommend them to management staff whose daily work is to create and manage information. We offer the course to people with little experience working on a computer and to those who are starting to use Microsoft Excel for their tasks.

Training methods

The course is conducted using interactive methods, using a multimedia projector. All exercises are conducted on the basis of examples taken from practice (so-called case studies). Despite presenting complex substantive knowledge, the classes are conducted in an understandable way, ensuring that each course participant absorbs the knowledge provided (regardless of previous experience with Microsoft Office). Each participant receives a set of written materials (scripts, supporting materials for exercises) and copies of data with all exercises conducted as part of the course.

Training program

  • Excel in the past and today – a short history of the program’s development, versions, differences and common features
  • Review of the capabilities of the Microsoft EXCEL sheet, program organization, document organization – workbook
  • Building, modifying, formatting sheets, creating and using functions.
  • Using relative, absolute and mixed references in formulas (e.g. A1, $A$1, $A1, A$1), fast formula copying.
  • Use of basic Excel functions (mathematical, date and time, logical functions, etc.)
  • Organization of work with Excel in a computer network: simultaneous work of many users on one sheet, combining sheets and workbooks via a computer network, merging data from many sheets.
  • Using controls (lists, drop-down lists, buttons, knobs) to automate activities performed on sheets.
  • Graphical presentation of data using charts (charts presenting multiple data series, trend analysis on a chart, custom charts).
  • Building a database – a data table on a sheet, entering data, selecting data using criteria, using a form. Rules for correct creation of tables – lists of data
  • Using simple pivot tables as an analysis tool (e.g. multi-variant sales analysis according to selected criteria, accounting data analysis, customer analysis, data summaries).
  • Preparing databases and implementing mail merge by transferring data to the Microsoft Word text editor – form letters, e-mails, envelopes, labels, using mail merge fields.

Benefits of training

After completing the workshop, the participant will be able to:

Certificate

After the training, the participant will receive a certificate confirming participation in the training and acquired knowledge.

Coach

Projekt bez nazwy-41

Janusz Gach

He has been providing training for years, explaining the intricacies of spreadsheets and accessibly showing the possibilities behind them. He specializes in Microsoft Excel, as well as other elements of the MS Office suite. His training courses are aimed at employees in the financial sector, as well as other office workers, engineers, salespeople of various professions. The trainer’s training courses and classes are used by all who wish to expand their practical use of the spreadsheet: both at a basic and more advanced level.

Trainings EXPO Katowice S.A.

Individual training

If you have not found a training course in our offer that perfectly suits your company’s needs, we encourage you to contact us. We will create a personalised offer for you, taking into account the specific needs and preferences of your company.