Germany - Type of contract: Service Title of the contract: IM - Microsoft Offic

Description

Type of contract:
Service

Title of the contract:
IM - Microsoft Office Specialist Word 2019 and Excel 2019 - Berlin

Short Description:
Microsoft Office Specialist - Excel 2019

Participants\/inside learn how to use the basic functions of MS Excel professionally and acquire the Microsoft Office Specialist certificate for MS Excel by successfully passing the exam.

Contents of the course include

Managing a worksheet environment
- Setting up and customizing a work environment
- Navigating in a worksheet
- Printing worksheets and workbooks
- Sharing data with other users
- Sharing spreadsheets and data
- Managing comments

Entering and formatting cell data and worksheets
- Entering content
- Applying auto-fill functions
- Editing hyperlinks
- Creating, applying and changing cell formats
- Merging and splitting cells
- Creating and editing row and column titles
- Hiding and showing rows and columns
- Creating, formatting and managing worksheets and workbooks
- Editing page settings for worksheets
- Editing the view options of windows and workbooks

Applying formulas and functions
- Creating and editing formulas
- Applying and editing cell ranges in formulas
- Working with cell references in formulas
- Applying conditional logic in a formula
- Assigning names in ranges and formulas

Visualizing data
- Creating diagrams
- Working with sparklines (miniaturized diagrams)
- Working with illustrations and objects
- Creating and modifying images with the image editor

Analyzing and organizing data
- Filtering data
- Sorting data
- Applying conditional formatting

Microsoft Office Specialist - Word 2019

Participants\/inside learn how to use the basic functions of MS Word professionally and acquire the Microsoft Office Specialist certificate for MS Word by successfully passing the exam.

Contents of the course include

Release and document management
- Use of different views
- Use of templates
- Managing the document version
- Saving and protecting documents
- Sharing documents

Formatting content
- Font and paragraph attributes
- Indents and paragraphs - Formatting
- Navigating and searching a document
- Creating and editing tables

Applying page layouts
- Applying and editing page settings
- Creating content in a document, e.g. with quick blocks
- Applying design, creating and editing page backgrounds
- Creating and editing headers and footers

Incorporating illustrations and graphics
- Inserting and formatting images
- Transferring and editing text fields
- Inserting and editing ClipArt formats
- WordArt and SmartArt

Proofreading documents
- Checking content using the spelling and grammar checker
- Inserting and changing comments
- Configuring with autocorrect settings

Using references and hyperlinks
- Inserting a table of contents
- Creating endnotes and footnotes
- Using hyperlinks

Mail merge functions
- Creating and customizing mail merge
- Execute mail merge
Framework agreement for 3 years with the option to extend by 1 year in accordance with Section 15 (4) UVgO or Section 21 (6) VgV in conjunction with Section 65 (2) VgV.

Opportunity closing date

03 December 2024

Value of contract

to be confirmed