Microsoft Excel 2013 (Advanced)
The aim of this course is to introduce and implement the extended MS Excel functions and add-on modules relating to MS Excel 2013.
- Database construction and data recording
- Database maintenance
- Search and sort functions
- Filtering, selecting and extracting
- MS Query introduction
- Database functions/filter functions
- Partial results and consolidation functions
- Creating pivot tables
- Editing pivot tables
- Creating diagrams from a pivot table
- Linking worksheets and workbooks
- Working with complex functions
- Creation of sample templates
- Methods of data analysis
- Data exchange with other applications, data import and export
- Structuring tables
- Excel workbooks on the Web
- Advanced charting
- Scenario Manager
- Target value search
- Multiple operations, matrix formulas
- Easy macro creation with the macro recorder
Target audience
This seminar is aimed at people who want to expand their basic knowledge of MS Excel in order to use the product more effectively.
Further seminars
Inhouse
We would be happy to conduct all of our open seminars for you in an adapted form as an in-house seminar.
All seminars on the topic