This training is for professional development purposes and the certificate obtained does not replace the MYK certification for courses that require the MYK certification.

Training Objective

The "Effective Use of Excel and Report Creation" Training is aimed at those who want to specialize in Excel and those who wish to use Excel more effectively. The goal of this training is for participants to understand the features of Excel and use them efficiently and quickly.

Who Should Attend?

This training is suitable for individual participants and employees of institutions who are able to use MS-Office and Excel programs.

After completing this training, participants will be able to:

• Learn Excel shortcuts, unknown features, and quick usage tips,
• Use simple functions and write them nested for solving more complex problems,
• Use text and date functions,
• Create visual alert systems using conditional formatting and validation with formulas, allowing for data entry based on specific conditions,
• Use complex logical functions like IF, nested IF, VLOOKUP, SUMIF, COUNTIF to obtain condition-dependent data,
• Compare data across tables and transfer information between tables using Lookup & Reference functions,
• Quickly search data in tables using Filter and Sort options,
• Generate summary data from tables using Pivot Table feature.

Training Content

Module 1: Practical Tips

• Keyboard shortcuts and practical tips
• Updating data without formulas (basic arithmetic)
• Special search (find empty, formula, or custom content cells in the table)
• Adjusting custom views and navigating quickly within the document
• Custom or tailored cell formatting

Module 2: Working with Functions

• Using SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTIF, SUMIF, TODAY, YEAR, etc. functions
• Copying and pasting formulas
• Step-by-step calculation of formulas
• Working with formulas between documents and sheets
• Using absolute references in formulas
• Using named ranges in formulas

Module 3: Data Security

• Protecting and/or hiding formula cells
• Allowing or blocking specific actions in cells
• Working with shared documents
• Collaborating in real-time with multiple users
• Tracking changes made to the document

Module 4: Querying and Reporting Tools

• Sorting data and sorting by format
• Simple sorting operations
• Sorting by multiple columns simultaneously
• Creating custom sorting lists
• Filtering data
• Filtering by text, numerical, and date values
• Filtering by colors and icons
• Using advanced filtering tools
• Conditional Formatting
• Creating custom rules
• Using formulas in conditional formatting
• Restricting data entry
• Using Subtotal functions with tables

Module 5: Logical Functions

• Performing conditional operations (IF, AND, OR)
• Writing nested functions
• Using multiple nested IF functions
• Working with SUMIF, COUNTIF functions
• Working with SUMIFS, COUNTIFS functions
• Handling errors while writing formulas
• Writing functions without using wizards
• Simultaneously using information functions with logical functions (ISERROR, ISERR, ISBLANK, ISNA, ISTEXT, ISNUMBER, etc.)

Module 6: Working with Lookup and Reference Functions

• Searching for data within numeric or date ranges (VLOOKUP, HLOOKUP)
• Comparing tables and data (VLOOKUP, HLOOKUP, MATCH, INDEX)
• Creating dynamic charts and named ranges (OFFSET, ADDRESS, etc.)
• Using IFERROR for error checking

Module 7: Fixing Problematic Data and Creating New Data Using Text Functions

• Converting text to upper, lower, or proper case (UPPER, LOWER, PROPER)
• Extracting information from text (LEN, LEFT, RIGHT, MID, FIND, SEARCH, etc.)
• Splitting text into columns
• Creating new text from existing data (CONCATENATE, TEXT, REPLACE, REPT, etc.)
• Fixing problematic data (TRIM, VALUE, etc.)

Module 8: Working with Date Functions

• Creating new dates with day, month, and year information (DAY, MONTH, YEAR, DATE, EDATE, WEEKDAY, etc.)
• Calculating days and workdays between two dates (NETWORKDAYS, WORKDAY, etc.)

Module 9: Working with Database Functions

• Summing and averaging data based on criteria (SUMIF, DSUM, DAVERAGE, DMIN, DMAX)
• Counting data based on criteria (COUNTIF, DCOUNT)

Module 11: Creating PivotTables

• Creating summary tables
• Creating percentage values in summary tables
• Automatically creating separate summary tables for each data point
• Grouping data
• Creating summary charts

Module 12: What-If Analysis

• Scenarios
• Goal Seek
• Data Tables

Training Process

• The training will be broadcast online via the internet.
• You need internet access and an appropriate data plan to participate in the training.
• To use the training system, you need a device (smartphone, tablet, preferably a computer) with a camera and microphone.
• Participants will log in to the system with their camera and microphone on at the specified lesson times.
• Before the training begins, participants will receive their username and password by email.
• The system will remain open for 7 more days after the training is completed. It will be completely closed at 23:00 on the seventh day.
• To assist during the training, a WhatsApp group will be created where only the admin can send messages. All support information will be shared by the admin during the training. Participants can send any questions or issues to us at usem@uludag.edu.tr, and emails will be monitored during the training.

The training is open to corporate collaborations (institution/company packages), and individual applications are not accepted. The content of the training can be adjusted based on the corporate participant profile and needs. After mutual discussions, the scope and method of the training (Face-to-Face, Online) will be determined, and the relevant processes will be completed. If agreement is reached, the training day and time will be determined in consultation with your institution’s participants and our trainers.