Delivered either online or onsite, these instructor-led live Microsoft Office training courses combine interactive discussions with hands-on practice to demonstrate the core fundamentals and practical applications of Microsoft Office.
Microsoft Office training is offered as either "online live training" or "onsite live training." Online live training, also known as "remote live training," is facilitated through an interactive remote desktop connection. Onsite live training can be conducted locally at customer premises in Gaia or at NobleProg corporate training centers in Gaia.
NobleProg -- Your Local Training Provider
Holiday Inn Porto - Gaia
220, Rua Diogo Macedo, 220, Vila Nova de Gaia 4400-107 , Gaia, Portugal
From Porto by Metro
If you're coming from Porto city centre:
Take the Metro Line D (yellow line) toward Vila d’Este.
Get off at João de Deus.
From João de Deus, walk about 13 minutes to: Rua Diogo Macedo 220, 4400-107 Vila Nova de Gaia.
From Vila Nova de Gaia train station
If by “local train station” you mean Vila Nova de Gaia-Devesas:
The address is approximately 12 minutes walking from Vila Nova de Gaia station according to the accommodation's location information.
You can therefore walk directly rather than taking the metro.
This instructor-led, live training in Gaia (online or onsite) is aimed at This instructor-led, live training (online or onsite) is aimed at beginner-level to intermediate-level 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.
This instructor-led Excel training in Gaia guides users from basic data entry to advanced automation techniques. Participants will master formulas, PivotTables, and VBA through hands-on exercises. Ideal for building professional reporting and analysis skills.
This instructor-led, live training in Gaia (online or onsite) is aimed at beginner-level to intermediate-level professionals who wish to master Microsoft Word, Excel, and PowerPoint for enhanced document creation, data analysis, and presentations.
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.
This live training in Gaia is tailored for intermediate Excel users seeking to excel in inventory control, budgeting, and reporting. Acquire skills in analyzing datasets of 5,000+ rows using formulas, pivot tables, and macros. Develop practical competencies in a hands-on lab to automate tasks.
This instructor-led, live training in Gaia (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 Gaia (online or onsite) is designed for beginner to intermediate 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.
Enrol in this live Excel modelling training in Gaia to strengthen your data analysis capabilities. Develop proficiency in structured problem-solving, advanced functions, and core model design principles. Participants will gain practical experience in creating scalable models for scenario analysis and producing effective business reports.
This instructor-led, live training in Gaia supports you in mastering Microsoft Word, progressing from basic fundamentals to advanced automation. You will acquire the skills to format documents, manage layouts, and utilize features such as mail merge and macros to significantly enhance productivity and efficiency.
Excel is a popular spreadsheet program developed by Microsoft. It is used to store, organize, and analyze data in tabular format. Here are some key features and functions of Excel:
1. Spreadsheets:
It consists of worksheets, where each sheet is a grid composed of cells arranged in rows and columns.
It allows the creation of multiple sheets within a single file, enabling the organization of different data sets.
2. Calculations and Formulas:
It enables performing various mathematical, statistical, and logical calculations using formulas.
It has a wide range of built-in functions, such as SUM, AVERAGE, MAX, MIN, IF, VLOOKUP, etc.
3. Data Formatting and Appearance:
It provides tools for formatting data, including changing fonts, colors, and styles, as well as creating charts, pivot tables, and diagrams.
4. Sorting, Filtering, and Grouping:
It allows sorting data according to specified criteria.
It enables filtering data to display only selected information.
It offers the ability to group data based on requirements.
5. Data Analysis:
Tools for performing advanced analyses, such as scenario analysis, trend analysis, forecasting, and creating macros.
6. Data Sharing:
It allows sharing and collaborating on data in real-time, enabling multiple users to work on the same data simultaneously.
7. Task Automation:
It allows creating macros and automating tasks using the 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.
Designed for data analysts looking to leverage advanced VBA in Excel for task automation, this instructor-led, live training in Gaia is available online or onsite.
By the end of this training, participants will be able to:
This instructor-led, live training in Gaia (online or onsite) is designed for data analysts who wish to acquire skills in preparing data in Excel and 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.
This practical course in Gaia establishes core data analytics skills using Excel, VBA, and R. Participants will acquire competencies in data manipulation, visualisation, and machine learning, enabling them to predict trends, optimise operations, and drive evidence-based business decisions.
Automate workflows and create robust desktop applications using VBA in Microsoft Excel and Access. This comprehensive Gaia training covers programming fundamentals, object-oriented coding, SQL database design, and user interface development through practical exercises focused on data management.
Acquire essential Microsoft Excel skills in this beginner-centric training held in Gaia. The curriculum encompasses data entry, formatting, formulas, functions, tables, and data visualization, empowering participants to establish a solid foundation for data analysis and reporting in practical, real-world settings.
Strengthen your financial analysis abilities with this comprehensive Excel course in Gaia. Gain mastery over advanced functions, pivot tables, and external data workflows while applying real-world scenarios such as time value of money, forecasting models, and securities analysis to facilitate data-driven decision-making.
This practical Excel course in Gaia focuses on data entry, formatting, formulas, functions, and chart creation. Participants will gain the ability to perform calculations efficiently, automate spreadsheet tasks, and secure sensitive data against unauthorised access or accidental modifications.
This Advanced Excel with VBA course in Gaia focuses on optimizing data management through advanced formulas and VBA automation. You will learn to build custom functions, design user forms, and streamline workflows by leveraging macros and external data integration to enhance productivity.
Develop the ability to craft clean, professional documents in this MS Word Fundamentals course. Gain command over text formatting, styles, and layout features such as bullets, tabs, and tables to ensure clarity and visual consistency. Ideal for beginners looking to acquire efficient document management skills in Gaia.
This instructor-led advanced Word training in Gaia develops expertise in custom styles, macros, templates, mail merge, and document comparison. Participants acquire practical skills in automated workflows, dynamic tables of contents, and enterprise-grade document management.
This instructor-led programme on Gaia enables Excel users to progress their VBA proficiency to an intermediate stage. Participants will design custom interfaces, gain mastery over complex data types, and implement solid error handling and debugging strategies. It is perfectly suited for professionals looking to achieve streamlined workflow automation.
Develop advanced Excel skills in this 14-hour session held in Gaia. Explore complex formulas, styling options, visualisations, and PivotTables to enhance your productivity. This programme is ideal for professionals aiming to refine their data interrogation and reporting capabilities, moving effectively from intermediate to expert proficiency.
This instructor-led, live training in Gaia (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.
Master advanced PowerPoint skills in Gaia to create polished, scalable presentations. Learn to customise slide masters, use SmartArt for visual mapping, and integrate deeply with Excel for live data dashboards. Equip yourself with add-in workflows to streamline complex deck production.
This Gaia course covers advanced PowerPoint slide design, emphasizing visual storytelling, composition, and chart generation. It develops practical competencies in image editing and optimal element placement, equipping professionals to deliver impactful presentations.
Participate in this instructor-led workshop in Gaia to master the techniques for delivering high-impact presentation decks using PowerPoint and contemporary tools. The course addresses slide design, data visualization, and presentation skills, enabling you to build confidence and engage your audience more effectively.
This instructor-led live training in Gaia (online or onsite) is designed for beginner to intermediate business analysts and data analysts who wish to use Excel for data analysis and reporting in their projects and 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.
Use Excel data import and export capabilities to connect with external data sources and share data effectively.
This one-day training in Gaia targets power users and SharePoint site owners. It focuses on configuring site navigation, customizing lists, managing content types, and monitoring activity reports, making it ideal for professionals seeking advanced SharePoint administration skills.
This one-day SharePoint User training in Gaia empowers site owners and users to leverage advanced features such as team collaboration, document management, and social tools. Participants will learn to effectively manage sites, configure web parts, oversee user permissions, and customize site settings to enhance productivity.
Master the creation of persuasive financial slide decks that translate complex figures into clear executive insights. This seven-hour programme covers design tactics, advanced visualizations, and Excel connectivity to elevate your storytelling capabilities. Acquire practical skills for delivering presentations with confidence in Gaia.
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
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
Very practical
Deenan - Vodacom
Course - Data and Analytics - from the ground up
Provisional Upcoming Courses (Contact Us For More Information)
Online Microsoft Office training in Gaia, MS Office training courses in Gaia, Weekend Microsoft Office courses in Gaia, Evening Microsoft Office training in Gaia, MS Office instructor-led in Gaia, MS Office trainer in Gaia, Microsoft Office on-site in Gaia, Evening Microsoft Office courses in Gaia, Online Microsoft Office training in Gaia, Weekend Microsoft Office training in Gaia, MS Office classes in Gaia, MS Office instructor-led in Gaia, MS Office private courses in Gaia, Microsoft Office instructor in Gaia, Microsoft Office boot camp in Gaia, Microsoft Office one on one training in Gaia, Microsoft Office coaching in Gaia
