Training Course in Excel

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

• Revision

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

• Examination.

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.