Course Outline - ITShare

MOS – Microsoft® Office Specialist

Core:
- Document Creation: Basic tools for creating and editing text documents.
- Text Formatting: Options for font style, color, and size.
- Spell Check: Tools for checking spelling and grammar errors.
- Templates: A selection of ready-made templates to help get started.
- Basic Editing: Tools for text modification, such as copy, paste, and find.
Advanced:
- Advanced Formatting: More sophisticated options for formatting text and tables.
- Mail Merge: Capability to send personalized messages to multiple recipients.
- References: Tools for adding citations, bibliographies, and indexes.
- Collaboration: Features for sharing documents and real-time collaboration.
- Inserting Graphics: Professional tools for adding charts, images, and graphics.

Core:
- Data Entry: User-friendly interface for inputting data into cells.
- Basic Formulas: Using fundamental functions like SUM and AVERAGE.
- Charting: Creating simple charts to visualize data.
- Conditional Formatting: Options for formatting cells based on values.
Advanced:
- Advanced Functions: Utilizing complex functions like VLOOKUP and IF.
- Pivot Tables: Creating tables for analyzing large datasets.
- Data Analysis Tools: Advanced options for graphing and analyzing data.
- Add-ins: Ability to use add-ins for enhanced functionality.

Comprehensive:
- Presentation Creation: Tools for making engaging and visually appealing slides.
- Animations: Options for adding motion effects to text and images.
- Transitions: Effects between slides to enhance presentation flow.
- Media Insertion: Capability to add videos and audio files.
- Collaboration and Sharing: Features for teamwork and feedback.

Email Management: Tools for sending and receiving emails efficiently.
Calendar: Scheduling meetings and appointments with reminders.
Tasks: Managing tasks and tracking progress.
Advanced Search: Tools for quickly finding messages and appointments.
Security Features: Improvements in email security and information protection.