Excel Training Courses in Macao

Excel Training Courses

Local, instructor-led live Excel training courses demonstrate through interactive discussion and hands-on 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 Excel training can be carried out locally on customer premises in Macao or in NobleProg corporate training centers in Macao. Remote live training is carried out by way of an interactive, remote desktop.

NobleProg -- Your Local Training Provider

Testimonials

★★★★★
★★★★★

Excel Course Outlines in Macao

Course Name
Duration
Overview
Course Name
Duration
Overview
14 hours
Overview
This instructor-led, live training in Macao (onsite or remote) is aimed at data scientists who wish to use Excel for data mining.

- By the end of this training, participants will be able to:
- Explore data with Excel to perform data mining and analysis.
- Use Microsoft algorithms for data mining.
- Understand concepts in Excel data mining.
14 hours
Overview
The course participants will be able to efficiently use primarily data analysis tools such as scenarios and pivot tables, use the features to perform calculations on dates and text-processing functions, and create and adapt to the needs of macros to automate work with spreadsheets.
14 hours
Overview
Audience

Financial or market analysts, managers, accountants

Course Objectives

Facilitate and automate all kinds of financial analysis with Microsoft Excel
14 hours
Overview
This instructor-led, live training (onsite or remote) is aimed at data analysts who wish to use Excel for data analysis.

By the end of this training, participants will be able to:

- Create spreadsheets in Excel.
- Visualize data with charts, graphs, etc.
- Generate reports to share amongst team members.
14 hours
Overview
During the training, will present the issues of financial analysis using the advanced features of Excel.

This course is intended for financial analysts, accountants and all those who want to expand their skills spreadsheet with issues of financial analysis.
7 hours
Overview
This instructor-led, live training in Macao (onsite or remote) 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.
14 hours
Overview
Audience

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.
14 hours
Overview
In this instructor-led, live training in Macao (onsite or remote), 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.
21 hours
Overview
This instructor-led, live training in Macao (onsite or remote) is aimed at data analysts who wish to program in R for Excel.

By the end of this training, participants will be able to:

- Toggle and move data between Excel and R.
- Use R Tidyverse and R features for data analytic solutions in Excel.
- Extend their data analytical skills by learning R.
21 hours
Overview
The objective of the course is to enable participants to gain a mastery of the fundamentals and usages of VBA for Access & Excel.
21 hours
Overview
This instructor-led, live training in Macao (onsite or remote) is aimed at data analysts who wish to use VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

- Record and edit macros as required.
- Write procedures using data from the sheet.
- Create your own functions.
- Handle an event (opening worksheet cell update etc.) by means of the handler.
- Create a form.
14 hours
Overview
This instructor-led, live training in Macao (onsite or remote) is aimed at data analysts who wish to use advanced VBA in Excel for automating tasks.

By the end of this training, participants will be able to:

- Write an advanced object-oriented application
- Convert text files
- Use of external data sources
- Use external libraries
Weekend Microsoft Excel courses, Evening Microsoft Excel training, Microsoft Excel boot camp, MS Excel instructor-led, Weekend Excel training, Evening MS Excel courses, Microsoft Excel coaching, Microsoft Excel instructor, Microsoft Excel trainer, MS Excel training courses, Microsoft Excel classes, Excel on-site, Microsoft Excel private courses, Microsoft Excel one on one training

Course Discounts

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Macao!

As a Business Development Manager you will:

  • expand business in Macao
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!