Speeding up Excel Usage 

- Quick insult on document and Excel shortcuts 

- Time-Saving Excel Techniques for Data Entry 

- Unknown Excel Features

Sorting Lists 

- Sorting by Font Colors or Cell Colors 

- Sorting by Multiple Fields 

- Sorting by Case Sensitive and Rows

Applying Filters to Your Lists 

- Applying Filter to Values ​​You Change 

- Giving Multiple Conditions When Applying Filters 

- Sorting in the Fields You Filter

 Working with Page Structures 

- Using Page Structures 

- Using Print Features 

- Adding Page Numbers 

- Saving files as PDF

Applying Conditional Formatting

- Apply Conditional Formatting to Selected Range

- Marking the highest and lowest values

- Finding repeating values ​​in lists

- Applying Conditional Formatting Based on a Formula

Validating Your Data Input 

- Giving entry conditions to cells with data validation

- Determining Input Messages 

- Identifying Error Warnings 

- Remove Data Validation 

- Performing Data Validation by Entering a Formula

Commonly Used Excel Functions 

- Addition, Largest, Smallest, Average

- Performing conditional operations with E-Total and IfSay functions.

- Making calculations based on values ​​in different columns with IF Function and Nested IF function

- Using the Vlookup Formula

Date and Time Functions 

- Year Function, Month Function 

- Day Function, Today Function 

- Creating work calendars with Weekday and Weeknumber functions

- Finding working days with the RegularWorkday Function

- Working Day Function

Creating Simple Reports

- Creating company sales reports

- Creating Product-Representative Sales Reports

Practice Exam

Practice Exam Questions and Solutions covering all the questions explained

Commonly Used Excel Functions 

- Hiding errors in formulas with the Iferror function

- Performing operations depending on multiple conditions with the Multivalue, Multisum functions

- Vlookup and Multiball Applications

- Working with Vlookup Applications Worksheets

- Copy/move worksheets

- Locking specific cells

- Allowing data entry into specific cells

- Protecting worksheets

- Moving quickly through worksheets

Working with Subtotals

- Getting Subtotals of Data

- Getting More Than One Subtotal

- Using the Subtotal Function

- Working with Groupings

Working with Graphics

- Getting to Know the New Graphics Features

- Swapping information in rows and columns.

- Using Graphics Features

Working with Goal Seek and Scenarios

- Reach the result you are looking for with Target Search 

- Working on different options using Scenarios

Text and Data Functions 

- Length Function, Lowercase Function

- Uppercase Function, Left Function

- Right Function, Piecewise Function 

- Merge Function, Trim Function

- Mbul Function, 

- Examples of Nested Use of Functions 

Practice Exam

- Practice Exam Questions and Solutions covering all the questions explained

Creating PivotTable Reports

- Understanding the pivot table logic

- Placing fields in pivot tables into row, column, and total fields.

- Finding the percentages of sales and purchases in the total value with Summary Tables 

- Quickly format PivotTables 

- Working with PivotTable Options 

- Show/Hide Field Headers 

- Changing the Source of Your PivotTable 

- Sorting Data in Your PivotTable 

- Changing the Settings of Pivot Tables

- Combining Summary Tables and Creating a Single Table from Different Tables

- Using Slicers

Practice Exam

- Practice Exam Questions and Solutions covering all the questions explained

- Active Excel users and those who work with tables and lists

- Those who want to use Excel's functions actively

- Those who create reports and analyze data

- Those who do data entry and work on lists

The purpose of this training is to help people work faster and more effectively with Excel, which is a must-have for everyone in business life today.

You can use the following methods when making payment for Istanbul Atlas University Continuing Education Center trainings;

A-PAYMENT VIA BANK

1. By EFT or Money Order to the bank account we have an agreement with, by stating the "Education Name" and "Name Surname" information in the description section.

At the end of the training, participants will be given an Atlas University certificate.