Excel Fundamentals
About This Course
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 cells and text indentation
- Data validation
- Recap and next steps
- Basic Excel formula structure
- Common mathematical functions
- Cell references
- Logical functions
- Text functions
- Date and time functions
- Lookup and reference functions
- Array formulas
- Advanced formula tips
- Introduction to Pivot Tables
- Practical exercises for analyzing worksheet data using Pivot Tables
- Real-world examples and case studies
Bekim Asani
Bekim Asani has been working as a Business Analyst at Tikveš Winery in Skopje since 2022.
He is an experienced SAP user with expertise across various modules, including:
Accounting Modules:
- SAP Controlling (SAP CO)
- SAP Project Systems (SAP PS)
Logistics Modules:
- SAP Sales and Distribution (SAP SD)
- SAP Materials Management (SAP MM)
- SAP Plant Maintenance (SAP PM)
Bekim has extensive experience in Operations, QA/QC, Project Cost Control, Sales, Procurement, Fleet Management, and other business areas. His professional experience spans multiple countries, including North Macedonia, the USA, Afghanistan, Iraq, and Mali.
He is skilled in SAP, Power BI, Microsoft Office, CRM systems, and other business tools.
Bekim holds a Master’s degree in Public Relations and Marketing Communications and a Bachelor’s degree in Communication Sciences and Technologies.