Pivot Table in Two Parts
It would be very advisable to have basic knowledge of Pivot when participating in this course as this is an advanced course. If needed basic Pivot skills can be acquired during the 6th class of this course “Excel (the Most Popular Functions in a Practical and Definite Way)”
Considered topics about Pivot tables:
- Pivot Table gridlines;
- Using Slicer of data cuts;
- Adopted calculations that are built in Pivot;
- Consolidation and division by worksheets in Pivot;
- Making charts in a couple of clicks.
* It is advisable to use two devices during the lesson. By launching Zoom on one device, use it to listen to the lecturer’s instructions, and use the second one for the practical assignments and their fulfilment. For example, Zoom can be launched and the lecture can be listened to on a mobile phone, and the assignments can be fulfilled by using a computer. It is not mandatory, however, highly recommended. It would be easier to work this way.
** The lecturer uses Microsoft Excel for the training. Other Excel versions (Libero, Apple, etc.) may be different.
The course is presented by:
Aija Virse
An IT lecturer having more than 20-years’ experience in various types of training for adults at various levels gained in both major and minor projects.
Thanks to Liepaja’s bitter winds, the lecturer was awarded an academic master’s degree in computer sciences and supplemented it with the professional master’s degree in psychology. Therefore, any classes conducted by the lecturer will go smoothly enriching user experience and leading to new conclusions. The most important is students’ motivation and willingness to learn, and the lecturer is responsible for the rest.
The most demanded topics are Microsoft Office applications: Excel, Outlook, PowerPoint and Word. If You have a question what MS Office version? – any version, starting with 1997 up to O365 and more recent.
This course can be presented by the lecturer in the Latvian, English or Russian language upon the audience’s request.
There are not more than 14 participants in a group!
Duration of the course: 6 hours
Find out the price
