Course MS Office I. - Key Skills
The MS Office course is intended for all interested participants who want to acquire basic IT skills with the aim of fin...
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.
Course dates MS Office I. - Key Skills
Daily courses (7 days): 09:00 - 15:00
Course price: 637.40 / 784.00 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:
Training syllabus MS Office I. - Key Skills
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
Output knowledge
Mastery of key basic skills in the programs of the MS Office office package - Word, Excel and PowerPoint.
Recommended courses after completing MS Office I. - 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 I. - Key Skills
This course has no published reviews yet.
You can add a review after completing the course.