Microsoft Office Excel 2016-Advanced

B21635 3 days 240

Complete this 3 day training and you will finish with advanced level knowledge of extended functionalities of Microsoft Excel 2016 in data analysis.

Overview

The course studies the extended functionalities of Microsoft Excel 2016 in data analysis. 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. Complete this 3 day training and you will finish with advanced level knowledge of MS Excel 2016.

The course aims to provide to the student’s expert skills in Microsoft Excel
2016 analytical capabilities, so that the student could apply their knowledge in their everyday work. 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. After the course’s completion the students will be able to apply their knowledge practically in accordance to the business environment that they work in.

Get the best of Microsoft Excel!

This course will help you learn how to track and visualize data for better management and insight of large amounts of information.

Combine theory with practice

The course is enriched with multiple demonstrations, practical exercises and scenarios for effective learning and
comprehension of the course material.


Instructors

Meet our team of certified trainers who are here to help you master your knowledge and practices in the area of Microsoft Technologies.

Antoniya Neycheva

Antoniya is Business Productivity Consultant and Trainer. She is a highly skilled IT professional with more than 10 years of experience in developing solutions and training programs based on Microsoft technologies. Her expertise focus lies in the field of MS SharePoint, MS CRM, MS Office, Business Intelligence and Microsoft e-Learning Gateway solutions implementation.


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
  • Generate and visualize data using Power View and Power Pivot
  • Securing and sharing workbooks
  • Create and run custom macros  without VBA

Calendar

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 challanged the team!

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