Basic Excel Tutorial

The purpose of education 

This education is aimed to teach the use of Excel effectively. The participants in this with education will learn features of excel and they will use excel quickly. 

Who can participate in the education 

It is suitable for the participation of individual participants and corporate employees who can use MS Office and Excel programs. 

Learning Outcomes 

• Will be able to keyboards shortcut which is process of speed up. 
• Will be able to use in the solution of complex problems is used functions for simple calculation 
• Will be able to create visual warning systems by using tools such as conditional formatting and verification with formulas. 
• Will be able to create a baseline level of table and writing base formula theory. 
• Will be able to format tables in different formats 
• Will be able to comparison between tables. 
• Will be able to prepare meaningful reports from is obtained result and they will be able to calculate using functions on the preparing tables. 
• Will be able to be saving to reports at table format also can present this report using visual graphic at excel. 
• Will be able to be editing page properties and will printing this page in your own want size. 

Education Dates: First is got preregistration then educations are dated and informed according to demand.

The method of education: Online education of live (synchronous) 

Duration of education: 12 hours 

Number of participants: Maximum of 15 people in Closed Group Education / Minimum of 10 people in Open Group Education 

 

Education Content 

Module 1: Working with Excel 

• Launching Excel 
• Browsing Through a Workbook 
• Navigating Through a Worksheet 
• Writing of Data 
• Modification and Correction of Data 
• Important keyboard shortcuts 
• Customization of Excel 

Module 2: Editing of the Worksheet 

• Creating of a new workbook 
• Creating and editing a table 
• Page process (rename, move, copy..) 
• Using comments 
• Determine of cell alignment and text wrapping features 
• Use of freeze pane feature 

Module 3: Adding formulas  

• Opening of existing workbook according to file features. 
• Making formulas more understandable and easier to use 
• Writing of calculating formulas 
• Using of Sum, Average, Max, Min, Count, Counta formulas 
• Creating of formula 
• Using of absolute and relative references 
• Basic date functions 

Module 4: Formatting of worksheet 

• Formatting of cells for professional view 
• Using of style 
• Formatting of numbers for professional view 
• Adding information of custom page, footer and header 
• Changing of page margins 
• Saving of file as template 
• Editing of template 
• Adding of pictures 
• Drawing of shapes 

Module 5: Customization of Graphics 

• Using of graphic wizard 
• Drawing of pie chart 
• Drawing of column graphic 
• Formatting of graphic 

Module 6: Printing of graphic and worksheets  

• Printing of multiple page workbook 
• Printing the selected parts of the worksheet 
• Printing of graphic 

Module 7: Other subjects 

• Using of conditional formatting 
• Sorting operations 
• Nested sorting operations 
• Automatic filtering operations 
• Link operations 
• Copy process between programs 
• Creating of custom list 

The Process of Education:

• The training will be broadcast live simultaneously over the Internet.
• In order to participate in the training, you must have internet access and a suitable internet package in your current environment.
• In order for the educational system to be used,camera and microphone equipment have been introduced, a device that can connect to the Internet(smartphone, tablet and preferably computer) is needed.
• Participants will log in to the system with their cameras and microphones turned on together with our instructor who provides the training during the specified lesson hours.
• User names and passwords will be sent to the participants' e-mails before the training starts.
• After the trainings are completed, the system will be kept open for participants for another 7 days. By the end of the seventh day at 23:00, the system will be completely shut down.
• In order to help us during the training period, a whatsapp group will be created in the form of sending messages only to the administrator, and all kinds of support information will be shared by the administrator during the lesson period. Participants have all kinds of questions and problems usem@uludag.edu.tr they can write to our address. The mail will be followed up instantly during the training.

Important Information:

• Certificates are issued for participation of 80% and above of the total training period. for participation of 79% and below, no documents will be issued. 
• After the completion of the training period, certificates will be issued after the controls belonging to our institution and will be sent to the addresses you entered at the time of registration with PTT Cargo. Your address and contact information must be up-to-date.
• Participants have all kinds of questions and problems usem@uludag.edu.tr they can write to our address. The mail will be followed up instantly during the training.
• Application for education and paying the tuition fee online are made via the Internet. Installment payments cannot be paid on the participants' bank credit cards.