Delivered either online or onsite, our instructor-led live Excel training courses combine interactive discussion with hands-on practice to demonstrate how to effectively use Excel for financial calculations, data analysis, and beyond.
Excel training is offered in two formats: "online live training" and "onsite live training." Online live training (also referred to as "remote live training") is conducted via an interactive remote desktop session. Onsite live training takes place directly at the customer's location in Prague or at NobleProg corporate training centers in Prague.
From Prague Main Train Station (Praha hlavní nádraží)
Take tram 9 from Hlavní nádraží toward Sídliště Řepy.
Get off at Újezd.
Walk about 10 minutes toward Malostranské náměstí / Prokopská.
Continue along Prokopská to 296/8.
Alternative: Take the metro C from Hlavní nádraží → Muzeum, change to metro A → Malostranská, then walk across Malá Strana. This involves more walking.
From Prague Bus Station — Florenc
Take metro B from Florenc toward Zličín.
Get off at Můstek.
Change to metro A toward Nemocnice Motol.
Get off at Malostranská.
Walk approximately 10–15 minutes to Prokopská 296/8.
This guided Excel training in Prague takes users from fundamental data entry to sophisticated automation techniques. Through hands-on exercises, participants will master formulas, PivotTables, and VBA. It is ideal for enhancing professional reporting and analytical capabilities.
This live training in Prague is tailored for intermediate Excel users seeking to master inventory control, budgeting, and reporting. Learn to analyze datasets with 5,000+ rows using advanced formulas, pivot tables, and macros. Develop practical skills in a hands-on lab to automate routine tasks.
This instructor-led, live training in Prague (online or onsite) is aimed at beginner-level to advanced-level data analysts who wish to use Excel to perform a variety of tasks such as data entry, formula creation, data analysis, and advanced automation.
By the end of this training, participants will be able to:
Navigate Excel’s interface and perform basic data entry, formatting, and calculations.
Apply advanced formulas, functions, and conditional formatting for data analysis.
Create and manage pivot tables and charts for data visualization.
Use tools like Power Query, Power Pivot, and perform data analysis.
Automate tasks using macros and VBA to streamline workflows.
This instructor-led, live training in Prague (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to enhance their productivity and efficiency by leveraging the advanced features of Excel and Google Sheets for data organization, analysis, and collaboration.
By the end of this training, participants will be able to:
Navigate and utilize the core features of Excel and Google Sheets.
Perform data analysis and create actionable insights using advanced spreadsheet techniques.
Collaborate in real-time using Google Sheets for seamless teamwork.
Create reusable templates for reporting, tracking, and project management.
Participate in this live Excel modeling training in Prague to develop robust data analysis capabilities. Master structured problem-solving, advanced functions, and core model design principles. Participants will gain practical experience in constructing scalable models for scenario analysis and effective business reporting.
Excel is a widely used spreadsheet program developed by Microsoft. It is employed for storing, organizing, and analyzing data in tabular form. Below are some key features and functions of Excel:
1. Spreadsheets:
Composed of sheets, where each sheet is a grid of cells arranged in rows and columns.
Allows the creation of multiple sheets within a single file, facilitating the organization of different data sets.
2. Calculations and Formulas:
Enables various mathematical, statistical, and logical calculations using formulas.
Offers a comprehensive set of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc.
3. Data Formatting and Appearance:
Provides tools for formatting data, including changing fonts, colors, and styles, as well as creating charts, PivotTables, and diagrams.
4. Sorting, Filtering, and Grouping:
Allows sorting data according to specific criteria.
Enables filtering data to display only selected information.
Supports grouping data based on user requirements.
5. Data Analysis:
Provides tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros.
6. Data Sharing:
Facilitates sharing and real-time collaboration on data, allowing multiple users to work simultaneously on the same data.
7. Task Automation:
Enables the creation of macros and task automation using the VBA (Visual Basic for Applications) programming language.
Excel is extensively used across various fields, from business to science and education. Its versatile features enable data analysis, report creation, budgeting, scheduling, data management, and many other applications.
This instructor-led, live training in Prague (online or onsite) is aimed at data analysts who wish to learn techniques for preparing data in Excel, then visualizing it in Power BI.
By the end of this training, participants will be able to:
Understand the principles of data analysis, objectives of data analysis, and approaches for data analysis.
Use DAX formulas in Power BI for complex calculations.
Create and use visualizations and charts for particular analysis cases.
Import with Power View to move from Excel based Power BI to independent Power BI.
Automate workflows and construct robust desktop applications using VBA in Microsoft Excel and Access. This comprehensive Prague course covers core programming concepts, object-oriented coding, SQL database design, and user interface development through practical exercises focused on data management.
Acquire core Microsoft Excel competencies through this introductory training in Prague. The curriculum encompasses data input, styling, formulas, functions, tables, and visualization techniques, empowering participants to establish a solid base for data analysis and reporting in practical settings.
Elevate your financial analysis capabilities with this extensive Excel course available in Prague. Gain proficiency in advanced functions, pivot tables, and external data workflows. The course explores real-world applications such as the time value of money, forecasting models, and securities analysis, empowering you to make data-driven decisions.
Gain proficiency in advanced Excel techniques for financial analysis, including INDEX-MATCH, PivotTables, VBA, and Solver, delivered in Prague. Develop skills in using Goal Seek, database queries, and external data integration to streamline workflows, enabling the transformation of raw data into actionable insights and accurate forecasts.
This hands-on Excel course in Prague focuses on fundamental skills including data input, styling, formula creation, function application, and chart generation. Learners will master efficient calculation methods, automate routine spreadsheet tasks, and secure sensitive information against unauthorized modification or accidental edits.
This Excel Advanced with VBA course in Prague focuses on optimizing data management through advanced formulas and VBA automation. It covers building custom functions, designing user forms, and enhancing productivity via macro-based workflows and external data integration.
This instructor-led training in Prague enables Excel users to progress their VBA capabilities to an intermediate level. Participants will construct custom interfaces, gain proficiency in complex data types, and implement robust error handling and debugging strategies. It is particularly suitable for professionals looking to optimize workflow automation efficiency.
Refine your Excel expertise in this 14-hour session held in Prague. Dive into advanced formula construction, detailed formatting, chart creation, and PivotTable management to significantly boost your productivity. This program is ideal for professionals looking to effectively elevate their data analysis and reporting capabilities from an intermediate to an expert level.
This instructor-led, live training in Prague (online or onsite) is aimed at beginner-level analysts who wish to use Excel VBA to automate repetitive work, clean and transform data, and improve reporting processes.
By the end of this training, participants will be able to: record and edit macros, write simple VBA procedures, work with Excel objects for reporting tasks, and debug basic automation solutions.
This instructor-led live training, available online or onsite in Prague, is designed for beginner to intermediate-level business analysts and data analysts who aim to leverage Excel for data analysis and reporting in their projects and daily tasks.
Upon completion of this training, participants will be able to:
Utilize Excel formulas and functions to perform calculations and manipulate data.
Employ Excel data analysis tools, such as PivotTables, What-If Analysis, and Forecasting, to summarize and visualize data.
Create and customize data visualizations using Excel charts and graphs.
Apply Excel data validation and conditional formatting to ensure data quality and highlight key insights.
Leverage Excel's data import and export capabilities to connect with external data sources and share data effectively.
Read more...
Last Updated:
Testimonials (8)
Flexibility in the course delivery and the interactive approach. The trainer was open to questions, clarified doubts clearly and also considered participants suggestions during the sessions. The training was well structured and informative.
Soundarya Mohan - Mizuho Bank Europe N.V.
Course - Financial Analysis in Excel
the trainer's patience,
Agata Halubicka - Sad Rejonowy w Krosnie Odrzanskim
Course - Microsoft Office Excel - poziom średnio zaawansowany
well-prepared training, interesting topics
Maciek Boiski - Instytut Energetyki - Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom podstawowy
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Visual Basic for Applications (VBA) w Excel - wstęp do programowania
Well structured. Good teaching techniques. Course well documented!
Sorin
Course - VBA For Access & Excel
very clear, very good explanation, wishing more teachers would train like this
Mihaela - Phillip Morris
Course - Excel Basics
trainer was expalning everything step by step which was very good as it was easy to follow if there was anything unclear trainer helped
Daria - LKQ Polska Sp. z o. o.
Course - Excel Modelling
What I liked most about the training was the trainer’s knowledge of Excel. I appreciated learning useful things like shortcuts and formulas that I can use every day.
Martin
Course - Visual Basic for Applications (VBA) for Analysts
Online MS Excel training in Prague, MS Excel training courses in Prague, Weekend MS Excel courses in Prague, Evening Excel training in Prague, Excel instructor-led in Prague, Online MS Excel training in Prague, Microsoft Excel classes in Prague, MS Excel private courses in Prague, Excel trainer in Prague, Weekend Excel training in Prague, Evening Excel courses in Prague, Microsoft Excel instructor in Prague, Microsoft Excel one on one training in Prague, MS Excel boot camp in Prague, Microsoft Excel coaching in Prague, Microsoft Excel on-site in Prague, MS Excel instructor-led in Prague
