10 academic hours of training with the option for separate groups to choose preferred topics.
Training goal – to get acquainted with the program’s features that help manage company data and prepare reports.
Program:
- Creating, editing, formatting tables, cell formats;
- Data formats and sequences;
- Actions with rows and columns;
- Conditional formatting;
- Coordinates (relative, absolute, mixed);
- Basic formulas and functions;
- Conditional (logical) functions (IF, COUNTIF(S), SUMIF(S), AVERAGEIF(S));
- Data joining, splitting;
- Sorting, filtering, introduction to pivot table creation;
- Cell, sheet, workbook protection;
- Creating and editing charts and graphs;
- Printing in MS Excel environment.
Benefits for the participant:
- Will get acquainted with data formatting in MS Excel;
- Will be able to perform basic calculations using MS Excel formulas and functions;
- Will prepare summaries and reports;
- Will learn about protection features;
- Will be able to summarize information using MS Excel charts.
Lecturer
| Karolis Visockas |
Head of the Computer Center at the Faculty of Business Management, Lecturer at the Department of Advertising and Communications, with an education in information technology and educational sciences. Subjects taught that meet the required qualifications: information communication and administration systems (MS Office package), business simulation, advertising history. Since 2009, he has been conducting MS Excel and graphic design software (CorelDraw, Adobe Photoshop) training. Clients include UAB “Delfi,” UAB “Swedbank,” UAB Hewlett-Packard, The American International School of Vilnius: AISV (in English), and many others.
The training is conducted in Lithuanian and English.
Contact for inquiries: info@vvf.viko.lt
