Excel Tabelle sortieren

Sort Excel spreadsheet automatically - this is how to do it!

Sort Excel spreadsheet automatically - this is how to do it!

The Excel spreadsheet programme – for example Microsoft Excel 2010 in Microsoft Office 365 – is incredibly versatile. The most important function is probably the creation of tables. But depending on the volume of data, this can quickly become quite confusing. To prevent this, it makes sense to let the programme sort the Excel table. There are various options available, which we will explain in more detail here.

Why should you sort an Excel table?

For a good analysis of data, it is necessary to be able to sort them in an Excel table. In Microsoft Excel 2010, various sorting options are available, such as sorting Excel rows or sorting Excel columns. A finer sorting of individual data is also possible. For example, data can be sorted by numbers, by date and time, by format or alphabetically in order to visually capture and understand data more quickly and to organise it effectively.

Sort Excel rows

If you want to sort an Excel table, you often start by sorting Excel rows. This can be done easily in just four steps:

  1. In an open Excel document, switch to the „Data“ tab and click on the „Sort“ button.
  2. A new window appears, select „Options“.
  3. Next, click on the option „Sort rows“ under „Alignment“ and then confirm with „OK“.
  4. Under „Column“, select a named column for sorting Excel rows and, if necessary, under „Order“, select which value is to be used for sorting the Excel table. Then press „OK“.

Sort Excel columns

  • First select the range you want Excel to sort.
  • You can now access the sort dialogue via the „Data – Sort“ tab.
  • In the „Sort“ dialogue box in Microsoft Excel 2010, select the option „Data“ in the „Sort and Filter“ group.
  • In the „Sort“ window click on „Options“, activate „Sort columns“ in the next dialogue box.
  • In the drop-down menu under „Row“ now select the row according to which Excel should sort columns and confirm with „OK“.

Sort Excel spreadsheet alphabetically

If, for example, you are dealing with staff or member lists, you can also sort an Excel table alphabetically to improve clarity. The following steps are necessary for this:

  • Select the table that Excel is to sort alphabetically. Do not mark the headings of the columns and rows!
  • Select the option „Sort“ in the „Data“ menu.
  • In the window, select the column that is to sort the Excel table and click on the corresponding option under „Order“.
  • Confirm with „OK“.

This is also possible: Move Excel table

Normally, Microsoft Excel 2010 takes over all data including formulas and values and formats when rows and columns are moved or copied. However, the cell reference is not adjusted in the case of a formula in the cell – an error message appears in the moved or copied cell. If this happens, the references must be re-entered manually. Otherwise, however, all columns and rows can be easily moved in an Excel table with the following steps. The simplest way:

  • First select the cell, row or column to be moved or copied.
  • Now select either „Cut“ or „Copy“ on the „Start“ tab. The key combinations „CTRL+X“ for cutting and „CTRL+C“ for copying are quicker.
  • Click with the right mouse button below or to the right of the new position of a cell or column.
  • To move, click on „Paste cut cells“.
  • To copy, click on „Paste copied cells“. The shortcut via the keys for this is „CTRL+V“.

Move the Excel table with the mouse

If you prefer to use the mouse to sort the Excel table, proceed as follows:

  • Select a column or row to move or copy
  • Move: Move the cursor to the edge of the selected rows or columns until it turns into a move pointer. Hold the mouse button and drag selected elements to the new position.
  • Copy: Hold down the CTRL key and move the cursor to the edge of the selection. When the copy pointer (white arrow) appears, drag the selection to the new position. It is essential to keep the CTRL key pressed!

Header image: © Yu_photo, stock.adobe.com

Outlook Mails sortieren

Sort Outlook mails automatically - this is how it works!

Sort Outlook mails automatically - this is how it works!

Office management without Outlook? Almost unthinkable! From receiving and sending e-mails to calendar management and tracking tasks to storing all contact data, the programme in Microsoft Office 365 on Windows 11 is a real jack-of-all-trades. But what many people don’t know: You can also sort mails with Outlook and move Outlook mails automatically.

Sort Outlook mails

In order not to lose the overview in the overflowing mailbox, you can sort Outlook mails by size, among other things, with Microsoft Outlook 2019. But also by sender name, read or unread messages, subject or date. If you want to sort Outlook mails by size, the procedure is very simple:

Sort Outlook mails by size

  • In the inbox, first click on „Filter“ in the upper area.
  • Now various options appear under „Sort by“, here select „Size“.

Sort Outlook mails by subject line

The programme also allows you to sort mails not only by size and other options, but also by certain keywords in the subject line. To do this, first create a subfolder in which every incoming mail containing this keyword in the subject line is automatically filed. The prerequisite for this is, of course, that the sender also knows and uses this keyword so that Microsoft Outlook 2019 recognises that it should sort this mail.

  • Click on the corresponding mail and select the „Start“ tab.
  • Next click on „Rules“, then select the option „Create rule“.
  • In the subsection „If an incoming message meets all conditions“ in the „Create rule“ dialogue box, activate „Subject contains“.
  • Enter the keyword in the corresponding text field.
  • Now go to the subsection „Execute the following“ and select the created and named subfolder under „Move item to folder“.
  • Press the „OK“ button and answer the control question with Yes.

Move Outlook mails automatically

With hundreds of mails arriving in a short period of time, confusion can quickly arise. A function of Microsoft Outlook 2019 as part of Microsoft Office 365 in Windows 11 helps to create clarity and order. This is the option to automatically move certain Outlook mails to previously created subfolders with the corresponding names.

  • First click on the e-mail folder with the right mouse button.
  • A context menu appears. Select the option „New folder“.
  • Each new folder must now be given its own name.

In order to be able to sort the individual Outlook mails so that they are automatically placed in the correct folders according to the specifications, a few rules have to be set:

Automatically move Outlook mails to folders

If, for example, you want to automatically move all Outlook mails from a certain sender into folders, first click on any mail from this sender.

  • Select the option „Rules“ on the „Start“ tab.
  • In the context menu that appears, select the option „Always move messages from (name)“.
  • Now just select the corresponding, previously named subfolder in the „Rules and Notifications“ dialogue box and click the OK button.

More tips

Time-shift sending: With Microsoft Outlook 2019, you can also send mails at a later time. To do this, select the „Options“ tab, go to the „Delay transmission“ button and select the date and time in the dialogue box. Then click on „Send“ as usual. Automatic forwarding: Before sending a mail, click on the „Options“ button and select „Reply directly to“. Then enter the desired recipient under „Forwarding functions“. The reply mail is now automatically sent to the selected recipient – for example, to a colleague if you are on holiday yourself. Recalling mails: If you have sent a mail by mistake, you can edit it with the „Actions“ button. After clicking on the corresponding mail, select the option „Recall this message“. Then select either „Delete unread copies of this message“ or „Replace unread copies with a new message“. Now the mail is deleted at the recipient’s or replaced by a corrected or extended mail. However, this only works if the recipient has not yet opened the original message.

Header image: © Leowolfert, stock.adobe.com

Setting up Windows Remote Desktop: quick and easy!

Setting up Windows Remote Desktop: quick and easy!

Setting up Remote Desktop – quick, easy and secure

To set up a Windows Remote Desktop, only a few simple steps are required. As this is a common method of remote access, it is also particularly secure. However, some requirements are placed on the PC that wants to provide or use this remote access. These include the fact that only certain Windows versions can be remotely controlled via remote desktop:

  • Windows 7: Professional, Enterprise and Ultimate
  • Windows 8: Professional and Enterprise
  • Windows 10: Pro and Enterprise

Microsoft specifies this restriction and therefore it cannot be eliminated by meeting other requirements. For example, a system running Windows 10 Home cannot be used for Remote Desktop.

Activate Remote Desktop

When setting up, it is necessary to first activate the Remote Desktop. Here we refer to the remotely controlled PC as the host PC. The computer using the remote desktop connection is the client. When setting up the Remote Desktop, the activation is done on the host PC. 1: Open the settings either manually or by shortcut [Windows]+[i]. 2: Select the „System“ button. 3: Navigate to „Remote Desktop“ via the menu and set the „Activate Remote Desktop“ switch to „On“. 4: The system displays a warning that must be confirmed. 5: With step 4, the activation is basically complete, as the default settings can usually be retained. If this is not the case, remote access does not work and they must be changed.

Set up cloud access via Windows Remote Desktop on PC

Those who do not want to access the cloud services via app, but via Microsoft Remote Desktop, must set up Remote Desktop. This RDP access takes place via the tools that Microsoft provides for Remote Desktop. It is important to have the necessary licences in advance and to have the access data to hand. 1: In order to be able to set up the Remote Desktop, an environment for remote access is necessary. This is provided by Windows as a remote desktop connection and must be started in the first step. 2: On the user interface that appears, enter the name of the computer and the individual user name. It is easiest to save the login information directly so that it does not have to be entered again and again. However, anyone using a shared PC should refrain from saving for security reasons. 3: Then select the local resources that are to be available for remote access. 4: In the last step, the remote desktop gateway server is stored. This step completes the process and the remote connection can be established. If necessary, the system will ask for the access data again to confirm their correctness, despite previous saving.

Setting up the RDP Client

To use the Windows Remote Desktop, it is necessary to set up the RDP client. Only after successful setup is it possible to connect to the virtual application server. 1: First start the Remote Desktop Client via Microsoft Start. 2: Then the manual configuration is carried out in order to be able to set up the Remote Desktop. This involves making the settings for the Remote Desktop gateway server. 3: Subsequently, it is necessary to start the Remote Desktop Connection in order to connect to the server. When setting up the remote desktop, the name of the target server is also specified. The user name of the terminal server user must also be stored. 4: In the last step, the user is asked again for the login data, which can alternatively be saved. If the user name and password are correct, the Remote Desktop connects. Important: In order to be able to set up the Remote Desktop and establish a connection to the Windows Server 2022 Datacenter, for example, at least the Windows 7 operating system is required. However, it is better to use a newer version such as Windows 8.1 or Windows 10.

Header Image: © Pixels Hunter, stock.adobe.com

Windows Server installieren

Installing Windows Server - it's quick and easy!

Installing Windows Server - it's quick and easy!

Windows Server installation – the preparation

Before you can install the Windows Server, you must ensure that the most important system requirements are met. In addition, the device drivers should be updated so that the installation of, for example, Windows Server 2022 is possible without complications. These two steps serve as preparation for installing the Windows Server and should be followed regardless of the respective Windows Server versions.

System requirements

The system requirements for the new Windows Server are primarily directed at the hardware components. They include the following points:

  • 64-bit processor with 1.4 GHz.
  • Compatible with x64 instruction set.
  • 512 MB or 2 GB, respectively, should the installation option „desktop display“ be selected.
  • ECC (Error Correcting Code) type or equivalent for physical host provisioning.
  • Support for NX and DEP.
  • CMPXCHG16b, LAHF/SAHF and PrefetchW supported.
  • Second Level Address Translation (EPT or NPT) support.

Important: Regardless of the system requirements, the necessary Windows Server CALs should be available. Only then can the new version of the Win Server be used as desired.

Update device drivers

If all system requirements are met, it makes sense to update the device drivers. By installing the latest drivers, you can ensure that they work properly with the current server.

Windows Server – Installation and Configuration

The installation of the new Windows Server works in the familiar way: It is delivered with the Windows Installer and can then be installed in two ways. Those who are familiar with the command line can use it for the installation, otherwise a GUI is available. After successful installation, the user finds himself on the desktop, which directly integrates the Microsoft Edge browser. The desired configurations can be made via the Server Manager, whereby the developers have hardly changed the interface. The Windows Admin Center, on the other hand, has been updated and looks more modern and appealing. All in all, both the installation and the configuration work as in previous years. This means that it remains easy to use for most administrators.

More security with Windows Server 2022

While there are some functional innovations in the new Windows Server version – the focus is on the significantly increased security level.

  • Multi-layered Secured Core security features provide increased protection against modern cyber attack threats. These functionalities extend across the operating system, firmware and hardware: a plus point that quickly makes itself felt in the company.
  • Preventive defence mechanisms help companies protect their sensitive information. In doing so, they detect advanced malware at an early stage and ward it off, which could otherwise manipulate the system.
  • Advanced Threat Protection helps detect and stop data leaks, network attacks and zero-day vulnerabilities.
  • Windows Defender Exploit Guard prevents intrusion attempts that target the host.
  • Virtualisation-based security prevents attackers from introducing malware should they wish to exploit a vulnerability in the operating system.
  • End-to-end encryption ensures that data is secure on untrusted networks

What to do after the Windows Server installation

In order for the new server to function properly, the most important points should be observed after the installation. This includes, for example, installing the latest updates provided by Microsoft’s update server. The group policies must also be set and the range of functions adjusted as desired. In addition, the following steps are important.

  1. Load and optimise workload templates: Those who choose to use templates should optimise them afterwards. Since they are designed to be used in a wide variety of companies, they are sure to differ from the actual requirements of the company.
  2. Set settings for virtualisation in the BIOS: These settings should always be checked separately. Especially if the server is to run Hyper-V, the most important adjustments must be made.
  3. Update drivers: Missing drivers for different devices may need to be installed. On the other hand, those that are not up to date must be updated in order to work best with the current server.
  4. Update firmware: In addition to the drivers, the firmware version must also be updated.
  5. Check product key and activation: The product key is not always activated automatically during installation. Therefore, it is important to check whether the activation was successful. If this is not the case, it must be deposited again in order to be able to use the full range of functions.

Header image: © rvlsoft, stock.adobe.com

PowerPoint Design

PowerPoint design for a perfect presentation

PowerPoint design for a perfect presentation

For a good and impressive presentation at university, at a meeting in the office or in the course of a product launch , the Microsoft# PowerPoint the leading tool. In cooperation with Microsoft Word in the complete package Microsoft Office 365 the presentation programme is ace! We explain how to easily create a PowerPoint template, how to use the PowerPoint design templates and how to realise your own PowerPoint design ideas.

Create PowerPoint template

Once you have familiarised yourself with Microsoft PowerPoint 2020 from Microsoft Office 365, you can easily create your own PowerPoint template. To do this, you can either use one of the numerous PowerPoint design templates, which you can then modify according to your own wishes. Or you can start with a „blank sheet of paper“. First, however, you should decide whether the presentation is to appear in portrait or landscape format. Accordingly, open a blank presentation in the appropriate formatunder „File“ and then under „New“. In the next step, switch to the„View“tab . Click onthe „SlideMaster“ icon in the „Master Views group on the quick launch bar . This automatically creates a basic slide with the corresponding settings. An overview of all slide types can be found on the left side of the screen in the presentation template. If you select there, for example in Microsoft Office 365 on Windows 11 to select one of the PowerPoint design templates, you can adapt it to your own wishes and ideas at any time. For a better overview, design templates that are not needed can simply be deleted with the right mouse button. Suitable tools for creating a PowerPoint template can be found in the tab at the top of the screen. If you have selected the quick starter bar, you can select suitable elements, special effects and animations directly.

PowerPoint Design Templates

Especially when starting to create PowerPoint design templates, it can be helpful to work with the default PowerPoint design ideas in Microsoft PowerPoint 2020. These can be changed at any time. And that’s a good thing, because the background in particular often doesn’t match your own needs or corporate identity To change the background (as well as all other elements in the PowerPont design), first open the „Slide master“ tab in the slide master view. In the subgroups „Background“ and „Edit design“, you will find numerous tools to adjust all elements in the PowerPoint design. From this point in the editing process, ready-made PowerPoint designs, effects, fonts, colour palettes, etc. can be incorporated. With a little practice, you can combine and redesign numerous PowerPoint design templates, but also realise your own effective PowerPoint design ideas.

Special effects for your own PowerPoint design ideas

In principle, the motto „less is more“ applies to a presentation with PowerPoint design. You should therefore not use too many colours and effects so that the audience is not confused and distracted. However, some special effects can capture the attention and make the presentation with Windows 11 and Microsoft PowerPoint 2020 much more interesting Examples of input effects that become active when the slide is opened:

  • Appearance: After a few seconds or after a key click, objects such as images or blocks of text appear.
  • Fly in: Objects fly in from a predefined direction to a specific place on the slide, increasing in size.
  • Split: Here, two halves of an element first appear on the left and right of the slide, which are then joined together at a predefined position to form a whole.
  • Wheel: From a central point, an image, block of text or symbol becomes visible after it initially rotates around its own axis at a slower pace
  • Zoom: In this effect, an element is slowly zoomed in from a small point.
  • Jump: Selected elements and/or objects jump into view from the top left corner of the slide.

These and even more special effects also serve as output effects. This means that the objects or elements animated in this way can disappear from the screen or slide just as they appeared.

Header image: © monticellllo, stock.adobe.com

Windows 11 Installation

Windows 11 installation already possible!

Windows 11 installation already possible!

Prepare the system

For the installation to be Windows 11 Installation is possible, the PC must fulfil a number of requirements. Ideally, the system is prepared in advance to avoiddifficulties later on. Step 1: Microsoft has noticeably tightened the hardware requirements. They should therefore be checked before installation. This works either by checking individual components or with the help of the official Microsoft tool PC Health Check. Step 2: If you want to install Windows 11, you should first install all updates. Ideally, both for the hardware components and for the software used. Step 3: Before the upcoming update, it makes sense to clean up the system. Although Windows 10 does much of the work, unnecessary programmes can be a potential source of errors during the upgrade. Step 4: The most important step from a major upgrade is aback-up. If something goes wrong during the Windows 11 installation despite all the preparatory work, the back-up can be restored.

Windows 11 installation is already that easy!

The Windows 11 installation will be available for Windows Insiders long before 5 October 2021. For all others, delivery will be staggered. Those who have prepared their system and decided to install itonlyneed afew steps to be able to use the new operating system. However, it is important that the hardware requirements are met so that the Windows 11 installation can succeed. 1. Go to the „Updates and Security“ section in the Windows settings and click on the „Windows Insider Programme“ entry. 2. Log in with your personal Microsoft account. 3. Select the „Release Preview Channel“, whereby a subsequent restart is necessary. 4. After waiting a moment, the update for the Windows 11 installation appears under „Update and Security“. 5. After the installation, switch to the „Windows Insider Programme“ again and click on „Stop receiving pre-release versions“. This will install only the regular Windows 11 updates in the future.

How is Windows 11 better than Windows 10?

Since Windows 10 is considered solid and stable, many users struggle with the decision: is it really worth installing Windows 11 early? It is a big step, as Microsoft shines with anew Windows 11 design and has implemented operating innovations. However, Win 11 is not only visually more modern – it also integrates numerous improvements.

  • Optics: Those who opt for Windows 11 will benefit from a modern modern user interface. On the one hand, these new visual aspects are intended to look more attractive, but on the other hand they are increasingly designed for user-friendliness.
  • Innovations: Numerous changes in the code have eliminated old burdens The new Windows 11 installation also includes the innovations already integrated in Windows 10 21H1 and goes a step further technically technically one step further.
  • Speed: The operating system has become faster, whereby the better performance is also related to the high demands on the hardware components hardware components.
  • Autostarts: Programmes that are run via autostart can be annoying and affect performance. Therefore, the new Windows version actively warns the user should this be the case.
  • App Store: The new app store has been modernised and allows Android apps to run.
  • Context menu: The new context menu appears airier and more manageable and has been noticeably adapted in terms of user-friendliness.
  • Copy paths: Anyone who regularly copies paths will benefit from the simple copy functionwhich replaces annoying intermediate steps.
  • Multi-window management: The management of multiple windows has been significantly improved and facilitates the use of different software instances.
  • Windows Terminal: The Windows Terminal is finally included in the operating system, combining the command line, PowerShell as well as the Azure Cloud Shell. The simplifies handling.
  • Animations: The new animations are closely related to the visuals – they look more impressive, sophisticated and fun to use.
  • Settings app: The Settings app has also been revamped and now uses its full potential. The app itself has been polished and is more functional.
  • Sound Dialogue: The new sound dialogue of the Windows 11 installation makes it easier to adjust the volume and screen brightness.

How long will Windows 10 be supported?

Those who do not yet want to or cannot switch to Win 11 currently have the option of continuing to use Windows 10. Microsoft will officially support the operating system until 2025. This means that incompatible PCs still have four years until the switch is finally necessary.

Header image: © monticellllo, stock.adobe.com

Edit formulas in Excel - easily and without a mouse

Edit formulas in Excel - easily and without a mouse

Microsoft Excel 2010 is one of the most used tools in Microsoft Office 365 for a reason. The spreadsheet program makes it possible to compile formulas in Excel, open up and display data, define predefined concatenations, calculate totals and determine statistical values – simply by entering numbers! Our Excel tips and tricks show how this all works super simply.

First create formulas

To create formulas in Excel that are to carry out calculation tasks, only a few clicks are necessary:

  • First enter the equals sign (=) in the input line.
  • Now enter the combination of row and column of the cells from which values are to be calculated (for example A2-C8).
  • Alternatively, the individual cells can also be clicked.
  • The colon (:) now describes the cell range, while the semicolon (;) separates commands.
  • Clicking on the formula symbol (fx) opens a function menu for selection.

Excel tips and Excel tricks for performing arithmetic operations:

  • Microsoft Excel 2010 represents the basic arithmetic operations with the usual characters +, -, *, /.
  • The order of operations is automatically followed by Microsoft Excel 2010, for example, the dot-before-dash rule.
  • For a different order, simply place a round bracket (()).
  • Powers can be represented with the circumflex character (^)
  • The word „WURZEL()“ allows the square root to be calculated.
  • If the word „SUM()“ is entered, the numbers in the marked cells are added together or subtracted from each other.

Automatically copy formats and formulas in Excel

Copying an Excel formula or transferring it automatically without using the mouse is also child’s play. This is necessary, for example, if new data is to be entered below an existing list. However, formats and formulas must exist in at least three list lines before the new line so that the programme can copy the Excel formula. Then the new data initially corresponds to the copied data above it; formulas that are repeated in each line are automatically duplicated. Copy formulas in Excel: In the „Tools“ menu of Microsoft Excel 2010, first call up „Options“. A dialogue box appears in which the box „Extend list format and formulae“ is activated under „Options – Edit“. Now all formatting is automatically applied. If you do not want this, „Extend list format and formulas“ must be deactivated.

Move formulas: It is not only possible to copy formulas in Excel, but also to move them to another place in the document. The references of the cell in the formula are not adjusted. For example, if you move the formula of cells A2-C8 to D2-F8, the formula still refers to the original cells. In practice, this is helpful if, for example, only the result cell is to be placed in a different position, but the references in the formulae are not to be changed.

  • To do this, first enter the corresponding formula and confirm with „Enter“.
  • Now select the cell and choose the key combination „Ctrl + X“.
  • Next, select the cell in which the formula is to be inserted.
  • The key combination „Ctrl + V“ now creates the formula in the new field.

Tip: If the cursor is clicked on the green frame of a cell, a small hand is displayed. With this hand, the cell can now be dragged to any position.

Editing formulas in Excel without the mouse

Basically, the F2 key can be used to edit the contents of cells in edit mode. When pressed, the arrow keys on the keyboard move the contents of the cell or formula in the desired direction. In addition, Excel marks the cells that are addressed in a formula by highlighting them in colour. The references within a formula are also marked so that errors can be found quickly and at a glance. Tip: The following Excel trick helps so that you don’t have to jump into a cell with F2 every time to check its formula content: Under „Formulas“, select the sub-function „Show formulas“. This will cause the individual formulas themselves to appear in the cells instead of the results. With the arrow keys you can now easily jump back and forth between the cells. The Esc key ensures that the editing mode is then exited again.

Header image: © Araki Illustrations, stock.adobe.com

Vorteile Windows Server

The differences between Windows Server and Windows OS

The differences between Windows Server and Windows OS

The basis: similar code

What are the advantages of Windows Server? Windows OS and the Windows Server have numerous differences. Nevertheless, they have a common basis: the source code. This serves as a kind of agreement through which it is possible to switch back and forth between the Windows OS and the Windows Server. Since both have the same task view, desktop and start buttons, it can sometimes be difficult to tell them apart. The similar code also helps to make it possible to use the same kernel on both, i.e. the central part of the operating system, as well as the same software. However, in order to access the Windows server, so-called Windows Server CALs are needed to access the Windows server. Only if they are available in sufficient numbers can a network connection be established. For users, the advantages of the Windows server are not least that preferred applications such as Microsoft Office or Google Chrome can be used on both.

The advantages of Windows Server

The advantages of a Windows Server are obvious for many companies, which is why they regularly opt for a new version of the product. Although it is not necessary to always run the latest edition, it should be considered as soon as major changes are imminent that will take the company further. The latest version of Windows Server stands for more security and a fundamental modernisation of the infrastructure, which is why the investment pays off in most cases:

  • The new platform supports a hybrid IT environment and is equally flexible, scalable and ready for the cloud.
  • Companies can choose a so-called Azure Edition so that they receive a direct connection to the Microsoft Azure data centre. This means that investments already made can continue to be used.
  • A better network connection, additional virtual machines and a revamped admin interface increase the efficiency of administration and make the data centre’s work easier.
  • The combination of a local infrastructure and the cloud resources used is favoured by optimised server management.
  • The modern server version also shows that the advantages of Windows Server focus strongly on containerised applications. This increases performance while simplifying development and deployment.
  • Remote access for external employees, employees in the home office or remote workers is noticeably simplified. Since data and applications are available at any time and from any location, comfortable and productive work is possible.
  • Another advantage of Windows Server is the increased and multi-layered security functions. They simplify protection against cyber attacks and protect sensitive company data as well as the apps.

Management software specifically for businesses

The Windows server is mainly used in companies, where it is used to run numerous services over a specific network. For simple offices or schools, on the other hand, a normal Windows OS is sufficient for day-to-day tasks in most cases. For this reason, the management software is specially tailored to the needs of companies and allows them comprehensive administrative control: from applications to data storage to the company network.

Fewer hardware restrictions

The new server from Microsoft makes it easier to connect additional hardware components to the existing system. In most cases, the appropriate software is offered directly for new end devices such as a printer. The same applies to other parts of the hardware, for example an extension of the existing memory.

Only relevant functions

Since Windows Server 2022 is aimed at different companies, it contains a wide range of functions. This includes all central aspects that are important in the daily workflow. Of course, not all functions have to be used: Instead, the company has a set of tools at hand with which the individual departments can be supported.


Companies benefit from the numerous advantages that the new Windows Server offers them. While most functions have been fundamentally improved, new approaches can also be found in the latest edition. These include, among other things, the focus on security. This makes the new Windows Server an important companion especially for companies that would like to use cloud computing. Private users, on the other hand, usually manage without the high range of functions – for them, the desktop version is usually sufficient.

Header image: © dennizn, stock.adobe.com

Remote Work

Remote Work: Der neue Arbeitsplatz

Remote Work: Der neue Arbeitsplatz

Das ist Remote Work

Mobiles Arbeiten, auch Remote Work genannt, ist keine neue Erscheinung: Es handelt sich dabei um eine Form des ortsunabhängigen Arbeitens. Beim Remote Working können Mitarbeiter einen festen Arbeitsplatz haben, sind jedoch nicht dazu gezwungen. Sie können also genau so gut im Park, in einem Café oder einem Co-Working-Space ihre tägliche Arbeit verrichten. Arbeitnehmer benötigen demnach nicht länger einen festen Schreibtisch im Unternehmen, sondern können an jedem beliebigen Ort des Landes oder gar der Welt arbeiten. Das einzig Wichtige: Das Ergebnis der Arbeit muss stimmen. Von wo aus diese Pflicht erfüllt wird, spielt hingegen eine untergeordnete Rolle.

Dieser Ansatz macht mobiles Arbeiten besonders attraktiv, da es die Vorteile des Homeoffice für Angestellte ausschöpft und mitunter erweitert. Das Modell ist sicherer als die Tätigkeit als Freelancer: Während Freiberufler mitunter lange Pausen zwischen Aufträgen und Projekten verbuchen müssen, besteht bei Remote Work ein normales Anstellungsverhältnis. Dennoch ermöglicht dieser Schritt den Angestellten ein freies und selbstbestimmtes Arbeiten. In Zeiten, in denen eine Homeoffice Pflicht vorangetrieben werden könnte, lassen sich auf diese Weise die wichtigsten Fachkenntnisse aus unterschiedlichsten Regionen in die Firma einbringen.

Übrigens: Damit mobiles Arbeiten funktionieren kann, dürfen die rasanten technischen Entwicklungen nicht vernachlässigt werden. Nur wer über ausreichend Bandbreite, leistungsfähige Endgeräte und weitere Tools wie einen Windows Remote Desktop und Windows Server 2022 CALs verfügt, kann die gewünschte Leistung erbringen.


Die Unterschiede zwischen Remote Work und Homeoffice

Obwohl Remote Work und Homeoffice auf den ersten Blick sehr ähnlich wirken, handelt es sich dabei nicht um dasselbe. Der deutsche Begriff für Homeoffice ist Telearbeit und setzt voraus, dass Mitarbeitende von zu Hause aus arbeiten. Damit genießt der Arbeitnehmer zwar Vorteile im Homeoffice, kann jedoch nicht sämtliche Vorteile von Remote Work für sich nutzen.

Im Rahmen vom allgemeinen Homeoffice oder einer Homeoffice Pflicht für Mitarbeiter stellt der Arbeitgeber die benötigten Arbeitsmaterialien: Dazu gehören beispielsweise ein Laptop, Windows 11, Bildschirme und zusätzliche Büroausstattung. Diese Notwendigkeit regelt die Arbeitsstättenverordnung. Allerdings lässt sich im Arbeitsvertrag genau regeln, welche finanziellen Teile der Arbeitgeber übernimmt und welche beim Arbeitnehmer verbleiben.

Bei Remote Work hingegen können Mitarbeitende von jedem beliebigen Ort aus arbeiten. Es besteht keine Bindung an das Büro zu Hause. Grundsätzlich müssen Arbeitgeber kein Equipment für diese Form des Arbeitens stellen, da es keine eindeutigen gesetzlichen Regelungen dazu gibt. Dennoch sollte der Arbeitgeber zumindest das notwendige Arbeitsequipment stellen, um ein vernünftiges und produktives Arbeiten zu ermöglichen.

Eine Gemeinsamkeit haben beide Arbeitsmodelle: Sowohl beim Homeoffice als auch bei Remote Work gelten das Arbeitszeit- und das Arbeitsschutzgesetz.

Das gehört zum Remote Work Arbeitsplatz

Die Vorteile von Remote Work sind sowohl die zeitlichen Freiheiten als auch die ortsunabhängige Wahl des Arbeitsplatzes. Doch: Ohne die richtigen Arbeitsutensilien und Tools funktionieren weder das Homeoffice noch mobiles Arbeiten.

Ein Windows Remote Desktop ermöglicht den Zugriff auf die interne IT-Infrastruktur und stellt sicher, dass die Daten in einer sicheren Umgebung erhoben, geändert oder gelesen werden können. Mit diesen Remote Desktop Services ist es möglich, die Anwendungen per Fernzugriff anzusteuern und von der Ferne aus vor Ort zu arbeiten. Das macht die täglichen Aufgaben einfacher und erlaubt eine höhere Produktivität unter den Mitarbeitern, die auf mobiles Arbeiten setzen.

Da die meisten Unternehmen mittlerweile digitaler aufgestellt sind, ist der Zugriff auf einen modernen Server wie den Windows Server 2022 selten ein Problem. Dabei gilt es, die richtigen Lizenzen zu wählen, die für den Zugriff auf einen solchen Server notwendig sind. Mit den richtigen Windows Server 2022 CALs kann beim Remote Work ein direkter Zugriff ermöglicht werden. Übrigens: Der neue Server von Windows eröffnet Firmen viele neue Möglichkeiten. Dazu gehören nicht nur zentrale Features, die den unternehmenseigenen Workflow unterstützen, sondern auch die besondere Effizienz im Rechenzentrum. Sie wird durch eine bessere Skalierbarkeit, Netzwerklösungen sowie leistungsstarke, softwarebasierte Speicher optimiert.

Damit dieses Vorgehen erfolgreich ist, müssen Unternehmen in die Digitalisierung und eine gute IT-Infrastruktur investieren. Sind beide gemäß dem Stand der Technik ausgerichtet, modern und flexibel, entsteht ein klarer Wettbewerbsvorteil für die Firma.

Header Bild: © andreusK, stock.adobe.com

Cloud Computing

Cloud computing: How secure is the system actually?

How secure is cloud computing, anyway?

What is cloud computing?

Cloud computing is a service where IT infrastructures are provided over the internet. This means that software and data do not reside on a local PC or server, but are instead managed via the cloud solution provided. Access therefore takes place via the internet, with cloud servers being accessed that are located in large data centres. Whether these are hosted in Germany or abroad is of secondary importance. An important aspect of cloud computing is the maintenance and protection of the stored data. It should be accessible at all times and protected from cyber attack. Some providers such as Microsoft or Google do not take over the complete protection, but integrate important components of cloud security into their offers.

Why more and more companies are opting for cloud computing

For some years now, a new trend has been emerging in the IT infrastructure of companies: As more and more employees work in home offices or on the move, software solutions and infrastructures are needed that allow easy access from outside. That is why far more companies today are opting to use different cloud solutions. Instead of buying and installing Microsoft Office, the choice falls on Microsoft Office 365, for example. The switch to Windows 11 also favours the move towards cloud computing.

  • Cloud solutions facilitate scalability: as soon as the company grows, more and more storage space is needed. This required storage is quickly used up on local servers, but is available indefinitely in the cloud because it can be adapted at any time.
  • Lower costs: Scalability reduces expenses in the short and long term. No money has to be paid for licences that are not needed or for storage space that needs to be secured.
  • Increased cyber security: Those who rely on cloud solutions benefit from numerous security precautions and can escape a system failure on the local server.
  • Increased productivity: Since all applications and data reside in the cloud, employees can access them from anywhere and at any time.

Are there risks?

Among the biggest risks are access permissions and access restrictions in the cloud. The fact that the data is easily accessible means that not only the company’s own employees can access it. So it requires a sophisticated concept that defines who can access which data. Particularly sensitive data or personal data should be protected especially well. However, most cloud providers invest in high-quality security systems that prevent unauthorised access as far as possible. Another important aspect is the flawless collaboration in a cloud product. While most solutions offer numerous collaboration tools, it takes a little time for all employees to find their way around. At the same time, the cloud solution must be able to work with other systems, which is why a secure and extensive API is one of the important components of cloud computing.

What are the benefits of cloud computing?

Cloud computing offers many benefits to businesses, allowing them to supplement or replace in-house IT infrastructure. For example, the Windows Server 2022 Datacenter can be operated locally, but also based on Azure, a Microsoft product. Nothing stands in the way of access via Windows Remote Desktop. Cloud computing offers the following advantages both in the private sector and at the corporate level:

  • Data encryption in the cloud follows strict algorithms that increase the security of the data and protect it from unauthorised access, as long as the right security precautions are taken.
  • Setting up an in-house data centre comes with high initial costs. Especially for small businesses, such a financial burden is hardly bearable. If, on the other hand, cloud-based offerings are used, the costs shrink to a monthly reasonable amount.
  • Another plus point for small or medium-sized enterprises: The technical know-how for administration, installation or even software development can be outsourced. Even the maintenance and servicing of the system can be placed in expert hands.
  • Cloud computing is a flexible solution that allows secure, fast and location-independent access both in the home office and for remote work.

Header image: © Ipopba, stock.adobe.com