Using MS Excel in Business – Intermediate Level online (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. What sets us apart is 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 proficiency in 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, investment project evaluation, the use of pivot tables, and conditional formatting. Through exercises, participants will gain the ability to build sales, profitability, and investment return reports. The course is designed for individuals who want to leverage Excel's capabilities in analytical work, controlling, or finance.

The training is intended for a wide audience, including:

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

The main objectives of the training are:

• Improving skills in financial data analysis in Excel
• Building analytical models
• Utilizing Excel in business decision-making

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

• Increased efficiency in financial analysis
• Smoother 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: Investment Project Evaluation
  • 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

Training duration: 2 training days - 14 hours with standard training breaks

• Training materials
• ZOOM platform
• Training support
• Training needs assessment