Sale!

Online: Advanced Excel Training from Scratch | Data Analysis

Original price was: ₺ 600,00.Current price is: ₺ 300,00.

Out of stock

Description

Online: Advanced Excel Training from Scratch | Data Analysis

Register for ClassGet Information
Oguzhan Colak
Online
1 weekend (12 hours)
20 people
16.01.2021

300₺

“Excel programı, çalıştığınız bölümden bağımsız olarak tüm çalışanların, stajyerlerin ve öğrencilerin bilmesi gereken en önemli ofis programlarının başında gelmektedir. Mindfulness bakış açısı ile hazırladığımız eğitimlerimizde, önce katılımcılarımızın zihinlerini eğitime hazır hale getiriyoruz. Excel'de en sık karşılacağınız işlevler ve fonksiyonlara yönelik uygulamalı eğitimimizle siz de sıfırdan ileri seviyeye geleceğiniz şekilde Excel programını öğrenebilirsiniz.”

Oğuzhan ÇolakKıdemli Uzman, Tedarik Zinciri Yönetimi // Hedef Filo & Excel Eğitmeni (Kikiça Akademi & Udemy)

WHAT THIS TRAINING WILL BRING YOU

Do you want to be able to use Excel quickly and efficiently? In the Working with Data with Excel training we prepared with Oğuzhan Çolak, you will be able to quickly solve the Excel language in just one weekend.

Training Hours: 09:00 – 15:00 (Saturday-Sunday)

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

    SECTION 6 | FORMS

    • Combo Box (Combobox)
    • List Box
    • Add Button
    • Value Changer(Spin Button)
    • Group Box
    • Option Button
    • Scroll Bar

Certificate

  • All training videos will be shared with participants
  • The PDF version of Turkey’s first video book “Working Quickly and Efficiently with Excel” is a gift to the participants (there is a link and QR code under each topic that provides access to the video),
  • Digital certificate of attendance will be issued with Sertifier
  • Kolektif Academy online certificate will be given.

Prerequisites & Requirements

The Excel program must be downloaded.
You do not need any prior knowledge of the subject, the training is open to all levels.

Who is Oğuzhan Çolak?

He started his career immediately after completing his education in Metallurgical and Materials Engineering at Kocaeli University. He has worked as an engineer in local and foreign automotive sector companies for years. He has carried out projects and studies in many domestic and foreign automotive supply industry companies in Turkey and abroad. It anticipates what you may need from an engineering perspective, prepares its trainings from this perspective and offers them to its participants. In addition to the trainings he has been giving on Udemy for the last two years, he has given and continues to give Working with Data | Advanced Excel trainings to Turkey’s largest companies. He prepares and delivers his trainings especially from a mindfullnes perspective. It cares about its students’ mental readiness for education and prepares them accordingly. In December 2018, in the competition opened by Udemy in December 2018, he prepared a training and by telling his dreams, he was entitled to receive 2 hours of one-to-one digital marketing training from Udemy experts. He enjoys telling people what he knows and being in contact with them.

GET EDUCATION INFORMATION

Bu eğitimin süresi maalesef geçti. Eğer bir sonraki eğitimden haberdar olmak istiyorsan aşağıdaki formu doldurabilirsin.

Additional information

Eğitmen

Oğuzhan Çolak

Lokasyon

Online

Kontenjan

20