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 Uruguay or in NobleProg corporate training centers in Uruguay Remote live training is carried out by way of an interactive, remote desktop
NobleProg Your Local Training Provider.
Machine Translated
Testimonials
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
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
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
all
Klaudia Leszczyńska
Course: Excel VBA Introduction
Machine Translated
appropriate adjustment of the level of exercises to the knowledge of the participants, help of the teacher
Paulina Ścigała
Course: Excel VBA Introduction
Machine Translated
A lot of practical examples
Course: Excel VBA Introduction
Machine Translated
Tasks and practical examples
Course: Excel VBA Introduction
Machine Translated
consolidating my basic knowledge and broadening it.
Jędrzej Siemiątkowski
Course: Excel VBA Introduction
Machine Translated
Organizing the acquired theoretical knowledge and the multitude of practical exercises.
Rafał Kozłowski
Course: Excel VBA Introduction
Machine Translated
a good explanation of all the issues, so that they were understandable
Course: Excel VBA Introduction
Machine Translated
practical examples of VBA application
Aleksandra Kadłubowska
Course: Excel VBA Introduction
Machine Translated
formula
Course: Excel VBA Introduction
Machine Translated
VBA practical exercises
Mali liu - 深圳汉莎技术有限公司
Course: Excel VBA Introduction
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
A lot of practical examples
Course: Excel VBA Introduction
Machine Translated
Tasks and practical examples
Course: Excel VBA Introduction
Machine Translated
a good explanation of all the issues, so that they were understandable
Course: Excel VBA Introduction
Machine Translated
formula
Course: Excel VBA Introduction
Machine Translated
Some of our clients
.jpg "european southern observatory (eso)")
.png "european space agency (esa)")
.jpg "international air transport association (iata)")
.jpg "american international group (aig)")
Excel Course Outlines in Uruguay
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.
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.