This training is for professional development, and the certificate received does not replace a MYK authorization certificate for trainings that require a MYK authorization certificate.

Objective of the Training

Participants will learn how to flawlessly tabulate and manage all their data, as well as prepare content-rich documents with images.

Who Should Attend?

This training is suitable for institution employees who are familiar with MS Office and Excel programs.

Participants Will Be Able to

• Use keyboard shortcuts to speed up tasks,
• Apply simple functions to more complex problems,
• Create visual alert systems using conditional formatting and validation tools with formulas,
• Develop basic formula theories and prepare basic tables,
• Format tables in different formats,
• Perform simple comparisons between tables,
• Use functions to perform calculations on their tables and create meaningful reports based on results,
• Present reports in table format or visually with Excel’s chart features,
• Adjust document page properties and print in desired sizes when needed.

Training Content

Module 1: Working in the Excel Environment

• Starting Excel
• Navigating a Workbook
• Navigating a Worksheet
• Entering Data
• Modifying and Correcting Data
• Important Keyboard Shortcuts
• Customizing Excel

Module 2: Formatting a Worksheet

• Creating and Formatting a Worksheet
• Using the Rename, Move, Copy Features
• Using Comments
• Aligning and Wrapping Text in Cells
• Using the Freeze Panes feature

Module 3: Adding Formulas

• Opening an Existing Workbook Based on File Properties
• Making Formulas More Understandable and Easier to Use
• Writing Calculation Formulas
• Using Sum, Average, Max, Min, Count, Counta Functions
• Creating Formulas
• Using Absolute and Relative References (Freezing Cells in Formulas)
• Basic Date Functions

Module 4: Formatting a Worksheet

• Formatting Cells for a Professional Look
• Using Styles
• Formatting Numbers for a Professional Look
• Adding Page Headers and Footers
• Changing Page Margins
• Saving a File as a Template
• Editing a Template
• Inserting Images
• Drawing Shapes

Module 5: Customizing Charts

• Using the Chart Wizard
• Creating a Pie Chart
• Creating a Column Chart
• Formatting Charts

Module 6: Printing Worksheets and Charts

• Printing a Multi-Page Workbook
• Printing Selected Areas of a Worksheet
• Printing Charts

Module 7: Other Topics

• Using Conditional Formatting
• Sorting Data
• Nested Sorting
• Using AutoFilter
• Linking Data
• Copying Between Programs
• Creating Custom Lists

Training Process

• The training will be delivered online via the internet.
• You must have internet access and an appropriate internet package to attend the training.
• The training system requires a device (smartphone, tablet, preferably computer) with a camera, microphone, and internet connection.
• Participants will join the system with the trainer at the designated times, with their camera and microphone turned on.
• Before the training, participants will receive their username and password via email.
• The system will remain open for 7 days after the training ends. It will close at 11:00 PM on the seventh day.
• A WhatsApp group will be created for administrative messages to assist participants during the training. Participants can contact us at usem@uludag.edu.tr for any questions. Emails will be monitored in real-time during the training.

The training is open for institutional collaboration (packages for institutions/companies), and individual applications are not accepted. Training content can be re-planned according to the profile and needs of the corporate participants. After mutual discussions, the scope of the training and its method (in-person, online) will be determined, and the related processes will be completed. Upon agreement, the suitable days and times for your institution's participants and our instructors will be determined, and the training location will be decided.