Description
Serdar Yasar
Online
2 days (12 hours)
50 people
27.06.2020
300₺
WHAT THIS TRAINING WILL BRING YOU
With this training, it is aimed to learn the menus and toolbars in the Excel interface, to be able to perform operations and to comprehend functions.
Training Hours: Saturday-Sunday: 10:00 – 16:00
Course Program
PART 1 | ADVANCED FORMULAS AND OPERATIONS
- Paste Special (Paste Speacial)
- Date Functions
- If Function
- Nested If Function
- And, Yada Function
- Etopla (Sumif)
- Ifsay (Countıf)
- How many
- Product(Sumproduct)
- Collection
- Subtotal
- Polynomial average
- Multicollection
- Iferror
- Search(Lookup)
- Vlookup
- Yatayara(Hlookup)
- Indis
- Bridge
- Days
SECTION 2 | TABLE OPERATIONS
- Table Creation
- Determining Table Spacing
- Using Table Values in Formulas
- Other Table Operations
CHAPTER 3 | DATABASE OPERATIONS
- Sorting
- Advanced Filtering
- Subtotal Receiving
- Convert Text to Columns(Text To Column)
- Remove Duplicates (Remove Dublicate)
- Creating a data table(Data Table)
- Pivot Table & Chart
- Timelines
CHAPTER 4 | DATA VALIDATION PROCEDURES
- Input Message
- Types of Validation
- Whole Number
- Decimal
- List
- Date
- Text Lenght
- Cleaning Verification Circles
CHAPTER 5 | WORKBOOK OPERATIONS
- Collaborating with Other Users
- Protecting and Sharing the Workbook
- Protection(Protect)
- Page Protection
- Protecting the Workbook
- Publishing the Workbook
- View Tab Operations
- Freeze Pods
- Place all
- Divide
Certificate
At the end of the online training, you will receive a certificate of participation from Kolektif Academy.
Prerequisites & Requirements
You do not need any prior knowledge of the subject, the training is open to all levels.
Participants are required to download Microsoft Office Excel program before coming to the training.
Who is Serdar Yasar?
- In 2004, he graduated from Gazi University Computer Education Department.
- He has worked in the IT sector for many years as an IT specialist, software specialist and trainer in important institutions and organizations of the sector.
- In his 16 years of experience as a trainer, he has provided individual and corporate trainings as “Information and Reporting Trainer” and “Data Analysis and Reporting Trainer”.
