Controlling mit Excel 2014

No more "trial and error". Learn, compact illustration of how to use Excel purposeful. The participants receive by Stefan Nelles, author of the successful reference book for Excel in controlling, field-proven tips and tricks to, inter alia, the following topics:

• Import and cleanup of raw data
• Basic Data Analysis with Excel tools: filters, database functions, conditional calculations
• Cost analysis with pivot tables and diagrams
• creating and controlling dynamic data models the example of a target-actual comparison and a forecasting
• working with shortcuts, structure functions, range names, dynamic column and row labels
• Calculation of scenarios based on a break-even analysis
• diagrams for a meaningful reporting create
• simplify work processes with macros

This seminar is aimed at professionals and executives who want to work with Excel more efficient, especially in the areas of controlling, finance, marketing, sales, production and project management.

For more information:
www.vereon.ch / eco