Anyone with basic knowledge about MS Excel.
1000 ₺ (800₺ for İZÜ students)
July 02-03, 2022
10:00 - 17:00
Training for conducting business reports using advanced Excel techniques
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
Asst. Prof. Mohammad Ghaıth MAHAINI
Certificate of Participant
Participants must have a minimum of 80% attendance to complete this program.
Identity Card Photocopy
- 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.