MS Excel Tables and Calculations
This level course is provided for employees that use a computer daily and wish to optimise the time they spend in front of it. You know and use MS Excel, however, would like to know even more about it and master opportunities that will facilitate the performance of many jobs.
MAIN TOPICS
Data collection and calculations
- Making a basic table
- Types of data
- Entering data into the table and table correction
- AutoSum and AutoFill functions
- Using formulas – relative, absolute and mixed formula
- Copying formulas
Applying functions
- Reflecting absolute values
- Determining the interest in periods
- Determining the main amount in a period
Work in several worksheets and workbooks
- Work with formulas that are used in several worksheets
- Linking workbooks
Data Import
- Exporting to Microsoft Word
- Importing Word tables
Working with charts
- Making charts
- Modifying charts
Protecting worksheets and workbooks
- Protecting access to a workbook and its content
Printing a document
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!
