Efficient calculations and visualizations with Microsoft Excel («ME2»)

1 Introduction and repetition

2 Cell references

• Relative, absolute, and mixed references

3 Using functions

• Creating functions
• Auto completion of functions

4 Round results

5 The IF function

• Structure of the function
• Nested IF functions

6 The functions AND and OR

7 Using names

• Definition, edit, delete and use

8 Consolidate tables 

9 Date functions and time calculations

10 Lookup functions

• VLOOKUP
• HLOOKUP

11 Charts

• Chart types columns, lines, bar, pie, and radar
• Customize charts
• Print charts

12 Data visualization with sparklines

13 Conditional formatting

• Predefined rules
• Rules with functions

Component of the following courses

• From Zero to Hero with Microsoft Excel («MEZH»)

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:

COURSE
Microsoft Excel Refresher («MEREFR»)
1 day
• Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
CHF
650.–
Learn more
COURSE
Microsoft Excel Foundation («ME1»)
2 days
• Basel, Berne, Geneva, Lausanne, Zürich
CHF
1'140.–
Learn more

This course is suitable for users of Excel 2019, 2016 and 2013.