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 paying for Istanbul Atlas University Continuing Education Center trainings;

A-PAYMENT VIA BANK

1. By EFT or Money Transfer to the following bank account that we have contracted with, "Name-Surname" and "TR Identity Number" information must be specified in the explanation section,

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