Basic Data Analysis Training with Excel

Data Analysis with Excel

Target audience
No matter which data analysis tool is used; Excel is definitely used at points such as adding data that does not come from the system, master data lists, data entry screens, unit tests and user tests. In this sense, knowing the basic use of Excel provides great convenience for all parties.
Scope
The scope of this training includes the general structure of Excel, data editing, data cumulation, filtering, sorting, formatting, matching, defining condition formulas, frequently used formulas, separating into columns, summary ( Pivot) table and graph creation.
Method
The Excel file used in the examples is shared among the training material so that you can practice step by step while watching the training.

Training Content

1. Introduction
2. Overview
1. Filtering and sorting (filter, sort)
2. Language and date settings
3. Remove duplicates
4. Assignment 1
1. Format cells
2. Conditional formatting
3. Assignment 2
1. Sum, sumif
2. Average, averageif
1. Vlookup
2. Hands-on 1
3. Assignment 3
4. Fixing Reference Cells
5. If, and, or
6. Iferror
7. Counting formulas (count, countif, countblank)
8. Assignment 4
1. Trim
2. Left, mid, right, len
3. Assignment 5
4. Round
5. Date (day, month, year)
6. Hands-on 2
7. Paste special
8. Convert text to columns
9. Assignment 6
10. Data validation
1. Subtotal, group
2. Pivot tablo
3. Copying with pivot
4. Graphics
5. Hands-on 3
6. Assignment 7
1. Closing

Video Training
Online Training
On-site Training

Data Analysis with Excel

Training Content

Let's Get to Know Excel

Data Editing

Cell Formatting

Addition and Average

Matching and Conditioning

Partitioning and Determining Data Type

Summarizing

Closing

Data Analytics User Trainings

Data Analytics System User Training

SQL Training for Data Analytics

Data Science Scenarios

How to Analyze Data?

International Business Communication Standards - IBCS SUCCESS

International Business Communication Standards IBCS Analyst Certificate Program