
Course Overview
In today’s data-driven business environment, analytical skills are essential for making informed decisions and driving strategic growth. Analytical Skills Through Mastering Excel is a comprehensive training program designed specifically for middle management professionals who seek to enhance their data analysis capabilities using Microsoft Excel.
This course goes beyond basic spreadsheet functions, equipping participants with advanced Excel techniques to efficiently analyze, interpret, and visualize data. Through practical, hands-on learning, professionals will gain the expertise needed to optimize workflows, identify trends, and generate actionable insights that align with current market demands.
By the end of the course, participants will have mastered Excel as a powerful tool for data-driven decision-making, enhancing their overall analytical proficiency and strategic impact within their organizations.
- Basic Cell Formatting
- Number Formatting
- Alignment and text Control
- Borders and Gridlines
- Conditional Formatting
- Cell Styles and Table Styles
- Merging and Text Indentation
- Data Validation
- Recap and Next Step
- Basic Excel Formula Structure
- Common Mathematical Functions
- Cell References
- Logical Functions
- Text Functions
- Date and Time Functions
- Lookup and Reference Function
- Array Formulas
- Advanced Formula Tips
- Introduction to Pivot Tables
- Practical exercises to analyse worksheet data using Pivot Tables
- Real-world examples and case studies

Meet the Lecturer
Bekim Asani is currently working as Business Analyst at Tikves Winery in Skopje since 2022.
Experienced SAP user within different modules:
– Accounting Modules: SAP Controlling-SAP CO; SAP Project Systems-SAP PS.
– Logistics Modules: SAP Sales and Distributions-SAP SD; SAP Materials Management-SAP MM; SAP Plant Maintenance-SAP PM.
Project Cost Controller with a demonstrated history of working in the different areas such: Operations; QA-QC; Project Cost Control; Sales; Procurement; Fleet Management etc… Worked in countries: Macedonia; USA; Afghanistan; Iraq and Africa (Mali).
Skilled in SAP; PowerBi; Microsoft package; CRM etc…
Master’s in the area of Public Relations and Marketing Communications. Bachelor in the studies of Communications Sciences and Technologies.

Price
300 EUR
For 2 or more than 2 members from the same company, contact us at info@m6.edu.mk .
This activity is co-financed by M6 Educational Centre and the Government of Switzerland through the Swiss project “Education for Employment” – E4E@mk implemented by Helvetas.