Course MS Office II. Professional
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. Professional
Course price: 590.40 / 726.19 EUR
without VAT / incl. VAT
Labour market services employees can attend this course free of charge through the Modernisation of Labour Market Services program.
More information about the conditions and participation options is available at the following link:
The manual is included in the training price.
Training syllabus MS Office II. Professional
Recap of Basic Control Elements in the Program
- 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 the 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
- types of objects inserting and formatting objects text wrapping around objects
Working with Fields
- types of fields and working with them comment footnote cross-reference captions for pictures, tables and objects
Document Protection, Security
- locking the document, passwords preparation of a complex document template and its protection printing - advanced techniques, discussion and conclusion
MS Excel Summary
- review of working with formulas and functions in Excel, function syntax, nesting functions table tool - table calculations, forms, controls, 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, discussion and conclusion
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, discussion and conclusion
Creating a Presentation in PowerPoint
- changing the appearance of the presentation working with templates and color schemes manual formatting - advantages, disadvantages creating, saving and using your own template
Working with Slides
- selecting a suitable slide type, changing the slide type working with text in MS PowerPoint drawing and working with objects working with tables, charts, diagrams and imported graphics OLE, DDE, updating links use of hyperlinks animations and transition effects in PowerPoint working with data stored in another presentation or in MS Word arranging the presentation in outline form flowcharts, organization charts, WordArt creating pages with notes and handouts printing, discussion and conclusion
Output knowledge
The MS Office Professional course - promotional package! will enable you to master and comprehensively use applications of the Microsoft Office package at advanced user level.
Recommended courses after completing MS Office II. Professional
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. Professional
This course has no published reviews yet.
You can add a review after completing the course.