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.