Professional Excel Training
Presented by Supply Chain Management by BMS
As Supply Chain Management by BMS, we deliver practically applicable business knowledge through professional trainers.
This time, we are launching a 3-level Professional Excel Program conducted by Samra Aliyeva, Head of Finance Department at Azersun Holding.
The program enables participants to systematically learn Excel starting from the fundamental level up to an advanced analytical and reporting-focused professional stage. The training is fully practice-oriented and built on real business cases.
The training is delivered online and covers a total of 22 hours of intensive learning.
Who Is This Program For?
This program is suitable for:
Professionals working in finance and accounting
Procurement and supply chain specialists
Analysts and reporting professionals
Office employees and managers
Individuals who want career growth and competitive advantage in the job market
Anyone who wants to systemize their Excel knowledge and reach a professional level
Key Benefits of the Training
By the end of the program, participants will be able to:
✔ Confidently use Excel’s fundamental and advanced functions
✔ Work with financial functions (PMT, PV, FV, NPER, RATE, etc.)
✔ Analyze and manage large data sets
✔ Effectively use VLOOKUP, SUMIF, IF, and other logical functions
✔ Create Pivot Tables and Pivot reports
✔ Build analytical charts to improve presentation quality
✔ Automate operations using basic macros
This program aims not only to teach Excel usage but to transform it into an effective business tool.
LEVEL I (Fundamental Excel Operations) – 4 Hours
Basic Operations
Cut / Copy / Paste, Find / Replace, Save / Save As, Send to Email, Comment, Hide / Unhide
Table Creation
Setting table borders, border formatting, preparing simple table examples
Cell Formatting
Font style, size, effects, font color, bold / italic / underline, patterns, format cells, cell categories (number, text, currency, etc.), alignment, wrap, merge, orientation, text direction
Basic Mathematical Operations
Addition, subtraction, multiplication, division (without formulas)
Filtering & Sorting
Simple sorting, filtering, conditional filtering
Freeze / Split Operations
Freezing row and column headers, split function
Page Setup & Printing
Page layout, portrait / landscape, adjust & fit pages, paper size, margins, header / footer, repeat rows/columns at top, center on page, print quality, print options, page order, print preview, printer selection
Shortcuts
Ctrl+A, Ctrl+C, Ctrl+V, Ctrl+Right, Ctrl+Left, Ctrl+Home, Ctrl+End, Ctrl+Shift+Right, Ctrl+Shift+Left, Ctrl+Shift+Home, Ctrl+Shift+End, Shift+Space, Ctrl+Space, Ctrl+F, Ctrl+P, Ctrl+Z, Ctrl+Y, etc.
Row / Column Grouping
Group and outline
LEVEL II (Functions & Charts) – 10 Hours
Rules of Using Functions
Correct function structure, removing formulas using Paste Special
Mathematical Functions
SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MAX, MIN, ABS, ROUND, TRUNC, MOD, PRODUCT, SUMPRODUCT, SQRT, POWER
References & Use of $
Example: =SUM($A$15:A19)
Text Functions
PROPER, LOWER, UPPER, CONCATENATE, Text to Columns, Remove Duplicates, Data Validation, MID, RIGHT, LEFT, TRIM
Logical Functions
IF, AND, OR, IFERROR
Filtering / Conditional Formatting
Filtering, conditional filtering, conditional formatting
Financial Functions
NPER, RATE, PMT, PV, FV
Date & Time Functions
DAY, TODAY, NOW, WEEKDAY, WEEKNUM, MONTH, YEAR, etc.
Charts
Chart types, data range selection, series, adding series, titles, axes, data labels, data tables, gridlines, chart formatting
LEVEL III (Database Operations: Recode, Pivot Reporting, etc.) – 8 Hours
Database Logic
How to structure a proper data table
Functions Used in Large Databases
HLOOKUP, VLOOKUP, SUMIF, COUNTIF, AVERAGEIF, IF (AND/OR combinations)
Pivot Tables
Pivot Table creation, dragging fields to field areas, field settings, refresh data, hide fields, table settings
Pivot Table & Chart Reports
Creating Pivot-based reports and charts
Basic Macro Usage
Security settings, writing a new macro, editing macros, etc.
The training is held online. It will be online 3 times a week. The training will be held in the evenings from 19:15-21:15.
