Excel in practice

The course was developed as part of the project "MOOC@PB-Nowoczesne technologie w procesie kształcenia" contract no. POWR.03.01.00-00-W040/18-00

COURSE DESCRIPTION

The course enables the acquisition of basic and intermediate skills in Microsoft Excel software. The course is divided into thematic modules in which the user acquires the skills to apply the learned solutions and tools in practice. The first thematic module introduces the user to the basic operation and functions of the Excel environment. Completion of the first module will allow you to use the basic functions of Excel. In module II, the user will develop their competences and acquire skills in advanced functions and formulas. The skills acquired in the second module will also enable the creation of professional reports, advanced analysis of large data sets and their graphic presentation.

COURSE ENTRY REQUIREMENTS

The course is dedicated to all those who want to learn or improve their skills in working with MS Excel. The student should have computer skills and have a computer with Microsoft Excel software before entering the course.

DURING THE COURSE YOU WILL LEARN:

• enter data correctly and work with multiple sheets,

• work with large lists (filtering, sorting, analysis, using pivot tables),

• phrases,

• graphically present data,

• analyze data using practical functions, formulas and pivot tables,

• use conditional logic in functions.

CONDITIONS FOR PASSING

The student should go through the whole course by doing all the tasks and analyzing the examples presented. In order to complete the course with a positive result, 51% of all possible points should be earned during the course.

During the course the student will encounter test questions:

• single choice,

• multiple choice.

COURSE STAFF

mgr inż. Patryk Zwierzyński

A practitioner and theorist in the areas of management, logistics, production engineering. I have extensive experience in manufacturing companies in the areas of procurement, logistics and warehouse management. I am a member of the Polish Society of Production Management - Podlasie branch. My professional interests focus on the following areas: production engineering, lean manufacturing, agile manufacturing, logistics and process management.

mgr inż. Cezary Winkowski

My professional and scientific interests focus on the areas of production engineering, logistics, lean management and technology roadmapping. Since graduation, I have been using the knowledge I gained in practice. I was a middle manager in several production and logistics areas. I have carried out projects related to the improvement of production and warehouse processes.