Təlimlərimiz

Bank işçiləri üçün Excel

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

Təlimin qiyməti (vergi daxil): 
Ofis və online rejim: 170 AZN

Ödənişə daxildir:
1) Digital Sertifikat - ACTD, ISO 9001-2015; ISO 29993-2017 loqosu ilə
2) Təlim materialları
3) Video recording 
 
Proqram:
Module 1:  Introduction to Excel
- Overview of Excel interface and essential navigation
- Understanding Excel ribbons and tabs
- Creating and managing workbooks and worksheets
- Excel options and settings for efficient work

Module 2:  Essential Excel Formulas for Banking
- Basic arithmetic operations
- SUM, AVERAGE, COUNT, and other essential functions
- Absolute and relative cell references
- IF statements for logical decision-making

Module 3:  Data Management and Validation in Excel
- Sorting and filtering data
- Data validation for accuracy and consistency
- Removing duplicates and handling errors
- Named ranges and dynamic data validation lists

Module 4:  Advanced Data Analysis Techniques
- PivotTables and PivotCharts for dynamic data analysis
- Advanced sorting and filtering options
- Goal Seek and Solver for financial modeling

Module 5:  Financial Functions in Excel
- Understanding financial functions (NPV, IRR, PMT, etc.)
- Loan amortization schedules
- Investment analysis using Excel functions
- Building financial models for banking scenarios

Module 6:  Advanced Charting Techniques
- Creating complex charts for financial data
- Using Sparklines for data visualization
- Customizing charts for presentations
- Dynamic charts and conditional formatting

Module 7:  Scenario Analysis and Sensitivity Testing
- Building scenario models for risk analysis
- Sensitivity testing with Data Tables
- Using Scenario Manager for multiple what-if analyses
- Risk management techniques in Excel

Module 8:  Real-life Case Studies and Practical Applications
- Applying Excel skills to real banking scenarios
- Solving complex problems and optimizing workflows
- Q&A and personalized support for specific challenges
- Best practices for ongoing skill development