Caucasus International University (CIU) is announcing admission to Excel Certification Training Course. The course is open to anyone who is interested in in-depth study of the Excel software for a variety of professional purposes.
The training course will be led by Tamar Arevadze, Business Analyst and Microsoft Excel Trainer.
Course Content
I meeting
- Studying the Excel interface; Data entry and editing; Entering and editing formulas in cells; Saving and updating worksheet; Fonts, auto-fill and layout;
- Retrieving and editing data; Inserting / editing comments;
- Working with columns and rows; (Delete, hide / show);
- Modifying the worksheet;
- Naming worksheets; Copying and pasting worksheets; Adding, deleting, hiding and showing worksheets;
- Formatting a worksheet;
- Formatting a text; Formatting a column and a row; Formatting numbers; Using AutoFormat and FormatPainter;
- Freeze panes;
- Arrange all;
- Hyperlink;
- Autofilter;
- Preparing the document for printing; Overview of Page Setup functions, Page Break Preview, setting and familiarizing with print settings;
- Document protection, password setting, encryption.
II meeting
- Text functions: Len; Left; Right; Mid; Upper; Proper, Lower, Find, Concatenate; Code; Char, Replace; Subtitute; Search; Trim; Remove Dublicate, Text to column;
- Date functions: Date; Datevalue; Day; Days; Day360; Edate; Eomonth; Hour; Isoweeknum; Mnute; Month; Networkdays; Networkdays. Intl; Now, Time; Today.
III meeting
- Text functions: Len; Left; Right; Mid; Upper; Proper, Lower, Find, Concatenate; Code; Char, Replace; Subtitute; Search; Trim; Remove Dublicate, Text to column;
- Date functions: Date; Datevalue; Day; Days; Day360; Edate; Eomonth; Hour; Isoweeknum; Mnute; Month; Networkdays; Networkdays. Intl; Now, Time; Today.
IV meeting
- Math functions: Sumif; Sumifs, Power; Int; Round: Roundup; Rounddown; Sumproduct; Mod; Rand, Randbeetwin; Subtotal.
V meeting
- Logical functions: IF; Double IF; AND, OR: IFEROR, NOT; Built-in logical functions.
VI meeting
VII meeting
- Conditional Formulas and Formating;
- Data Validation - Creating drop-down lists in a box, setting criteria for them to set text, date or number constraints.
VIII meeting
- Connecting databases: Vlookup, Hlookup, Match, Index.
IX meeting
- Creating PivotTable & PivotCharts summary spreadsheets based on a database; Creating a summary diagram.
X meeting
Training Details
- Duration: 10 lectures (20 hours)
(2, 4, 11, 16, 18, 23, 25, 30 May; 1, 6 June)
- Intensity of lectures: twice a week (19:00-21:00)
- Number of students in a group: 8-10
- Course fees: 350 GEL
- Format: face-to-face, room 101
The program provides the following types of discounts:
1. For CIU students and graduates - 10%
2. In case of family members - 10%
3. 15% for each subsequent training for CIU training-course graduates
4. In case of participation of two or more people from one organization, for each participant - 15%
(Discount is valid only in case of funding by the organization/company).
Certificate of participation will be issued upon completion of the training course!
For registration, please visit the following link:
https://forms.gle/iFuGeoWE5CNZEYEcA
Deadline for registration – 28.04.2022
For further information, please contact us: ulll@ciu.edu.ge
The training center reserves the right to change or cancel the start date of the course, if there are objective reasons, about which the trainees registered in the course will be additionally notified.
