Excel course: Organize your your daily office routine

Language: German

Excel training for more efficiency in the office: calendar, organization chart & Co

Training for more efficiency in everyday office life: customize Excel with color markers and helpful functions. Create a calendar that reminds you of appointments and displays calendar weeks. Calculate working times, create an intelligent organization chart and receive numerous tips and tricks for working with tables and workbooks. All this and more - in a 3-hour Excel training course from René Fürst.

Three-hour Excel training: How to use Excel functions for more efficiency in the office
Customize Excel: use colored spreadsheets & grids, create chart templates, remove metadata, fix columns and rows
Excel calendar: create an annual calendar, calculate the calendar week and a date in the future, display appointments
Office organization: calculate working hours, create intelligent organization charts, PDF export, add an interactive search function, create help texts for cells

Make your job even easier with Excel! After this Excel training course, you will be able to use the program even more extensively and effectively - for example, for coordinating appointments or invoicing.

Details

Usable with:
content: 3 h Video training
Licence: private and commercial Rights of use
Bonus: including working material

Intro" means the same in both German and English. It is a common term used to introduce or begin something.

free of charge

Excel training for more efficiency in the office: Calendar, organization chart & Co - 1 intro

Welcome to an Excel training course that will simply make you more efficient in the office.

download project file

Work individually and efficiently.

Excel training for more efficiency in the office: calendar, organization chart & co - 2.1 Start Excel differently

Use of various options when starting Excel to set Excel directly to different modes

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.2 User-defined views

Create individual views and call them up easily via quick access

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.3 Using colored gridlines

Optical adjustments to the grids

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.4 Highlight worksheets in color

Customize the color of the worksheets

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.5 Fixing columns and rows

Fix columns and rows sensibly

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.6 Reusable chart templates

Create a diagram template that can be used again and again

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.7 Prevent automatic hyperlinks

Prevent automatic links to websites and emails

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.8 Metadata in Office files

Personal information is often attached to a file without being asked. However, we can remove these again.

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.9 Increase the number of backward steps

When working with Excel, you often undo numerous work steps after incorrect attempts. Excel normally only remembers the last 16 steps.

Excel training for more efficiency in the office: Calendar, organization chart & Co - 2.10 Repairing a defective workbook

Different methods to repair defective Excel files with luck after all

Organization with the calendar

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.1 Flexible annual calendar

Annual calendar, which creates all days of the year starting on January 1 with marked weekends

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.2 Weekends in the calendar

Visually separate Saturdays and Sundays from normal weekdays

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.3 Remembering an anniversary

Whether it's the anniversary of a death or the birthday of your friends or stars - it never hurts to let them know when the time has come.

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.4 Working with calendar weeks

Calculate the calendar week of a date with Excel functions

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.5 calendar weeks with year

Create calendar weeks with year information and the correct display of the New Year

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.6 Calculating a future date

Calculating a date in the future, such as an invoice that is payable x days after receipt.

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.7 Calculating a future date with special times

Calculate time to a future date without public holidays and weekends

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.8 Color-coding appointments

Have appointments that are approaching or have passed highlighted in color with conditional formatting.

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.9 Create Excel calendar with working days only

Generate an automated list of consecutive dates with the exception of weekends

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.10 Convert hours into minutes

Various methods for repairing Excel workbooks

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.11 Calculate negative hours and minutes correctly

Automatic hyperlinks in Excel are often annoying. Learn how we can prevent them and remove them afterwards.

Excel training for more efficiency in the office: Calendar, organization chart & Co - 3.12 Useful birthday list

Various methods for highlighting birthdays from birthday lists

Organization made easy.

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.1 Adding hours correctly to record working time

Avoid mistakes when adding up working times with Excel

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.2 Working time with industry time

Instead of minutes, we use fractions of an hour

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.3 Create organization chart with SmartArt

Create beautiful organization charts with common SmartArt

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.4 Create an intelligent organization chart without Smart Art

Learn to create intelligent organizational charts with calculation methods without SmartArt

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.5 Images in tables

Enhancing tables with images

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.6 Save workbooks to PDF

Various methods for exporting the contents of a workbook as a PDF

Excel training for more efficiency in the office: calendar, organization chart & co - 4.7 Crossing out, superscripting and subscripting texts

It is also possible to cross out, superscript and subscript text with Excel

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.8 Swap columns and rows of a table with the transpose function

Swap horizontal and vertical table headings including content

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.9 Sorting and filtering the table

Long content can be easily sorted and filtered in Excel

Excel training for more efficiency in the office: calendar, organization chart & co - 4.10 Integrating Excel tables into Word documents

Embedding an Excel table in a Word document

Excel training for more efficiency in the office: Calendar, organization chart & Co - 4.11 Inserting an interactive search field into the worksheet

In large tables, the search function is the most important tool for quickly finding specific cells. Equip the table with an interactive search function.

Tips and tricks for efficient organizing

Excel training for more efficiency in the office: Calendar, organization chart & Co - 5.1 Use autocorrect helpfully

Create autocorrect values yourself

Excel training for more efficiency in the office: Calendar, organization chart & Co - 5.2 Help texts for cells

Help text for certain cells helps the user

Excel training for more efficiency in the office: calendar, organization chart & co - 5.3 Working with the "Excel camera"

Linking technique in Excel workbooks

Excel training for more efficiency in the office: Calendar, organization chart & Co - 5.4 Hide rows and columns

For the sake of clarity, it can be useful to hide columns and rows

Excel training for more efficiency in the office: Calendar, organization chart & Co - 5.5 Double values

Different methods for evaluating duplicate values in a table

Details of the content

Excel training for better organization with calendar, organization chart ...
Go beyond the basic functions of Microsoft Excel - and you'll see how the program makes your everyday office life easier with every step you take. We'll explain what you can expect in this Excel training course from René Fürst :

Overview of the training content

In three hours and 39 lessons, the Excel training course offers you numerous in-depth tips and tricks for using the software. The focus is on functions and procedures that are particularly useful for your daily work in the office. A few selected highlights from your Excel training:

Remove personal data stored in the background before sending Excel files.
Create an Excel calendar in which the weekends are highlighted in color.
Use the calendar to display calendar weeks and important dates.
Calculate a date in the future, for example when an invoice is due.
Create informative organization charts with and without SmartArt.
See ways to repair Excel spreadsheets and workbooks.
Increase the number of work steps that you can undo.
Provide your cells with help text for other people.
Calculate working times with a target-oriented method.

Tips and tricks for working efficiently with Excel

The content already mentioned is peppered with further helpful tips for working with Excel. Did you know that you can start the program in different modes, customize your views or highlight worksheets and grids in different colors? - Customize Excel to your needs and get a better overview at all times!

You will also learn how to create templates for charts that you need again and again, how to fix or hide columns and rows and how to link workbooks. You will embed Excel tables in Word documents (ideal for creating invoices) and swap horizontal and vertical table headings in just a few steps. After the Excel training, you will save a lot of time in organizing your everyday office life thanks to the methods you have learned.