Advanced Techniques in Microsoft Excel («ME2»)

• Creating your own tables with different calculations in an efficient way
• Understanding percentage, date and look-up functions in Excel
• Visualising data using charts, sparklines and conditional formatting
• Consolidating multiple worksheets or workbooks

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: