Course
Efficient calculations and visualizations with Excel («ME2»)
In this two days course you will learn how to use the most important functions of Excel and the possibilities of data visualization.
Duration
2 days
Price
1'140.–
exkl. MWST
Course documents
Digital courseware
Course facts
- Efficiently create your own tables with a wide variety of calculations
- Understanding of percentages, date and lookup functions in Excel
- Skillfully visualize data using charts, sparklines, and conditional formatting
- Consolidation of multiple worksheets or workbooks
In two days you will acquire a comprehensive knowledge of the possibilities of Excel and learn how to use it efficiently. Using practical examples, you will learn how to use simple to nested functions to evaluate your data. You will also learn the basics of consolidation and the possibilities of data visualization.
- Introduction and repetition
- Cell references
- Relative, absolute, and mixed references
- Using functions
- Creating functions
- Auto completion of functions
- Round results
- The IF function
- Structure of the function
- Nested IF functions
- The functions AND and OR
- Using names
- Definition, edit, delete and use
- Consolidate tables
- Date functions and time calculations
- Lookup functions
- VLOOKUP
- HLOOKUP
- Charts
- Chart types columns, lines, bar, pie, and radar
- Customize charts
- Print charts
- Data visualization with sparklines
- Conditional formatting
- Predefined rules
- Rules with functions
Component of the following courses
This course is aimed at users who already have experience with Excel and want to expand their knowledge in a practical way.
Attention: This course is not suitable for beginners. Basic knowledge of Excel similar to the following course is required:
This course is suitable for users of Excel 2019, 2016 and 2013.