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:
The participants\/inside learn 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

Manage 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 the 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
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

17 October 2024

Value of contract

to be confirmed