Excel Training
Originally published: 06/04/2020 07:38
Last version published: 14/04/2020 07:06
Publication number: ELQ-55221-3
View all versions & Certificate
certified

Excel Training

Spreadsheet with excel exercises

Description
Spreadsheet with multiple excel exercises, covering various topics. The file can be used to test your knowledge, refresh usage of different excel formulas or can be used to facilitate internal and external excel training.

The spreadsheet covers the following topics:

• Keyboard navigation and shortcuts - list of the most useful shortcuts.
• Absolute References - different anchoring methodologies.
• Basic Formulas - for sum to max and min.
• Conditions - with and without if statement.
• Powers
• Sumproduct - weighted average concept.
• Vlookup vs Index + Match - which one is better?
• Data cleansing and connections - using left and right formulas to clean the data.
• Pivot Tables
• Graphs - dynamic graphs as an option.
• Conditional Formatting - ways to improve your report.
• Data Validation - controlling other users inputs.
• Goal Seek - fast iterative process.

Excel training improves your efficiency in using the tool. And the key factor can be start using the keyboard shortcuts instead of mouth. Concentrating on that will help your fingers muscle memory to improve your speed in the future.

Facilitation of the training is a good chance for collaboration with your colleagues. The attached file can be a starting point depending on the needs of your company/team.

If you have any suggestions or questions please leave a comment or contact by sending the private message.

This Best Practice includes
Excel Spreadsheet

Samir Asadov CFA offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Training purpose


0.0 / 5 (0 votes)

please wait...