Microsoft Excel for Power Users («MEPU»)

1 Entry and repetition

• Exercise with nested IF functions

2 Using names

• Define, apply, customize and delete names

3 Consultation function

• Functions VLOOKUP, HLOOKUP, MATCH, and INDEX

4 Text functions

• Functions LEFT, RIGHT, FIND, MID, TRIM

5 Other important features

• Functions COUNTIF(S), SUMIF(S), INDIRECT, OFFSET

6 Intercept errors in functions

• Functions IFERROR, ISERROR

7 Statistical evaluations

• Functions RANK, STDEV.P und FREQUENCY
• Add-in analysis functions

8 Conditional formatting with functions

9 Data validation (validity)

• Values from lists
• Dynamic validity
• Prevent duplicate entries

10 Protect data

• Cell protection, sheet protection, workbook protection
• Protect areas, protect file

Component of the following courses

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

Advanced Excel users who have very good knowledge and practical experience with Excel and now want to take full advantage of the possibilities of Excel.

• Very good knowledge of Excel is required for this training
• You will be able to create nested functions
• You know how to deal with names
• Know-how about PivotTables an advantage
• The course builds on the knowledge from our predecessor trainings

COURSE
Efficient calculations and visualizations with Microsoft Excel («ME2»)
2 days
• Basel, Berne, Geneva, Lausanne, Virtual Training, Zürich
CHF
1'140.–
Learn more