Kimler Katılabilir
Anyone with basic knowledge about MS Excel.
Eğitim Süresi
12 hours
Eğitim Ücreti
1000 ₺ (İZÜ öğrencileri için 800₺)
Son Başvuru Tarihi
Eğitim Yeri
İZÜ Halkalı Yerleşkesi
Eğitim Gün ve Saati
July 02-03, 2022
10:00 - 17:00
Eğitimin amacı
Training for conducting business reports using advanced Excel techniques
Eğitimin İçeriği
Training Language: ENGLISH
Session ONE:
TEXT functions: TRIM, LEN, RIGHT, LEFT, MID, CONCATENATE, EXACT, LOWER, UPPER, PROPER, FIND, SEARCH, VALUE, Text to columns, Remove duplicates, Find/Replace, Transpose data, Named ranges.
DATE functions: DAY, MONTH, YEAR, DATE, WEEKDAY.
MATH, STATISTICAL and LOGICAL functions: LOG, RAND, RANDBETWEEN, AVERAGE, COUNT, COUNTA, COUNTBLANK, IF (creating IDs, filling in the empty cells), IFERROR.
Conditional formatting
Session TWO:
LOOKUP functions: VLOOKUP and HLOOKUP (for combining datasets);
Pivot table: Summarizing large data, filtering and extracting the data, reshaping the dataset, converting original data into lower frequency data
Eğitmen
Dr. Öğr. Üyesi Mohammad Ghaıth MAHAINI
Sertifika / Katılım Belgesi
Certificate of Participant
Devam Zorunluluğu
Participants must have a minimum of 80% attendance to complete this program.
Notlar
- The class size is limited to a minimum of 11 and a maximum of 25 participants.
- Istanbul Sabahattin Zaim University Continuing Education Center (İZÜSEM) reserves the right to make any changes in the announcement and implementation stages of programs.
- If the quota of the relevant program is limited, applicants who have been granted a definite registration by İZÜSEM and who have paid for the training program will not receive any reimbursement, regardless of whether or not the applicant participates in the program, except for those who submit a written request toİZÜSEM at least 2 weeks prior to the relevant program’s start date.
- The program participant groups will be determined according to the number of accepted applicants in the final registration period.
Yorumlar