Local, instructorled live Excel training courses demonstrate through interactive discussion and handson practice how to use Excel for financial computations, data analysis and more
Excel training is available as "onsite live training" or "remote live training" Onsite live training can be carried out locally on customer premises in Bolivia or in NobleProg corporate training centers in Bolivia Remote live training is carried out by way of an interactive, remote desktop
NobleProg Your Local Training Provider.
Machine Translated
Testimonials
Everything was shown very well but as I said too fast.
Damian Szuflada - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
I generally was benefit from the quality of the material, exercises.
UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
I mostly was benefit from the fitted training to people needs.
Robert Solek - UBS Business Solutions Poland Sp. z o.o.
Course: Visual Basic for Applications (VBA) in Excel - Advanced
I enjoyed the flexibility of the trainer, many practical examples, good atmosphere during the training.
Aleksandra Bauer - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
I really enjoyed the many practice.
Magdalena Chowaniec - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
I liked the useful tips, knowledge and flexibility in answering from the trainer's side.
UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
practical application using my data and how I can use VBA to process and produce my reports
Environment, Marine and Fisheries
Course: Excel VBA Introduction
It was great that we could try to do an exercise by our owns and then we did it together with trainer. Moreover the trainer shown us a few solutions per each exercise.
UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
Working on and using our own data/spreadsheets, where we could see how it would benefit us most.
Julie Longridge - Environment, Marine and Fisheries
Course: Excel VBA Introduction
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
The guy was really helpful and knowledgeable and i really learned a lot in two days.
Francesca Maggiolo - Bettzeit GmbH
Course: Excel Basics
The fact he had dif excel and data sheets with exercises for us to do.
Deepakie Singh Sodhi - Queens College, CUNY
Course: Excel For Statistical Data Analysis
Steve was willing to answer every questions and worked diligently to address any individual concerns or technical issues as they arose in the class. He also did a great job of presenting the technical details in a way that made it less intimidating to even the least tech savvy people in the room. Personally, learning about some useful shortcuts in Excel that I didn't know about will certainly improve my overall workflow when using Excel in the future! I am so appreciative of those little details that I was exposed to during the two-day training.
Alan Gonzalez - Queens College, CUNY
Course: Excel For Statistical Data Analysis
matching the examples given by the participants
NBP
Course: Excel Advanced
Machine Translated
practical knowledge
Oskar Krzesicki - NBP
Course: Excel Advanced
Machine Translated
reaction to the participants' questions
NBP
Course: Excel Advanced
Machine Translated
Good contact with listeners and willingness to explain until the end of ambiguity
Katarzyna Zięba - NBP
Course: Excel Advanced
Machine Translated
A lot of examples ..
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
Course: Excel Advanced
Machine Translated
The right amount of exercise.
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
Course: Excel Advanced
Machine Translated
That the trainer walked around and devoted time to virtually everyone.
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
Course: Excel Advanced
Machine Translated
Checking exercises by the lecturer on each computer on a regular basis.
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
Course: Excel Advanced
Machine Translated
A lot of transmitted knowledge in an understandable way. A lot of time dedicated to each individual. .
Aneta Świerszcz - „ADM CONSULTING GROUP” SPÓŁKA AKCYJNA
Course: Excel Advanced
Machine Translated
Accessible to the VBA readily explained. .
ADM CONSULTING GROUP SPÓŁKA AKCYJNA
Course: Excel Advanced
Machine Translated
the lectures were interspersed with exercises.
Natalia Jędrasik - NBP
Course: Excel Advanced
Machine Translated
READY AND DIFFERENCE OF AUXILIARY MATERIALS.
NBP
Course: Excel Advanced
Machine Translated
Prepared exercises and a step-by-step guide in which it is difficult to get lost.
NBP
Course: Excel Advanced
Machine Translated
Materials and prepared exercises ..
NBP
Course: Excel Advanced
Machine Translated
range of topics, exercises how to develop them.
NBP
Course: Excel Advanced
Machine Translated
practical ways of using ms excel
NBP
Course: Excel Advanced
All training
Katarzyna Litwinska - UBS Business Solutions Poland Sp. z o.o.
Course: Excel Advanced
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
Some of our clients
.jpg "european southern observatory (eso)")
.png "new york stock exchange (nyse)")
.jpg "international air transport association (iata)")
Excel Course Outlines in Bolivia
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.
Financial or market analysts, managers, accountants
Course Objectives
Facilitate and automate all kinds of financial analysis with Microsoft Excel
This course is intended for financial analysts, accountants and all those who want to expand their skills spreadsheet with issues of financial analysis.
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.
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.
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.
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.
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
After the course you can:
- Write an advanced object-oriented application
- Convert text files
- Use of external data sources
- Use external libraries