ObjectivesYou have mastered basic and intermediate commands and would like to progress towards advanced feature. This course will enable you to discover or perfect your knowledge concerning advanced calculation functions, control tools and the search, protection and sharing of your workbooks and data. You will also discover macros.
Targeted audienceUsers who have mastered the essential commands and wish to move towards more advanced techniques.
PrerequisiteExcel basics (EL440).
- Converting data
- Custom views
- Advanced functions (time, date, text, AND, OR, NOT, IF, etc.)
- Financial and matrix functions
- Creating styles, templates and forms
- Sharing and security
Complete online self-paced training. Accessible anytime from anywhere. One year access to the training and the digital book.