Page 1
MS Office courses
Category overview
Word courses - training and corporate education, focused on the use of Microsoft Word
Word course can run in MS Office 2007, 2010, 2013 or even 2003
We'll be happy to prepare a closed training session for you:
- syllabus of the Word course customized
- training in case we will organize at your place of interest
- we also organize residential training Word related to wellness, hiking or skiing , "why not combine the pleasant with the useful?"
- we will adjust the term of the course to your requirements
- take advantage of significant volume discounts for training, Word and Office courses
- Testing: We can test your employees in advance and recommend a suitable course level
E-learning: e-courses
We will give you access to selected computer courses in the student zone, where students will have online access to study materials and can return to the downloaded curriculum at any time.
Word - a text editor is a popular program for creating various documents, users can easily and at the same time very comfortably create a professional document. The program has a very wide range of options, which the average user uses about 20%. The user can write in it from the application, the contract, the creation of the order, the writing of the CV, to the creation of several-page documentation to the publication of the book binding. Due to its wide use, this program is popularly used in the offices of small and large companies, scientific institutes, schools, and last but not least, households.
Macrosoft Training Center - PC School has prepared syllabi for Word courses and trainings are conducted so that mastering the program Microsoft Word was from the ground up , advanced, advanced up to the creation of forms and templates clearly presented by the participants, who, together with the lecturer, also practice illustrated examples in the Word course . A separate part is the Word Course for assistants such as business correspondence , normalized document editing or Word in practice
Word training curricula are listed for each course separately, including course dates.
In case of interest Macrosoft - PC School prepares customized Word training that takes into account all customer requirements. If the participants are interested, they will test the participants in advance, recommend them to the appropriate level and place them on a course according to the previous convention. Refreshments, study materials, stationery are prepared for the participants of the training and after completing the training they will receive a Certificate!
Feel free to contact us on tel. No: 02/55 410 308 , 0948 88 40 88, 0948 88 41 88 or by e-mail [email protected]
The Macrosoft team looks forward to working with you.
Call Send SMS Add to Skype You'll need Skype Credit Free via Skype
Contents
Active courses: 14
Page 2
MS Office I. - Key Skills
Price incl. VAT
784.00 €
Current VAT 23%
Duration
Day: 7 days
Course overview
The MS Office course is intended for all interested participants who want to acquire basic IT skills with the aim of finding employment in the labor market not only in administration, but also in other sectors where basic computer skills are required. Only the start of the course is listed in the date; we will inform you about the other dates. The package includes the courses: MS Word II. with a duration of 2 days MS Excel I. with a duration of 2 days MS Excel II. with a duration of 2 days MS PowerPoint in Practice with a duration of 1 day
Minimum input knowledge
No specific entry knowledge is expected.
Output knowledge
Mastery of key basic skills in the programs of the MS Office office package - Word, Excel and PowerPoint.
Training syllabus
MS WORD Program and Working Environment Settings in Microsoft Word
- toolbars automatic saving display options spelling and working with dictionaries automatic correction options etc.
Document Formatting in Microsoft Word
- font, paragraphs, tabs and indents borders and shading bullets and numbering page format
Styles in MS Word and Their Use
- automatically saved formats editing styles creating your own style outline levels replacing direct formatting with styles
Multilevel Numbering in MS Word
- basic use and control setting properties for each level possibilities of use when working with styles
Working with Tables in Word
- table design editing the table range and format converting text - table and table - text automatic table format
Editing an Extensive Document in Word
- creating a document outline, generating a document table of contents
Other Microsoft Word Functions
- working with columns page numbering line numbering watermark
Printing a Document
- settings before printing creating a document header and footer
Discussion and Conclusion
MS EXCEL
- Excel window: title bar, Ribbon, division of the Ribbon into individual tabs and groups, name box, formula bar, workspace, status bar
Basic Terms and Operations
- column, row, cell, worksheet and workbook cell cursor, its Edit and Enter modes working with a cell: entering data and formulas setting column width and row height selecting larger continuous and non-continuous ranges opening a file, saving a file in xlsx and xls formats inserting and deleting rows and columns, hiding and unhiding rows and columns print preview, zoom
Working with Worksheets
- creating and deleting worksheets renaming, moving and copying worksheets color differentiation of worksheets
Visual Processing of Tables (Formatting)
- basic formatting of text and cell, superscript and subscript filling cells with one color, gradient and pattern table borders using quick options, drawing or the Format Cells window automatic table format merging cells, aligning text number formatting, use of categories: General, Number, Currency, Accounting, Date, Text difference between the Currency and Accounting categories
Working with Formulas and Basic Functions
- cell names entering formulas, difference between cell names and constants in formulas, advantages of using names relative reference, copying formulas, preserving table formatting after copying formulas basic functions: sum, average, count, maximum and minimum use of functions for non-continuous ranges, reading functions from the formula bar
Copying, Automatic Series
- different ways of copying through the Paste Special menu and Clipboard group creating linear series, dates, names of weekdays and months
Working with Data Tables
- sorting data filtering data, filtering based on a condition, searching
MS POWERPOINT Working with Slides
- creating slides adding new slides selecting and laying out a slide title and content writing text inserting slides from another presentation creating notes
Selecting a Theme and Adding Other Content
- background design color scheme font types and sizes placeholder positions inserting pictures and objects editing and arranging slides creating, saving and using your own template checking, printing and preparing a presentation preview on a computer spell checking, adding comments printing handouts and notes adding footer text to handouts and notes color options for printing packaging the presentation, discussion and conclusion Discussion and conclusion
Page 3
MS Office I - Complex Skills
Price incl. VAT
1 190.00 €
Current VAT 23%
Duration
Day: 10 days · Evening: 20 days · Weekend: 10 days
Course overview
The MS Office I - Complex Skills with AI course is intended for all interested participants who want to acquire basic IT skills with the aim of finding employment on the labor market not only in administration, but also in other sectors where basic computer skills are required. The MS Office I - Complex Skills package includes courses: MS Word I and II with a scope of 3 days MS Excel I with a scope of 2 days MS Excel II with a scope of 2 days MS Outlook I with a scope of 1 day MS PowerPoint I with a scope of 1 day MS PowerPoint II with a scope of 1 day The course start is shown in the date; we will inform you about the other dates.
Minimum input knowledge
Basic knowledge of working with a computer is assumed
Output knowledge
Gaining an overview and mastering the use of MS Office applications at the level of a slightly advanced user, also using the possibilities of artificial intelligence
Training syllabus
MS WORD
- Familiarization with the Microsoft Word environment ribbon, ruler, workspace, status bar keyboard language settings using help Working with text typing, editing copying, deleting and moving text inserting and deleting blank lines
Text Formatting
- Font type and size, bold and underlined font, italics, superscript and subscript text color and shading clearing formatting error checking
Working with Paragraphs
- paragraph settings indents tabs single-level bullets and numbering
Working with Tables
- creating a table and entering data editing a table
Working with a Document
- page setup - margins, orientation, format print settings and print preview saving a document
MS EXCEL
- Excel window: title bar, Ribbon, division of the Ribbon into individual tabs and groups, name box, formula bar, workspace, status bar
Basic Concepts and Tasks
- column, row, cell, sheet and workbook cell cursor, its Edit and Enter modes working with a cell: entering data and formulas setting column width and row height selecting larger continuous and non-continuous areas opening a file, saving a file in xlsx and xls formats inserting and deleting rows and columns, hiding and unhiding rows and columns print preview, zoom
Working with Sheets
- creating and deleting sheets renaming, moving and copying sheets color differentiation of sheets
Visual Processing of Tables (Formatting)
- basic text and cell formatting, superscript and subscript filling cells with one color, gradient and pattern table borders using quick options, drawing or the Format Cells window automatic table format merging cells, text alignment number formatting, use of categories: General, Number, Currency, Accounting, Date, Text difference between Currency and Accounting categories
Working with Formulas and Basic Functions
- cell names entering formulas, difference between cell names and constants in formulas, benefits of using names relative reference, copying formulas, preserving table format after copying formulas basic functions: sum, average, count, maximum and minimum use of functions for non-continuous areas, reading functions from the formula bar
Copying, Automatic Series
- different copying methods through the Paste Special menu and Clipboard group creating linear series, dates, names of weeks and months
Working with Data Tables
- sorting data filtering data, filtering based on a condition, searching
MS Excel Pivot Tables
- Basic rules for working with tables in Excel, recapitulation of functional options working with a database as a source for a pivot table
Creating a Pivot Table
- working with row, column and page fields and the data area
Modifying a Pivot Table
- setting properties of the table value field setting properties of the table description field setting properties of the whole table formatting the table using automatic format working with a calculated field of the pivot table display in sheets using the page field
Creating a Pivot Chart
- chart formatting selected numeric formats of axes changing axis ranges adding data and data series to a chart changing chart type access to external data sources, multiple consolidation ranges
Options for Automating Data Processing
- creating a macro - running a data query and subsequent processing by a pivot table, creating a predefined chart and using it discussion conclusion
MS POWERPOINT Working with Slides
- creating slides adding new slides selecting and laying out a slide title and content writing text inserting slides from another presentation creating notes
Selecting a Theme and Adding More Content
- background design color scheme font types and sizes placeholder positions inserting images and objects editing and arranging slides creating, saving and using your own template checking, printing and preparing a presentation preview on a computer spell check, adding comments printing handouts and notes adding footer text to handouts and notes color options for printing packaging the presentation, Discussion and conclusion
Page 4
Word 1 - Basics
Price incl. VAT
134.07 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
You will learn to create documents independently in Word. You will gain an overview of Word's options. You will efficiently create your first documents in Word. You will be able to independently set printing of a document you have created for different paper sizes. Experienced lecturers will point out the most common bad habits when writing a document, which in the long term complicate editing of shorter and larger text documents. In our Microsoft Word course, we have prepared many examples for independent practice. Under the guidance of an experienced lecturer, you will gain the necessary skills for editing documents. We have prepared a Word manual for you, which you can use during independent work in practice.
Minimum input knowledge
Basic knowledge of working with a computer, basic skill in using the keyboard and mouse.
Output knowledge
You will discover the possibilities of working with text in the Microsoft Word word processor. You will gain the knowledge needed to read and edit existing documents, create new documents, edit them efficiently and effectively and then print them on paper.
Training syllabus
Getting Familiar with the Microsoft Word Environment
- Ribbon, ruler, working area, status bar.
- Keyboard language settings.
- Using help.
Working with Text
- Writing, editing.
- Copying, deleting and moving text.
- Inserting and removing blank lines.
Text Formatting
- Font type and size.
- Bold and underlined font, italics, superscript and subscript.
- Text color and highlighting.
- Clearing formatting.
- Error checking.
Working with Paragraphs
- Paragraph settings.
- Indents.
- Tabs.
- Single-level bullets and numbering.
Working with Tables
- Creating a table and entering data.
- Editing a table.
Working with a Document
- Page setup - margins, orientation, format.
- Print settings and print preview.
- Saving a document.
Page 5
Word 2 - Intermediate
Price incl. VAT
200.00 €
Current VAT 23%
Duration
Day: 2 days · Evening: 3 days · Weekend: 2 days
Course overview
Work in Word faster and more effectively. You will create tables, images, styles and mail merge letters without problems. You will learn how to correctly edit shorter and more complex documents so that you avoid the most common shortcomings. You will save time with manual writing of envelopes and documents by using tools for mass creation of documents. You will master creating your own text styles so that you do not always have to manually set font and text properties. You will try how to effectively work with co-workers on one document, or how to track changes and respond to comments. In addition to working with the document itself, we will teach you how to protect the created document, not only in the sense of GDPR, so that you can safely store and send documents containing sensitive data.
Minimum input knowledge
Routine computer control and experience with Windows. Experience with Word such as writing, copying and deleting text, moving through a document, basics of formatting and printing a document.
Output knowledge
You will gain an overview of more advanced functions of Word. You will be able to work effectively and quickly with shorter as well as more extensive documents. You will be able to independently secure a document, create your own text styles, templates, insert tables, images and, last but not least, send mass documents.
Training syllabus
Setting the Program and Working Environment of Microsoft Word
- toolbars automatic saving display options spelling and working with dictionaries AutoCorrect options, etc.
Document Formatting in Microsoft Word
- font, paragraphs, tabs and indents borders and shading bullets and numbering page format
Styles in MS Word and Their Use
- automatically saved formats editing styles creating your own style outline levels replacing direct formatting with styles
Multilevel Numbering in MS Word
- basic use and control setting properties for each level options for use when working with styles
Working with Tables in Word
- table design editing the range and format of a table converting text - table and table - text automatic table format
Editing an Extensive Document in Word
- creating a document overview, generating document contents
Other Microsoft Word Functions
- working with columns page numbering line numbering watermark
Printing a Document
- settings before printing creating document header and footer
Discussion and Conclusion
Page 6
Word 3 - Advanced
Price incl. VAT
146.37 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
Become a professional in Word, create short and extensive documents with elegance and efficiency. You will learn how to create an extensive document in Word (e.g. a book, seminar paper), correctly set page numbers, create bibliographic references (including footnotes), document contents with automatic generation of page numbers, etc. In addition to advanced tools for document editing, you will become familiar with macros and fields. Do not leave your works at the mercy of plagiarists and reveal whether some seemingly foreign documents were not your creations! In addition to tools for editing a document, we will show you how documents can be secured with a password, a hidden author mark or a watermark. At the end, we will create documents in PDF format and also show advanced techniques for printing brochures and other less common document formats. You will simplify and speed up your work in Word using macros that speed up your work.
Minimum input knowledge
Knowledge of MS Word at the level of an everyday, routine user. Knowledge of working with a computer on a daily basis - user.
Output knowledge
You will gain an overview of creating and managing extensive documents in Word, including books and long papers. You will protect your documents against plagiarism and unauthorized use. You will be able to automate some activities using a macro.
Training syllabus
Recapitulation of Basic Controls in the Program
- formats styles tools tables conversion
Working with Extensive Documents
- document parts outline document organization master document view working with nested documents comparing documents
Creating Contents
- working with document contents creation, editing contents of master and nested document copying contents to another document creating 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 a Field
- field types and working with them comment footnote cross-reference captions of pictures, tables and objects
Document Protection, Security
- document locking, passwords preparation of a complex document template and its protection printing - advanced techniques
Discussion and Conclusion
Page 7
PowerPoint 1 - In Practice
Price incl. VAT
121.77 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
The PowerPoint in Practice course is intended for everyone who needs to quickly and 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
Basics of working with a computer.
Output knowledge
Creation of electronic presentations, reports and advertising brochures in PowerPoint.
Training syllabus
Description of the PowerPoint Working Environment
- Creating, opening and saving a presentation in MS PowerPoint.
- Working with different views of a presentation.
Creating a Presentation in PowerPoint
- Changing the appearance of a 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.
- Using hyperlinks.
- Animations and transition effects in PowerPoint.
- Working with data stored in another presentation or in MS Word.
- Arranging a presentation in outline form.
- Flowcharts, organization charts, WordArt.
- Creating pages with notes and handouts.
- Printing.
- Discussion.
- Conclusion.
Page 8
PowerPoint 2 - Advanced
Price incl. VAT
159.90 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
The Advanced PowerPoint course is intended for everyone who needs to deepen their knowledge of working in PowerPoint, learn to create visually attractive, professional and interactive presentations with emphasis on efficiency and design.
Minimum input knowledge
Basic knowledge of creating presentations in PowerPoint
Output knowledge
The participant will be able to:
- create a professional presentation,
- work effectively with animations and design,
- present information visually and clearly,
- use PowerPoint as a communication tool, not just "text on slides".
Training syllabus
Quick Review of Basics
- Interface and new functions
- Slide types and layouts
- Most common 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
- Aligning, layers and object groups
- Precise work with shapes and icons
- Working with images (cropping, effects, background removal)
- Using SmartArt and editing it
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 their combination
- Setting timing and sequences
- Using Morph transition
- Creating dynamic presentations
Interactivity in a Presentation
- Hyperlinks and action buttons
- Navigation menu in a presentation
- Creating "clickable" presentations (e.g. training, 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-core-conclusion)
- How to engage the audience
- The "less is more" rule
- Working with presenter 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
Page 9
Outlook 1 - Basics
Price incl. VAT
121.77 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
Course participants will learn to use this program for e-mail communication, organizing information and their time.
Minimum input knowledge
Standard PC operation, experience with the Windows environment.
Output knowledge
Mastering work with Outlook as an e-mail program as well as its use for organizing time, contacts and tasks on a computer.
Training syllabus
Possibilities and Use of Microsoft Outlook
- Introduction to Microsoft Outlook.
- Working with Outlook Today.
- Parts of the program window.
- Working with folders.
Microsoft Outlook E-mail
- Receiving, displaying and printing new messages.
- Replying to a message.
- Forwarding a message.
- Working with attachments.
- Message format.
- Inserting signatures.
- Setting rules for sending messages.
- Sorting received mail.
MS Outlook Address Book
- Displaying, description of possible address books, searching.
- Creating new records and distribution lists.
- Contacts (inserting, editing, customizing the contacts folder, using visitcard).
MS Outlook Calendar
- Planning.
- Displaying a meeting, event reminders.
Tasks in MS Outlook
- Entering.
- Editing, checking.
- Assigning, deleting.
Notes
- Working with MS Outlook Journal.
- Working with notes.
- Discussion.
- Conclusion.
Page 10
Outlook 2 - Advanced
Price incl. VAT
184.50 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
The training is intended for users who need to master working with the program as a workgroup client on Microsoft Exchange Server with all the possibilities that teamwork brings.
Minimum input knowledge
Standard PC operation, experience with using Microsoft Outlook.
Output knowledge
Using Outlook as a workgroup client on Exchange Server, with mastery of the possibilities it provides for teamwork.
Training syllabus
Possibilities and Use of the Program
- Brief overview of the program organization.
- Managing mail folders.
- Preferences for new mail messages.
- Arranging mail folders and searching in them.
- Mail filtering options.
- Use of certificates.
- Distribution lists.
Contacts in MS Outlook
- Import and export of contacts.
- Automatic creation of contacts.
- Sharing common contacts and delegating access rights to contacts.
- Tracking communication, tasks and notes concerning a shared contact for multiple users.
MS Outlook Calendar
- Regular and irregular events.
- Sharing a calendar.
- Publishing a 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 note properties).
Public Folders
- Creating new folders.
- Delegating and removing access rights to public folders.
- Use of public folders.
- Program customization (customizing Outlook Today, toolbars, application panel, folder organization).
- Effective work with folders (creating folders, working with multiple personal folders and their location and security, managing individual items in folders, sharing and delegating rights for individual folders, working with network folders, security of shared folders, compressing and password-protecting 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.
- Security of working in the program.
- Discussion.
- Conclusion.
Page 11
Word in Practice
Price incl. VAT
184.50 €
Current VAT 23%
Duration
Day: 1 day · Evening: 2 days · Weekend: 1 day
Course overview
Gain skills for everyday efficient work in Word. You will become familiar with tables, templates, print formats and images. Avoid the most common mistakes at work. In addition to working with text, we will teach you how to secure a created document containing sensitive data against unauthorized access. Experienced lecturers have prepared many practical tasks for you, through which you will master the covered program tool options and will thus be able to efficiently create effective and purposeful documents that you will not be ashamed of.
Minimum input knowledge
Standard computer operation and experience with Windows. Experience with Word such as writing, copying and deleting text, moving through a document, basics of document formatting and printing.
Output knowledge
You will be able to independently use the Word word processor, edit and create more complex and longer texts. You will gain an overview of style and template tools, be able to create tables, set document printing and secure a document against unauthorized access.
Training syllabus
Rules for Writing Text
- Paragraphs and their use, inserting and removing blank lines
Document Formatting
- Font, paragraphs, tabs and indents, borders and shading, bullets and numbering, page format
Styles and Their Use
- Automatically saved formats, editing styles, creating a custom style, outline levels, replacing direct formatting with styles
Working with Templates
- Customizing properties, creating a template, changing the document template
Working with Tables in Word
- Table design, editing table range and format, inserting formulas into a table, automatic table format
Basics of Mail Merge
- Using the wizard, form letters, address labels, query definition
Cooperation between Word and Excel
- Linking documents from Excel to Word, update options
Printing a Document
- Settings before printing, creating document header and footer, page numbering
Price incl. VAT
526.44 €
Current VAT 23%
Duration
Day: 4 days · Evening: 6 days · Weekend: 3 days
Course overview
The MS Office in Practice course is intended for moderately advanced users who want to deepen their skills when working in the Windows and Microsoft Office environment. The package includes the courses: MS Word in Practice, 1 day; MS Excel in Practice, 1 day; MS PowerPoint in Practice, 1 day; MS Outlook in Practice, 1 day.
Minimum input knowledge
It is assumed that participants already have basic experience with computer work and in the MS Office environment.
Output knowledge
The MS Office in Practice course - promotional package - will make it easier for you to master computer operation at the level of a standard user as well as an administrative worker. It provides practical skills for comprehensive use of Windows and the basic office applications of the Microsoft Office package in administration.
Training syllabus
Microsoft Word Practical Exercises
- Overview of functional options, operation of MS Word, opening a new document, saving to a folder, renaming
Rules for Writing Text in Word
- Inserting text, corrections; selecting text, tips and tricks in MS Word, automatic corrections
Text Formatting in Word
- Page layout, formatting using toolbar icons, font, paragraphs, tabs, bullets and numbering, print settings and printing documents
Microsoft Excel Practical Examples and Exercises
- Overview of functional options, tips and tricks in Excel
Cell Formatting
- Formatting using toolbar icons, automatic format)
Calculations in Tables
- Basics of working with a table as a data source, sorting data, selecting data using a filter, basic functions in MS Excel (sum, average, minimum, maximum)
Working with Multiple Worksheets and Workbooks
- Naming, renaming, referencing, loading and working with data from external sources
Charts - Chart Types in Microsoft Excel
- Creating charts, editing and formatting
Practical Exercises in Microsoft PowerPoint
- Description of the PowerPoint working environment, creating, opening and saving a presentation in MS PowerPoint, working with different presentation views
Creating a Presentation in MS PowerPoint
- Changing presentation appearance, working with templates and color schemes, manual formatting - advantages, disadvantages, creating, saving and using a custom 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 and charts, working with diagrams and imported graphics, OLE, DDE, updating links, using hyperlinks, animations and transition effects in PowerPoint, working with data stored in another presentation or in MS Word, arranging a presentation in outline form, flowcharts, organizational charts, WordArt, creating notes and handout pages, discussion, conclusion
Options and Use of Microsoft Outlook
Microsoft Outlook Electronic Mail
- Receiving, displaying and printing new messages, replying to a message, forwarding a message, working with attachments, message format, inserting signatures, setting rules for sending messages, sorting received mail
MS Outlook Address Book
- Display, description of possible address books, searching, creating new records and distribution lists, contacts (inserting, editing, customizing the Contacts folder, using a visitcard)
MS Outlook Calendar
- Planning, displaying meetings, event reminders
Tasks in MS Outlook
- Entering, editing, checking, assigning, deleting
Notes
- Working with the MS Outlook Journal, working with notes, discussion, conclusion
Page 13
MS Office II. - Key Skills
Price incl. VAT
745.50 €
Current VAT 23%
Duration
Day: 5 days · Evening: 10 days · Weekend: 5 days
Course overview
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.
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.
Training syllabus
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
Price incl. VAT
1 246.00 €
Current VAT 23%
Duration
Day: 8 days · Evening: 16 days · Weekend: 8 days
Course overview
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.
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.
Training syllabus
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
Page 15
MS Office II. Professional
Price incl. VAT
726.19 €
Current VAT 23%
Duration
Day: 5 days · Evening: 10 days · Weekend: 5 days
Course overview
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.
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.
Training syllabus
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