MS Office - Training

(includes: Word, Excel, Outlook)

 

 

Why is this training very special?

 

The new version of Office XP looks ripped but not old fashioned. The changed outfit works very well with the style of Windows XP but even in connection with the other Windows versions. The users can work with the XP version more efficient because of the well working features for formation and searching of text and files.

 

The qualification for MS Office will give to you the required knowledge on a high level. It will help you to work with the modules of MS office successfully. You will receive detailed knowledge about the functions, the organization and the handling of this product. You increase your know-how about successful methods and technologies using Word and EXCEL and MS Outlook. You will learn about tools which will support you while your daily business.

 

Use the chance of this offer and receive a certificate “Certified MS Office User” where we confirm that you have absolved this training with success.

 

We want to accompany you in MS Office training, to answer all your questions and we want to give you the requested know-how starting of the functions, hints and tips you will need to use MS Office as a manager.

 

Certificate

 

After absolving this training and an agreement of the trainer we will make out a certificate with the title “Certified MS Office User” with detailed information about the learned subjects. You will receive this certificate 2 weeks after finishing the training.

 

Your level of qualification will be tested each day. But don’t worry – we will not produce examination stress but our target is that you will be able to practice the learned subjects.

 

Seminar Organization

 

Generally we plan to organize the training location and the training schedule together with you. We are prepared for organizing the training at the location of your company or at an external location.

 

Location

Hotel / Company’s location

Seminar Date

According to our agreement

Seminar Duration

3 days

Seminar Language

English or German or Romanian

Seminar Price (individual)

€ 1.500,- per Person. This price doesn’t include VAT.

Seminar Price (Groups, up 3)

€ 1.350,- per Person. This price doesn’t include VAT.

Seminar Price (Company)

According to our agreement, but exclusive accommodation and traveling costs of the trainer. This price doesn’t include VAT.

 

 

Hotel / Restaurant

In case that the seminar will be organized at a Hotel / Restaurant, the hotel costs (accommodation) and the restaurant costs (food and drinks) are  not included into the seminar price and have to be paid directly at the reception desk of the Hotel / Restaurant by the participants.

 


MS Office - Training : Contents

 

MS Word

Basics of WORD

·          Kind of views

·          New Document

·          Navigation within Word

·          Print out of Word documents

 

Formation of text

·          Format procedures

·          Format of paragraphs

·          Using of Tabs

·          Preparing of pages

 

Efficient working with Word

·          Grammatical checking

·          Search and replace

·          AutoText feature

·          Concept of format layouts

·          Document formats

·          Fine tuning

 

 

Special for text processing

·          Headers and footers

·          tables

·          Word separation

·          Field functions

·          File attributes

·          Searching for documents

 

Desktop Publishing

·          Building of columns

·          Using text fields

·          Embedding Graphic

 

Working with large documents

·          Headers

·          Table of contents

·          Footnotes

 

 

 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


MS EXCEL

Basics of EXCEL

·          The EXCEL Screen

·          Entering of figures, text and formulas

·          Specials knowledge about formulas

·          Printing of work-sheets

·          Graphs within EXCEL

 

Working on a work sheet

·          Shift and copy

·          Copying of formulas

·          Deletion of cells

·          Insert and delete of lines, row and cells

·          Setting of high and width of cells

·          Show and hide of cells

·          Working with named cells and areas

·          Quick-jump to defend cell addresses

·          views

 

Formation of cells

·          different kind of formats

·          user defined formation

·          formation of fonts

·          frames and background

·          protection of cells

·          conditional formation

 

Efficient working with EXCEL

·          function assistant

·          Formula pool

·          Statistically functions

 

·          Combine text and figures

 

Specials of EXCEL

·          Maps and work-sheets

·          3D and 4D relations

·          search and replace of values and contents of cells

·          Draw within a work sheet

·          Comments

·          Breakdown into categories

·          Controlling of formulas

·          Scenario manager

·          Target calculation

·          The solver

 

Databases and Reporting with EXCEL

·          Working with data

·          Sorting

·          Setting of filters

·          Working with sub totals

·          Comfortable entering of data

 

EXCEL functions

·          Mathematically functions

·          Logically functions

·          Date and time functions

 

 
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


MS Outlook

Basics of OUTLOOK

·          Object of Outlook

·          Creating and working with objects

·          Handling of folders

·          Five basic views

·          Selection of a view

·          Categorize of Outlook elements

 

Time schedule for profis

·          New schedule

·          Daily, weekly, monthly view

·          Schedule serial management

 

 

Contact – address book

·          Working with the contact form

·          Contact folder as central tool

 

Journals

·          Configuration of journals

·          Protocol of client contacts

·          Reporting

 

To-DO list

Notices