Using MS Excel in Business – Intermediate Level (in Polish)

HILLWAY Training & Consulting is a Polish training and consulting company, established in 2011 by experienced industry practitioners. We specialize in developing competencies and qualifications through high-quality business training – including soft skills, hard skills, and industry-specific training. We focus on real business challenges, offering dedicated training programs and consulting projects in areas such as: management and leadership, sales, customer service, effective communication, HR, debt collection, and call center operations. We are distinguished by our individual approach to clients, commitment to high quality and efficiency, flexibility, and a team of expert practitioners. We conduct projects throughout Poland and abroad. Our mission is to support the development of companies and employees by providing knowledge and tools ready for immediate application. More information can be found on our website hillway.pl

"Using MS Excel in Business – Intermediate Level" is a training program aimed at combining knowledge in finance and business management with practical knowledge of the MS Excel spreadsheet. Participants will learn advanced techniques for working with Excel, analyze financial data, create analytical models, and use tools for making business decisions. The training covers practical topics such as ratio analysis, evaluation of investment projects, use of pivot tables, and application of conditional formatting. Through exercises, participants will gain the ability to build reports on sales, profitability, and investment feasibility. The course is intended for individuals who want to leverage Excel's capabilities in analytical work, controlling, or finance.

The training is designed for a wide audience, including:

• Individuals with intermediate knowledge of MS Excel
• Financial analysts
• Controlling specialists and employees of reporting departments

The main objectives of the training are:

• Improving skills in analyzing financial data in Excel
• Building analytical models
• Using Excel for making business decisions

Participation in the training will bring participants a range of benefits, such as:

• Increased efficiency in financial analysis
• More efficient data reporting
• Enhanced competencies in working with Excel
• Support for better decision-making in the company

"Using MS Excel in Business – Intermediate Level" is a training composed of 6 modules that develop practical skills in data analysis and report creation:

• Module 1: Operations on Numbers and Formats
  • Custom formatting
  • Working with dates and date functions
  • Data grouping
• Module 2: Errors and Advanced Functions
  • Identifying and removing errors
  • Financial and statistical functions
  • Goal Seek tool
• Module 3: Conditional Formatting
  • Based on values, formulas, or graphics
  • Copying formats
• Module 4: Evaluation of Investment Projects
  • NPV, IRR, ROI
  • Discounting cash flows
  • Profitability index and payback period
• Module 5: Outlines and Pivot Tables
  • Creating and managing outlines
  • Data analysis in pivot tables
  • Adding calculated fields
• Module 6: Practical Reports and Data Analysis
  • Sales, profitability, and feasibility reports
  • Ratio analysis
  • Exercises on financial data

Duration of the training: 2 training days - 16 hours with standard training breaks

• Training materials
• Trainer's travel to the location
• Training management
• Training needs assessment