The course studies the extended functionalities of Microsoft Excel 2013 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 2013.
The course aims to provide to the student’s expert skills in Microsoft Excel
2013 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.
Meet our team of certified trainers who are here to help you master your knowledge and practices in the area of Microsoft Technologies.
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:
- Prepare data for Analysis
- Organizing data into tables
- Sorting and filtering data
- Base Functions
- Expert functions
- Analyzing data with charts
- Data Analysis with Power Pivot
- Securing and sharing workbooks
- Macros without VBA
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!