Training on Using Excel Effectively and Creating Reporting

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 

This education 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 learn Excel 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 use textual and historical functions. 
• Will be able to create visual warning systems by using tools such as conditional formatting and verification with formulas. 
• Will be able to get can changed data according to conditions by using logical functions like IF, NESTED IF, VLOOKUP, SUMIF, SUMIFS, COUNTIFS. 
• Will be able to do data transcription between tables and can comparison between tables which is worked by lookup and reference functions. 
• Will be able to do search at tables data by using filter and sort options. 
• Will be able to do pivot data by using pivot table function. 

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: Practical hints 

• Keyboard shortcut and practical hints 
• Data update without writing formula 
• Custom search (Find cells with formula, scratch, custom content in table.) 
• Arrange custom view and move quickly through the document. 

Module 2: Working with functions 

• Use of functions SUM, AVERAGE, MIN, MAX, COUNT, COUNTA, COUNTIF, SUMIF, TODAY, YEAR vb. 
• Making a copy, paste special and formula duplication. 
• Making a step-by-step calculation to formula. 
• Making an action with formula between document and worksheets. 
• Use of fixed reference in formulas. 
• Making denotation to cells and using formulas at cell. 

Module 3: Data security 

• To hide or protect cells with formula.  
• To block or allow particular processes to be performed on cells. 
• Working with is shared files. 

-Concurrent execution with multiple users. 

-To follow which is made change to files. 

Module 4: Querying and Reporting Tools 

• Enumeration operations and sequencing according to format. 

- Simple sequence operations. 

-Sequencing with simultaneous at more than one column. 

- Creating a special sequencing list. 

• Filtration operations. 

- According to textual, numerical and historical values filtration. 

-According to colors and icons filtration. 

-Use of advanced level filter tool. 

• Conditional format 

-Making a special rule. 

-Use of formulas in conditional format. 

• Restriction of data entry. 
• Getting subtotal with tables. 

Module 5: Logical Functions 

• Making conditional transactions. 
• Writing formula using nested functions. 
• Use of nesting multiple if functions. 
• Working with SUMIF and COUNTIF functions. 
• Working with SUMIFS and COUNTIFS functions. 
• What to do in case of error occurrence and errors that may occur when writing formulas. 
• Write of functions without wizard. 
• Using simultaneous knowledge functions and logical functions. (ISERROR, ISERR, ISBLANK, ISNA, ISTEXT, ISNUMBER) 

Module 6: Working with search and reference functions. 

• Searching knowledge at numeric range and historic range. (VLOOKUP, HLOOKUP) 
• Comparing data and tables. (VLOOKUP) 
• Creating dynamic graphics and region which was named. 
• IFERROR error-checking function. 

Module 7: Fixing bad data with textual functions and creating new data 

• Converting texts to lowercase or uppercase letters (UPPER, LOWER, PROPER) 
• Getting information from inside any text (LEN, LEFT, RIGHT, MID, FIND, SEARCH) 
• Dividing the text into columns. 
• Creating new texts from existing information. (CONCATENATE, TEXT, REPLACE, REPT) 
• Fixing problematic data (TRIM, VALUE) 

Module 8: Working with date functions 

• Creating new date with day, moon, year knowledge. 
• Find the number of days and working days between two dates (NETWORKDAYS, WORKDAY) 

Module 9: Working with data base functions 

• Collecting data and centering with criteria. (SUMIF, DSUM, DAVERAGE, DMIN, DMAX) 
• Counting data with criteria (COUNTIF, DCOUNT) 

Module 10: Creating pivot table 

• Creating pivot table 
• Creating percental value at pivot table 
• Automatically create a separate pivot table for each data 
• Grouping the data 
• Creating pivot graphics 

Module 11: What – If Analyses  

• Scenarios 
• Goal Seek 
• Data table 

 

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.