Workshop Objectives:
- Create worksheets and workbooks
- Navigate in worksheets and workbooks
- Format worksheets and workbooks
- Change views and configurations
- Print and distribute worksheets and workbooks
- Manage data cells and ranges
- Create tables, charts and objects
- Perform operations with formulas and functions
Workshop Objectives:
- Save a workbook as a template, with colors, fonts, cell styles and
themes - Reference data using structured references or data in another
workbook - Protect a workbook from further editing
- Prepare a workbook for internationalization
- Apply custom data formats and validation
- Apply advanced conditional formatting and filtering
- Use form controls
- Work with macros
Workshop Objectives:
- Control Pagination
- Work with styles
- Perform advanced editing and formatting
- Create and manage indexes
- Create and manage references
- Manage forms and fields
- Create mail merge and labels
- Create and modify building blocks and content controls
- Work with Macros
- Create custom style sets, themes and templates
- Prepare a document for internationalization and accessibility
- Work with templates
- Use version control
- Manage document reviews and changes
Workshop Objectives:
- Connect one or more email accounts
- Preview, read, reply to and forward messages
- Process, create, format and check messages
- Use advanced message options
- Organize messages
- Use signatures and stationary
- Automate replies and organization
- Clean up and archive messages
- Create, organize and manage calendars, appointments, meetings and events
- Create and manage notes and tasks
- Create and manage contacts and contact groups
- Customize the Outlook environment settings
- Print and save Information
- Perform search operations in Outlook
Workshop Objectives:
- Create Presentations from scratch or templates
- Insert and format slides, handouts and notes
- Change Presentation views and configurations
- Insert and work with text, pictures, audio and video
- Work with tables, charts, and SmartArt
- Use transitions and animations
- Prepare for a presentation, including the slide size, narration, and timing
- Manage multiple presentations
Workshop Objectives:
- Create and modify databases
- Manage relationships and keys
- Navigate through a database
- Protect and maintain databases
- Print and export data
- Create and manage tables
- Manage records in tables
- Create and modify fields
- Create a query
- Modify a query
- Create calculated fields and grouping within queries