
Local, instructor-led live Microsoft Office training courses demonstrate through interactive discussion and hands-on practice the fundamentals and applications of Microsoft Office.
Microsoft Office training is available as "onsite live training" or "remote live training". Macao onsite live Microsoft Office trainings can be carried out locally on customer premises or in NobleProg corporate training centers. Remote live training is carried out by way of an interactive, remote desktop.
NobleProg -- Your Local Training Provider
Testimonials
I generally enjoyed the knowledge and sense of humor.
Łukasz Rózga - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
Adjusted to my knowledge of Excel, I learned new things. Explained very well. I finally understood how the formulas work. The trainer concentrated on the most useful parts.
Martyna Szczurek - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
I liked the trainer, nice guy with great attitude.
Lukasz Kanior - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
he managed to adapt to the heteroclit level of the people attending the training.
UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
I liked the practical use of the presented formulas, an opportunity to practice and discuss the results after each exercise.
UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
I mostly liked the style.
UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
I really enjoyed the many practise.
Magdalena Chowaniec - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
I was benefit from the trainer knowledge, explanation and tips.
Kornel Tymcio - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
I really enjoy the training. Huge and practical! knowledge of the trainer combined with his skill to conduct the training made the training time very efficient. The trainer recognized the level of participant's experience in VBA and provided exercises relevant to that experience which made the training very useful.
Barbara Peek - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
I liked the overall scope, presentation style and organization.
Marek Dudka - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
Trainer was approachable, helpful, ready to answer questions, explain.
UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
The instructor's method of writing the code and finding solutions provided a good example of how to approach things in VB. Recording a macro to access its code, intentionally leaving some items incorrect to show how that impacted the result, etc. Finding errors and solutions in code can be difficult but his training approach showed his VB problem solving methodology
Manson Construction Co.
Course: Excel VBA Introduction
Trainer's knowledge sharing, sense of humor and sharing innovation tools
Agata Gwozdziewicz - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
Practical exercises
Patrycja - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
-
Agata Szafranska - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
well structured.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
VBA practical exercises
Mali liu - 深圳汉莎技术有限公司
Course: Excel VBA Introduction
Machine Translated
I found out a lot
Barbara Kozłowska - NBP
Course: Advanced MS PowerPoint
Machine Translated
quick response to additional questions
Krzysztof Krawczyk - NBP
Course: Advanced MS PowerPoint
Machine Translated
Understanding keyboard shortcuts, references to other Office programs, cool pace.
NBP
Course: Advanced MS PowerPoint
Machine Translated
job
Artur Kosim - NBP
Course: Advanced MS PowerPoint
Machine Translated
LECTURE
jacek zapędowski - NBP
Course: Advanced MS PowerPoint
Machine Translated
the pace and manner of translation and presentation allowed for a smooth exercise
NBP
Course: MS Word Basic
Machine Translated
All trivia improving work.
Barbara Bednarczyk - NBP
Course: MS Word Basic
Machine Translated
A large amount of practical exercises
NBP
Course: MS Word Basic
Machine Translated
A large amount of practical exercises
NBP
Course: MS Word Basic
Machine Translated
inserting tables
Andrzej - NBP
Course: MS Word Basic
Machine Translated
Practical problem solving
NBP
Course: Word Advanced
Machine Translated
Good pace of classes. Clear and practical translation of individual issues.
Mariusz Szpringer - NBP
Course: Word Advanced
Machine Translated
Good contact with the lecturer, the opportunity to ask questions, good atmosphere
NBP
Course: Word Advanced
Machine Translated
Field codes and abbreviations
NBP
Course: Word Advanced
Machine Translated
exercises
NBP
Course: Word Advanced
Machine Translated
All training
Katarzyna Litwinska - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
Machine Translated
Discusses the topic in a broader aspect.
Unilever Poland Sercives
Course: Access Basics
Machine Translated
Organisation and practical Approach to topics
Adam Cedrowicz - Unilever Poland Services sp. z o.o
Course: Access Basics
Machine Translated
Interactive
Mateusz Wardecki - Unilever Poland Services sp. z o.o
Course: Access Basics
Machine Translated
A lot of knowledge in a short time. Plus Anecdotes
Justyna Góral - Neinver Asset Management Polska Sp. z o.o.
Course: Advanced MS PowerPoint
Machine Translated
A lot of useful knowledge related to the work performed in the field of program use.
Izabela Sarniak - Neinver Asset Management Polska Sp. z o.o.
Course: Advanced MS PowerPoint
Machine Translated
The trainer explained the issues on which I was most dependent
Neinver Asset Management Polska Sp. z o.o.
Course: Advanced MS PowerPoint
Machine Translated
How to Drive
Agata Chudzińska - Neinver Asset Management Polska Sp. z o.o.
Course: Advanced MS PowerPoint
Machine Translated
A lot of exercises, a reminder in an affordable form of Excel
Neinver Asset Management Polska Sp. z o.o.
Course: Advanced MS PowerPoint
Machine Translated
ok
Neinver Asset Management Polska Sp. z o.o.
Course: Advanced MS PowerPoint
way of driving
jolanta czajka - Neinver Asset Management Polska Sp. z o.o.
Course: Advanced MS PowerPoint
Machine Translated
trainer's skills
Neinver Asset Management Polska Sp. z o.o.
Course: Advanced MS PowerPoint
Machine Translated
Training approx. The trainer has adapted to the participants' request for additional discussion of interesting issues.
expondo Polska Sp. z o.o. Sp.k.
Course: Excel Advanced
Machine Translated
Presentation of new tools that I didn't know before.
Knauf Bełchatów Sp. z o.o.
Course: Excel For Statistical Data Analysis
Machine Translated
well structured.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
Microsoft Office Subcategories in Macao
Microsoft Office Course Outlines in Macao
This course is intended for financial analysts, accountants and all those who want to expand their skills spreadsheet with issues of financial analysis.
After the course you can:
- Record and edit the macro as required,
- Write procedures using data from the sheet,
- Create your own functions
- Handle the event (opening worksheet cell update etc) by means of the handler,
- Create form
In this instructor-led, live training, participants will learn how to combine the capabilities of Python and Excel.
By the end of this training, participants will be able to:
- Install and configure packages for integrating Python and Excel
- Read, write, and manipulate Excel files using Python
- Call Python functions from Excel
Audience
- Developers
- Programmers
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- To request a customized training for this course, please contact us to arrange.
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
Course objectives:
- Configure site navigation
- View site activity reports
- Customize lists and libraries
- Work with Site Columns and Site Content Types
- Configure Check out/in, Content Approval and Versioning
- Create and modify pages and web part pages
The course covers procedural programming in VBA. Students will learn which objects are available in Excel and how to use them. They will also learn how to write their own worksheet functions, debug programs and write complete applications using VBA forms.
This course can also be run in more depth, and with more practical examples, as a three day course.
Analysts, researchers, scientists, graduates and students and anyone who is interested in learning how to facilitate statistical analysis in Microsoft Excel.
Course Objectives
This course will help improve your familiarity with Excel and statistics and as a result increase the effectiveness and efficiency of your work or research.
This course describes how to use the Analysis ToolPack in Microsoft Excel, statistical functions and how to perform basic statistical procedures. It will explain what Excel limitation are and how to overcome them.
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.
Financial or market analysts, managers, accountants
Course Objectives
Facilitate and automate all kinds of financial analysis with Microsoft Excel
By the end of this training, participants will be able to:
- Optimize the report creation process
- Prepare data for Pivot Tables and formula-based reports
- Import data from various data sources using Open Database Connectivity (ODBC) and Online Analytic Processing (OLAP)
- Use Tables and PivotTables to create financial reports and analyses
- Automate the processes involved in reporting
- Build validation structures into spreadsheet reports
- Master Excel shortcuts for formatting financial reports
- Implement Excel templates to improve productivity
- Reduce errors, simplify reporting processes and improve the quality of reports
Audience
- Experienced Excel user
- Accounting professionals
- Financial professionals
Format of the course
- Part lecture, part discussion, exercises and heavy hands-on practice
Note
- This course can be taught using different versions of excel (Excel 2007, Excel 2010, etc.). To request a specific version, please contact us to arrange.
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
- optimizing processes
The course itself can be delivered either as a 6 day classroom course or [remotely](https://www.nobleprog.co.uk/instructor-led-online-training-courses) over a period of weeks if preferred. We can work with you to deliver the course to best suit your needs.
Improving the ability to prepare an attractive presentation using Powerpoint and other tools
Addressees:
Sales representatives, consultants, research and teaching staff, managers, teachers, corporate employees, SMEs and public institutions, for which the challenge is to stand in front of a group of people, say to them, arousing interest
After the course you can:
- Write an advanced object-oriented application
- Convert text files
- Use of external data sources
- Use external libraries