MS Excel (Beginner аnd Expert Level)
MAIN POINT
Excel is a tool used by most accountants daily. This software offers a lot of possibilities and tools that considerably facilitate each accountant’s work. Moreover, the statistical information shows that most employees lack the skills needed to use tools and functions for handling large numbers that are built in Excel. In principle, this is an easy-to-use tool, however, some practical training is necessary first. The acquired skills will help a lot when analysing and preparing a budget, financial plans and planning the future. The course also offers various text processing skills that are needed for formatting a text.
How to select the appropriate course?
The level 1 course is provided for employees who 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. Special skills will not be needed.
Level 2 course is provided for experienced Excel users who are well familiar with the topics included in level 1: accountants, economists and financial managers who respond for budget planning, data processing and report preparation electronically and in hard copy.
COURSE PROGRAM
| Level 1 | Level 2 |
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 Duration: 6 hours | Actions involving databases Arranging (sorting) lists Filtering lists Making user filters Adding interim results to a spreadsheet Using several spreadsheets, files simultaneously Calculations in spreadsheets Consolidate Data Making and editing links to various workbooks Data analysis tools Making a report containing a cross-section table, chart Making simple commands Applying conditional formatting Add Data Validation Criteria Editing default parameters in Excel Duration: 6 hours |
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!
Find out the price
