Excel Laboratories
The course is provided for profound solidification and development of knowledge obtained during the previous Excel courses.
Before, you mastered the work with several Excel functions and components, but in this seminar, you will master how to combine and work simultaneously with several Excel components.
Laboratory assignments will deal with the following topics:
- Data validation
- Use of passwords (sheet, workbook, cell)
- Making simple forms for entering data
- Applying functions for various data requests
- Text functions;
- Logic functions;
- VLOOKUP functions;
- Math functions;
- Date and time functions.
As is usually the case with laboratory assignments, there will be many practical examples, including review with the use of PivotTables and data visualisation with Conditional formatting.
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.
Duration of the course: 6 hours
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!
