MS Office for Secretariat and Advisory
This course aims to provide participants with advanced level knowledge and practice in word processing Microsoft Excel and Word, applied to advisors with responsibility of the Executive Secretariat.
Specific objectives:
At the end of the course the trainees will be able to:
• Mastering advanced Word tools;
• Elaborate long documents;
• Create automatic indexes;
• Use the capabilities of mail merge;
• Apply advanced Word tools to organizational templates;
• Use code fields;
• Record macros;
• Identify all the computing capacity enhanced by the use of functions, using data contained in several worksheets;
• Perform simulation of data and pivot tables;
• Analyze scenarios, using the capabilities provided by Excel;
• Create reports from the information contained in the worksheets;
• Use the ability to automate routine tasks;
• Organize and manage lists of data.
Specific objectives:
At the end of the course the trainees will be able to:
• Mastering advanced Word tools;
• Elaborate long documents;
• Create automatic indexes;
• Use the capabilities of mail merge;
• Apply advanced Word tools to organizational templates;
• Use code fields;
• Record macros;
• Identify all the computing capacity enhanced by the use of functions, using data contained in several worksheets;
• Perform simulation of data and pivot tables;
• Analyze scenarios, using the capabilities provided by Excel;
• Create reports from the information contained in the worksheets;
• Use the ability to automate routine tasks;
• Organize and manage lists of data.
CONTENTS
Module A - ExcelModulo 1 - File Management
Module 2 - Advanced Functions
Module 3 - Databases
Module 4 - Macros
Module 5 - New Features of Excel
Module 6 - Practical Exercises
Module 7 - Graphics
Module 8 - Working with Bases or Data Lists
Module 9 - Simulation Tools
Module 10 - Simulation Tables
Module 11 - Database Tools
Module 12 - Creating Views and Reports
Module 13- Custom Controls
Module 14- Toolbar Customization
Module 15 - Automation of Tasks
Module 16 - Excel And Internet
Module 17- Using Bookmarks
Module B- Word
Module I - Advanced Actions
Module II - Long Documents
Module III - Mail
Module IV - Word from the desktop
