Proficiency in Microsoft Excel is beneficial for individuals in any line of work. You will study both the fundamental and more complex features of Microsoft Excel as part of the training course.

After completing the course, you will be able to process data in MS Excel, generate detailed reports, build work files, analyze, visualize and use AI (artificial intelligence).

• A 20% discount is available for students and graduates of the International Black Sea University.
• After completing the course, you will be awarded a bilingual certificate of the International Black Sea University.

Mentor Tsotne Shermadini – Financial Director of IVH Holding, Head of the Financial Analysis Department of Award Holding.

Course Schedule:

Starts April 24, 2025
Tuesday / Thursday
19:30 – 21:00
10 meetings, 5 weeks

Topics:

• MS EXCEL interface – overview (RIBBON, TOOLBAR, WORKSHEET TABS)
• Overview of column and row functionality
• Entering data into a cell. Formatting. Entering data on several sheets at the same time
• MS EXCEL sheet adding, copying, hiding and removing a separate sheet functionality.
• Setting and removing a password on an MS EXCEL sheet and file
• Overview of basic navigation SHORTCUTs
• Entering and formatting numeric and date data
• Sorting and filtering.
• Working with tables and charts
• Absolute and relative addresses
• PASTE SPECIAL
• SUM, COUNT, AVERAGE, SUBTOTAL.
• LEN, LEFT, RIGHT, MID, COCATENATE, UPPER, LOWER, PROPER, TRIM.
• REMOVE DUPLICATES, TEXT TO COLUMN, FIND AND REPLACE
• ROUND, ROUNDDOWN, ROUNDUP, RAND, RANDBETWEEN, SUMPRODUCT
• TODAY, YEAR, MONTH, DAY, DATE, NETWORKDAYS.INTL, EOMONTH,
• AND, OR, IF, IFS.
• SUMIFS, COUNTIFS, AVERAGEIFS.
• IFERROR, ERROR Overview
• VLOOKUP, HLOOKUP, XLOOKUP
• DATA VALITADION
• CONDITIONAL FORMATTIG
• Principle of Dynamic Tables
• Choosing the Right Fields for a Dynamic Table
• Using the SUMMARIZE VALUES BY Function
• Using the SHOW VALUES AS Function
• Slicers (SLICER)
• Overview of Basic Charts
• Choosing a Chart Shape by Data Type
• Inserting a Chart and Managing its Design
• MACROs and Understanding Their Use
• Recording Basic MACROs to Automate Repetitive Tasks
• Assigning MACROs to Buttons for Easy Access
• Using AI in Excel
• Solving Examples of Combined Tasks Based on the Past Material.

Training Venue: International Black Sea University

Address: St. Tbilisi, David Agmashenebeli Alley, 13th km, N2

Contact information:

E-mail: training@ibsu.edu.ge
Tel: +995 322 800 064

Registration: https://forms.gle/U7FcAw7rx7JUwxGW6

Course fee 490 GEL

Bank details

Receiving bank: JSC “TBC Bank”
Bank code: TBCBGE22.
Recipient name: International Black Sea University LLC
Recipient account number: GE52TB7505036080100001
Indicate the word “Training MS Excel” in the subject field.