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

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

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

Create individual views and call them up easily via quick access

Optical adjustments to the grids

Customize the color of the worksheets

Fix columns and rows sensibly

Create a diagram template that can be used again and again

Prevent automatic links to websites and emails

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

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

Different methods to repair defective Excel files with luck after all

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

Visually separate Saturdays and Sundays from normal weekdays

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.

Calculate the calendar week of a date with Excel functions

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

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

Calculate time to a future date without public holidays and weekends

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

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

Various methods for repairing Excel workbooks

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

Various methods for highlighting birthdays from birthday lists

Avoid mistakes when adding up working times with Excel

Instead of minutes, we use fractions of an hour

Create beautiful organization charts with common SmartArt

Learn to create intelligent organizational charts with calculation methods without SmartArt

Enhancing tables with images

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

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

Swap horizontal and vertical table headings including content

Long content can be easily sorted and filtered in Excel

Embedding an Excel table in a Word document

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

Create autocorrect values yourself

Help text for certain cells helps the user

Linking technique in Excel workbooks

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

Different methods for evaluating duplicate values in a table