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
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
- Polynomial average
SECTION 2 | TABLE OPERATIONS
- Table Creation
- Determining Table Spacing
- Using Table Values in Formulas
- Other Table Operations
CHAPTER 3 | DATABASE OPERATIONS
- Advanced Filtering
- Subtotal Receiving
- Convert Text to Columns(Text To Column)
- Remove Duplicates (Remove Dublicate)
- Creating a data table(Data Table)
- Pivot Table & Chart
CHAPTER 4 | DATA VALIDATION PROCEDURES
- Input Message
- Types of Validation
- Whole Number
- Text Lenght
- Cleaning Verification Circles
CHAPTER 5 | WORKBOOK OPERATIONS
- Collaborating with Other Users
- Protecting and Sharing the Workbook
- Page Protection
- Protecting the Workbook
- Publishing the Workbook
- View Tab Operations
- Freeze Pods
- Place all
At the end of the online training, you will receive a certificate of participation from Kolektif Academy.
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.
- 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”.