Microsoft Office Excel – Advanced

This training will provide you with advanced-level knowledge of extended functionalities of Microsoft Office Excel in data analysis.

Overview

The course studies the extended functionalities in data analysis of Microsoft Office Excel. The course is structured as a set of modules, emphasized on the embedded functions, tables, as well as all possibilities of the product for quick and effective work with data and gathering the required information.

Get expert skills in the analytical capabilities of Microsoft Office Excel

The goal of the course is not just comprehension of the instruments for working with the product, but development of skills to choose the right tool in order to receive the demanded result.

Combine theory with practice

The training is enriched with many demonstrations, practical exercises and scenarios to ensure quick and effective learning.

Put what you’ve learned into practice

After the completion of the course, you will be able to apply you knowledge practically in accordance with the business environment that you work in.


What you’ll learn

In this course you will learn how to:

  • Perform complex calculations and apply in practice different categories of embedded functions
  • Control the input data and the results of the calculations
  • Structure the data in an appropriate way for analysis and use the various analysis tools
  • Create reports with summary tables to analyze data with charts
  • Securing and sharing workbooks
  • Create and run custom macros, without using Visual Basic Applications.

Frequently Asked Questions

Who should attend?

The course is designed for financial experts and analysts, accountants, marketing specialists and others, who need to be comfortable in working with a tool for data analysis.

Can the training be customized? 

Yes. If you are organizing a training for a group of people from your organization, we can discuss what your goals for the group learning outcomes are. This training can be customized to include more real examples from your everyday work, that have challenged the team!

What version of Microsoft Office is used during the training?

The training can be based on Microsoft Office 2010, 2013 or 2016 depending on the needs and requirements of your group or organization.

Register






Once you submit your registration, we will get in touch with you to confirm your interest and attendance.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close