Office with Word and Excel

Free of cost

by funding

The course teaches word processing with Word and important basics of spreadsheets with Excel. The course is rounded off by the administration of secretarial tasks in the area of office organization. You will learn how artificial intelligence is used in the workplace.
  • Certificates: Microsoft Word" certificate
    Microsoft Excel" certificate
    Certificate "Office organization"
    "Driving license for digital competence" certificate
  • Examination: Practical project work with final presentation
    Module examination Microsoft Word
    Module examination Microsoft Excel
    Driving license for digital competence
  • Teaching Times: Full-time / Part-time
    Full-time: Monday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.). Part-time: Monday to Friday from 8:30 a.m. to 11:45 a.m. (in weeks with public holidays from 8:30 a.m. to 12:35 p.m.).
  • Language of Instruction: German
  • Duration: 7 Weeks full-time / 14 Weeks part-time

Word processing with Microsoft Word

Word processing with Word (full-time 5 days/part-time 10 days)

Basics of text input and processing

Character, paragraph, page and document formatting

Using format templates

Using tables, graphics and shapes

Saving, printing and protecting documents

Creating form letters

Editing and correction functions

Designing page layouts and multi-page documents

Spreadsheet calculation with Microsoft Excel

Spreadsheet calculation with Excel (full-time 10 days/part-time 20 days)

Basics of table editing

Working with formulas and functions

Formatting cells, editing and printing tables

Filling, moving and copying

Calculating with date and time

Creating and editing diagrams

Using individual print settings

Manage workbooks

Using chart templates and chart layouts

Using Excel templates

Sorting and filtering data

Office organization

Office working environment (full-time approx. 4 days/part-time approx. 8 days)

Workplace organization

Video conferencing

Preparing presentations

Time and self-management

Setting priorities

Mail processing


Organization of appointments (full-time approx. 3 days/part-time approx. 6 days)

Planning appointments and meetings with MS Outlook

Event planning

Planning business trips


Artificial intelligence (AI) in the work process

Presentation of specific AI technologies

and possible applications in the professional environment


Business management basics for office professions (full-time approx. 5 days/part-time approx. 10 days)

Fundamentals of business management

Company forms, goals, management

Organizational structure in companies/organizational charts

Management styles and techniques

Agendas/protocols

Fundamentals of accounting

Offer and order management


Project work (full-time approx. 3 days/part-time approx. 6 days)

To consolidate the content learned

Presentation of the project results


Digital office (full-time approx. 3.5 days/part-time approx. 7 days)

Modern letter style

Commercial correspondence

DIN 5008

Preparation of telephone calls

Template design, form letters

Document management - digital and analog

Data protection, laws

Digitalization/digital transformation and working world 4.0

Phishing emails and spam filters

Email, voice messages, messenger services

Using search engines and applying filters

Online banking, online orders

File sharing - synchronizing, sharing and accessing files

Creating and changing passwords securely (two-factor authentication)


Practical project work and exam: Driving license for digital competence (full-time approx. 1.5 days/part-time approx. 3 days)



Changes are possible. The course content is updated regularly.

You work routinely with the word processing program Word and can use it to create everyday letters and documents.

You will also understand the concept of spreadsheets and master the use of Excel quickly and confidently in order to achieve optimal and accurate work results.

You are also familiar with office administration, have sound cross-sector knowledge of the professional workflow of an office and are proficient in modern communication techniques. You will be able to take on administrative and organizational tasks in the secretariat and administration and complete commercial work orders independently. In addition, this course will provide you with a meaningful proof of your current knowledge of digital office work in the form of a "digital competence driver's license".

The course is aimed at anyone who would like to acquire or refresh their knowledge of administrative or organizational office processes.

Knowledge in the use of various MS Office programs is a prerequisite for successful and efficient work in professional life.

Your new skills will open up numerous new opportunities in the job market: typical commercial, administrative and organizational activities in secretariats and administrative offices are in demand in companies in almost all sectors of the economy.

Your meaningful certificate provides a detailed insight into the qualifications you have acquired and improves your career prospects.

Didactic concept

Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).

You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.

 

Virtual classroom alfaview®

Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face lessons via video technology.

 

The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).

We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm
free of charge from all German networks.
Contact
We will gladly advise you free of charge. 0800 3456-500 Mon. - Fri. from 8 am to 5 pm free of charge from all German networks.