Course MS Office II. - Comprehensive 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
MS Power BI 1 with a duration of 3 days
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. - Comprehensive Skills
Course price: 1 013.01 / 1 246.00 EUR
without VAT / incl. VAT
This course can be completed free of charge within the support program for UoZ job seekers.
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. - Comprehensive Skills
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 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 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
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
Power BI - Getting Data from Various Sources
- From Excel, from text files, from the web, from a folder, from pdf
Editing Data in the PowerQuery Editor
- Using the first row as headers
- Replacing values
- Changing the type of values in a column, using locale settings
- Splitting a column
- Standard mathematical operations
- Adding a conditional column and a column from examples
- Removing duplicates
Creating a Data Model
- Multiple tables in the data model
- Relationships between tables, cardinality
- Filter direction
- Date table
- Hierarchy
DAX Language
- Creating a measure
- Adding a column to a table
- Operations and functions of the DAX language
Data Visualization
- Various visuals - card, table, matrix, charts, map
- Formatting visuals
- Using themes, creating a custom theme
- Sorting data in charts
- Creating a custom tooltip
- Creating a details page
Filters
- At visual level, page level and report level
- Editing interactions between individual visuals
Discussion and Conclusion
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. - Comprehensive 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. - Comprehensive Skills
This course has no published reviews yet.
You can add a review after completing the course.