Advanced Techniques in Microsoft Excel («ME2»)

1 Introduction and repetition

2 Cell references

• Relative, absolute, and mixed references

3 Using functions

• Structure of functions

4 Auto-completion of functions

5 Rounding results (incl. rounding by five)

• Structure of the function
• Nested IF functions

6 Logical functions

• «IF» family of functions
  • Structure of the function
  • Nested IF functions
  • IFs
  • IF errors
• AND and OR functions

7 Using names

• Definition, customise, delete and use
• Table names

8 Date functions and time calculations

9 Lookup functions

• VLOOKUP function (optional: HLOOKUP)
• XLOOKUP

10 Charts

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

11 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