Instructor-led live Microsoft Office training courses, offered either online or onsite, illustrate the core concepts and practical applications of Microsoft Office through engaging discussions and hands-on exercises.
Microsoft Office training is available in two formats: "online live training" and "onsite live training." Online live training (also referred to as "remote live training") is facilitated via an interactive remote desktop. Onsite live training can be conducted locally at your premises in Leiden or at NobleProg’s corporate training centers in Leiden.
NobleProg -- Your Local Training Provider
Leiden
Golden Tulip/Tulip Inn Leiden Centre, Schipholweg 3, Leiden, Netherlands, 2316XB
The 4-star Golden Tulip Leiden Center is located right next to the Tulip Inn Leiden Center hotel; together they accommodate 7 stars under one roof. The hotels are ideally located with Leiden Central Station directly opposite and many motorways within easy reach. A beautiful location in the center of the historic city of Leiden full of museums and picturesque spots. Experience, enjoy and be inspired.
Golden Tulip & Tulip Inn Leiden Center have a large diversity of hotel rooms; from comfortable and modern furnished standard rooms to luxurious executive rooms. In total there are 155 rooms. Furthermore, the hotels have a renovated restaurant called "Rubens", a cozy bar / lounge and an extensive meeting & conference center.
The 6 multifunctional rooms make Golden Tulip & Tulip Inn Leiden Center the ideal location for small and medium-sized meetings. The rooms have a capacity of 4 to 100 people. The meeting rooms offer countless possibilities in terms of setup and technical facilities. Convenience, efficiency, hospitality and professionalism are paramount. All rooms have air conditioning, free wireless internet and daylight.
Until the early 19th century, fishing in Noordwijk aan Zee remained the most important form of income. Later the population started to focus more and more on tourism. More than 1 million overnight stays take place every year. Noordwijk aan Zee consists of several districts and is located on the dunes. There are various catering establishments such as hotels, entertainment centers and restaurants (also on the beach) and there is a shopping center that has a Sunday opening. Every year events take place on the boulevard around the lighthouse on the Vuurtorenplein. The municipality has a KNRM rescue station and a reformed church (1647) with pulpit from the 17th century.
Since the merger with the Noordwijkerhout municipality, the municipality consists of four centers.
Noordwijk aan Zee, traditionally a fishing village, has become a seaside resort with a long coastal strip of approximately 13 km. . Noordwijk aan Zee has two boulevards, both of which are named after a queen, Queen Wilhelmina Boulevard and Queen Astrid Boulevard.
Noordwijk-Binnen radiates the tranquility of earlier centuries in the old core. In 1992 the old village center was designated as a protected village view under the Monuments Act.
Noordwijkerhout, a village and former municipality northeast of Noordwijk..Noordwijk aan Zee is rated as the 12th richest location in the Netherlands. Beer magnate Freddy Heineken has built a villa there with the characteristic green roof.
The Two Brothers Noordwijk Beach Hotel is located on the boulevard of Noordwijk with a view of the village and the sea and has several conference rooms and training rooms that make it the perfect place for business meetings and stimulating training. Noordwijk is a 30-minute drive from Amsterdam and The Hague and only 20 minutes from Leiden.
This instructor-led, live training in Leiden (online or onsite) is aimed at This instructor-led, live training (online or onsite) is aimed at beginner to intermediate business professionals, educators, and marketers who wish to integrate DeepSeek with PowerPoint to automate and optimize their presentations.
By the end of this training, participants will be able to:
Automate the creation of text-based content in PowerPoint slides using DeepSeek.
Generate data-driven visuals and infographics powered by DeepSeek models.
Use AI to summarize long reports and turn them into presentation-ready slides.
Integrate DeepSeek with PowerPoint for streamlined, dynamic presentations.
Excel is a spreadsheet application designed for data entry, analysis, reporting, and automation.
This instructor-led, live training (available online or onsite) targets users from beginner to advanced levels who aim to build confidence and proficiency in Excel's essential, intermediate, and advanced capabilities.
Upon completion of this training, participants will be prepared to:
Work confidently with spreadsheets, formulas, and formatting.
Utilize intermediate tools such as tables, charts, and conditional logic.
Apply advanced functions, data analysis features, and automation techniques.
Create professional worksheets that support business decision-making.
Course Format
Instructor-led demonstrations and guided explanations.
Extensive workbook exercises and hands-on practice.
Practical lab activities using real-world spreadsheet scenarios.
Course Customization Options
For tailored coverage based on your department’s workflows, please contact us to arrange a customized version of this course.
This instructor-led, live training in Leiden (online or on-site) is designed for beginner to intermediate professionals who wish to master Microsoft Word, Excel, and PowerPoint to enhance document creation, data analysis, and presentation skills.
By the end of this training, participants will be able to:
Effectively create, format, and manage documents in Microsoft Word.
Utilize Excel for data entry, analysis, and visualization.
Design engaging and professional presentations in PowerPoint.
Leverage collaboration features across Microsoft Office applications.
Excel is a ubiquitous spreadsheet application utilized for organizing data, performing analysis, and automating processes.
This instructor-led live training, available online or onsite, targets intermediate-level Excel users seeking to apply the software for inventory control, budgeting, reporting, and automation using real-world datasets.
Upon completion of this training, participants will be able to:
Apply formulas such as SUMIF, IF, VLOOKUP, and SUMIFS within inventory and purchasing scenarios.
Efficiently manage and analyze large datasets containing over 5,000 rows.
Create and interpret pivot tables for monthly and cumulative tracking.
Automate repetitive reporting tasks using macros.
Track material purchases against consumption using structured templates.
Course Format
Interactive lectures and discussions.
Extensive exercises and practical practice.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request customized training for this course, please contact us to arrange details.
This instructor-led, live training in Leiden (online or onsite) targets data analysts from beginner to advanced levels who wish to use Excel for 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 to 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 live, instructor-led training in Leiden (online or onsite) is designed for beginner to intermediate-level professionals who want to enhance their productivity and efficiency by leveraging the advanced capabilities 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.
This instructor-led live training in Leiden (online or onsite) is designed for data analysts or anyone wishing to learn how to use Excel for creating data models for data analysis.
By the end of this training, participants will be able to:
Analyze and solve business problems using structured problem-solving tools.
Navigate Excel tools with ease.
Set up, format, and present data effectively.
Understand the logical structure and apply correct functions to Excel models.
Microsoft Word is a robust word-processing application designed for creating, formatting, and managing professional documents.
This instructor-led live training (available online or onsite) caters to users ranging from beginner to advanced levels who aim to develop comprehensive skills in document creation, editing, formatting, and automation within Microsoft Word.
Upon completing this course, participants will be able to:
Produce professional documents with consistent formatting.
Utilize intermediate features such as styles, templates, and collaboration tools.
Apply advanced tools including mail merge, references, and automation functionalities.
Boost productivity by leveraging Word’s advanced layout and document management capabilities.
Course Format
Engaging demonstrations and guided instruction.
Extensive practical exercises and skill-building tasks.
Real-time document creation and refinement in a live environment.
Customization Options
If you require a tailored version of this training, please contact us to discuss customization options.
Participants will gain the ability to efficiently utilize primary data analysis tools, such as scenarios and pivot tables. They will also learn to leverage features for date calculations and text-processing functions, and create and adapt macros to automate spreadsheet workflows.
Excel is a popular spreadsheet program created by Microsoft. It is used to store, organize, and analyze data in tabular form. Here are some key features and functions of Excel:
1. Spreadsheets:
It consists of sheets, where each sheet is an array consisting of cells arranged in rows and columns.
Allows creating multiple sheets in one file, which enables organizing different sets of data.
2. Calculations and formulas:
Allows performing various mathematical, statistical, and logical calculations using formulas.
Has a wide range of built-in functions such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc.
3. Data formatting and appearance:
Provides tools for data formatting, including changing fonts, colors, styles, and creating charts, pivot tables, and diagrams.
4. Sorting, filtering, and grouping:
Allows sorting data according to specific criteria.
Enables filtering data to display only selected information.
Capability to group data depending on needs.
5. Data analysis:
Tools for performing advanced analyses such as scenario analysis, trends, forecasting, and creating macros.
6. Sharing data:
Allows sharing and collaborating on data in real time, enabling multiple users to work simultaneously on the same data.
7. Task automation:
Possibility of creating macros and automating tasks using VBA (Visual Basic for Applications) programming language.
Excel is widely used in 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, available Leiden (online or on-site), targets data analysts who wish to leverage advanced VBA in Excel for task automation.
By the end of this training, participants will be able to:
This instructor-led, live training in Leiden (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.
Data analytics is a crucial tool in business today. We will focus throughout on developing skills for practical hands on data analysis. The aim is to help delegates to give evidence-based answers to questions:
What has happened?
processing and analyzing data
producing informative data visualizations
What will happen?
forecasting future performance
evaluating forecasts
What should happen?
turning data into evidence-based business decisions
Automate workflows and develop robust desktop applications using VBA across Microsoft Excel and Access. This comprehensive training covers programming fundamentals, object-oriented coding, SQL database design, user interface development, debugging techniques, error handling, and advanced Excel analysis routines through practical exercises — empowering analysts, financial professionals, and developers to eliminate manual tasks and unlock advanced data management and reporting capabilities.
Microsoft Excel serves as a robust spreadsheet tool designed for structuring, analyzing, and presenting data.
This instructor-led live training, available online or on-site, is tailored for beginner data analysts looking to leverage Excel for reporting and analysis.
Upon completing this course, participants will be capable of:
Building and maintaining spreadsheets within Excel.
Formatting and organizing data to enhance clarity and efficiency.
Applying formulas and functions to automate calculations.
Visualizing information through charts, tables, and conditional formatting.
Collaborating and sharing workbooks securely via Microsoft 365.
Course Format
Interactive lectures paired with discussions.
Extensive exercises and practical practice.
Hands-on application in a live-lab environment.
Customization Options
For customized training arrangements, please get in touch with us.
This Excel training for financial analysis equips finance professionals with advanced spreadsheet techniques. The course covers lookup functions, search formulas, Pivot Charts, conditional formatting, external data workflows, and securities analysis. It delves into practical methods for evaluating the time value of money, identifying market trends, building financial forecasting models, and leveraging Excel's comprehensive analytical toolkit for complex financial computations and reporting.
This course equips financial analysts and accountants with advanced techniques for automating complex calculations and reports. It covers core principles of financial functions, INDEX-MATCH lookups, database queries, PivotTables, PivotCharts, and external data integration. Participants will delve into Goal Seek, Solver, Analysis ToolPak, and VBA macros to automate recurring workflows. The training helps professionals transform raw figures into actionable financial insights and accurate forecasts for strategic planning.
Upon completing this course, participants will be equipped to efficiently execute a wide range of calculations while presenting results clearly and transparently. You will learn various techniques to streamline and accelerate spreadsheet creation, as well as how to safeguard your calculations and data against unauthorized access.
This course empowers participants to maximize their efficiency by creating, consolidating, and managing data effectively. It introduces a range of tools designed to streamline workflows, significantly reducing the time spent on tasks compared to previous methods, while also enabling you to develop applications capable of handling new challenges.
Participants will learn how to create clean, professional-looking documents (including all types of official correspondence) and fully utilize the basic mechanisms that ensure a clear flow of information in both short and long documents.
Gain mastery over complex document workflows by leveraging the full capabilities of Microsoft Word. This course covers custom style creation, mail merge operations using external databases, macro recording, and template development. Participants will acquire skills in section-level layout management, dynamic table of contents generation, indexing, hyperlinks, content controls, document comparison, and version tracking. This training empowers professionals to construct automated reporting systems, establish standardized enterprise templates, develop cross-referenced documents, and implement workflows integrated with SharePoint.
Elevate your VBA expertise to an intermediate proficiency by mastering custom interfaces, complex data types, conditional logic, loop structures, and professional debugging strategies. This practical Excel VBA course focuses on robust error handling, performance optimization, the creation of VBA UserForms, and workflow automation through real-world applications. The training bridges the gap between elementary macros and advanced automation solutions, empowering data analysts, reporting specialists, and business users to leverage enterprise-grade spreadsheet capabilities.
Achieve mastery over Microsoft Excel through this professional training program designed to significantly improve your spreadsheet efficiency and productivity. Gain essential skills in editing worksheets, managing workbooks, constructing complex formulas with powerful functions, formatting cells, creating professional charts and graphs, working with PivotTables and data lists, and handling graphic objects. This course is ideal for business analysts, accountants, data handlers, and office professionals looking to advance their Excel proficiency from an intermediate to an expert level. Enhance your data analysis capabilities, streamline reporting workflows, and unlock the full power of Microsoft Excel to make better decisions and boost workplace productivity.
This instructor-led, live training in Leiden (online or onsite) targets 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.
Moving beyond the fundamentals of PowerPoint unlocks the ability to create polished, scalable presentations that truly captivate an audience. This course explores advanced techniques such as customizing slide and handout masters, designing bespoke templates, utilizing SmartArt for effective visual process mapping, and integrating Excel for live-linked data dashboards and charts. Professionals will gain access to high-efficiency workflows through add-ins like Office Timeline and Poll Everywhere, helping them accelerate the creation of complex decks, streamline review processes, and deliver powerful business presentations.
Professionals who aim to create polished presentations can greatly benefit from advanced slide design techniques that turn basic content into compelling visual narratives. This course explores the fundamental principles of slide composition, the creation of charts and infographics, and image editing, while developing practical abilities in the visual distribution of elements, highlighting key information, and personalizing the workspace. Participants will leave with actionable strategies for crafting clean, impactful slides and delivering confident presentations through structured public speaking techniques.
Enhancing the ability to create compelling presentations using PowerPoint and other tools
Target Audience:
Sales representatives, consultants, research and teaching staff, managers, teachers, corporate employees, SMEs, and public institutions, where professionals must present to groups in a way that captures their interest
This instructor-led, live training Leiden (online or onsite) is designed for beginner to intermediate-level business analysts and data analysts who want to leverage Excel for data analysis and reporting in their projects and daily tasks.
Upon completion of this training, participants will be able to:
Apply Excel formulas and functions to perform calculations and manipulate data.
Utilize Excel data analysis tools such as PivotTables, What-If Analysis, and Forecasting to summarize and visualize data.
Employ Excel charts and graphs to create and customize data visualizations.
Use Excel data validation and conditional formatting to ensure data quality and highlight key insights.
Utilize Excel's data import and export capabilities to connect with external data sources and share data effectively.
This one-day training session is tailored for individuals who utilize SharePoint as end-users and wish to gain insight into some of its more advanced capabilities. Attendees should enroll in this course if they need to master functions such as team collaboration, document management, and the social features inherent to Microsoft SharePoint 2013.
This course is designed for:
SharePoint Site Owners and users
Course objectives:
Manage Sites and Site Collections
Add users and groups and manage site, list, folder and item security
Add and configure web parts
Configure site options including theme, title, description and icon
This course explores how to create impactful financial presentations using PowerPoint, transforming complex data into clear executive-level narratives. Participants will learn design techniques for slide organization, utilizing treemaps and sunburst diagrams, formatting budget charts, and structuring streamlined reporting tables that emphasize critical financial indicators. The training also covers integrating Excel for dynamic data updates, highlighting key figures, and delivering confident financial stories that secure stakeholder approval.
Read more...
Last Updated:
Testimonials (11)
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
peace of mind of the person presenting
Anna Szper - Sad Rejonowy w Krosnie Odrzanskim
Course - MS Word - poziom podstawowy
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
practicality of advice and attempts to solve problems reported by the group in their companies
Kacper - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Word dla zaawansowanych
scope of material
Marcin - Instytut Energetyki- Panstwowy Instytut Badawczy
Course - Microsoft Office Excel - poziom zaawansowany
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
Provisional Upcoming Courses (Contact Us For More Information)
Online Microsoft Office training in Leiden, Microsoft Office training courses in Leiden, Weekend Microsoft Office courses in Leiden, Evening Microsoft Office training in Leiden, MS Office instructor-led in Leiden, Microsoft Office classes in Leiden, Evening Microsoft Office courses in Leiden, MS Office boot camp in Leiden, MS Office coaching in Leiden, MS Office private courses in Leiden, Microsoft Office one on one training in Leiden, Online MS Office training in Leiden, Microsoft Office instructor in Leiden, Microsoft Office on-site in Leiden, Weekend Microsoft Office training in Leiden, MS Office trainer in Leiden, Microsoft Office instructor-led in Leiden
