Course MS Office II. - Key Skills
The MS Office Professional course package is intended to increase work efficiency in the MS Office environment. It is co...
The MS Office Professional course package is intended to increase work efficiency in the MS Office environment. It is composed of higher-level courses: MS Word 3 Advanced with a duration of 1 day MS Excel 3 Advanced with a duration of 2 days MS Outlook 2 Advanced with a duration of 1 day MS PowerPoint 2 with a duration of 1 day
The MS Word 3 course is focused on effective work with standard and extensive documents, correct setting of page numbering, creating bibliographic references, a document table of contents with automatic generation of page numbers, etc. In addition to advanced tools for editing documents, you will become familiar with macros, fields, securing documentation with a password, a confidential author mark or watermark, creating PDF format and advanced printing techniques. The MS Excel 3 course focuses on lookup, text and logical functions, work with automatic and advanced filters, pivot tables and effective use of the Solver function. The MS Outlook 2 course will prepare you for effective use of e-mail, contact management, working with the calendar, tasks, journal, public folders as well as integration of MS Outlook with other applications. The MS PowerPoint course is intended for everyone who needs to effectively process information intended for presentation purposes in advertising, business and promotional areas, as well as in the field of professional presentations and modern teaching methods.
Minimum input knowledge
Knowledge of MS Office applications at a slightly advanced level.
Course dates MS Office II. - Key Skills
Daily courses (5 days): 09:00 - 15:00
Course price: 606.10 / 745.50 EUR
without VAT / incl. VAT
This course can be completed free of charge within the support program for ZoZ employed applicants.
If you are interested in attending the course free of charge, you can find more information at the following link:
The manual is included in the training price.
Training syllabus MS Office II. - Key Skills
MS Word 3
Recap of Basic Control Elements in Word
- formats
- styles
- tools
- tables
- conversion
Working with Extensive Documents
- document sections
- outline and organization of the document
- working with nested documents
- comparing documents
Creating a Table of Contents
- working with the document table of contents
- creating, editing, contents of the main and nested document
- copying contents to another document
- creating a document index
Microsoft Word Mail Merge
- form letter
- return address
- envelopes and labels
- query definition
Working with Objects
- object types
- inserting and formatting objects
- text wrapping around objects
Working with Fields
- field types and working with them
- comment
- footnote
- cross-reference
- captions for pictures, tables and objects
Document Protection, Security
- locking a document, passwords
- preparation of a complex document template and its protection
- printing - advanced techniques
MS Excel 3
MS Excel Summary
- review of working with formulas and functions in Excel
- function syntax
- nesting functions
- table tool - table calculations
- forms
- controls and setting their format
- options for securing cells, worksheet and workbook
- locking the file
- naming ranges
Array Formulas
- use of array formulas
- one-dimensional and two-dimensional arrays
Excel Lookup Functions
- LOOKUP, VLOOKUP, HLOOKUP, CHOOSE, MATCH, INDEX
Logical Functions
- IF, nesting IF, AND, OR
Text Functions
- CONCATENATE, FIND, SEARCH, LEFT, RIGHT, MID, SUBSTITUTE
Working with Automatic and Advanced Filters
- limitations of the automatic filter
- entering complex filtering conditions
- use of wildcard characters in text criteria
Summaries, Subtotals
- creating simple and nested summaries
- tool for consolidating multiple ranges
Working with Pivot Tables
- working with row, column, page and data area fields
- setting the properties of a table field and also the properties of the entire table
- multiple consolidation ranges
- calculated field
- grouping
Solver Function and Its Use
- working with the SOLVER add-in: optimization tasks entering conditions
MS Outlook 2
MS Outlook Program Options
- brief overview of the organization of MS Outlook
- management of mail folders
- preferences for new mail messages
- organization of mail folders and mail filtering options
- use of certificates
- distribution lists
Contacts in MS Outlook
- import and export of contacts
- automatic creation of contacts
- sharing contacts
- delegating permissions
- tracking communication, tasks and notes
MS Outlook Calendar
- regular and irregular events
- sharing the calendar
- publishing the calendar as a www page
- checking the workload of other users when planning meetings
Tasks
- creating a new task
- recurring tasks
- assigning tasks to users and subsequent delegation of task control to another user
MS Outlook Journal
- notes, setting default properties of notes
Public Folders
- creating new folders
- delegating and removing permissions
- use of public folders
- program customization
- effective work with folders
Integration of Microsoft Outlook with Other Applications
- OLE, DDE
- mail merge
- sending mail from an application
- import and export of data to other formats
- working with address books
- work safety in the program
PowerPoint - Quick Review of the Basics
- Interface and new functions
- Slide types and layouts
- Most frequent mistakes in presentations
Working with Layout and Design
- Rules of visual communication (contrast, colors, typography)
- Use of themes and custom templates
- Working with Slide Master
- Design consistency across the presentation
Advanced Object Formatting
- Alignment, layers and groups of objects
- Precise work with shapes and icons
- Working with images (cropping, effects, removing the background)
- Use of SmartArt and its modifications
Data Visualization
- Advanced work with charts
- Connection with Excel
- Infographics directly in PowerPoint
- Simplifying data for the audience
Animations and Transitions (Advanced)
- Types of animations and combining them
- Setting timing and sequences
- Use of Morph transition
- Creating dynamic presentations
Interactivity in a Presentation
- Hyperlinks and action buttons
- Navigation menu in a presentation
- Creating clickable presentations (e.g. trainings, kiosks)
Multimedia and Advanced Elements
- Inserting video and audio
- Recording a presentation (voice + screen)
- Export to video
- Working with captions and timing
Storytelling and Presenting
- Presentation structure (introduction-body-conclusion)
- How to engage the audience
- The rule of less is more
- Working with speaker notes
Efficiency and Tips for Advanced Users
- Keyboard shortcuts
- Duplicating and working with content
- Quick formatting
- Automation and templates
Practical Exercise
- Creating your own presentation
- Assignment: professional slide deck (e.g. product / project)
- Feedback and recommendations
Output knowledge
The MS Office II. - Key Skills course package will enable you to master and comprehensively use Microsoft Office applications at advanced user level.
Recommended courses after completing MS Office II. - Key Skills
Show all courses from category MS Office courses
Contact us
If you need a custom date, group training, or help choosing the right course, contact Macrosoft directly. We will help you with the next step.
Need more details?
Open the contact page for a full enquiry flow, company billing details, and directions to the training centre.
Course Reviews MS Office II. - Key Skills
This course has no published reviews yet.
You can add a review after completing the course.