Təlimlərimiz

Excel (təkmilləşdirmə)

Təlimdə kimlər iştirak edə bilər: istənilən şəxs
Təlimin davam etmə müddəti: 12 saat, 8 dərs
Təlimin keçirilmə üslubu: ofis rejimi və ya online
Tədris dili: Azərbaycan dili

Təlimin qiyməti:
OFİS və ONLİNE - 170 AZN (vergi daxil)

Ödənişə daxildir:
1) Digital Sertifikat - ACTD, ISO 9001-2015; ISO 29993-2017 loqosu ilə 
2) Təlim materialları
3) Video recording (online olduqda)
4) Coffee break (ofis olduqda)

Proqram:
Module 1: Advanced Formulas and Functions
1. Nested Functions
- Understanding and creating nested functions
- Practical examples for complex calculations
2. Lookup and Reference Functions
- VLOOKUP, HLOOKUP, and INDEX-MATCH functions
- Using named ranges for efficient referencing
3. Text and Date Functions
- CONCATENATE, TEXT, DATE, and TIME functions
- Formatting and manipulating text and date values

Module 2: Data Validation and Protection
1. Data Validation Techniques
- Setting up drop-down lists
- Creating custom data validation rules
2. Protecting Worksheets and Workbooks
- Password protection and encryption
- Sharing and collaborating securely

Module 3: PivotTables and PivotCharts
1. Introduction to PivotTables
- Creating PivotTables to summarize data
- Grouping, sorting, and filtering data
2. PivotCharts for Data Visualization
- Creating dynamic charts linked to PivotTables
- Customizing chart elements and styles

Module 4: Data Analysis with What-If Analysis Tools
- Goal Seek and Scenario Manager
- Using Goal Seek for reverse calculations
- Creating and managing scenarios for decision-making

Module 5: Data Analysis with Data Tables and Solver
- Data Tables and Solver
- Building and analyzing data tables
- Solving complex optimization problems with Solver

Module 6: Advanced Data Visualization Techniques
1. Conditional Formatting
- Applying advanced conditional formatting rules
- Using icon sets and color scales effectively
2. Sparklines and Data Bars
- Creating mini-charts within cells
- Visualizing trends and variations in data

Module 7: Advanced Charting Techniques (Combo Charts and Trendlines)
- Combo Charts and Trendlines
- Creating combination charts for dual-axis representation
- Adding trendlines to visualize data trends

Module 8: Advanced Charting Techniques (Dynamic Charts with Form Controls)
- Dynamic Charts with Form Controls
- Using form controls to create interactive charts
- Building dashboards for effective data presentation