• English
  • Polski

EXPO Katowice S.A.

Excel for intermediates

shutterstock_2244267633

Excel for intermediates

Want to take your Excel skills to the next level? Discover advanced techniques and tools that will allow you to effectively analyse data and create professional reports. Join our intermediate training course and become an Excel master!

Target group

The workshop is designed for those people for whom the computer is a tool of everyday work. We recommend it to office workers, secretaries, assistants, employees in human resources, finance, sales or production departments. We also recommend it to executives and managers for whom their daily work is the creation and management of information. We offer the course to people with little computer experience and those who are beginning to use Microsoft Excel spreadsheet for their tasks.

Training methods

The course is conducted using interactive methods, with the use of a multimedia projector, All exercises are conducted on the basis of examples taken from practice (so-called case studies). Classes, despite the presentation of complex factual knowledge, are conducted in an understandable manner, ensuring the assimilation of transmitted knowledge by each participant of the course (regardless of previous experience with the package
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.

Each participant receives a set of materials and electronic copies with all exercises conducted in the course and sample Microsoft Excel worksheets.

Training program

  • Excel once and today – history of program development, versions, differences and common features, Comparison of Excel versions 2003, 2007, 2010, 2013, 2016, 2019
  • Overview of the capabilities of Microsoft EXCEL worksheet, organization of the program, organization of the document – workbook
  • Building, modifying, formatting worksheets, creating and using functions
  • Using relative, absolute and mixed references in formulas (e.g. A1, $A$1, $A1, A$1)
  • Using basic Excel functions (math, date and time, logical functions, etc.).
  • Building a database on a worksheet, entering data, selecting data using criteria.
  • Creating electronic forms, using forms for typical applications.
  • Organizing Excel work on a computer network: simultaneous work of multiple users on a single worksheet, linking worksheets and workbooks using a computer network, merging data from multiple worksheets.
  • Use of controls (lists, drop-down lists, buttons, dials) to automate actions performed on worksheets.
  • Graphical presentation of data using charts (charts presenting multiple data series, trend analysis on a chart, custom charts).
  • Use of pivot tables as an analysis tool (e.g. multivariate analysis of sales by selected criteria, analysis of accounting data, customer analysis, data summaries).
  • Transferring information from worksheets to databases and retrieving information from databases.
  • Preparation of databases and implementation of serial correspondence by transferring data to Microsoft Word word processor.

Benefits of training

After completing the workshop, the participant is 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.