It is not difficult to add a page number to a Word document from page 3 onwards. Not even if the numbering should start with 1 instead of 3. We will show you how to do it. Step 1: break the Word document into sections To be able to insert page numbers from page 3 onwards, you first have to structure your document in sections: Click at the very end of the text on the second page...

If you want to enter the holidays for the current or coming year in Outlook, you do not have to enter each appointment individually by hand. We will show you how it is much easier and faster. Outlook: delete old public holidays and enter new public holidays So that you do not see the holidays twice and three times in the overview, you should first delete the old holidays: Open the calendar in Outlook and switch to the "View" tab at the top...

To be able to edit protected documents in Word, you have to remove the write protection. We'll show you how to do it. Word: Remove write protection with password If you have not forgotten the password, you can easily unlock the document in this way. To do this, open the respective file in Word. Then click on " File "> " Information "> " Protect Document " and select " Restrict Editing "...

If you want to compare two columns in Excel to find duplicate values, you can use a formula. We will show you in our practical tip. Compare columns in Excel: difference If you want to roughly compare numbers according to their size, you can easily have the difference between the cell values ​​output. As...

For a better overview, you can fix rows or columns in Excel - or even both. Freeze rows and columns in Excel - Here's how Latest videos Excel: Freeze rows and columns - Open the "View" tab Clicking on "Freeze window" opens a dropdown menu. Select the desired option here. The fixed area is marked with a thin, black line...

With a few tricks, you can use Outlook more efficiently. We'll show you 5 secret tricks that make using Outlook even more convenient. Outlook trick 1: delete emails directly Mails can be deleted in Outlook in two ways. With a tip you get the mails deleted faster. You can delete the emails in Outlook by clicking the "Delete" button...

You want to put a check mark for completed entries in an Excel table. The detour by copying the character from Word's special characters dialog is too cumbersome for you. Create a check mark using the Excel system font You can access this check mark fairly quickly in all applications. It is in fact stored in the TrueType system font "Marlett"...

To automatically forward received emails in Outlook, all you have to do is create a rule. You can specifically define the conditions under which an email should be forwarded. Set up automatic forwarding in Outlook To forward emails automatically in Outlook 2013, go through the following step-by-step instructions: Go to the "Start" tab...

If you would like to cancel your ticket subscription with VVS, please note the notice periods. We have summarized here for you when and how you can quit conveniently and safely. Cancel subscription at VVS in good time As a rule, the duration of a ticket subscription with VVS is one year. If you do not cancel the subscription in good time one month before the end of the one-year period, the contract is automatically extended for another year...

In Microsoft Word, vouchers can either be created using templates or freehand with a little more effort. So you can conjure up a lovingly designed birthday present with a bit of creativity - regardless of whether it is a voucher for washing your car three times or for a romantic candlelight dinner. That's how it works...

If you would like to cancel your account at HypoVereinsbank, there are several ways of doing this. Here we show you what to look out for and how you can best proceed. HypoVereinsbank account: Cancellation possible at any time You can cancel your account at HypoVereinsbank by post, email and in person at the counter...

This practical tip shows you where you can find the spam folder in Outlook. Spam folder in Outlook: You can find it here The folder in which spam mails collect is called "Junk E-Mail" in Outlook. You will find this folder on the left in the navigation bar below your email address (see picture)...

Stiftung Warentest makes it easy for subscribers to terminate the contract. Read here how to do it best. Unsubscribe from Stiftung Warentest - how it works In contrast to most other subscriptions, the termination of the contract with the Stiftung Warentest is done very quickly. Stiftung Warentest offers its subscribers the option of completing their cancellation conveniently by telephone...

With the help of conditional formatting, you can easily color every other line gray or in any color in Excel. We'll show you how it works. Excel: Color every other line Mark the area in which you want to color every second cell. Under Start, click Conditional Formatting and choose New Rule. Click "Use formula to determine cells to format"...

If you would like to terminate your Bauspar contract with BHW Bausparkasse, you should inform yourself in advance of any consequences. We have summarized what you need to know for you. We also show you how best to quit. Terminate BHW Bausparkasse - deadlines and opportunities BHW Bausparkasse has a six-month notice period...

If Outlook blocks an attachment, you cannot easily release the file. We'll show you how to solve the problem. Outlook: Allow blocked attachments For security reasons, some attachments are blocked directly. However, you can allow certain types of files to be received temporarily or permanently. First, close Outlook if the program is open...

If you have found a cheaper offer, you can easily cancel the deposit at DekaBank. We'll show you how it's done. Instructions: Cancel the deposit at DekaBank You can cancel your deposit at DekaBank at relatively short notice, because there is no notice period. With the subscription alert form, you can create a termination for the deposit in just a few steps...

You can easily cancel your contract with Wüstenrot Bausparkasse. Here we show you what you should pay attention to and how you can best proceed. Terminate Wüstenrot Bausparkasse - observe important deadlines Wüstenrot Bausparkasse has a six-month notice period. You can cancel your building society contract at the Wüstenrot building society at any time. By...

If you are bothered by the Word autocorrection, you can safely switch it off. Words are often incorrectly corrected or punctuation marks converted into smileys. We show you for various Word versions how you can set the auto correction options. Step 1: Open auto correction options Office 2013: Click on the "File" tab at the top and select the "Options" item in the bottom left...

If you do not want to change the default font in Word manually each time you start it, you can set this in the settings. We'll show you how it works. Change the default font in Word 2013, 2010 and 2007 Open Word and click the Start tab at the top if it isn't already open. Click to the right of the "Font" item on the small symbol with the arrow (see picture)...

Holidays are not shown in advance in Microsoft Outlook, but can be imported quite easily. An external file is not necessary for this: you just have to make a few small settings in the calendar. In this practical tip, we will show you how to proceed with Outlook 2010. Import public holidays via Outlook settings Go to "File" in the top left of the navigation bar and then to "Options"...

Microsoft offers you an option in Excel to have fields in a table filled out automatically. This automation saves you a lot of unnecessary work and time. Have fields filled in automatically in MS Office Excel Below we present the practical automation mechanism at Excel based on the months. For example, if you want the month names as column headings, first enter the month name with which you want to start in a cell...

In Excel, the AND function helps you to check entries in your workbook. You can find out exactly what the formula does and how you can use it here. The "AND" function in Excel The AND formula is used to define criteria that must be met at the same time for a field to return a positive value...

Set vacation notice: In Microsoft Outlook, you can automatically reply to incoming e-mails with a vacation notice if you are unavailable for a long time. We'll show you two ways to set up vacation notices. 1. Outlook: Quick to the vacation note via "Automatic replies" If you want to set up an out-of-office note in Outlook without any special rules, this can be done quite quickly via "Automatic replies"...

In this practical tip, we describe how to use the comparison function in Excel. Use the comparison function in Excel Click in a free cell in Excel and type in "= COMPARISON". The comparison function syntax consists of three arguments and is displayed automatically. Under "Search criterion", the first argument, specify the value with which you want to compare the elements of the search matrix...

In Excel, an arrow skillfully draws attention to the numbers that are relevant. In the program you will find a lot of different arrows - from subtle to striking. Insert arrow into Excel - this is how you find the character In Excel you will find subtle arrows for your spreadsheet under the special characters...

Excel offers an index function to call up data from tables and subtables. We explain how you can use this function. Use index function in Excel Excel is a spreadsheet program. You can call up individual entries in a table using the combination of row and column. You can create multiple sub-tables in a table...

In Excel, you can use conditional formatting to reshape the cell contents as you like. For example, you can display completely different text or change the font. The powerful toolset includes numerous options as well as predefined rules. This article shows the main types of rules for conditional formatting...

If Excel no longer calculates, this is mostly due to incorrect settings. We'll show you how to solve the problem and get Excel to do the math again. Excel: Automatic calculation deactivated Click on the "File" tab in the top left and select the "Options". If you switch to the "Formulas" category on the left, you will find the "Calculation options" above...

You can save a Word document in many formats, including a JPG file. We show you what you need and how it works. How to save Word documents as JPG with one tool You cannot save a document as a JPG file directly from Word. With the help of a practical tool you can easily convert it into an image file: Download the "PDFCreator" to the PC and install the tool...

If your Office version cannot be activated even though you have a valid product key, you can use these steps to solve your problem. Office can't be activated: General troubleshooting Often it is not a big problem if your Office suite cannot be activated. Therefore, check the following steps to clear simple problems and narrow down the search for the cause...

Sometimes you don't want to start a new paragraph in Microsoft Word, you just need to wrap it in a new line. We explain how you can insert such a line break. How to create a line break in Microsoft Word This tip also works in LibreOffice or OpenOffice, in Microsoft PowerPoint and also on many websites such as Facebook...

If you cannot find a missing folder in Outlook, the problem can usually be solved with a few clicks. We'll show you the options. Show missing folders in Outlook again Latest videos Image 1: Folders disappeared in Outlook: Click on the "View" tab above Image 2: Select the "Normal" option in the "Navigation area" drop-down menu If not only an Outlook folder has disappeared, but also the entire folder bar on the left side, the error is easy to fix...

If your formulas are no longer calculated in Excel, this is usually due to incorrect settings. These instructions show you how to set these correctly. Formulas are not calculated in Excel Click on the faulty cell with the mouse or select all affected cells. On the "Start" tab you will find a selection menu in the "Number" category...

If you want to rotate a table in Word, the associated function cannot be seen at first glance. We'll show you step by step how to rotate the table in Word. Rotate table in Word: No function available In Word you can rotate a lot of content around its own axis, unfortunately tables are not included...

If you want to share a page in Word, you can do this in several ways. You can do this either with the column function or with an invisible table. We present both variants to you. Share page with columns in Word The usual way to split a page in Word is through the column function. It only takes a few clicks...

In Word, you can only create one page in landscape format and leave all other pages in the document in portrait format. You can find out how this works for a single page within a document here. Microsoft Word: Create only one page in landscape format In order to create a page in landscape format with Word, you have to work with a page break ...

In this practical tip, we explain how to customize the toolbar in Word. You can adapt the user interface to your personal way of working. Customize toolbar in Word: make favorite commands quickly available The "Quick Access Toolbar" is located at the top left, above the "File", "Start", "Insert", etc...

In this practical tip, we will explain how to enter the approximate character on your Windows PC. This is mainly used for mathematical formulas. Enter approximate characters: These options are available The approximate or rounded sign ≈ is mainly used in mathematics. It is used when a number is given rounded. ...

In this practical tip, we explain how to insert a background image in Microsoft Word. This is how you create interesting layouts with the wall papers. Insert background images as watermarks in Word In Word you will find background images under the term "watermark". Here's how to add the effects: Go to "Draft" in the menu bar...

With the Stuttgart insurance company, you can insure yourself for old age in many ways. This practical tip shows you how to cancel insurance. Terminate Stuttgart Insurance: You should know that Each insurance policy has a different contract term. The same applies to the notice period. This is usually 1 to 3 months at the end of the contract period...

This practical tip shows you how to create a new folder for your emails in Outlook. Create a new folder in Outlook Open [[//www.chip.de/downloads/Outlook-2013_43620649.html|Outlook] and right-click on the "Inbox" folder. Select "New Folder". Then enter the name of the folder. The changes are saved automatically...

The "AutoComplete" function can be both a blessing and a curse in Word. We'll show you how to use or disable the tool correctly. Word: Switch autocomplete on and off In this practical tip, we use the Office version 2013. Among other versions, the functions can be arranged differently or titled...

In Word documents you can quickly insert one or the other check mark and you should use it. A tick is always a small eye-catcher that you use to draw attention to a certain point and is often used in to-do lists. Insert a check mark in Word - this is how it works quickly Special special characters, such as the tick, are usually not found on the keyboard...

MS Office Excel is an extensive spreadsheet program. However, some functions are denied to the user. Add-ins can help here. We have examined the 5 best add-ins for you. All shortcuts at a glance with shortcut reference Shortcuts (key combinations for certain actions) can make working in Excel much more efficient...

In Excel, you can format individual cells as in Word. We will show you this in detail in our instructions. Format cells in Excel Start Excel and open the document you want to edit. Left-click the cell to be formatted to select it. Now select the first tab under the menu bar. In most cases this is "POS1"...

Sometimes you may have to copy values ​​from a cell in Excel without copying the formula behind them. We show you here what steps are necessary. Excel: Copy and paste values ​​without formula - how it works Copying the values ​​is very easy in all Excel program versions from 2007: Select the desired cell and copy the content. Click in t...

This practical tip shows you how to convert a Word document into a PDF file. If you send the document by email or distribute it on the Internet, compatibility problems with other users are excluded. Convert Word File to PDF (Word 2010) If you have opened a document in Word, you can save it in various file formats - including as a PDF...

If you would like to terminate your electricity contract with LichtBlick, there are a few things you should consider. We tell you how to end the contract legally. Terminate LichtBlick Strom: End contract You can cancel the contract at LichtBlick at any time, as there is no minimum contract term. The notice period is four weeks to the end of the month...

With PowerPoint you can easily create a poster and save yourself expensive layout software. We show you the most important steps in this article. 1. Set the poster size To ensure that no images or text shift due to incorrect scaling when printing, set the correct sheet size at the beginning: Open the "Design" tab and click on the "Page Setup" menu Enter the dimensions of your poster under "Width" and "Height": A4 has the dimensions 210mm x 297mm, A3 297mm x 420mm, A2 420mm x 594mm...

If you want to cancel your contract with FitnessKing, there are a few things to consider. In this article you can read how you can best do this. FitnessKing: cancel the contract - how it works You cannot view FitnessKing's terms and conditions online. The notice period must therefore be found in your contract documents...

If you no longer wish to receive the Handelsblatt, you can cancel the subscription. We'll show you how it's done. Terminate Handelsblatt: You have to know that The contract period for a Handelsblatt subscription is 12 months. The notice period is one month. If you do not cancel in time, the subscription will be extended for another 12 months...

The cover page and the table of contents of your Word document should normally not contain any page numbers. In this practical tip you can read which settings you have to make. Table of contents and cover page without page numbers: how it works Latest videos Word: Table of contents and cover page without page numbers - create another page in your Word document...

With the formula = googlefinance you can call up stock prices in Google Sheets. We will briefly explain how to use the command correctly. Get stock prices in Google Sheets with = googlefinance You can download various stock tools for a quick overview of the stock market. In so-called spreadsheets at Google Docs, the online counterpart to Microsoft Excel, you can call up and create your own stock price overview...

With a folder spine template you can easily label your folders. You can customize the templates in Word and then print them out. This tip shows you how to find the templates for folder spines in Word. Find templates for spine folders in Word Open Microsoft Office Word and click "New" to go to the template catalog...

If you no longer wish to purchase your electricity from enviaM, you can terminate the contract. We'll show you how it's done. Cancel enviaM: You have to know that Since enviaM is a basic provider, you can terminate the contract at any time with a notice period of only two weeks. The termination must be received by enviaM in text form...

If you would like to cancel a subscription to the journal Freie Presse, you have to consider a few small things. You can find out how best to proceed here. Unsubscribe from the Freie Presse - so it'll work So that nothing goes wrong when canceling the subscription, you must observe the notice periods...

Google Sheets can also translate: With the formula = googletranslate you can translate words and sentences in real time. We will introduce you to the function and show which languages ​​have been supported so far. = googletranslate: How to translate with Google Sheets The formula = googletranslate lets you translate in real time. Yo...

If you have chosen another bank, you can terminate your account with ING-DiBa. We'll show you how it's done. Instructions: Cancel account with ING-DiBa There is no notice period for bank accounts. You can close your account and the associated deposits with immediate effect. Use the following form for the current account or the extra account...

If you no longer wish to support the Bund Deutscher Tierfreunde with your membership, you can cancel the relationship. We'll show you how it's done. German Animal Friends Association: You have to know that Membership in the Bund Deutscher Tierfreunde is two years. Subsequently, it will be extended by one year if no notice of termination is submitted...

Before you send Word documents to colleagues or business partners, you should remove the personal data from them. Otherwise you may send confidential company data or private information in the so-called "metadata". We'll show you how to do it in old and newer versions of Word. As of Word 2010: Remove personal data from documents Latest videos Remove personal data from Word documents: First open the "File" tab...

To make pictures transparent in PowerPoint, you have to accept a small detour. In this article we will show you exactly how to do this. Make pictures transparent in PowerPoint - how it works Latest videos Powerpoint: Make images transparent - Click on "Shapes" under the "Insert" tab, here you can select any shape...

If you no longer wish to be a member of the IKK classic, you can simply cancel your health insurance. We'll show you how it's done. Quit IKK classic - how it works To cancel the health insurance of IKK classic, all you have to do is provide your name, address and insurance number. It is best to use the following IKK termination form...

If you have decided to cancel skyDSL, this is possible at the end of the minimum contract term. We have all the information in this post for you. skyDSL: How to cancel your contract correctly The minimum contract term of your contract can be found in your order confirmation. Your cancellation must be received by skyDSL customer service at least one month before the term expires...

If you want to cancel Lifeline insurance for your cell phone, you should take a close look at your contract. There you will find information about the term of the contract. We'll show you what to look out for when canceling and how best to proceed. Lifeline insurance: when to cancel the contract Whether you have to cancel the contract at all depends on your payment method...

If you have a newspaper subscription through ZENIT Pressevertrieb, you must cancel it there as well. We'll show you how it's done. Terminate ZENIT Pressevertrieb: All information ZENIT Pressevertrieb sells subscriptions to a wide variety of newspapers and magazines. The contract terms and notice periods also vary...

This practical tip shows you how you can display and calculate negative times in Excel. Before doing this, you have to make changes in the settings in Excel. Preparation: Display negative times in Excel To work with negative times in Excel, you first have to make a setting. If you can already display negative times, read on in the next paragraph...

You can cancel your membership in the Bundeswehr social welfare service by giving a deadline. Read in this post what there is to consider for you. Bundeswehr social welfare office: You should note that It doesn't matter what month your membership started. The Bundeswehr Social Service (BwSW) accepts terminations in writing at the end of each year...

If you no longer wish to use NetAachen's DSL contract, you can terminate it at the end of the contract. We'll show you how it's done. Instructions: Cancel DSL contract with NetAachen The contracts of NetAachen usually have a term of 24 months. The notice period is three months to the end of the term...

If you no longer wish to receive TV TODAY magazines, you can cancel your subscription at any time. We'll show you how it's done. Cancel TV TODAY - all information No matter how long the contract runs for your subscription, the notice period for TV TODAY is always six weeks. If the cancellation is not received by the publisher in time, the subscription will be renewed for the same term and only then terminated...

If you no longer wish to use the Click and Date service, you can cancel the subscription. We'll show you how it's done. Cancel click and date - you have to consider that Depending on the chosen tariff, the contract term for Click and Date is different. However, the notice period is always two weeks...

Depending on the term model, you can terminate your contract with SunYa at certain times. We will inform you about your options and provide you with a notice of termination. Cancel SunYa: These are the deadlines First, check your records to see if your contract was for six months, a year, or two years...

If you no longer wish to subscribe to the Kronen Zeitung, you can simply cancel the contract. We'll show you how it's done. Terminate Kronen Zeitung: You have to know that If you have a subscription with a fixed term, the notice period is six weeks to the end of the term. Otherwise the subscription will be extended for a further period, usually by 12 months...

You can cancel your membership in VidaVida at the end of the term. Read what you should pay attention to in this article. VidaVida: cancel the contract correctly VidaVida must receive notice of termination of the contract at least 14 days before the end of the term of your choice. Log into your VidaVida account with your username and password...

If you would like to cancel your private health insurance with Allianz, there are several ways to do it. We show you how to do it. Allianz: Cancel private health insurance - how it works It is important that you adhere to the three-month notice period at the end of the contract. You can cancel the contract via the Allianz website...

If you no longer want to read the world of miracles regularly, you can cancel your subscription at any time. We'll show you how it's done. Cancel subscription to Welt der Wunder: All information Depending on the selected subscription model, the notice period also varies: The gift subscription expires automatically after the selected term...

If you no longer wish to receive newspapers or magazines from Lesershop24, you can cancel the subscription. We'll show you how it's done. Terminate Lesershop24: You have to know that At Lesershop24 there is basically no notice period. If you cancel the subscription, you will receive a maximum of one more edition depending on the receipt of the cancellation...

You can cancel your membership in the recreational sports club. There are a number of things to consider so that the exit is legally binding. We have put together all the important information for you. Cancel membership in Sports Fun You can give notice of termination at the end of each quarter. In order for the contract to end accordingly, your resignation must be received by the club in writing by March 15th, June 15th, September 15th or December 15th...

If you would like to cancel your subscription to Sky Austria, you must observe the cancellation deadlines. These depend on how long the contract has existed. We show you how to do it best here. Cancel Sky Austria: observe deadlines A notice period of two months applies to newer contracts. If you have concluded your contract from July 4, 2009, there is a notice period of two months at the end of the term...

If you no longer wish to use HDI's pension insurance, you can cancel the contract. We explain how this works in this practical tip. Canceling HDI pension insurance: you need to know that The cancellation of the pension insurance should be considered carefully. Check beforehand in the contract documents what consequences will arise from the termination and whether it is really worthwhile...

If you no longer wish to subscribe to the magazine "My beautiful garden", you can simply cancel the subscription. We'll show you how it's done. Quitting my beautiful garden - you should know that No matter which subscription model you choose, the notice period is always six weeks before the subscription expires...

If you want to cancel your membership in SaferSurf, you can do it quite easily. In this practical tip, we will show you exactly how to proceed. SaferSurf: Cancel directly from the provider SaferSurf promises its customers a simple procedure for termination: simply enter your name and email address in the contact form provided on the provider's website, which you also used when you placed your order, and send it off...

You are a customer of Grünwelt Energie and want to change providers. You can cancel your contract by giving a deadline. We will tell you what else you need to look out for and we will also provide you with a legally compliant notice of termination. Grünwelt Energie: How to cancel properly Your contract with Grünwelt Energie has a first term of one year. Y...

You can cancel your subscription to Großraum-Verkehr Hannover (GVH) if you no longer need it. In this article you can read how you can best do this. Großraum-Verkehr Hannover (GVH): Cancel the subscription correctly When canceling your subscription, you must observe the applicable deadlines. The GVH annual subscription has a term of one year and is extended for another year if you do not cancel in time. ...

If you want to cancel your membership in DAK-Gesundheit, you have to consider a few things. We will show you what is important and how you can best proceed. DAK health cancel - membership and deadlines In order to cancel your membership in DAK-Gesundheit, you must be insured with the health insurance for at least 18 months...

There are several things you need to consider to cancel your account at Berliner Sparkasse. We will tell you here how you can legally close your account. Terminate an account with the Berliner Sparkasse - this is how you proceed If you want to cancel your account at Berliner Sparkasse, you can do so at any time...

If you receive an email with the attachment "Winmail.dat", you can do little with it. The attachment can be prevented in Outlook 2016. We'll show you how. Prevent winmail.dat in Outlook - causes Before we show you how to prevent the "winmail.dat" file from being sent along, this chapter tells you the causes of the dubious attachment...

If you have made notes in your PowerPoint presentation, you can also print them out. We show you how this works. PowerPoint: Print notes Tip: Instead of printing out the notes, you can simply display the notes during the presentation. In the upper left corner of PowerPoint, click on the "File" menu item and select the "Print" category...

You can count colored cells in Excel without much effort. Read here how exactly this works. Count colored cells in Excel - that's what you have to do Start Excel on your computer. Switch to the "Formulas" tab and click on "Define name". Now you can define a new formula Name it "Color" and add the property "= CELL...

Alternatives to Microsoft Office applications are very popular. Many programs are available free of charge and offer a similar range of functions. We show you three good freeware solutions that you can use instead of MS Project. This is MS Project - and these are the alternatives If you want to plan complex projects, MS Project has been the method of choice for many years...

Microsoft's "Outlook" is a powerful email software, but there are also good and free alternatives for Mac and Windows. In this practical tip, we will show you the five best. 1. Thunderbird: The most comprehensive Outlook alternative The powerful and extensive e-mail program "Thunderbird" comes from "Firefox" maker Mozilla...

As a spreadsheet program, Excel is ideal for arithmetic. We'll show you how to enter formulas and perform calculations in the Microsoft program. The formula entry in Excel First of all, Excel considers every entry to be simple text input. If you want Excel to calculate, you have to tell him. To calculate in Excel, enter the first character in the input line with an equal sign "="...

When you select new messages with the arrow keys, Outlook automatically marks the e-mails as read as soon as you hesitate a little while browsing. This is annoying, but can be easily deactivated. No longer automatically mark emails as read in Outlook - a video tutorial Change Outlook "read" settings In its basic setting, the program actually marks new messages as read very quickly...

In Word, you can add numbers and letters with just a few clicks. We explain how to write superscript numbers. Word: Write superscript numbers In Word, highlight the numbers or letters you want to superscript. The "x ^ 2" icon is located under "Start" in the "Font" area. Click on it...

Microsoft Excel is sometimes annoying. We therefore introduce you to the five most annoying functions of the program including * solutions. Nerve killer 1: Excel calculates incorrectly Excel calculates incorrectly. At least that is the impression of many users if, for example, there are suddenly decimal places missing in the result...

There are numerous alternatives to Windows for Microsoft Office, most of which are available for download free of charge. In this practical tip, we present five recommended programs. 1. Office alternative: OpenOffice OpenOffice is the classic alternative to Microsoft Office. The OpenOffice suite consists of a program for word processing, spreadsheets, creating presentations, drawing and a database solution...

You can easily calculate your overtime with the Excel spreadsheet. We'll tell you exactly how this works in this practical tip. Calculate overtime with Excel - how it works Download and open this template for Excel. Enter the month in which you would like to make the calculation. In the field below, enter the hours you have to work per day...

In Excel you can round numbers to a desired number of decimal places. We show you how rounding works in Excel. Rounding in Excel: by formatting If you want to round a number to a certain number of decimal places without specifying whether you want to round up or down, you can use the formatting: Select one or more cells and right-click on them...

As a VBA or Excel layman, you are sometimes faced with the problem of having to open an Excel file from another Excel file with VBA. We'll show you which command works. Excel VBA: Open file Open a file in Excel using VBA with the command line "workbooks.open" x: \ blub \ ihrpfad.xls ", replacing" yourpath "with the path to the file you want to open...

If you see runtime error 9 in the Excel spreadsheet, there are several ways to fix it. We present the solutions here. Excel: How to fix runtime error 9 This error message says that you want to use your code to access a worksheet that does not (yet) exist. Check your code in Excel for spelling errors and correct punctuation so that the relevant data sheet can be called up...

With placeholders in Excel, only part of a cell's content can be checked. For example, you can count all cells in a range whose content begins with a specific letter. In this article we will show you how to use placeholders in Excel. Use placeholders in Excel The asterisk (*) acts as a placeholder in Excel...

If you see runtime error 13 in the Excel spreadsheet, you can usually fix it yourself in just a few simple steps. Read in this practical tip how to do it. Runtime error 13 in Excel - what to do? This error occurs when you use bad code in Excel. Excel marks the spot for you, so you should check it closely...

Excel has a simple formula for calculating the logarithm of a number. We show you how to calculate the natural logarithm and the logarithm on any basis. Calculate logarithm in Excel You always start a formula in Excel with an equal sign. You can calculate the logarithm of a number using various formulas: Natural logarithm: Use the formula "= LN (number)" to calculate the natural logarithm, ie the logarithm to the base...

To make price lists or invoices attractive in Word, it is not enough to set automatic tab stops. In this practical tip, you will learn how to set tab stops individually. Microsoft Word: Manually set tab stops The automatic tab spacing is 1.25 cm and is sometimes impractical when formatting. Find the ruler above the document...

You can also easily calculate sine, cosine and tangent in Excel. This practical tip shows you how to get the angle functions in Excel. Calculate sine, cosine and tangent in Excel Excel calculates angles like sine, cosine and tangent by default not in degrees, but in radians. The angle 180 degrees corresponds to the number pi in radians...

In order for your PowerPoint presentation to succeed, the pictures must also be correct. In this article, we will tell you how to enlarge and reduce inserted graphics. PowerPoint: Enlarging and reducing images and graphics Once you have inserted pictures in PowerPoint, you can scale them in two different ways and adapt them to your needs: Select the desired image and small blue dots appear in the corners and on the edges of the graphic (see photo)...

If you don't just want to design your PowerPoint presentation with text and images, you can draw a little. We'll show you exactly how it works. Instructions: Draw in PowerPoint Note: If you want to draw more complex and professional, you can alternatively create your drawing in free software such as "Paint...

It is easy to square numbers in Excel. Because simple calculations can be carried out directly in the cell. All that is needed is a small formula that even Excel beginners can do. This practical tip shows you how to square such a number. Square number in Excel: This formula makes it possible To square a number in Excel, you need to enter a formula...

You won't find many special characters on your keyboard, such as the up, down, right, and left arrows. Instead, you need a special key combination to enter the symbols. Enter up and down arrows and right and left using the keyboard To be able to enter the four arrow symbols using a key combination, you need a keyboard with a numeric keypad: Hold down the [Alt] key to the left of the space bar and then enter the following combinations of numbers on the numeric keypad...

If you want to make your PowerPoint presentation special, you can change the background color of your slides. We show you how this works in this practical tip. PowerPoint: Change background color of individual slides Black writing on white slides no longer impresses listeners - that's why you can change the background color of your slides in PowerPoint at any time: To do this, start PowerPoint and select the slide for which you want to change the color...

You can zoom in PowerPoint if you want to enlarge an area in your presentation. You can also zoom into the slides when creating the presentation, for example to place a graphic exactly. We show you both options. Zoom in PowerPoint First open the slide in the presentation on which you want to zoom in on an object...

To ensure that pictures and text in your presentation do not look stretched, you must set the correct format (16: 9 or 4: 3) in PowerPoint. In this article, we will tell you exactly how this works and how you can even set up other formats. PowerPoint: Set format 16: 9 or 4: 3 Most projectors and screens use the 4: 3 and 16: 9 image formats...

If you want to convert your Word document into PowerPoint, the formatting is retained. You can turn the individual slides later with a click of the mouse. Word in PowerPoint - Method 1 There are two ways to do this. You should choose one of the methods and apply it to all text pages: The first is to open your original document in Word and an empty presentation in PowerPoint...

With OpenOffice you can create posters in all common formats. We will show you the individual steps from creating the document to completion as a PDF. Create posters with OpenOffice First you need to choose the right format for your poster: Open OpenOffice and click the "Format" menu. Because select "Page ...

If you have not installed Office 2016 in German or corrected the auto correction incorrectly, you can change the language at any time. We'll show you how it works. Office 2016: Change Word, Excel and Co. to German Note: In the following instructions you will find the options in both German and English...

In this practical tip we will show you how to display a Powerpoint presentation in black and white. For example, you can bypass the poor color rendering of an older projector. Display presentation in Powerpoint in black and white To display your presentation in black and white, first open a PowerPoint file and then follow these steps: Open the "View" tab in the top menu bar...

If you want to enter a per mille sign in Microsoft Office Word, this is only cumbersome the first time. We will show you how to easily insert the special character afterwards. The alcohol sign as a special character As with most word processing programs, you can find the alcohol mark in Microsoft Word under the special characters: To insert a thousandth character into your text for the first time, go to the menu "Insert" -> "Special characters"...

In this practical tip, we will show you how to combine several cells and / or columns into one in Microsoft Excel - for example, to get more space for a heading. Connect cells and columns in Excel Microsoft Excel still represents the top dog in spreadsheets. To connect individual fields, proceed as follows: Mark the desired area with the mouse...

In this practical tip, we will show you how to create a mailing list from an Excel address table in Outlook. Step 1: Adjust the Excel address list for the Outlook Mail distribution list Before you can import your contact list into Outlook, you have to prepare it first. Otherwise Outlook cannot handle your spreadsheet...

In this practical tip, we present the three best alternatives to the OpenOffice office software. 1. Calligra Suite as an OpenOffice alternative The Calligra Suite is a combination of office and graphic tools. The application originally comes from the Linux area, but is now also available for download for Windows...

The easiest way to insert a video into your PowerPoint presentation is through the content field that usually appears with every new slide. You can read exactly how to do this in these instructions. Spice up PowerPoint presentation with video To insert a video into the PPP, proceed as follows: Click the "Add media clip" icon in the content field of the desired slide...

Do you often use copy & paste and want to delete the clipboard after work to protect it from prying eyes? There are two options with which you can quickly and safely delete or overwrite the clipboard. Overwrite clipboard under Windows 7 The fastest and easiest way to clean the clipboard under Windows 7 is to select a small letter and copy it...

If you use Outlook for private and business purposes, you often have to use multiple email signatures. We'll show you how. Variant 1: Frequently use an email signature in Outlook If you mainly use a signature in your emails, you can simply save it as a standard signature in Outlook. We show you how this works in this practical tip...

In the word processing program MS Word there is no direct provision for saving individual pages. How you can achieve this goal without much effort, read in the following instructions. Concentration please - save extracts from Word documents with just a few clicks Simply copying a selected page and pasting it into a new, blank document does not work for most Word documents...

A set of three can be solved very quickly with Excel. This practical tip shows you how to enter the formula in Excel and calculate tasks. Solve three sentences with Excel In Excel, click a cell where you want to see the result. Type in your three-sentence formula, for example "= A1 * B1 / C1"...

In Outlook you can configure the preview window for e-mails according to your wishes. For example, determine whether you prefer to display it in the lower area, on the right margin or simply not at all. Set up preview window in Outlook To switch on or realign the reading area for e-mails, proceed as follows: Select the "View" tab...

Style sheets can make working with Word easier. In this practical tip, we will show you how to create it. How to create a new style in Word Start a blank document in Word. Click the arrow at the bottom right under "Styles". Then select "New Style" at the bottom right. The window that you can see in the picture opens...

With the new version of Microsoft Office, Excel 2013 was also equipped with new functions - for example, the date difference can be calculated using the day function. Find out how it's done here. Calculate the date difference using the day function in Excel To be able to calculate the date difference between different days in Excel, you only need the "day command" (English: DAYS) and the two dates to be used for the calculation...

Have you accidentally deleted emails or other items in Outlook and now want to restore them? No problem, here's how to do it. Restore from your own "trash" Outlook comes with its own recycle bin, so that you cannot permanently delete items without asking again. Click on the "Deleted Items" item in the menu bar on the left...

Excel has a quick and, above all, simple solution for rounding numerical values. This can be helpful if, for example, you want a better overview of the amounts of cents in your documents. Rounding in Excel with a simple formula In Excel, the function "= ROUND (number; number_digits)" rounds a number to the specified decimal places...

In Word, the page formats within a document can vary. This means that even a single page can be created in landscape format, while the others are still in portrait format. This function is useful if, for example, you want to insert a diagram that only fits in one of the two formats. How to adjust the individual pages...

There are many reasons to insert a watermark in a Word document: Whether you want to mark the status of the processing, particularly important or confidential documents or perhaps want to save a logo - with Word you have a large selection of pre-made watermarks and you can also create your own, Insert custom watermark...

There are many ways to include a table in your Word document. You can choose already prepared table templates or use the table menu to manually determine the number of rows and columns. For example, schedule tables, data tables or periodic tables can be arranged in a coherent manner. The "Table" command in Word To insert tables of various sizes in Word, you only need a few clicks: After you have marked the position in the document where the table is to be inserted, go to the "Insert" button in the menu and then click on "Table"...

When Windows starts, programs such as Outlook can be started automatically. While this takes longer to boot up your computer, it helps automate workflows. We want to show you how to do this using a PC with Windows 7. Store Outlook shortcut in autostart With Windows there is a very simple solution for you to let programs load when the system starts: the autostart...

Cutting off a text in Excel is usually an option if the text content in a cell extends beyond the edge of the box, but the cell length should not be changed. There are two options for this. Cut off text in Excel using the neighboring line You only need one click and the appropriate text value for this process: Click the cell to the right of the box that contains the text you want to cut off...

Office 2016 is available for the Mac in a free trial version. In this practical tip, we will show you where to find the download and what new functions Office has to offer. Download: Office 2016 for Mac OS Office 2016 brings the latest versions of Word, Excel, PowerPoint, Outlook and OneNote to your Mac...

If Microsoft Word's spell checker doesn't work, there can be several reasons. We'll help you fix spelling mistakes. Word spell check no longer works The problem is often related to the fact that you accidentally changed the spelling checker language you selected. In this case, German words cannot be recognized as correct...

Concise colors as a hint can be very helpful for extensive Excel tables. With the logic function "if-then" you can quickly assign event-dependent colors to the corresponding cells. Change cell color in Excel: Using the if function In our example, we manage our inventory using an Excel table...

If you want to insert the unequal character (≠) under Microsoft Office or Windows, there is a certain key combination that allows you to do this. In the following practical tip we will show you which keys you have to press for this. Enter unequal characters in Word and Excel To insert the unequal character in Word, Powerpoint, Excel or another office program, all you need is a number and a key combination. ...

If you convert your PDF files to JPG, you can edit the content with an image editing program, for example. Our instructions show you several procedures. Convert PDF to JPG with the PDF24 Creator Download the free "PDF24 Creator" here and install the tool. In order to be able to use all functions, the tool asks you to enter your email address...

You can easily create a photo album in PowerPoint. Read in this practical tip how to do this. Create your personal photo album with PowerPoint With just a few clicks you can compile your photo album in Microsoft Office Power Point: Start PowerPoint and switch to the "Insert" tab. Click "Photo Album" and then "New Photo Album"...

You can insert a plus minus sign in Word, for example, with a simple key combination. This practical tip shows how this works. Insert plus minus sign with key combination Make sure that the "Num" key on your keyboard is active. Now enter the key combination "Alt + 0177" at the desired position in your Word document...

To make cool party invitation cards yourself, you can use ready-made templates, great pictures and creative fonts. We show you different options for beginners and professionals. Create party invitation cards: simple, fast and chic Beginners use the Word templates for the Pary invitation cards. Alternatively, you can of course also use templates for OpenOffice...

You have to search for the greater than and less than equal sign in Word or enter it as a key combination. We will introduce you to the two options. Enter less than and equal to characters in Word In Word, go to the "Insert" tab and select "Symbols". With a simple left-click, the frequently required special characters are already opened, under which you will also find the less than and greater than or equal sign in the second row...

Flyers are handy, informative and easy to produce: You can even create flyers in Word without having to rely on special layout software. You can find out exactly how this works in this tip. 1. Set the flyer size Open a new document in Word and click on "Page Layout" in the menu. There you will also find the "Size" item, which already hides a small selection of the most popular formats...

Fortunately, if you forgot your Outlook password, you can easily reset it. We'll show you exactly how this works in this case. Forgot Outlook password - so reset your password Open this page from Microsoft (click on the link). Enter your email address and confirm with "Next". You will receive a verification code via email, which you will need for the next steps...

If Outlook no longer starts, there can be several reasons. We'll show you how to get Outlook up and running again. Outlook no longer starts - test in Safe Mode Press the [Windows] and [R] keys simultaneously so that the "Execute" command opens. Enter "outlook.exe / safe" here and confirm with "OK"...

If you want to use Outlook on two computers or switch to another email program, you can export your calendar. Export calendar to Outlook To save your Outlook calendar as a CSV file, follow these steps: Open Outlook and click on "File" in the upper left corner of the window. Select the "Import / Export" menu item there...

In Word, you can not only manage your text, but also create a checklist with check boxes. In this article we will show you how to do this. MS Word: Printable box With the word processing software "Word" from "Microsoft Office" you can create simple checklists with the integrated symbols...

The very good write protection options are one of the reasons why the PDF format is so popular. This practical tip shows you how to quickly and easily save your own PDFs. Protect PDFs with "Dinbrief" For fast encryption without additional programs, the web tool "Dinbrief" is recommended: Go to "Select file" and upload the relevant PDF document...

An absolute reference in an Excel formula is - as the name suggests - the unchangeable part of the formula. You can, for example, fix formulas in a cell. In this practical tip, we explain how an absolute reference is created in an Excel table. Create an Excel formula with absolute references Absolute references are always useful if you have one or more values ​​in the Excel formula that should apply to all formulas in a certain range. Fo...

In Excel, you can easily convert a single date into the corresponding calendar week. In this practical tip, we will show you the appropriate function and the associated parameters. Convert date to calendar week - this is how it works with Excel Latest videos Step 1: Enter the date in Excel Step 2: Enter the command for calculating the calendar week Step 3: Calendar week was calculated from the date To quickly find out the corresponding calendar week for a specific date, there is the practical "Calendar week" function in the Excel spreadsheet...

You can also define names in the Excel spreadsheet. In this practical tip, we will show you exactly how this works. Define and use names in Excel - so it'll work Click the cell whose name you want to define. At the top left of the program you can see the current name of the cell, for example A1. Click in the field and enter the desired name...

By inserting a button in Excel, macros can be started easily with one click. We show you how to insert such buttons. Insert buttons: Show developer tools in Excel Before you can use the button function, you have to activate the developer tools in Excel. If you already see the "Developer" tab in Excel above, follow the instructions in the next paragraph...

In Microsoft Excel's dynamic calendar, you can choose any year for which you can display the correct days of the week for each month. If you change the year, the daily date values ​​change accordingly. You can read how to create such a flexible calendar manually in our practical tip. How to create a dynamic calendar in Excel Enter the word "Year" in cell A1 and to the right in B1 any year, such as 2050. (s...

In this guide, we explain how to use the mean function in Excel. Use mean function in Excel In Excel, click on "Formulas" in the menu bar and there on the small arrow next to "AutoSum". Excel will then already suggest cells for the mean calculation. Now mark the values ​​you need for your mean calculation. To...

If you want to determine the highest value of a series of numbers in Excel, you can do this with a simple command. We'll show you how it's done. Find the highest value of a series of numbers in Excel Write down any series of numbers in Excel. In the cell below, type "= MAX (" without the quotation marks...

If you want to create a list of data in Excel 2010, the dropdown function can save you a lot of time and nerves. In this article we will show you an example of how to do this. Integrate a dropdown menu in Excel Let's say you have to create a directory for your company. You must specify which worker worked how many hours on which day of the week...

If you create a very large table in Excel, it can be useful to fix certain areas. For example, you can fix the top row of a table so that you can always keep an eye on it - even when you are looking at row 100. We'll tell you how it works. Office 2013, 2010, 2007: Freeze rows and columns in Excel Click the View tab at the top...

To make tables stand out in Excel, you can draw a frame around your table. Draw a frame around tables Select the range of cells around which you want to draw a frame. Click on "Start" in the tab. In the menu you will find a small button under the font selection that looks like a grid (see screenshot)...

In Excel, the if then function - or if called formula - is one of the most helpful features. In this article we explain how you can use them optimally. If then function in Excel Not only is the formula useful, it can be complicated, especially for inexperienced Excel users who only use it occasionally...

Microsoft Excel can do more than just boring spreadsheets: With our ten free games, you can spice up the office program and spend boring hours in the office. 1. Excel game 2048 Smartphone owners have been enthusiastic about the game 2048 for a long time. Now the puzzle game is also available for Excel...

With Microsoft Excel you can create complex tables, large diagrams and extensive calculations. Here we show you where to find exercises with a solution. Excel exercises in IT course In addition to small explanations, you will also find numerous free Excel exercises on the following topics on the website "IT course": Calculate with Microsoft Excel: basic arithmetic and percentage calculation...

You have created several spreadsheets in Excel and want to combine them into one? In this practical tip we will show you how this works. Merge Excel spreadsheets: Using the consolidation function Latest videos Image 1: First select the cell in Excel in which the worksheets are to be merged. Then click on "Consolidate"...

Excel offers numerous functions and formulas. In this practical tip, we will introduce you to the most useful formulas and tricks. 1. Function: Fixed conditions for conditional sums With the function "SUMIFIF" you can set fixed conditions for conditional sums in Excel. In our example, we use data in cells A1 to A10 and the corresponding values ​​in cells B1 to B10 that are used for the condition. Th...

OneNote is a note-taking application that exists for Windows as well as an app for iOS and Android. In this practical tip, we give you tips for getting started with OneNote. OneNote Getting Started: Notebooks and Notes Instructions OneNote is a free notebook program from Microsoft. Up to the 2016 version, the application was also integrated in Microsoft Office, but development was discontinued...

Deleting a page from Word may seem cumbersome at first, but it's actually quite simple. This practical tip shows you how to remove a page from your document. Delete page in Word: Set draft view When deleting a page, always make sure that you are in the draft view. In the draft view, a page break is marked with a paragraph mark...

You need a non-breaking space if you want to prevent Microsoft Word from separating a word at the end of a line. It is particularly useful to use this function for names or titles. This practical tip shows you how to create a non-breaking space. Put the non-breaking space in Word Latest videos Make the non-breaking space visible in Word You can recognize a protected space by this Even if you write the text in justification, a non-breaking space is advisable for some words...

Word offers its own function for creating address labels. This is particularly useful if envelopes do not have a viewing window and you do not want to write down the address by hand. We'll show you how it's done. Instructions: Create labels and address stickers in Word Basically, creating a label is relatively easy...

Since completely empty lines can be annoying in Excel, you can simply delete them. We show you how it works. How do I delete blank rows from the Excel spreadsheet? To remove blank lines, do the following: Select the area where you want to remove the blank lines. Go to the "Data" tab and click on "Filter"...

It is not difficult to create templates in PowerPoint if you have familiarized yourself a little with the Office program. PowerPoint also provides you with numerous templates that you can modify according to your ideas. Create PowerPoint templates: preliminary considerations Before you start designing, make some basic decisions...

In addition to Word and Excel, Microsoft also offers less well-known software such as Access in its office suite. We show you what it is and how the program works. This is Access overview Access is a software from Microsoft. Like Word, Excel and PowerPoint, Access can also be purchased separately or in a complete Microsoft Office package...

Not every user is aware of the possibility of removing the password of a PDF. It is not difficult to get around the annoying hurdle. All you need is the appropriate instructions, which you can find from us. PDF: Remove passwords Adobe Acrobat Reader DC is one of the standard programs for PDF files. If they are password-protected, it is difficult to edit the file...

Word's automatic spell checker lets you easily change the language. This is particularly useful if you are writing texts in a foreign language, such as English. In this practical tip, we'll tell you how. Change the language for the automatic spell check You can not only change the language for all text in Word, but also for individual sections...

You can make your text paragraphs more beautiful with the automatic hyphenation. In this article we show you how to activate the feature in PowerPoint. Activate automatic hyphenation - is that available in PowerPoint? Unfortunately, there is no automatic hyphenation function under any PowerPoint version...

An animated GIF can be useful to loosen up a presentation. In this practical tip, we explain whether you can also insert animated GIFs into PowerPoint. Insert animated GIF in PowerPoint - how it works Of course, you can also insert animated GIFs in Microsoft PowerPoint. Simply do the following: First you have to select the "Insert" tab in PowerPoint...

If you want to move Microsoft Office to a new PC, this is quite easy with Office 365, Office 2013 and Office 2016. We'll show you step by step how this works. Office move: You should know that Before you start moving, you should make sure which version of Office you are using. There are slight differences depending on the version...

With a timeline in PowerPoint you can present various data in an impressive way. However, PowerPoint does not offer a tool with which you can automatically generate such a beam. We will therefore show you how you can still show a chronological course with a few clicks. Creating a timeline in PowerPoint - Instructions Open PowerPoint and select "Shapes" from the "Insert" main menu...

You know these chic Word Clouds and would also like to have them for your PowerPoint presentations. We'll show you how you can easily create them. Word Cloud in PowerPoint with an add-in Latest videos With the "Pro Word Cloud" add-in, you can create a Word Cloud in PowerPoint Make basic settings in the mask for the Word Cloud The add-in creates the Word Cloud from text in a slide In PowerPoint, you have the option of managing and installing add-ins in the "Insert" tab...

Microsoft has hidden the function with which you can insert PDF files in Excel in the depths of its menu navigation. We show you how to quickly integrate any PDF files into Excel. Insert PDF file in Excel: how it works step by step Note: To use the following function in Excel, you need the free Adobe Reader...

With just a few simple steps, you can quickly count the number of characters and words in the OpenOffice document. Here we explain how it works. How to count characters and words in OpenOffice First open the OpenOffice document. If you only want to count the words and characters of a certain section, you must mark it now...

A list of figures in Word is part of every scientific work and is easy to create. Whenever you insert tables, photos and graphics in the text or appendix, the directory must not be missing. List of figures in Word: Prepare graphics For a list of figures you have to format the graphics in Word and name them correctly: Right-click on the graphic and select "Insert caption"...

If you have exchanged or forgotten entire columns in Excel, you can add them between two other columns. We'll show you how to swap columns in Excel on Windows and Mac OS. Instructions: Swap complete columns in Excel First select the column you want to move. To do this, click on the letter at the top of the column header (see picture)...

If you want to prevent other users from accessing or editing an Excel spreadsheet, you can protect the file with a password. We will show you which settings this works for. Protect Excel spreadsheet with a password - this is how you proceed Latest videos Protect your Excel spreadsheet with a password How to set a password for your Excel spreadsheet on Windows In the following we explain the procedure for protecting your Excel spreadsheets...

You can use a checkbox that you insert in your Excel document as a form element or as a control element. We show you exactly how to proceed in order to integrate this "check box" by means of these instructions. Simply tick off: Checkboxes in Excel make forms clear Latest videos Insert checkbox in Excel: Activate developer tools Form elements: Select the checkbox symbol Edit the check box text To align to the grid In the standard Excel setting, you do not have direct access to the "Checkbox" button...

You can create a vacation plan very well with Excel. So you always keep an eye on the vacation of all colleagues or employees. Create vacation plan with Excel Open Excel on your PC. You can then create your vacation plan, for example: Use column A to provide the names of your employees. In the second cell of the first row (B1) enter the date, e...

With the write protection, your PowerPoint presentation is safe from accidental changes. We'll show you how to remove it. Powerpoint write protection: This is what it looks like If you open a PowerPoint presentation with write protection, the following message appears: "Enter the password to change this presentation"...

We show how you can change the menu language in OpenOffice and thus, for example, set the English language as the default language. OpenOffice: Download language packs You should download the language pack of your desired language in advance. To do this, open the OpenOffice installation page. Search for your desired language in the list eg English (GB) and click on the [exe] in the line "Langpack" and the column "Windows Intel"...

Would you like to write a detailed curriculum vitae in text form? We will give you the best tips so that you can shine with your application. Even if you think that writing is not your thing, our tips will help you get there. Correctly design a detailed CV in text form As the name suggests, the detailed curriculum vitae is a description of your career in the form of an essay...

Creating a keyword index in Word requires extensive preparation, but the directory itself can be created quickly. We'll show you how to add a keyword index to your document. Index in Word: Mark keywords Before you can create a keyword index, you have to go through your document and mark all the words that should appear in the keyword index...

In this practical tip we will show you how to update all fields simultaneously in MS Office Word. This saves you a lot of effort in large documents, since Word does not automatically update formulas, tables of contents and other dynamic content. Update all fields in Word If you want to update a field in Word, first mark it with a mouse click and then press the [F9] key...

Editing an Excel spreadsheet with multiple users is not a problem if you release the spreadsheet in advance. You can read how to do this in this practical tip. Share Excel spreadsheet - how it works After you have opened the Excel folder, click on the "Check" tab. In the ribbon of the spreadsheet, go to the last area "Changes"...

By default, Word divides tables when a page breaks, so the table is split into two pages. However, you can set the table to appear completely on the following page if it does not match the end of the previous page. We'll show you how it works. Word: Split table at page break First, we'll show you how to format your spreadsheet so that it automatically splits when you break a page...

This practical tip explains how to insert an empty column in Excel. How to get an empty column in your Excel spreadsheet (quick guide) Select the column you want to move to the right. Use the column letter for this. Right click on the selected column. Select the "Insert cells" option. The new column appears in your Excel document...

If you activate write protection in Excel, you can protect your workbooks with a password. We'll show you how it's done. Protect Excel file with password Open the desired Excel file and click on the "File" tab in the top right. Switch to "Information" in the menu bar on the left...

In Excel, you have various options for integrating a background picture. We'll show you how easy it is. Excel: insert background image Excel includes a function that you can use to insert a background image quickly and easily. However, you cannot edit this after inserting it. You should therefore cut it to a suitable size beforehand...

You can buy a product key for Office 365. Before you can download the software, you must first enter it. We'll show you how. Office 365: Enter product key Enter the product key on the Office website. Download this website in your browser and log in with your Microsoft account. If you don't have an account yet, you need to create a Microsoft account...

SmartArt graphics can be expanded as required in PowerPoint. You can find out exactly how this is done in this practical tip. Extend SmartArt graphics in PowerPoint - how it works You can customize SmartArt graphics with just a few clicks: In PowerPoint, first insert any SmartArt graphic using "Insert"> "SmartArt"...

If there are several data records in a Word table, you can divide certain lines. In this article we show you how it's done. MS Office Word: Split rows of a table To split a row of a table in "MS Office Word", you can either split the table into two parts from a certain position or expand the cells within a row...

If you bought Microsoft Office 2016, you have to activate the software after 30 days at the latest. We'll show you how activation works both online and by phone. Activate Microsoft Office 2016 online You need a free Microsoft account to activate it. It is only necessary for registration, you do not have to use it later...

Exchanging columns and rows of a table - i.e. rotating the table - is quickly done in Excel. Incidentally, in mathematics this operation is called transpose and, strictly speaking, is a reflection of the table on its main diagonal. But don't worry - the MS Office program Excel does the work for you...

You can easily sort tables in alphabetical order in Word. We'll show you where to find these settings. Word: Sort tables alphabetically These instructions were written with Microsoft Word 2010, however, there are only minor deviations from other versions: Open your Word document and select the table...

It is not difficult to add a page number to a Word document from page 3 onwards. Not even if the numbering should start with 1 instead of 3. We will show you how to do it. Step 1: break the Word document into sections To be able to insert page numbers from page 3 onwards, you first have to structure your document in sections: Click at the very end of the text on the second page...

If you need to create signs or notices in Word, you should do so in landscape format. Our tip shows you how to set the page layout in Word. Set page layout in Word to landscape Start Microsoft Word. In the top menu, select the "Page layout" tab (see screenshot). Then open the menu item "Alignment"...

To change the line spacing in Microsoft Word, just a few clicks are necessary. We will show you step by step where you can find the appropriate option. Changing the line spacing in Word: Instructions Latest videos Change line spacing in Word Word: Select line spacing individually Word: Button for the line spacing Highlight text in Word The usual line spacing of "1...

This guide shows you how to insert a line break in a cell in Excel. Insert line break in Excel cell There are two ways to insert a line break in Excel. Manual line break: If you want to insert a line break manually, press the key combination Alt + Enter at the appropriate point. You can now continue to write on a new line within the cell...

Switching on the overwriting of the text in Word is hidden deep in its settings. The function replaces any character to the right of the cursor with the newly entered character. Depending on which version of Word you are using, the steps differ slightly. Switch overwrite function in Word on and off The overwrite function is deactivated by default in Word...

There are numerous Unicode characters that you can enter in different ways. We'll show you the options. Find and enter Unicode characters Each letter and special character has a specific Unicode. This means that you can type in over 100, 000 characters on the computer if you know the correct Unicode...

If an Office application has problems, you can repair Office 365. This only takes a few minutes and can fix problems such as incorrect settings, defective plugins and other software errors. Repair Office 365 for errors - how it works Use Office 365, but suddenly an application like Word or Excel can no longer use as usual, it can help to repair Office...

If you have activated Office 365 in the wrong language, you can change the language at any time afterwards. We show you step by step how to do it. Instructions: Change language in Office 365 Open the Office 365 website and log in to your account. Click on the gear icon in the top right corner to open the "Settings"...

Office 365 is a great service for working together online on a document. To do this, you need to set up a public folder. You can find out how this works in this article. Create a public folder in Office 365 First you have to open OneDrive in your browser. Now you need a folder that you want to share...

In Office 365, you can share your calendars with others with just a few clicks. We'll show you how. Office 365: share calendars in Outlook - how it works If you want to share a calendar with Outlook, click on "Calendar" and then on "Start"> "Share Calendar". In the "To" field, enter the name of the person for whom you want to grant approval...

You can compare and merge old and newer Excel spreadsheets in a few simple steps without having to manually compare all data. You can find numerous complicated formulas on the Internet - we will show you how this works more easily. How to Compare Excel Spreadsheets (Quick Start Guide) To compare tables and remove duplicate content, use Excel as described in our quick guide...

In rare cases, LibreOffice can not be installed. We have summarized the most important solutions to the problem for you in this practical tip. LibreOffice cannot be installed - general information The first thing to check is whether your computer meets the minimum requirements for LibreOffice. These are quite low, so there shouldn't be any problems in most cases...

You can show and hide comments added in Word at any time. We show you where you can find the relevant settings and display the comments. Show and hide Word comments First, open your document in Word. Click on the "Review" tab. In the "Track" group, click the drop-down list. Select "Original" here so that the plain text is displayed without comments...

If you want to make your PowerPoint presentation more visually appealing, you can insert an unlimited number of images. In this practical tip, we will show you step by step how to do it. Insert pictures in PowerPoint - how it works Start PowerPoint and select the slide you want. Switch to the "Insert" tab above and select the "Images" item...

Inserting a signature into a Word document is especially necessary for business letters. But even with regular documents, a signature looks more professional. We explain how you can insert the signature in Word. Word signature easy to insert You can easily add a signature to a Word document. For the first variant you need a scanner or a smartphone with a document scanner app...

With MS Office Word, you can quickly convert table content into body text. You can find out how to do this in this practical tip. Convert table into text - how it works in MS Office Word Select the table that you would prefer to convert into continuous text. If you only want to convert a certain section of the table into text, mark this part with the left mouse button pressed...

Microsoft Office is usually updated automatically. However, if this does not work, you can update it manually. In this practical tip you will learn how to do it. Update Microsoft Office 2013 to 2016 To update your Microsoft Office manually, first open any application in the Office family: Create a new blank document...

If you want to insert a star smybol with your keyboard, you have the choice between many different stars. We present some symbols. Tap the star symbol on the keyboard You need a keyboard with a number pad to insert the stars. By pressing the "Num" or "Num Lock" button, you can type in the numbers there...

With Office 365, you can work anytime, anywhere on the device of your choice. In this practical tip, you can read how easy it is to install Office. Install Office 365: step by step for the PC Before you can install Office 365, you need to buy it from the Office Store and have a Microsoft account. You also have the option to test the software free of charge for 30 days in advance...

Mail merge can save you a lot of time in Word. If you send letters, invitations or anything else, you will appreciate the mail merge. Our instructions show you exactly how to proceed. Mail Merge for Labels in Word Instructions Almost all Office packages offer you the function of mail merge - from Word to OpenOffice...

If you want to add a caption in PowerPoint, you can do it with just a few clicks. In this practical tip, we will show you step by step how to do it. Add caption in PowerPoint - Here's how Once you have inserted the desired picture in PowerPoint, switch to the "Insert" tab above. In the "Text" category you will now find the "Text field" option...

In Word 2003, the landscape function is somewhat hidden. In this practical tip, we will show you how to switch from portrait to landscape. Set landscape format in Word 2003 - how it works To create a landscape document in Word 2003, click "File" and then "Page Setup". Under the heading "Orientation" you will find portrait and landscape format next to each other...

Watermarks can be used to mark or save papers - you can also add them in Excel. These instructions show you the individual steps. Add watermarks in Excel - the steps Since Microsoft has not yet integrated such a function, you have to take a small detour for the watermark. But that's not difficult at all: First open your document in Excel...

With Word, you can easily have a text read to you. We show you how to do this in this practical tip. How to set up the reading function in Word In order for Word to be able to read a text at all, you must first set up this function. Here's how: Open Word. Click on "File" in the top left and then on "Options" at the bottom...

If you want to get Office 2010, you should compare the individual versions exactly. We will tell you what Office 2010 costs and which versions are available in this article. Office 2010: The different versions can and cost that Home & Student: Available from 149 euros. Includes Word, Excel, PowerPoint, OneNote...

In Excel you can compare the date of different tables or within one table. In this practical tip, we will show you step by step how to proceed. Compare date in Excel - how it works First, copy the two rows with the dates in two columns next to each other. Then check whether Excel has recognized it as a date: Is the entry "Date" displayed in the dropdown menu via "Number" in the Start menu...

If you are a student, you can buy the cheap office for education to organize your studies. In this guide, we will show you how it works. How to set up your office for education First you have to register and prove that you are authorized to use the software: To do this, go to the Office for Education page and enter the validation key...

With a footer you give your Word document a professional look. We'll show you how to set the same footer on every page. Word: Set up the same footer on every page - how it works Business and other professional documents almost always have a footer. So that you do not have to label each page individually, we will show you below how to set up the footer on every page...

Creating a justification in Word rarely works without gaps. We'll show you how to remove the placeholders. Word: Format justification without gaps Start Word and switch to the "Page Layout" tab above. Under the "Page Setup" category you will now find "Hyphenation". If you set the function to "Automatic", the justification is formatted much better...

If Excel does not save, there are many problems, especially under Windows. We show you what is possible and then present the solutions. Excel does not save - it can be because of that Excel may have problems saving a file for the following reasons: You no longer have access to the original location. This can be the case especially with network drives or USB sticks...

Changes can be easily tracked in the Excel spreadsheet. This practical feature of Excel is particularly useful for tables that are used for the long term as well as for jointly edited tables. Record the changes in an Excel table in three steps The steps below refer to Excel 2010, but are similar in the other versions...

Even if you uninstall Microsoft Office from your computer, the MSOCache folder remains. The data stored there comes from the installation of the individual office programs. Even if you are still using Word and Co., you no longer need these files. We will therefore show you how to delete them. Microsoft Office: Remove MSOCache The folder only contains a few Microsoft Office installation files that were transferred from the CD to the PC for faster installation...

In order to insert a 0 in front of a series of numbers in Excel, you have to do a little trick. Phone numbers, postcodes and other numbers are then displayed correctly. We'll show you how to do it. Postal code and phone numbers: How to insert a 0 before Excel number series Right click on the cell and open the "Cell Format" and select "Custom" from the list...

Individual values ​​can not only be entered manually in Microsoft Excel, but also using a slider. It is not difficult to create one, although the associated option is well hidden. We show you how to do it. View developer tools in Microsoft Excel The option for the slider is located in the so-called "developer tools". Th...

Document templates are often identified with the word "pattern". In this practical tip, we explain how to remove this and other watermarks from Word. Remove watermarks from Word documents Watermarks can be removed from all Word documents in just two steps: Navigate in the menu bar under "Format" via "Background" to the menu "Printed Watermark"...

Outlines allow you to record main and sub-items on your slides in PowerPoint. We'll show you how easy it is. Create sub-items in PowerPoint How to create sub-items with PowerPoint from version 2010: Start a new presentation in PowerPoint and navigate to the "View" tab. In the Presentation Views group, click Outline View...

If you have created a file with Microsoft Publisher, you can also save it as a PDF or convert it later into a PDF file. We'll show you the options. Publisher: Convert files to PDF If you can currently access Microsoft Publisher, the easiest way to save the file is directly as a PDF. Alternatively, you can start a conversion online on various websites...

With an organization chart you can, for example, show the structure in a company. This practical tip shows you how to create one with Microsoft Visio. Create organization chart with Microsoft Visio An organizational chart illustrates the hierarchy in a company. To create an organization chart with Visio: Start Microsoft Visio and select the "Categories" tab...

With the Microsoft Access office component, databases can be created quickly and easily. Before doing so, you should think about what data the database contains and what purpose it should serve. Access gives you three easy ways to create a database. Microsoft Access: Create database with the wizard The database wizard helps you to create a database...

With Microsoft Visio you can quickly create your own drawings using so-called shapes. This practical tip shows you how to create your own shape. Create your own shape with Microsoft Visio You can reuse your own shape in all of your Visio drawings without having to completely redraw each time. To create your own shape, you have to do the following...

If you use several pictures or graphics on a PowerPoint slide, you can quickly create order by aligning the objects. We'll show you how it's done. Align objects in PowerPoint First click on the desired object in PowerPoint. You can align graphics, text, images and other content. Go to the "Format" tab above and look for the "Arrange" category...

You can use a flowchart to clearly illustrate processes in a process. This practical tip shows you how to create a flowchart with Microsoft Visio. Create a flowchart with Microsoft Visio To create a flowchart with Visio, you need to do the following: Start Visio and click on the "Categories" tab...

In this article we will show you how to search and replace words in MS Office Word. You will always find the same words or combinations of characters and can change them throughout the document. Search Word documents for words With Word Search you can browse entire files. You can either search the entire document, start the query for individual pages or limit your search to the headings: To do this, click on the "Start" tab and select the "Search" entry in the "Edit" area...

With Microsoft Access, you can quickly create a local database at home. In this practical tip, we have explained the if-then function in Access in an understandable manner. If-Then function in Microsoft Access simply explained The if-then function breaks down the three sections and looks like this: if ("condition"; "if true"; "if false")...

You can also discover one or two surprises in Word - so-called Easter Eggs. Unfortunately there are fewer of them with every new version of Word, since they usually represent small security holes. We show you the three best and most extraordinary Eastereggs in Microsoft Word. Easter Egg 3rd place - The Word Cursor 2...

You only need the header on the first page in the Word document. In this article, we show you how to set this up at Office Online. How to set up the header in Word With "Office Online" from Microsoft you can create and edit free Word documents in the browser. First open the document. Go to the "Insert" tab at the top and select "Header and footer"...

Regardless of whether for school or for university studies - you often have to deliver a handout for complex work. In this practical tip, we explain what a handout is and what information it should contain. Handout - what is it actually? A handout is a rough summary of a work, such as a presentation...

Free access templates can save you a lot of work, since they already contain queries, relationships, forms, macros and reports in addition to the corresponding tables. Therefore, the Access database templates are also ideal for database beginners, both for practicing and for building your first own database...

If you still need a cover page for your Word document, you can select it from a template or create it yourself. We'll show you how. Create your own cover page in Word Open the desired Word document and switch to the "Insert" tab at the top. Select the category "Cover page" at the top left and select a desired variant...

Microsoft Word allows you to use custom templates. This practical tip shows you where you can find the location of the Word templates. Word template: Here is the location on the PC Word 2016 provides templates right from the start, so you don't have to look far for the location. If you still want to know where your Word templates are stored, do the following: Open a new Word document...

With your own shortcuts, you can equip Word with individual key combinations and thus make your work easier. Here we show you how to program shortcuts for the word processor. Work faster - own shortcuts in Word To define your own shortcut, for example to give the "Insert footnote" option a quick selection, proceed as follows: Open Word, navigate in the tab to the point to which you want to assign a shortcut (for example, click the "References" tab for footnotes)...

The OneNote note app is pre-installed in Windows 10. In this article we show how you can uninstall the program. Uninstall OneNote on Windows 10 OneNote cannot be uninstalled on Windows 10 like other apps by right-clicking on the tile. Instead, you have to intervene in the system via the so-called powershell: Press the key combination [Windows] + [R] so that the Run dialog opens...

OneNote appears on both PCs and mobile devices. In this article, we explain exactly what OneNote is and what the note app can be used for. OneNote simply explained: Microsoft's note app OneNote is a software from Microsoft that can be used as a digital notebook. You can create as many notebooks as you want in OneNote and divide them into individual pages and sections...

In this practical tip we explain how to count graphics or images in Word. Word: Count graphics or images There is no direct way to count graphics in Word. However, you can make it easy for yourself. To do this, save the document as an html file. To do this, click on the Office icon in the top left and select "Save As"...

The curly bracket is a commonly used special character in Excel. In this practical tip you will find out which shortcut you use to conjure up the braces in your table. Excel: Shortcut for braces To write an opening brace on your Windows computer, press [Alt Gr] and the [7] key at the same time. For the closed bracket, press [Alt Gr] and [0]...

In addition to the usual "quotation marks", you can also insert square quotation marks »« in Word, so-called guillemets. However, this only works with a trick. In our practical tip, we will show you how to insert the square quotes. Enter square quotes in Word Press the [Ctrl] and [, ] (comma) keys simultaneously. ...

In Microsoft Word, you can use shortcuts to insert the date and time. These can be static or update dynamically. In this guide, we will show you how this works. Insert date and time with shortcuts in Word With just two shortcuts, you can insert the date and time in Word. Two further shortcuts update or fix the entry...

Mirroring an image in Word is not that difficult. In this practical tip, we will show you how it works. Mirror images in Word Open Word and select the picture you want. Use the image tools at the top of the screen and select the "Format" item in the "Arrange" area. Click the rotate icon (see screenshot)...

In Microsoft Office Word you can insert a caption for pictures. This practical tip explains how this can be done in just a few steps. Insert caption in Word - this is how you do it From the Word menu bar, choose Insert> Graphics> Insert Graphics. Then find an image of your hard drive and click "Insert"...

To convert PDF files to Word documents, you usually need a separate tool. After all, the PDF format is also intended to save documents and protect them from editing. In this practical tip, we present you with a free download and an online tool with which the conversion can still be carried out quickly and easily...

There are a few ways to write an inverted exclamation mark in Word. In addition to a simple key combination, you can also select the special character in the menu or create your own combination. We present the options to you. How to write an inverted exclamation mark in Word The special character, which is often used in Spanish, is not noted on the German keyboard...

You can easily write notes in Word, for example for music lessons, work analysis or reviews. Read here how it works. Install the correct font for writing notes in Word Although many symbols are represented in the international Unicode character encoding system, the corresponding character is stored in very few TrueType fonts...

If you enter your vacation in the Outlook calendar, for example, your work colleagues can see immediately if they are not available. In this practical tip we will show you how. Enter vacation in Outlook To enter your vacation in Outlook, proceed as follows: Open Outlook and select the calendar. Then click on "New appointment"...

If you are looking for software that allows you to create a tree diagram for free, you have a choice. You can either create tree diagrams using Microsoft PowerPoint. On the other hand, the freeware "yEd Graph Editor" also offers many functions for creating tree diagrams. Create tree diagram in PowerPoint If you want to create a tree diagram for a presentation, you can create it directly in PowerPoint...

A PDF document with many formulas and tables can be converted into Excel and edited there. With a special converter, this process is completed in a matter of seconds and is also child's play. Convert PDF to Excel with software If you want to convert PDF to Excel, the free "PDF To Excel Converter" is a good help...

In order to correctly add hours and minutes in Excel, for example, for calculating your working time, you only need a small trick. Add hours and minutes correctly in Excel Click on the cell (as shown in the picture) in which you want the total hours to appear later. Go to the "Format" button under the menu bar and then to "Format cell ...

If your computer does not have the old German font, you can set it up in Word after a short installation. We'll show you how it's done. Word: Write in old German script Open the website Schrifarten-Fonts.de and choose the desired version of the old German font. If you have found a suitable variant, click on the "Download" button to the right of it...

Word already has many print templates ready for you to create business cards. You can download this and then only have to enter your company name, company logo and address on the cards. Read here how it works. Create business cards using templates Open an empty Word document and click on the "File" tab and then click on "New"...

This guide shows you how to add a chic font to your Word. Word: Spice up your documents with attractive fonts You don't have to do much to enrich your word processor with new fonts: Open the "Control Panel" and select "Appearance and Personalization". Then click on "Fonts"...

If you want to change your email signature in Outlook or create a new one, it's very easy. Although the feature is somewhat hidden, you don't have to look far for it. Change or create new email signature in Outlook Use the following procedure to change the signature or create a new one. Click "File" in the top left...

If you enter a number in Excel, you can also define it as text. However, for Excel to be able to make correct calculations, numbers must be declared accordingly. If you work with an Excel file in which numbers have been defined as text, there are options to convert them back into effective numbers. Convert text to numbers with troubleshooting If you enter a number in a cell defined as text, Excel displays this as an error with a small green triangle in the top left of the cell...

With the V-reference, Excel provides a versatile function. The VLook searches the first column of a search area and scrolls to the right to return the value of a cell. The best way to explain how it works is with an example. Components of the V-reference in Excel Each function has certain parameters for which you can determine values...

There are different ways to insert the "corresponds" sign in Word. If you often deal with numbers, it is good to know where such mathematical operators are hidden. Corresponds to characters via the symbol selection In Word you can insert all sorts of things, including countless symbols. Follow the instructions to find and insert the "Matches" sign: Click the "Insert" tab...

In Outlook 2013, many users seem to have problems setting up the synchronization of their IMAP accounts. Among other things, each folder must be clicked individually so that it is synchronized. Not only is this tedious, but emails can also be lost if you don't remember to manually sync the folders...

Setting a filter in Excel makes data sheets with many entries much clearer. And this is how it works. Set a filter in Excel To set a filter: Go to the "Start" tab. The "Sort and Filter" function is located on the far right of the Excel ribbon. After clicking on it, select "Filter" from the drop-down menu...

With long texts in particular, you may want to set up and configure the individual pages of a Word document. A little trick brings the "Page Setup" window to your screen quickly. Shortcut to "Page Setup" in Word Normally you have to torture yourself through the Word file menu and call up "Page setup"...

With pivot tables, you can display large amounts of data clearly and analyze them more easily. In addition, all questions that begin with "How many" or "How much" can be answered. For example: "How much revenue did a company generate in the 3rd quarter of 2011?" Create pivot table - how it works Before you can create a pivot table, you have to enter your data...

It is worthwhile to create a dropdown list in Excel if you only want to enter fixed values ​​in a field. This means that you don't have to write the values ​​again and again, you simply select them from the list. Click the "File" tab in the top left. Now click on "Options" in the left sidebar. In old...

You can find out here how to paste unformatted text copied from the clipboard into Microsoft Word. For example, formatting such as fonts, italics or HTML links are not taken into account in your Word document. Copy-paste in Word texts without formatting Depending on where the text in your clipboard comes from, Word has different options for formatting an inserted text passage...

Variance and standard deviation can be calculated in Excel using two fixed Excel formulas. So you no longer have to insert the values ​​into the formulas yourself. Using an example, we will show you how to proceed most effectively. 1. Create a table of values ​​and calculate the mean First, enter the values ​​whose variance and standard deviation you want to calculate in Excel. In this ex...

A weighted average is easy to calculate in Excel. In this article we show you how to do it. Excel: calculate weighted average - how it works To calculate the weighted average in Excel, you need the "Sum product" and "Sum" functions. The average depends on the weight you assigned. Example: You want to calculate the average price of a pencil...

Time spans of all kinds can be easily calculated with Excel. In this practical tip, you can read how to calculate the times. Calculate with clock signs - input and format in Excel In Excel, every time entered corresponds to an absolute value. A day has the value 1. 12 hours is therefore 0.5. In order for Excel to recognize that your entry is a time, you must enter it in the format hours: minutes...

In Excel you can use the Msgbox in VBA. We have summarized all information about this feature for you here. MS Office Excel: How the Msgbox works Thanks to the Msgbox you can output and create messages with Excel VBA. Use the following code for a simple message: "Sub Msg_exe () MsgBox" Message...

There are two ways to save an Excel spreadsheet as an image. We'll show you both in this guide. Create an image of an Excel spreadsheet In Windows from version 7 you will find the practical snipping tool with which you can quickly take a screenshot. Then, if necessary, edit the image with an image editing program such as Paint...

Inserting an Excel spreadsheet in Word is child's play once you have the trick out. There are two different ways to copy your spreadsheet into Word. Read here where the differences are and what you need to consider in this process. Insert the Excel table as an Excel table in Word It is possible to copy an Excel spreadsheet into your Word document and have it linked to the source file...

In Word you can insert arrows in different ways. In this practical tip, we will show you two different approaches. How to insert arrows in Word Open Word and switch to the "Insert" tab. Then select "Shapes". Depending on the version of Word, you will now see a bar similar to the one in the screenshot...

In PowerPoint presentations, inserting hyperlinks is helpful in many situations. With one click you can switch from the presentation to a website or call up a document on the PC. We will show you step by step how to insert the hyperlink. Insert hyperlink in PowerPoint presentation First select the text or the object with the mouse that should have a hyperlink...

With an endless presentation in PowerPoint, you can create simple picture shows, for example for trade fairs or exhibitions. So you don't have to start the presentation manually again and again. In this article we will tell you how you saved yourself this unnecessary work. Endless loop in PowerPoint - how it works Open the "Slide Show" tab in PowerPoint...

If you want to back up your signature from Outlook externally or transfer it to another computer, you must first find the location. We'll show you where to find the file. Open the location of the Outlook signatures Press the [Windows] and [R] keys simultaneously so that the "Execute" command opens...

If you want to use Outlook on another computer, you have to export the signature manually from Outlook. In this practical tip, we will show you how to do it. Export & import signature in Outlook - how it works Note: Make sure that Outlook remains closed for all processes. Otherwise complications may arise...

In Word it is not so easy to hide individual page numbers: changes to the page numbers always affect the entire document. With a little trick it works anyway. Word: Hide page numbers of individual pages In order for the consecutive numbering to be broken, you have to divide your text into individual sections...

Microsoft Outlook has an offline mode. This is especially useful on the go - Outlook shows you annoying error messages without an internet connection. In this practical tip, you will read how to activate offline mode. Activate offline mode in Outlook 2010 and 2012. Open Microsoft Outlook as usual. Click the "Send and Receive" menu...

If you would like to convert a PowerPoint presentation into a PDF, you can do this both with PowerPoint and via a service in the browser. We'll show you how it's done. Save PowerPoint presentation as PDF Powerpoint 2013, 2010, 2003: Open the PowerPoint presentation and click on "File" in the top left corner of the screen and then on "Save As"...

In this practical tip, we will explain how to shrink Word documents. Compress images in the Word document to shrink files You can shrink Word documents if they contain images. Double-click on the image to be reduced in the Word document You are now in the "Image Tools" - "Format" tab...

If you activate the spelling checker in Outlook, every mail is checked for spelling errors before being sent and then corrected. We'll show you where to find the function. Enable spell checking in Outlook 2013 and 2010 Start Outlook and click the "File" tab at the top left of the screen...

If you want to print on index cards with Word, you have to set a certain page format and insert the paper correctly. We'll show you exactly how it works. Step 1: Select index card format in Word Various file card formats are pre-installed in Word. You can choose from them or create your own format...

If you want to create an organizational chart for your company, association or other institution, you can use the numerous format templates at PowerPoint. In just three steps you have created a professional organization chart with MS Powerpoint. Step 1: Find the template in PowerPoint In Microsoft Office Powerpoint 2007 on Windows 7, you create an organization chart as follows: Open a new project in Microsoft Office Powerpoint and select an empty slide...

If you cannot find the key for your Office 2013 installation, free software will help you to read the key. We'll show you how it works. Read product key in Office 2013 Simply download the free ProduKey tool and open the ZIP file. Now open the EXE file it contains and confirm the security warning by Windows...

Word does not always have the text in the right place in a table. This practical tip shows you how to align the text so that it is centered, right-aligned or left-aligned in the cell. Align text in a Word table - how it works First select the entire cell content you want to align. If several cells are to be changed, you can mark them with...

A list of abbreviations is often required in scientific work. You can read how to create one in Word in this practical tip. Word: Create a list of abbreviations First of all you have to add all abbreviations in your text to the index. Select an abbreviation and press the key combination [Alt] + [Shift] + [X]...

PDF files can also be easily edited under Windows 10. This practical tip shows you which software can open and edit PDFs. Edit PDFs in Windows 10 - with this tool it works How to edit your PDF files for free on Windows 10: For this you need the free tool Foxit Reader, which you can download from our download area...

You can also make a data source for a Word mail merge from an Excel spreadsheet. Create an Excel file as usual and fill it with data. We explain the further steps in this practical tip using an example. Word mail merge with Excel as data source For the example, first create an Excel file according to the graphic...

To keep LibreOffice up to date, you should regularly install the available updates. We'll show you how. LibreOffice: How does the update work? Start any LibreOffice program, for example the LibreOffice Writer. Click on "Help" at the top of the menu bar and select the "Check for updates" option...

You can easily insert square brackets in Word. We'll show you where to find the square bracket on the keyboard and how you can insert special characters in Word. Find square brackets on the keyboard No matter whether you need the brackets in a Word document or want to insert them elsewhere - the way is always the same: For an opening square bracket, press the key combination [Alt Gr] + [8]...

The formatting characters in Word can be very helpful, but also annoying. Therefore, you can quickly show and hide the characters. We show you how to do this. Word texts with and without formatting characters In Word, first select the "Start" tab. In the ribbon, switch to the "Paragraph" section...

You can use an automatic feature to create a table of contents from your PowerPoint slides. However, Microsoft has abolished this since version 2007. We'll show you how to do this for the table of contents instead. Create a table of contents for PowerPoint First create all the slides and only then start creating the table of contents...

In Microsoft Word you can insert and center images, among other things. In this practical tip, we explain step by step how to center already inserted images. Center images in Microsoft Word Even if several versions of Microsoft Word already exist, the processes for processing the images are mostly identical or differ only slightly...

Using the print preview in Word, you can check the layout again before printing. In this guide, we show you how to open the side view. Open side view in Word 2010 You can find the page view in Word 2010 by clicking the "File" tab. Then select the "Print" option. In addition to the print settings, you get a view of your Word document in a page view...

If several people edit a Word document, the "Track changes" function is extremely helpful. We show you how it works and what you should consider. Track changes in MS Word Open the document and go to the Review tab at the top. Now click on the "Track changes" button under the "Tracking" category...

If you want to transfer your Outlook contacts to a list, you can export the mail addresses from your inbox. We'll show you how. Outlook: Export mail addresses from the inbox Open Outlook and click the "File" button in the top left. There, select the "Import / Export" option under the "Open and export" menu item...

The logic operations in Microsoft Excel offer you a lot of functions, such as the unequal condition. Knowing how to use the functions correctly will make your daily work with the spreadsheet much easier. Unequal condition: Manual entry of the formula in Excel Latest videos Fig. 1: Check the content of a cell using the Excel unequal condition Fig...

With Word document properties, you can add more information to your files. In this practical tip, we explain how you can change the properties quickly. Change document properties in Word - how it works Open a document in Word and click on the Office icon in the top left. In the open display, select the "Prepare" entry...

If you no longer wish to use the World of Fitness offer, you can terminate the contract with WOF. We'll show you how it's done. World of Fitness: Submit termination to WOF Depending on the tariff booked, the contract term is up to 12 months. The notice period also varies depending on the tariff...

If you no longer wish to receive the newspaper subscription from the Akademische Arbeitsgemeinschaft Verlag, you can cancel it at any time. We'll show you how it's done. Cancellation of the Academic Working Group: You have to know that The contract period for magazines and magazines is 12 months...

Creating a table of contents in Word can often be tedious if you manually type in chapter headings and page numbers. Word's table of contents templates make it quicker and easier. The automatic table of contents is a great help, especially for longer work, and prevents incorrect page numbers or headings from creeping in at the end...

If you no longer want to read the Ruhr Nachrichten in the future, you can cancel the newspaper at any time. We'll show you how it's done. Terminate Ruhr Nachrichten: You have to know that Irrespective of the contract term, the notice period for the Ruhr Nachrichten is three months. If you do not cancel in time, the subscription will be extended for another period and will only be terminated after that...

Never lose word texts again? The automatic backup copy makes it possible. In this practical tip, we show you how you can always have these created automatically. How to make the auto backup in Word Open an empty Word document and click the Office button in the top right corner. Now you have to click on the "Word Options" and then select the "Advanced" tab...

If you want to work with your colleagues on an Excel file, problems and conflicts with Excel often arise. We will show you what you have to set so that the joint processing goes smoothly. Share the Excel file for editing Before you can work on an Excel file with several people, you have to release it...

If you would like to cancel your subscription to the newspaper Bild + Funk, we will present you with various options. We will also show you when you can exercise a special right of termination. Terminate Bild + Funk: You have these options You can cancel a subscription at any time after the minimum term has ended...

If you no longer want to use your account at Netbank, you can cancel the account and change providers. We'll show you how it's done. Instructions: Cancel your account at the Netbank There is no notice period for bank accounts. You can cancel the Netbank account at any time. However, it is advisable to have a new account with another bank before you cancel...

If you no longer wish to receive the auction catalogs of Data Info Service Eibl GmbH, you can cancel the subscription. We'll show you how it's done. Termination at Data Info Service Eibl GmbH - all information The subscription period is always 12 months. The notice period is two weeks. If you do not cancel the contract in good time, it will be extended for another 12 months and will only be terminated afterwards...

If you no longer want to read the Rheinische Post regularly in the future, you can cancel your subscription. Read here about the deadlines to be observed. Rheinische Post: With these deadlines, you cancel properly A subscription to the Rheinische Post is initially concluded for 24 months. At the end of the term, you can terminate the subscription to the newspaper with a period of two months to expire...

If you no longer need HanseMerkur travel insurance, you can cancel the contract at any time. We'll show you how it's done. Cancel travel insurance with HanseMerkur: All information If you only have travel insurance for a specific trip, you do not have to worry about cancellation. Insurance ends automatically...

If you no longer wish to use your VIABUY credit card, you should cancel it so that there are no further fees. We tell you what you should consider. VIABUY credit card: How to cancel properly The first time you order a card, the term is two years. If the credit card is not canceled afterwards, the term is extended by a further 12 months...

If you no longer wish to receive magazines from Gong Verlag, you can cancel your subscription at any time. We'll show you how it's done. Cancel Gong Verlag - all information As a rule, Gong Verlag offers subscriptions with a term of one year. If you do not cancel in time, the subscription will be extended for another year...

If you want to cancel your contract with 123energie, you have to consider a few things. You can find out what they are here. Terminate energy - how it works There are a few things to consider when terminating your contract with 123energie. You can cancel the contract at 123energie with a period of six weeks to the end of the contract...

If you would like to cancel your credit card account with Hanseatic Bank, you can do so at any time. We show you which requirements have to be fulfilled and how you can best proceed. Account at the Hanseatic Bank: cancel the card at any time You do not have to give notice if you want to cancel your credit card account with Hanseatic Bank...

In Word you can easily insert form fields, at least if the function has been activated beforehand. Read how this works in this article. Insert form fields in Word 2007 - a video tutorial Form fields in Word 2010: Integrate "pre-version tools" Open Word. Then click on "File" and then select the "Options"...

You can also create flowcharts in Word that are used to visualize a data flow. This practical tip shows you how to find, insert and edit the symbols. How to create a flowchart in Word If you often have to create elaborate flowcharts, it is best to install the appropriate software. The Office package also contains programs that are much more suitable than Word for creating a flowchart...

Compress the pictures in PowerPoint presentations, reduce the file size and make it easier to send the presentation by email. We'll tell you how this works quickly and without a reduction in quality. Compress PowerPoint images - how it works First click on the image whose file size is to be reduced...

If you no longer wish to use the pleasure agent service, you can terminate the contract at the end of the term. We'll show you how it's done. Terminate lust agents: You have to know that The contract term for pleasure agents varies between the different tariffs. However, the notice period is always 14 days...

If you have opted for a different health insurance policy, you can cancel the contract with Huk-Coburg. We'll show you how it's done. Cancel health insurance from Huk-Coburg - Here's how The health insurance of Huk-Coburg generally has a contract term of 12 to 24 months. The notice period is 3 months...

If you no longer wish to subscribe to the Westfälische Nachrichten, you can cancel it at any time. We'll show you how to do it and what to look out for. Westfälische Nachrichten quit: You have to know that Depending on the subscription, the notice period for Westphalian news differs: If you have a classic newspaper subscription, it has a minimum term of 12 or 24 months. ...

For some documents it is necessary to change the format in Word beforehand. In addition to the normal A4 page, you can also switch to landscape or a sheet in A5. In addition, styles allow faster creation of attractive texts. We have all the information in this practical tip for you. MS Word: change format - how it works Start Word and go to "Page layout" at the top of the tab...

If you would like to switch to a cheaper provider, you can cancel ERGO's car insurance. We'll show you how it's done. Canceling car insurance at ERGO: All information As a rule, car insurance always runs for a whole year, from January 1 to December 31. The notice period is always one month, so you must submit the notice by November 30th...

If you use the Word clipboard correctly, you will work much more efficiently. We give you the best tips for this in this practical tip. Use Word clipboard correctly - all information In the "Start" tab, click the arrow in the lower right corner to display the options. You will then see which elements are on the clipboard...

In Word you can create your own bullets. You can read how to do this in this practical tip. Create your own bullets in Word - how it works First, click the bullet icon as usual to start a new bullet. Now mark the bullet by clicking directly on the character several times. If it is selected, the list symbol in the menu bar also turns gray...

Microsoft Word contains a practical tool that hardly anyone knows: You can sort lines with just a few clicks. You can choose between alphabetical or numerical. We show you how to use the tool correctly. Sort lines in Word alphabetically or numerically In order to use the sorting tool, you must have several paragraphs in your document...

If you want to cancel your subscription to the Sächsische Zeitung, it is quite easy and without much effort. We'll show you what to look out for and how best to proceed. Sächsische Zeitung cancel: Interesting facts about the subscription With the subscription to the Sächsische Zeitung you can choose between different payment methods. I...

If you don't like the current paragraph spacing in Word, you can set it as you wish. In this practical tip, we will show you how it's done. MS Word: Set paragraph spacing - how it works Go to the "Design" tab above and you will find the "Paragraph spacing" category there. You can now select various options here...

Many special characters such as the sun symbol ☼ cannot be found on the keyboard. Nevertheless, you can enter it with a key combination or insert it into your texts in another way. Enter the sun sign using the keyboard You can only enter the sun symbol ☼ on keyboards with a number pad. To do this, hold down the [Alt] key to the left of the spacebar. At...

With the right key combination, you can write eighth notes ♪ and double eighth notes ♫ on your keyboard. We'll tell you how to do it. Write notes ♪ ♫ on the keyboard You can only enter the two note characters ♪ ♫ on keyboards with a numeric keypad. This way works on both Windows and MacOS. To do this...

Word hyphenation sometimes does not work as intended. This is mostly due to the wrong attitude. We give you tips on how to set hyphenation correctly. Hyphenation doesn't work - Word Tips The fact that the separation does not work may be due to the fact that the corresponding areas are not formatted correctly...

Especially if you need help with an Office product, it is good to know which version of Office is running on your PC. We'll show you how to find out. Which version of Office do I have? - The user interface tells you The easiest way to identify the version of Office installed on your computer is the user interface, which is different in each edition...

With Word 2016, you have to go through "Save As" every time before you can choose where to save it. You can remove this step if you want to get to the file path immediately. Word 2016: How to open the Explorer directly with "Save As" Many users find it annoying that they always have to take an extra step to "save as"...

A chic letter paper is part of the perfect letter. Read here where you can find such stationery templates in Word. Find the right stationery in Word MS Word already has some samples for stationery. You just have to download it: In the open Word document, go to the "File" menu button and then to the "New" button on the left...

If you want to insert several empty rows into an existing Excel spreadsheet, you can easily do this using the "Insert cells" command. In this practical tip, we will show you exactly how this works. Insert multiple blank lines in Excel - Here's how Mark the desired line by clicking on the number on the front of the worksheet...

In Excel you can calculate the correlation between two variables and establish a connection. A simple formula will help you do this. Calculate correlation coefficients You can calculate the correlation in Excel using the formula "= CORREL (Area1; Area2)". Each area represents a variable. You can calculate the correlation coefficient between the values ​​in A1 to A6 and the values ​​in B1 to B6 with "= CORREL (A1: A6; B1: B6)". The re...

Text wrapping is enabled by default in PowerPoint. In this practical tip, we explain how to prevent the function. Disable text wrapping: edit formatting of the shape Right-click the text box in which you want to prevent the text wrapping. In the opened menu, select "Format shape". Mark the tab "Text field" on the left...

If you want to guide the reader through your Word document, the best way to do this is to insert cross-references. We'll show you how it's done. Word - insert cross-reference We use Word 2013 in this practical tip. Under other Office versions, the individual functions can be labeled and arranged differently...

In this practical tip, we will explain how to change the unit of measurement of the ruler in Wordpad. Inches, centimeters, points or pica - change the unit of measurement of the ruler in Wordpad Open the Wordpad. Click on the "View" tab. Then click on "Units of measurement" and select your desired unit of measurement...

If you want to insert barcodes in LibreOffice, you need an additional add-on. We'll show you how it's done. LibreOffice: insert barcodes The add-on is currently still in the test phase and can therefore still cause problems. To use it you also need a relatively current version of LibreOffice...

You can prevent word wrap in Word with just a few settings. We show where you can find them and switch off the break. Microsoft Word: Prevent line breaks In some cases, Word inserts a line break, although this is not desired at all, for example when specifying sizes, street names or units. However, the line break can be prevented very easily, here are two simple methods: If you want to prevent the line break behind a space, you can enter a so-called "protected space"...

If you would like to terminate your sales contract with PM-International, you have several options. We'll show you what these are in this practical tip. PM-International: Cancel the contract correctly A contract with PM-International is a distribution contract with specific deadlines. The contract runs indefinitely, so it does not end automatically...

There are several ways to cancel HanseMerkur health insurance. We tell you what to look out for when terminating the contract in order to terminate the contract with legal certainty. HanseMerkur: cancel health insurance correctly In order to terminate the insurance with HanseMerkur, you can use the special termination right in addition to the ordinary termination if your contributions have been increased...

If you no longer wish to receive contact lenses from iWear Direct, you can cancel the contract at any time. We'll show you how it's done. Cancel iWear Direct: You need to know IWear Direct does not have a fixed contract term. The notice period is only 15 working days. Submit the cancellation to iWear Direct, so you will receive a maximum of one more delivery...

If you want to cancel your membership in the German Armed Forces Association, you have to consider a few things. We will show you what is important and how best to end the contract. German Bundeswehr Association: Cancel in time You must observe a notice period with the German Bundeswehr Association. You can cancel at the end of a calendar quarter, i...

If you would like to cancel your building society contract, you can terminate the contract at any time with the Badenia building society. We'll show you how it's done. Cancellation by the Badenia building society: All information Depending on the contract, not only the minimum term differs, but also the notice period for the home savings contracts...

If you no longer wish to read GLAMOR, you can simply cancel your subscription to the magazine. We'll show you how it's done. Cancel subscription at GLAMOR: All information With GLAMOR you can take out an annual subscription and a mini subscription through 3 magazines. After the expiry of this contract period, you can cancel at any time, so that in the best case you will receive no or only one more edition...

You can delete created comments in Word at any time. This prevents too many comments from confusing your document. The procedure for deleting is the same for all versions of Word. Delete comments in Word With the comments in Word, you can take notes on individual passages of text and point other editors to certain points...

You can easily open CSV files with MS Excel. We present two methods - a simple one and a more sophisticated one for more complex CSV files. Very simple: Open CSV file from Excel Latest videos Image 1: Import CSV file into Excel - Click on "Open" under the "File" tab Image 2: You can now open the desired CSV file with a double click If you want to import a CSV file into Excel, you can do it in two different ways...

An aborted study may not be pleasant, but it should still be on your CV. In this article, we show how you can correctly enter the relevant information. This means that an aborted course of study is not a disadvantage In your CV, you indicate your previous professional career and previous education. The information should always be complete...

The reader should remember the first sentence of your application. It is therefore particularly important that you find a good start for your cover letter. Our article will help you. This is what matters in the first sentence of your application Everything is pure formality, but in the first sentence of your application letter you have to arouse the interest of the HR manager...

On the resume, you should provide different knowledge and skills to qualify for a job. However, it is better not to write down some knowledge. Find out more about the dos and don'ts in your resume here. Knowledge and skills in the curriculum vitae: what should not be included A CV only includes the skills and knowledge that are really useful or meaningful for the position advertised...

If you want to convert your PowerPoint presentation into a GIF, this works directly in PowerPoint and also externally via a website. We present you with both options. PowerPoint: Convert slides individually to GIF files Open the presentation and click on "Save As" in the upper left under "File"...

The curriculum vitae is the heart of an application - the form must be right. Fortunately, you can find templates for the most common types of CVs right in Word. There are templates for tabular or functional CVs, CVs in a subtle design as well as very strikingly designed form samples. Suitable for every resume - Word templates in abundance You can access the CV templates that Microsoft has put together for you on Office...

Outlook Express has been replaced by Windows Live Mail from Windows 7. This practical tip shows you how you can still back up your old emails with Outlook Express. Secure emails from Outlook Express Open Outlook Express, click on "Tools" at the top and then select the "Options". Select the "Maintenance" tab and click on "Storage folder" to display the storage path of your emails...

If Excel hangs up and reports that the software has stopped working, it is not always due to a simple problem. We show you how you can use Excel reliably again. Excel doesn't work - that can help Restart: First try restarting the computer. This solves temporary problems. If that doesn't help, follow the next steps...

If PowerPoint reports the error that the software no longer works, this can have a variety of causes. We'll show you how to solve the problem. PowerPoint has stopped working. It can help Restart: First switch your computer completely off and on again. Temporary errors are deleted. In some cases this can already solve the problem...

There are several reasons why Microsoft Word may report that the application has stopped working at startup or during operation. We'll show you how to solve the problem. First aid: Word has stopped working Restart: First switch your computer completely off and on again. If Word still doesn’t work afterwards, it’s a bigger problem. Up...

You can anonymize all your comments in Microsoft Word. This way, other reviewers do not see which annotations you have. We reveal how you anonymize your comments in the different versions of Word. Word 2016 and newer: anonymize comments When you create a comment in Word, your name is displayed by default...

If you experience problems with Microsoft Office, you usually have to completely uninstall it first and then reinstall it. In some cases, a simple deinstallation via the control panel does not completely delete all data and entries. We'll show you how to remove any data. Uninstall Microsoft Office completely To really uninstall Office completely, Microsoft offers a small tool for every version of Office, the so-called "Microsoft Fix it"...

For example, a half space in Word can be useful if you use abbreviations like "usually" want to avoid unsightly, large gaps. With multi-part abbreviations, automatic separations can also be prevented. We'll show you how. Create half a space in Word The first step is to define a protected space by simultaneously pressing Ctrl + Shift + Spacebar at the desired position in Word...

You can insert a hanging indent in Word with just a few clicks. Read this practical tip to find out exactly how to do this. Word: Insert hanging indent - how it works Open the Word document and finish writing your paragraph. Then, in the "Paragraph" area, click the arrow pointing to the bottom right...

You can quickly and easily insert a position frame in Word. In this practical tip we will show you how this works in word processing. Word: Insert position frame - how it works Enter "Form" in the search bar at the top right and click on "Insert horizontal frame" under "Previous version tools"...

Citizenship is one of the details on the résumé that is not absolutely necessary. Nevertheless, it can make sense to provide appropriate information under certain circumstances. We show what you should know. Citizenship is usually not part of the resume The common rules of what should and shouldn't be on the résumé have changed in recent decades. Mu...

If you have marked the empty cells in your table with an X in Excel, you can have the spreadsheet count how many cells there are. You can find out how to do this in this practical tip. Let Excel count all X in a table Counting the cells filled with X is very easy with the right function: First click on the cell in which you would like to have the result displayed...

If the black CMD window opens constantly on Windows 10, this is annoying, but in most cases there is no virus behind it. In this practical tip, we will show you how to solve the problem. Windows 10: CMD window constantly opens by itself - problem solving The black CMD window, also called the command prompt, is the command center of Windows...

With a frame around the page you can fine-tune pictures and texts in Word. This can be done, for example, as a clip art. In this practical tip, we will show you how this works and what other options are available. Frame by page in Word: How to insert frame cliparts You can find a frame for the online graphics: Click on "Online graphics" in the "Insert" menu and enter "Frame" in the search mask...

Compatibility mode allows you to open and edit your Excel documents even with older versions of the software. In this practical tip, we show you what you need to know. Excel compatibility mode: All information and tips The old Excel versions 97 to 2003 save Excel files in XLS format. If you use a newer version such as Excel 2007, 2010, 2013 or 2016, all files will be saved in XLSX format...

With CSV files, for example, you can save contact information very easily. This practical tip shows how you can import them into Microsoft Outlook 2010. Import of CSV files in Outlook Open Outlook and go to the orange "File" field in the top left. Select the item "Open" in the left line and then click on the "Import" field...

In Outlook 2010 it is possible to change the view for several folders in one step. We show where you can find the appropriate option. Apply current view to other folders in Outlook 2010 After opening Outlook, go to the "View" tab at the top. Click on "Change view" on the far left and select the desired view type - for example "Preview"...

Business processes and customers can be managed with the "Business Contact Manager" in Outlook. We explain how you can use it. Use Business Contact Manager - how it works In the following steps we will explain how to use the CRM software in Outlook. Download the extension from the Microsoft Store and install it...

Fold and punch marks are especially useful and helpful in the office. In this practical tip, we will show you how you can insert these into Word. Fold and punch marks in Word - this wizard helps Thanks to the free "folding and punch mark assistant" you can equip all your Word documents with the marks: To do this, download and install the free tool...

Cool fonts with shadow and gloss effect - we explain how to insert WordArts in MS Word. Select WordArt from the Insert menu Click "Paste" on the Word menu bar. In the Word toolbar there is a large A symbol on the right with the signature "Word Art". Click on the icon. Double-click the WordArt style...

You have copied passages from a web text into Word and now you want to remove the hyperlinks that have been transferred. It's that simple. Remove hyperlinks in Word - with two clicks! Right click on the hyperlink. In the opened menu select "Remove hyperlink". If you want to keep the hyperlinks in your document and you are only bothered by the blue hyperlink color, we also know the solution: Read how to change the hyperlink color in Word...

Microsoft OneNote is more than just a notebook. Here we show you the 5 best tips for the extensive note-taking software. Tip 1: Send websites to OneNote with a timestamp and link This function is particularly advantageous for online research. If you are surfing the Internet, you can easily save the relevant sections in your OneNote notebook with this function...

For example, in the event of a long outage in the office, you can grant other users permissions for your Outlook mailbox. We'll tell you how to do it. Step 1: Set up Exchange with Outlook First you need to set up Exchange so that you can later assign rights to another user: Go to the control panel of your computer...

If you want to display the calendar week in the monthly view of Outlook, you have to activate the option in the settings. We'll show you how it's done. Outlook 2003 and 2007: Show calendar week Click on the "Tools" menu item in the top left and select the "Options" item there...

Learn how easy it is to put Word documents together in this practical tip. Merge multiple Word documents - that's what you have to do Open the Word document that you want to start. Navigate to the "Insert" tab and click on "Object". Select "Text from file" from this context menu...

If you write about temperatures in Word, you need the degree sign. We'll tell you two ways you can quickly insert the degree symbol. Insert the degree sign using the keyboard in Word You need the degree symbol in Microsoft Word especially for temperature information and for mathematical formulas...

The mark is rarely needed in Word. But when the time comes, the big search begins. Here's how to quickly and easily insert a mark in your Word document. Microsoft Word - how to insert the mark If you want or need to integrate a mathematical operation into your Word document, you have various options for adding the mark...

In Word documents you can quickly insert one or the other check mark and you should use it. A tick is always a small eye-catcher that you use to draw attention to a certain point and is often used in to-do lists. Insert a check mark in Word - this is how it works quickly Special special characters, such as the tick, are usually not found on the keyboard...

If you want to insert a phone symbol in a Word document, you have the choice between several symbols. We'll show you where to find the handset. Word: Insert phone symbol in document Switch to the "Insert" tab at the top of the menu bar and click on the "Symbols" on the right. Under "Other symbols" you will find an overview of all symbols...

In this practical tip we will show you how to insert page numbers in Word. Word: Insert page numbers - how it works Read how to insert page numbers in Word below: Click on the "Insert" tab at the top of the menu. In the "Header and Footer" section, select "Page Number". You now have the option to insert the page numbers at the top or bottom of the page, for example...

With an organization chart, you can clearly show structures in a diagram. This practical tip shows you how to create an organization chart with Microsoft Word. How to create an organization chart with Word Tip: If you prefer to use Microsoft Excel to create an organization chart instead, you will find the instructions for this in another practical tip...

If you want to know how many words you have written in Excel, you can have them counted. In this practical tip, we will show you exactly how this works. Words count in Excel - how it works With Excel you can only count the words used within a line. Unfortunately, it is not possible to count all the words used...

With data validation, you can only allow certain values ​​in cells in Excel. This means that you immediately ensure that incorrect entries cannot be made in the first place. This is particularly useful when more than one person is editing the file. Allow only certain values ​​in Excel The following instructions work with all versions from Excel 2007. Select...

If you want to arrange pictures, texts and objects to the exact centimeter in Word, you should have the help lines displayed. We show you how to activate it. Word: Show guides Right-click on an empty area in PowerPoint and you will find the settings for "Grid and Guideline". In Word, these functions are unfortunately only available in a comparatively minimalist form...

If you are no longer interested in certain RSS feeds, you can delete them from Outlook. We'll show you how it's done. Instructions: Delete RSS feed from Outlook Outlook 2007 and older: Click on "Extras" in the menu bar at the top and select the "Account Settings". Outlook 2010 and newer: Click on the "File" tab in the top left and select the option of the same name under "Account Settings"...

With PowerPoint, you can easily create slides for a presentation and change the order later. With these instructions you can adjust the order in a few seconds. How to change slide order in PowerPoint With just a few simple steps, you can determine the order of your slides in PowerPoint yourself: Open the desired presentation in PowerPoint...

In Word, you can indent the text, for example, to send longer quotations or to structure your text better. Our instructions show you the various options that you have in Word. Indent text in Word - that's how you do it To indent a text in Word, you first have to select it. Then you can use the tab key (above the caps key to permanently capitalize letters) to indent the selected text...

So that not everyone can watch your PowerPoint presentation, you should protect it with a password. In our instructions, we show you how to set your own password in just a few steps. No additional programs are necessary for this. Set password for PowerPoint presentation First create your PowerPoint presentation as usual and save the file on your computer...

You can easily remove the password of a PowerPoint presentation. Even if you don't know the password anymore, that's not a problem. Our instructions show you the exact procedure. Remove password from PowerPoint If you still know the password, open the presentation and enter the password. Then click on "File"> "Information" and here on the big button "Protect Presentation"...

This quick guide shows you how to change the slide color in PowerPoint. You can set just about any color for your slides. Change slide color in PowerPoint In PowerPoint, click the "Design" tab and then select the "Format background" button on the far right. Then a small menu opens on the right side...

With Word, you can set the exact distance from the text to the edge of a table. In this article, we show you where you can set this margin. Word table: Set the edge distance from the text to the table edge You can specify this exactly in Word so that the text is the same distance from all pages in the cell...

Microsoft provides extensive templates for its office programs. We'll tell you which templates are available for OneNote and where you can find them. Numerous templates for OneNote For the OneNote note-taking program, Microsoft provides templates for versions from 2003 to OneNote 2013. You will find designs for a wide variety of areas such as companies, protocols, planners or lists...

Unfortunately, there is no direct function in OneNote that you can use to crop images. But we will show you a way in which it still works. Crop images with Paint for OneNote Since there is no direct function in OneNote with which you can crop images, you have to use Paint: Open Paint. Insert your picture by drag & drop or via "File" and "Open"...

If you receive PowerPoint files, you can view them without PowerPoint. We'll tell you which free software this works with. Open PowerPoint presentation without PowerPoint With the free tool PowerPoint Viewer from Microsoft you can play all PowerPoint formats. Since Office versions 2007, 2010 and 2013, the documents are mostly saved in the PPTX format instead of the old PPT...

To display a PowerPoint presentation on your website, you need to convert the file to Flash. With a free add-in, this works without problems. PowerPoint: convert presentation to flash Unfortunately, PowerPoint itself does not have such a function. With a free add-in, you can integrate the feature into PowerPoint afterwards: Download iSpring Free from the CHIP download area and install the tool...

With the OneNote note program, you can quickly create a checklist. We explain here exactly how this works. OneNote 2013: How to create a checklist Select the OneNote tab where you want to create your checklist. Alternatively, you can also create a new page. Click an area on the page where you want to place the checklist...

It is often useful to create additional calendars in Outlook. For example, in addition to the business calendar, you can also create a private calendar. In this practical tip we will show you how. Add more calendars in Outlook Just follow the steps below to add more calendars in Outlook: First select the calendar in Outlook...

If you would like to cancel your account at Volkswagen Bank, this is relatively quick and easy. We'll show you how it's done. Instructions: Cancel an account with Volkswagen Bank There is no notice period at Volkswagen Bank. You can close your accounts and deposits at any time and transfer your money to a new account...

For homework or contracts, it can be useful to change the margins in Word. We'll show you exactly how it works. Change all margins in Microsoft Word Start Word and open the document you want to change. Click the "Layout" or "Page layout" tab at the top. Then select the "Margins" or "Margins" button on the left...

If you want to cancel the subscription to Wirtschaftswoche, you have to stick to the deadlines. We'll show you how to get rid of the subscription. Cancel Wirtschaftswoche subscription: deadlines and what else you need to consider The Wirtschaftswoche subscription has a term of one year. The notice period is 3 months...

Outlook completes your entries automatically. However, you can delete unwanted entries from the auto-completion. We show you how to do this. Delete entry from Outlook auto-completion In the Outlook address bar, enter a name whose entry you want to delete from the list. Now mark the contribution to be deleted in the list...

Do you want to attach a file to an email in Outlook but don't know how to do it? Find out here. To attach a file to an email in Outlook: On the 'File' menu, click 'New', then click 'Email Message'. A tab has now opened for your new e-mail message. Now click on 'Add file' in the 'Add' group...

If you no longer wish to support NABU financially, you can cancel your membership in the Naturschutzbund Deutschland. We'll show you how it's done. Terminate NABU - you need to know that As a member of NABU, you pay an annual contribution of at least 48 euros. Termination is always possible at the end of the year...

If you as a doctor no longer wish to be a member of the Marburger Bund, you can simply cancel the contract. We'll show you how it's done. Terminate Marburger Bund: You should know that The notice period at the Marburger Bund is 3 months to the end of the quarter. This means that the cancellation will only become effective at the end of the next quarter...

You can cancel your account with Consorsbank quickly and easily if you use a subscription alert template. We will show you what you have to consider and how you can best proceed. Consorsbank: cancel account and other contracts Whether you have to give notice depends on what you want to cancel. If it is a loan agreement, you must observe the agreed notice period...

Quitting the Bavarian Red Cross is easier than you think: You can quit the sponsoring membership of the Bavarian Red Cross in just a few steps. We'll show you exactly how to do this. Bavarian Red Cross: Submit termination You can determine the monthly amount of your sponsoring membership yourself...

If you create a notebook in OneNote, you can also share it with other people. All you need is an account with Microsoft. With our instructions, you will then share your notebook with friends or colleagues. OneNote: Share your notebook with OneNote 2013 Microsoft offers the OneNote 2013 note program from the Office Suite for free...

If you no longer wish to be a member of the SoVD (Social Association Germany), you can cancel your membership at any time. We'll show you how it's done. SoVD (Social Association Germany) cancel - all information SoVD is an annual membership that is automatically renewed. The notice period is three months to the end of the year...

If you have subscribed to FID Verlag, you can cancel it at any time. We'll show you how it's done. Cancel FID Verlag - you should know that Like the contract term, the notice period differs depending on the tariff. Sometimes there is no notice period. If your cancellation is not received by FID Verlag in time, the subscription will be extended for a further period and only then terminated...

If you have concluded a mobile phone contract with Telefónica Insurance's mobile phone insurance, you can also cancel it. We'll show you how it's done. Terminate Telefónica Insurance's mobile phone insurance - all information Telefónica Insurance's mobile phone insurance has a contract term of 24 months. A...

In order to terminate your ADAC legal protection insurance, you must observe deadlines. We will tell you what is important and provide you with a legally compliant template. Termination of ADAC legal protection insurance: special termination right and deadlines The contract with legal expenses insurance is initially concluded for the time specified in the insurance policy...

If you no longer wish to train at Selection Fitness, you can cancel the contract at any time. We'll show you how it's done. Cancel Selection Fitness: You need to know The contract period for Selection Fitness is usually 12 months. The notice period is usually 3 months. If you do not cancel the subscription in good time, it will be extended for another 12 months...

If you no longer wish to use the Bogestra subscription, you can cancel it at any time. We'll show you how it's done. Cancel Bogestra: You have to know that The contract period at Bogestra is usually 12 months. The notice period is 3 months. If you do not cancel the subscription in time, the contract will be extended for another 12 months...

Converting a PDF document into an image file is done quickly and easily with the right program. If you want, you can do the conversion online right away. Convert PDF to image file - how it works With the free PDF Creator you can quickly create PDF documents, but not only that. The Creator also has some other useful tools on board...

PDFs are one of the most important file formats today. But how can DOCX files be converted into PDFs? You can find out in this practical tip. Convert DOCX to PDF - that's how it works on a PC In many cases it is necessary to send just created Word files as PDF. With Microsoft Word it is also very easy: First open the document in Word that you want to convert to PDF...

If you want to merge cells or columns in Excel, you can do it with a simple formula. We'll show you how it's done. Merge cells and columns in Excel For example, if you want to combine a list of names - listed in a column for the last name and one for the first name - into a column, it is best to use the ampersand: Enter the formula = A2 & "" & B2 in the cell where you want to receive the merged text to merge the values ​​in A2 and B2 with a space in between. To...

There are clear differences between the different Office versions Office 2016 and 365. In this practical tip, we explain whether you should buy Office 2016 or 365 and where the versions differ Office 2016 vs. 365 - these are the differences Basically, the two offers differ in that you purchase Office 2016 once, whereas Office 365 is an annual subscription model...

Thanks to Outlook, you always have your emails in view. If Outlook doesn't update, there may be a problem with the Internet or settings. This practical tip shows you how to fix the problem. Outlook does not update - what to do? First, make sure your computer is connected to the Internet and has a constant connection...

Is there an anniversary celebration or a birthday coming up and you want to design the invitation cards yourself? No problem - Word provides many great templates for every occasion. Design invitation cards yourself - How to find the templates in Word The first step is to open Word. This practical tip refers to the latest version of Microsoft Word...

This practical tip shows you what the Excel function "If cell is not empty, then ..." and how you can integrate it into your document. Excel function "If cell is not empty" - this is how ISTLEER works To find out whether a certain cell is described or empty, there is the function IS EMPTY...

You can activate the automatic update of the version so that the Office version on the Mac is always up to date. Then your Mac will download the update in the background as soon as an update from Office is available. We'll show you how to turn on the automatic update and get the latest version of Office right away...

You can update to Office 2016 free of charge if you own the Office 365 package. You will always get the latest version of Word, Excel and Co. We will show you how to download and install the update. Update Office 2016 for free First, open a new document in Word and then click "File"> "Account"...

If your Microsoft Office product key doesn't work, there can be several reasons. We will show you why and how you can solve the problem. Microsoft Office: Product Key cannot be activated If the product key does not work, you should contact the seller directly. If you recently purchased the product key, the exchange should not pose any problems...

If you want to hide the menu in Word 2016, this works in two different ways. We present both options in this article. Hide menu in Word 2016 The menu takes up a lot of space, especially on smaller screens. If you are currently writing and do not want to edit the layout, the menu can simply be hidden...

Although Word is a pure writing program, you can insert individual symbols and draw sketches yourself. We explain where you can find the corresponding functions in Word and how to use them. Basic instructions: Drawing in Word After you have opened your Word document, click on the "Insert" tab...

You want to reset the Microsoft email program Outlook to the default settings. Unfortunately, this is not possible directly - but by using a trick, you can bypass a completely new installation. Reset Outlook 2010 and 2013 - how it works To reset Outlook, you must first delete your email profile from Outlook and then the cache memory...

If you no longer receive feedback from Outlook, the program has hung up. We will show you how you can eliminate potential problems with Outlook and get the mail client up and running again. No feedback from Outlook: Deactivate add-ons Press the "Windows" and "R" keys simultaneously so that the "Execute" command opens...

In Office 2016, you can still easily import data into Excel. This works for SQL databases, Oracle and IBM DB2, among others. We'll show you exactly how to do this. Excel: import data from SQL, Oracle and Co. First open Excel as usual and a new workbook. Then click on the "Data" menu and select a new data source in the "Retrieve and transform" group...

In the well-known editor Atom you can not only program, but also compile LaTeX. In this practical tip, we will show you the packages and additional software required for this. Compile LaTeX in Atom: You need these extensions Most TeX and LaTeX distributions such as TeXStudio or Texmaker have their own editors...

The Office.com templates in MS Excel make it easy to create a schedule. Here you have the choice between a vacation schedule, a shift schedule or an office cleaning schedule. Create a schedule using Excel templates After you have opened an empty Excel document, go to the "File" tab in the menu bar (see screenshot)...

In Word, you can cross out individual text passages to indicate the changes. We show you how to do this. Microsoft Word: Cross out texts In Word, select the text you want to cross out. Under "Start" you will find the crossed out "abc" icon in the "Font" area. Click on it...

Whether for housework or a birthday card - in Word you can change the character spacing at any time. We'll show you where to find the options. Word: Set the character spacing Start Word and open the desired text document. In the "Start" tab in the "Font" section, click on the small arrow at the bottom right (see illustration)...

Small caps are used to create capital letters in lower case letters in Word. We show you how this works in this guide. Word: Create small caps First mark all letters of the desired word, except the first one. Tip: Hold down the Ctrl key to highlight several letters. The quickest way to create the small caps is with the key combination Ctrl + Shift + Q...

If you want to share a text document with other people, it is recommended to save it as a DOC file instead of an ODT file. Many users have problems opening the less common ODT format. Convert ODT to DOC with Word or Open Office We'll show you how to convert the file using Microsoft Office Word 2010...

If you use the Atom editor on multiple devices, you can synchronize your packages and settings. For example, you can work on your projects without restrictions at work and at home. In this practical tip, we explain how to set up Atom for this. Atom: Synchronize editor settings and packages - you need that With the solution presented here, your Atom settings are synchronized with a Git repository...

Your own invitation cards for a baptism should be particularly beautiful - it usually only helps to do it yourself. We show how you can create invitation cards according to your ideas using simple means. Make invitation cards for baptism yourself: with these programs it works Complex software like Photoshop is not necessary: ​​You can also create great invitation cards with Word or a simple layout program: In Word, click File> New and enter Formal Invitation. Th...

Microsoft Lync Online is the successor to the meeting tool Office Live Meeting. Read in this practical tip what exactly it can do. Microsoft Lync Online: Meetings over the Internet thanks to web technology Office Live Meeting is a subscription-based service that was used to hold web conferences. The service has now been discontinued...

Cloud services such as Dropbox or Google Drive can also be integrated into your system as a storage location. You can then find them easily in the »Save« dialog. You can save documents from Word, Excel or PowerPoint directly in the Dropbox or in Google Drive. Integrate cloud services as a storage location using the PowerShell script The PowerShell script "Create_Shortcuts.p...

In this practical tip, you can read how to install Service Pack 1 for Office 2013. How to install Service Pack 1 for Office 2013 There are two ways to install Service Pack 1 for Office 2013: Installation via Windows update Installation with the download package from the Microsoft website. Service Pack 1: Installation via Windows update If you have not activated the automatic Windows update, proceed as follows to start the download and installation: Click Start - Control Panel - Windows Update Click the "Check for updates" link...

Descriptive Sankey diagrams (energy flow arrows) can be quickly created in Excel and designed in a comprehensive manner. Create a simple Sankey diagram in Excel In this section we describe the easiest way to create a Sankey diagram: In Excel, click Insert> SmartArt. Click on "Process" in the new window and select here, for example, the "Simple Process"...

Sharing an Excel workbook is a useful feature so that you and other users on a network can work on the document at the same time. We show you in this practical tip how this works and what you have to watch out for. Prepare workbook for sharing Open the workbook that you want to share. Click the Microsoft Office icon in the top left...

Embedding videos in an email is not easy with Outlook. We'll show you what options there are depending on where the video came from. Embed video file in the attachment If the video is a file on your hard drive and not a clip on the Internet, you can simply send the file as an attachment to your email...

If you have problems with Excel, because it obviously does the wrong calculation, we will show you what it can be and how you can solve the problem. 1. Excel calculates incorrectly - correct cells selected? The most common problem why Excel calculates incorrectly is that the wrong cells are selected...

This guide shows you how to add times in Excel. Add times in Excel - how it works Please note that these instructions refer to Excel 2013. Select the corresponding cells in which the times are located and select the "Format cells" option with the right mouse button. Click on "Custom" under the "Numbers" tab...

This practical tip shows you how to export an Excel spreadsheet as a PDF. How to export an Excel spreadsheet to a PDF document As of Microsoft Office Excel 2007, you can export the table as a PDF document in the program. To do this, click on the Office icon in the top left and move the mouse pointer over the "Save as" button...

This practical tip shows you how you can deactivate the Outlook popups in simple steps. Disable Outlook popups on the desktop The pop-up messages in Outlook show you information on the lower right side of your desktop as soon as you receive a new email. However, this is not always desirable. Below you will find the deactivation steps, which can also be seen in detail in the image gallery: In Outlook, click "File"...

If you want to open several tables side by side in Microsoft's spreadsheet program Excel without these being displayed in a window, you can open your tables separately. We show you how to do this in this practical tip. Open multiple Excel spreadsheets side by side Start Excel and open your first Excel table with a double click with the left mouse button...

In Microsoft Excel you can hide entire cells and still calculate with the hidden numbers. In the case of extensive portfolios, unimportant intermediate values ​​can be hidden without influencing the calculations. We'll show you how it works. Hide and count on Excel cells The real trick is to hide the values. Yo...

We'll show you how to color-code fields in Excel automatically. Automatically highlight fields in Excel - what for? With the automatic marking of cells in Excel, it is even easier to evaluate documents and plans and to identify errors or problems. For example, you can use it to create work plans and receive colored feedback on who has exceeded their number of hours...

You can print Excel documents not only in portrait format, but also in landscape format. We'll show you how. Excel 2013 and 2010: Print pages in landscape format Open the desired Excel file and navigate to the "Print" option via the "File" menu item. Alternatively, you can also use the key combination "Ctrl" + "P"...

Raw Excel data looks much more descriptive as a diagram. We'll explain how to make cake, column and other diagrams. Excel: create charts First you need the values ​​for the diagram. Simply create a small table. It is perfectly sufficient, for example, to write the time in column A and right next to it in column B the associated values. Se...

In Word, you can insert footnotes with just a few clicks: either using the menu or using a keyboard shortcut. In this guide, we show you step by step how to do this. Word: How to insert footnote Click where in the document you want to add a footnote. Click the References tab above. The "Insert footnote" icon is now available in the task bar...

In this practical tip, we will show you how to split CSV files into columns in just a few steps. Columns in CSV files - Here's how Do you want to split a CSV file into columns? Below you will find step-by-step instructions that you can also follow in our picture gallery: Start Microsoft Excel and open the desired ...

If you don't like the auto-correction in Excel, you can turn it off. We'll show you how. Step 1: Call up auto correction settings in Office If you are using Office 2013, click on the "File" tab at the top and then select the "Options" item. Now you can select the "AutoCorrect Options" option under "Document Review"...

If Microsoft Outlook is no longer working properly, you can often repair the program with just a few clicks. We show you step by step how to repair Outlook in this practical tip. Repair Outlook - try Safe Mode When you start Outlook, numerous plugins are also loaded. These can be responsible for possible crashes if they are out of date or do not function properly after an update...

In this practical tip, we will show you how to create a table with Wordpad. How to create a table using Wordpad It is a bit of a hassle to create a spreadsheet using Wordpad. If you still want to fall back on this, you can help yourself with a little trick: Open Wordpad using Windows Search. Take a step to the right with the tab key and insert the name of the first column...

With curved texts in PowerPoint, you can make your presentations even more interesting. In this practical tip, we explain how to bend individual text passages in PowerPoint. Bend PowerPoint text over the format options In PowerPoint, click the text box you want to bend. Select the "Format" entry in the menu bar...

To save time with homework and long documents, you can insert an automatic table of contents in Word. We'll show you how this works fastest and easiest. Insert automatic table of contents in Word Open Word and navigate to the "References" tab. In the upper left corner you will find the "Table of Contents" button...

We explain below how you can mix pages from portrait and landscape format in a Word document. Mix portrait and landscape format in the Word document Open the desired Word document and mark the section that should be transferred to landscape. Open the "Page Layout" tab at the top. Click on the small icon to the right of the "Page Setup" category (see picture)...

The password for sheet protection in Excel is quickly forgotten. To be able to edit the table again, the sheet protection must be removed. We'll show you a trick on how to remove the password for it. Forgot password: Remove sheet protection in Excel To open the table, you need the 7-Zip or WinRAR extractor program...

A PowerPoint presentation can be made very interactive by using different transitions. We show you how to insert them. Change transitions in PowerPoint - Instructions Open your PowerPoint presentation and click on the "Transitions" tab. Go to the slide you want to transition and choose from the pre-made animations...

How you insert and change bullets in PowerPoint is not always clear. We explain in individual steps how you create the key points and what options you have for more individuality. PowerPoint: How to insert bullets Open your PowerPoint document and make sure that the normal view is selected under the "View" tab...

If you have created a larger table in Excel and later want to convert and swap the rows into columns, you can do this with just a few clicks - but Microsoft hides the process behind the cryptic name "transpose". That's how it works. How to convert rows to columns in Excel 2010 First mark all the data to be converted...

The rulers on the edges of a Word document not only help with orientation: they also contain numerous functions. You can show the rulers with one click. We'll show you how it works. How to show the rulers in Word Open a Word document and click on "View" in the menu. Here you will also find the "Ruler" in the "Show / Hide" field...

In Word, you can change the background color of a page and do not necessarily have to use the white background. This can refresh the look of a presentation or printout, for example. We show you exactly how to do this. Change background color in Word 2007 Open a Word document and click on the "Page layout" tab...

Microsoft Office is the standard among office applications. In this practical tip, you can read whether you should prefer Office 2013 or the 2010 version. In the following we have summarized the most important innovations between the versions for you. Office 2013 or 2010 - general differences There are some general differences between the Office versions, which may lead to a purchase decision...

Creating a bibliography for academic papers is not difficult if you know how to do it. In this practical tip, we will show you how to insert sources and citations in Microsoft Word 2010 and then turn them into a complete bibliography. Maintain sources in Word A bibliography is based on literary sources, which you must first enter into Word: Click on "Manage Sources" on the "References" tab and in the "Citations and Bibliography" group...

If you work with cross-references in Word, the error "Bookmark not defined" may occur. In this practical tip, we will show you how to deal with the problem. You can do this if the bookmark is not defined in Word If Word gives you the error "Bookmark not defined", you have probably removed or edited a passage that was anchored to the bookmark...

In this practical tip, we will show you how to set up a WEB.DE account in Outlook. This way you can manage your emails practically. Set up a Web.de account with the Outlook Assistant Simply connect your WEB.DE account with the setup wizard in Outlook. To do this, proceed as follows: In Outlook, click the "File" tab in the top left...

This article shows you how to format a footnote in MS Office Word. It allows you to adjust the font size and font of the style to format all footnotes evenly. Instructions: Format footnote in Word The following steps change the formatting of your footnotes in Word. Open the document in which you want to format the footnotes...

To separate elements such as headers and footers, you need to insert page sections in Word. You can find out how to do this in this practical tip. Set page sections in Word Open the "Page layout" workspace in MS Word. Click on the menu item "Breaks". You can find it in the "Page Setup" area...

Microsoft's new office solution "Office 365" has several advantages. We have summarized them for you in this practical tip. Office 365 benefits Office 365 has these advantages over the classic Office package: With Office 365 you always get the latest version of Microsoft Office. You can stream your office to any Windows computer and Mac using "Office on Demand"...

With "XING Outlook Connector" you can directly access your XING contacts from Outlook Express 2003. Here's how to set it up. Set up XING Outlook Connector If you have not yet downloaded the XING Outlook Connector, you can find the download here. After installing the program, you need to connect to your XING account...

In this practical tip, we will show you how to use Excel to refer to another file. For example, you can use the table of another file as the basis for your calculation. Reference another file with Excel To be able to make a reference with Excel, you must first open both files. Then do the following: Put an equal sign (=) on the line where you want to make the calculations...

Thanks to the "net working days" formula, you can use Excel to calculate your working days. In this guide we show you step by step how exactly this works. Determine working days in Excel with "net working days" - so it'll work First enter your start of work in a field (see picture)...

In Excel you can format cells as time and calculate with the times entered. To convert the time to hours, you need to do a trick. For example, you can calculate the difference between two times in hours. We'll show you how it works. Excel: Convert time to hours If you enter a time in a cell in Excel, Excel automatically recognizes this and formats the cell accordingly...

In Excel, you can format a cell depending on the date. With the conditional formatting, one or more cells can be provided with a desired color or with effects. We show you how to do it here. Excel: Conditionally format cell with date You can format a cell with a date quickly and easily: Select the cell and click Conditional Formatting on the Home tab...

If you see runtime error 1004 in the Excel spreadsheet, you can quickly fix it yourself. This practical tip shows you exactly how to do this. Excel: Fix runtime error 1004 - so it'll work This error can be caused if your code is incorrect or you have set loops incorrectly, for example. If you use objects, you should make sure that you have defined and specified them correctly...

If you want to arrange text or graphics exactly in your PowerPoint presentation, it is advisable to create guidelines. We'll show you how it's done. Create guides in PowerPoint Start PowerPoint and switch to the "View" tab in the menu bar at the top. Under the "Ads" category you will find three options to help you with the arrangement...

Stacked columns can be very clear in an Excel chart and help you with important information in compact presentations. In this article, we will tell you how to create such diagrams. Stacked columns in Excel charts This tip applies to Excel Online, which is included in the free Office 365 package for students...

With a ComboBox in an Excel worksheet, you can make it easier for users to enter values. Such a combo box can be used to select a value from a dropdown list. We show you how to use a ComboBox. ComboBox in Excel: Activate developer tools This guide was created for Excel 2016. In other versions, the menu navigation may differ slightly...

If you want to perform the same arithmetic operation with different fields in Excel, the "Relative reference" feature is useful. This practical tip shows you how to use the function. Excel: Use relative reference - how it works The relative relationship in Excel can be used very well if you want to use a certain formula with several values...

In this practical tip, we will show you how to count the number of specific words in Word. Word: Count certain words Word does not have a function for counting individual words, but you can use a little trick. With the "Replace" function you can replace the word meaninglessly with yourself...

Microsoft has disabled hyphenation by default since Word 2007. If you want to activate the hyphenation, this is done quickly, although Microsoft has somewhat hidden the feature in Office. We explain where you can find the option. Word: Activate hyphenation in four steps First call up the "Layout" tab...

Inserting two tables side by side in Word sounds easy, but it doesn't work easily. We'll show you a trick that will still work. Word: Insert several tables side by side There are several ways to arrange two tables side by side. As of Word 2013, you can simply insert the tables one below the other and then slide them side by side...

With a certain function you can round off all numbers in Excel from a desired decimal place. We show you how to use the function and give examples. Round down in Excel The rounding function is: ROUND DOWN (number; number_digits) Explanation: For "Number", enter the number with decimal places to be rounded off...

In the Excel spreadsheet you will find the PowerPivot plugin. We have summarized all the information in this practical tip for you. PowerPivot in Excel - all information Since Excel 2010, PowerPivot has been integrated as an add-in as standard and can be used free of charge. Visually, the plugin doesn't differ much from a normal Excel spreadsheet...

If you want to arrange lists randomly, Excel offers simple solutions. This practical tip shows you how to sort cells in a random order. Randomly sort cells in Excel A list can be randomly arranged with Excel according to the following scheme: First open your list in MS Office Excel. Insert an empty column next to the column you want to sort randomly...

With SmartArt you can create chic graphics in Word. These are particularly practical for clearly depicting processes or simply depicting information. In this guide, we show you how to create these images. Create SmartArt graphics in Word Start Word on your PC or Mac and open the document you want to add SmartArt graphics to...

With Harvey Balls, you can also graph percentages in Excel. We'll show you how it's done. Paste Harvey Balls into Excel The following instructions were performed with Excel 2013. In other versions, the individual options can be titled or arranged differently. Open Excel and use the mouse to highlight any numbers (between 0 and 1) or percentages (between 0% and 100%) that you want to convert into Harvey Balls...

Auto-summary is a nice feature, but it is no longer supported in Word. This practical tip shows you how to use this function in the older versions. This is how Word Auto Summary works You need Word version 2007 or 2003 for this feature, because Microsoft no longer continues this in newer versions: The feature highlights the focus of your text or document...

The most important part of any application is the application letter. You can find numerous samples for download on the Internet. This saves you the tedious work of writing one yourself. Application letter: Sample letter as download One of the most important points of your application is the application letter...

Linear regression measures the relationship between two different values. We'll show you how to do this in Excel. Linear regression in Excel - how it works First you have to enter data pairs. In our example it is body size and shoe size. Select the data area for which you want to display a linear regression...

If you have not saved your PowerPoint or the program has crashed, you can usually restore the file. We'll show you what options you have. Restore unsaved PowerPoint These instructions work with the newer versions of Office such as 2013 and 2010. If this does not help you, read on in the next paragraph...

To make your presentation appear clearer, you should format your PowerPoint slides consistently. In this practical tip, we will tell you how to do this. PowerPoint: Format slides uniformly - so it'll work So that the slides in your presentation are clearer and easier to read, you should format them as follows: Design: Use only one design for all slides for your presentation...

With the right letterhead templates for Word, you have the exact DIN dimensions for window envelopes. You can create your individual templates with just a few tricks. How to use Word to create your letterhead template We provide a simple template for free download here. Alternatively, you can select a template in Word under "New" in the "Letters" tab...

In this guide, we explain how to hide page margins in Word. Hide margins in Word - do this Note: This practical tip was tested with Word 2007. In Word, click the Office icon at the top left. Select the "Word Options". In the "Show document content" area, remove the check mark from "Show text limits"...

The automatic enumeration can be annoying in Outlook in some situations. In this guide, we will show you how to deactivate it. Disable automatic enumeration in Outlook Note: This practical tip is based on Microsoft Office 2010 under Windows 7. Open Outlook and click on "File" at the top and then on "Options"...

If you want to use files in a PowerPoint presentation, you have to embed them. PowerPoint: Embed files - the steps No matter what type of file you want to embed in the PowerPoint presentation, you have done it in just a few steps: Open the desired presentation and select the appropriate slide. In the program bar you will find the different file types image, audio, video under "Insert"...

You can save PDF files to your computer with several programs and in different ways. We present you with a few variants. Adobe Reader: Open, edit and save PDFs Adobe Acrobat Reader is probably the most popular PDF software. This allows PDFs to be opened, printed and edited as far as possible. Alternatively, you can also use other software such as the PDF-XChange Viewer...

If you want to loosen up your PowerPoint presentations with pictures, you do not have to crop them with a separate program. We'll show you how to do it easily with Powerpoint. Crop pictures in Powerpoint - this is how you proceed Paste the image into PowerPoint as usual. Then click on the inserted image and switch to the new "Image Tools" tab at the top...

If Outlook reports that the application was not found when opening a link, the problem can be solved quickly. We'll show you exactly how troubleshooting works. Application not found: Outlook does not open any links The error usually occurs after installing Google Chrome or other Google software. A value is changed in the system, which means that Outlook can no longer find a browser to open the link...

If you use autocorrection in Outlook when writing emails, you can change the language from the dictionary to German at any time. We show you how to do this. Change the dictionary in Outlook to German Click the "File" tab in the upper left corner of Outlook and select the "Options"...

As in Microsoft Office Word and other word processing programs, text can be crossed out in Excel. We show how this works in this practical tip. Cross out text in Excel Right-click in the cell with the text you want to cross out. In the context menu, select the "Format cells" menu item. There you choose the "Font" tab...

If you switch from an older version of Outlook to a new one, you can export your contacts. Below you will find two instructions for the respective Office versions. Outlook 2010 and 2013 Start Outlook on your computer and click on "File" in the menu on the top left. Select the "Options" sub-item there...

If you do not expect acceptance from all participants, you can also invite optional participants in Outlook. We'll show you how it's done. Invite optional participants with Outlook Start Outlook and select the desired appointment in the calendar. Click the "New Meeting" button in the top left to invite participants...

A protected hyphen ensures that two words are kept together in Word. We show you how to use the hyphen. Word: Use a protected hyphen If two words are connected with a hyphen at the end of a line, a new line can separate the two words. That doesn't happen with a hyphen. Simply delete the old hyphen and enter a hyphen for it...

Excel's Find function allows you to find a string within another. You can find out what you need to consider and the syntax of the function here. Find function in Excel: description and syntax With "FIND" you can find a certain string within another. In addition to FINDEN, Excel also knows the FINDENB function...

Word, Excel, PowerPoint and Co. have included numerous animations since Office 2013, but you can deactivate them again. We'll show you how it's done. Word, Excel, PowerPoint: Switch off animations in Office 2013 The animations are hardly noticeable in normal use, but they can lead to delays in larger calculations...

The cedilla, the "C with a hook" is actually not used in our language. But it is often used especially for French and Portuguese names and vocabulary. This practical tip shows you how to create this special character on a computer, on a Mac, in latex and in HTML. C with cedilla - How to write it There are several ways to add a hook, i...

Setting up portrait at Powerpoint is no problem. We show you how to do this in our tip. Set portrait format in PowerPoint When you start PowerPoint, the slides are displayed in landscape format. You can change this orientation with just a few clicks. In the upper part of the program you will find a bar with tabs...

If you lock individual cells in Excel, they can no longer be changed, but the remaining rows and columns of the workbook can. In this tip, we show how to apply this protection. Lock cell in Excel - the preparation Protecting one or a few cells is a bit more cumbersome than locking an entire worksheet: First of all click with the right mouse button on the small gray square, which you will find in the top left between the column name and the row numbering...

If you switch to a new computer or operating system, you can export your accounts under Outlook 2007 so that you can load them back into the program later. We'll show you how it's done. Export account to Outlook 2007 To back up your complete account, i.e. all data directly related to your email address, you just have to copy a file from the directory...

Do you want to enhance your PowerPoint presentation with a chic image as a background? In this practical tip we will show you how you can quickly and easily insert your own background image for your slides. How to set a PowerPoint background image As of Office 2007, you have to change the background images of one or more slides using the Design tab...

As in all other Office programs, you can also count the words and characters of your presentation in PowerPoint. We'll tell you exactly how this works in this practical tip. Count words and characters in PowerPoint 2007 and earlier Click on the Office button at the top left and select the "Prepare" entry from the menu...

If you print out your PowerPoint slides, this is usually not done without borders. We show you how you can improve the printout and set as little margin as possible. PowerPoint: Enable borderless printing A certain margin cannot be avoided when printing, but you can keep the margin in PowerPoint as small as possible...

If you have received an Excel file with a sheet protection, you can only edit the sheet if you remove the protection. We'll show you how it's done. Remove sheet protection in Excel documents The sheet protection can only be removed if you know the password for the protection. If the file is not from you, you must first ask for the password...

If you install the complete office package, OneNote will also land on your computer. This practical tip shows you how to deactivate the notepad tool again. Microsoft Office: Deactivate OneNote afterwards OneNote has been an integral part of Microsoft Office for years. Nevertheless, the note program has significantly fewer users than Word, Excel and Co...

You can change the quotation marks in MS Office Word. We show you how to do this in our tip. Quotation marks change in Word Quotation marks, or colloquially "goose feet", can be found in many languages. However, they are set differently. Word recognizes the language used on your computer and automatically sets up the characters...

Printing a document borderless with Word is not a big art - we will show you how it works. 1. Borderless printing of the Word document: the requirements So that you can print Word documents borderlessly, your printer must of course also support borderless printing. Therefore, first change the settings: First go to the "File" tab in Word...

If you want to sync your notebooks in OneNote, it's relatively easy. We'll show you how to do it step by step. Sync notebooks in OneNote With OneNote Online, the notebooks are constantly synchronized in the background. If you have OneNote installed on your computer, the synchronization usually happens automatically...

You need the HLOOKUP in Excel if you want to get information from a horizontal table. We show you how to use the function correctly. How the HLOOKUP works in Excel The HLOOKUP in Excel searches for a value in a predefined table. As a result you get what is in the column with this value in a predefined row...

You can also use your Outlook calendar together - whether in the office or at home. Find out in this practical tip how exactly this works. Share Outlook calendar - so it'll work You can use your Outlook calendar with your family or colleagues with the following instructions: First start Outlook and click on "Start"> "Share"> "Email Calendar" at the top...

You can insert Roman numbers in Word in different ways - we present three simple variants. Word: Write Roman numerals in normal text Of course, you can simply write Roman numbers in the text as a string of capital letters. If you set the font for this to "Times New Roman", the numbers also stand out visually...

To loosen up the text in documents a bit, you can insert cliparts in Microsoft Office. The huge repertoire ranges from large photos to small drawings. How to find the cliparts in MS Office: In the MS Office programs such as Word and Powerpoint, you will find the "Cliparts" button in the "Insert" menu...

You can use the subtotals function in Excel tables in which values ​​are assigned to different categories. This is a useful tool for summing up values ​​sorted by characteristic, for finding the largest or smallest value or for averaging. We will show you how to create the partial results in Excel - you can also follow the individual steps in our picture gallery. Apply ...

You can archive old emails in Microsoft Outlook. You can find out how this works and what you should pay attention to here. Mailbox organization is important Before you archive your old emails, you should consider which system you want to use to store them. For example, you can sort them by date (months or years), topics (invoices, private items, etc...

In Microsoft Excel, several values ​​can be divided from one cell - for example, to make a table clearer. You can read how to do this in this guide. Split cell values First select the cells whose content you want to split into several cells. Then click on the "Data" tab above. Then select the menu item "Text in columns". In...

If your Outlook calendar cannot connect, this may be due to an incorrect configuration. In this practical tip, we will show you what you can do in this case. Outlook calendar is not getting connected - what to do? With our tips below, the connection to the server works again without any problems, so that Outlook then works: Open Outlook and click "File"> "Account Settings" at the top...

If you no longer want to use a calendar in Outlook, you can delete it at any time. We'll show you step by step how this works. Delete calendar in Outlook Note: The following instructions refer to Office 2013. The procedure may differ slightly in older or newer versions. Start Outlook and switch to the Calendar category at the bottom left...

In PowerPoint, you can spice up lectures by inserting videos into your presentation. This practical tip explains two methods for this. Click the "Add media clip" icon in the content field of the desired slide. Now select the video you want to insert and confirm below on "Insert". The video has now been inserted and you can scale it as usual or apply effects to it...

You can add a watermark to protect your presentation in PowerPoint. This works in just a few simple steps, as this practical tip shows you. Insert watermark in Office Powerpoint In PowerPoint, click on "View"> "Slide Master". On the left side you have to select the foils you want to watermark...

With the right keyboard shortcuts, you can work even more efficiently in Word. For example, there is a shortcut for bold, underlined and italics. We'll tell you exactly what these are in our practical tip. Word key combination: bold, underlined and italic In Word you can mark a text with the mouse and then use the symbols "F", "K" and "U" to bold, slant or underline your text...

With a new font in Office 2010 you give Word documents an individual touch. You can insert the font in a few simple steps - we will show you how exactly. 1. Install the font on the PC Before you can give your Word documents a certain twist with new fonts, you first need the appropriate fonts. Here we have put together 50 extraordinary fonts that you can also use in Office 2010...

If you have to perform the calculation in Excel, the percentage calculation is not long in coming. We show you how to calculate the percentages. Simple percentage calculation in Excel If you select a cell and click the percent button under the "Start" tab, the cell content is displayed as a percentage...

This practical tip shows you how you can easily convert a text into a table without re-inserting the text into a table. Word: Convert text to table In Word, you can easily convert text to a table using separators and the table function. Add a separator (tab stop or comma) after the desired word, after which you want to divide the text into a column...

In Outlook 2010 you can have pictures and graphics in emails downloaded automatically. With the standard settings, this is only possible manually for each individual email. Automatic download of images in Outlook You can find the corresponding option in the Outlook security center: Go to the "File" tab in the top left...

If the VLOOKUP function does not work in Excel, this may be due to incorrect values. In this practical tip we will tell you what you can do about it. VLOOKUP doesn't work - you can do that The VLOOKUP function searches the selected area for a specific matrix and outputs the overall result. To do this, you must enter the formula followed by the search criterion (for example "CHIP") and the search area (example A1; B1)...

If you do not want to use the standard Word settings, you can adapt them to your personal needs. For example, the font and font size can be changed. We'll show you how it's done. Change default template in Word Open Word and click the "Start" tab at the top. Click on the small symbol to the right of the item "Style sheets" (see picture)...

This guide shows you how to use conditional formatting in LibreOffice Calc. Use conditional formatting in LibreOffice Calc In LibreOffice Calc click on "Tools" and under "Cell contents" tick "Automatically calculate". Then choose Format and click Conditional Formatting. You can now choose from the "Condition", "Color bar", "Data bar", "Icon set" and "Date" items...

In this practical tip, we will show you how you can back up your PowerPoint presentation with appealing music. How to add music to your PowerPoint presentation With Microsoft PowerPoint you can create beautiful presentations quickly and easily. In addition to the numerous features and tools of Microsoft PowerPoint, you can also store your presentation with music...

How to protect cells from changes in LibreOffice is explained in this practical guide. Protect cells in LibreOffice In LibreOffice, cells can be protected against accidental changes. To do this, follow the steps below. Select the "Protect document" option under the "Tools" menu item and click on "Table"...

In Word, you can hide individual sections of text if necessary. This can be useful, for example, if you want to print out a text and omit individual passages without completely deleting them. Hide sections of text in Word - Here's how: First mark the corresponding text section in Word with the mouse...

In this guide, we'll show you how to turn on automatic hyphenation in LibreOffice. Turn on automatic hyphenation in LibreOffice In LibreOffice, right-click the paragraph for which you want to turn on automatic hyphenation. Choose "Paragraph". In the "Text Flow" tab you will find the "Hyphenation" item...

In PowerPoint you can embed YouTube videos directly without having them on your PC. We'll show you how it's done. Embed YouTube video as a Flash object in PowerPoint You can include a YouTube video as a Flash object in your PP presentation. Please note that you must have an internet connection...

In this guide, we show you how to insert line breaks in table cells in LibreOffice. Insert line breaks in LibreOffice table cells To insert a line break within a table cell in LibreOffice, press the key combination [Ctrl] + [Enter] at the corresponding point. This automatically switches to the next line and you can continue to write in the same cell...

This guide shows you how to change the color of bullets in OpenOffice. Change bullet color in OpenOffice Press the [F11] key in OpenOffice and click on "Character templates" in the style sheets. Either create a new style or open an existing style with a right click and "Modify". Click on the "Font Effect" tab and select the desired color under "Font Color"...

To save space in the Office 2010 programs, you can easily show and hide the top menu bar. We show you how it works. How to show and hide the ribbon in Office 2010 There are two very simple methods for showing and hiding the ribbon: By mouse: Double click on one of the menu items such as "Start" or "View"...

This guide explains how you can copy formulas in Excel. Copy formulas in Excel - this is how you proceed Note: These instructions refer to Excel 2013. To copy a formula in Excel, first select the cell in which the formula to be copied is located. Select the "Start" tab at the top of the screen and click "Copy" underneath...

In this practical tip we will show you how to transfer a format multiple times in Excel. Format transferred multiple times in MS Office Excel Note: This practical tip was tested under Microsoft Excel 2010. Click the cell whose format you want to transfer. Double-click the "Format Format" icon (see screenshot)...

You can quickly merge multiple CSV files using the command prompt. We show you how this works in this guide. Merge CSV files at a command prompt With the command prompt and a simple command, you can merge any number of CSV files. Save the CSV files you want to merge in a shared folder. Open the command prompt by typing "cmd" in the Windows search and selecting the entry...

In this guide, we explain how to subtract in Excel. Subtract in Excel Open Excel and enter a value in two cells. Then you have to click in the cell in which the result should be. Next, enter an equal sign followed by an open bracket (see picture). Now click with the mouse on the cell with the minute end (the number from which something is subtracted)...

This guide shows you how to convert your Word document into HTML format. Convert Word to HTML file - you have to do that Start Word and open the document you want to convert to HTML. Click "File" and then select "Save As". Now select the location of your HTML file. Under "File type" click on "Website (* ...

Below we show you how you can easily insert the root symbol in Word documents. The simple root sign as a symbol If you only need the simple root symbol, proceed as follows: First activate the "Insert" tab. Then move to the "Symbols" area in the quick start bar to the far right end and then select "Symbol"...

In this guide, we explain how to display Excel on two screens. Here's how: Show Excel on two screens Open the first document and slide it onto one of the screens. Then open a second Excel program instance. To do this, click on the Excel program again (e.g. via the start menu). In the second newly opened Excel instance, click on the Office icon at the top left and select "Open"...

If you want to create the popular copyright symbol in Word to add the circled "C" to your own work, you will notice that there is no key on the computer keyboard. However, you do not have to do without the copyright logo. Insert Copyright-C in a Word document - three easy ways There are various options for creating the copyright symbol...

In this practical tip we will show you how to delete an empty table in MS Office Word. Word: delete empty table What was cumbersome in old versions of Word is quite simple among the newer ones: Select the entire table that you want to remove. Then right click on it and select "Delete Table"...

To change the character encoding in Excel, only a few steps are required. This quick guide explains how to set them. Set character encoding in Excel In order to set the character encoding in Excel, you have to do a little trick: First start Excel as usual. Then choose File> Save As. Click on "Tools" below and select the "Web Options ...

Excel can be used to round numbers with a simple formula as precisely as desired. At times it gets a bit more complicated. A trick will help you with this. Round the time in Excel - so it'll work Suppose you want to round up a time like 05:20 to the hour. Since times are not expressed in the tens system, you have to use a little trick for this...

The error "WAB.DLL not found" mostly occurs when using Outlook 2000 under Windows 7. In this practical tip, we will show you how to solve the problem. Outlook: WAB.DLL is not found The error arises because the file systems have changed over the years and Windows is looking for the file elsewhere...

If you want to edit several Word files at the same time, you can display them in parallel. We show you how this works in this guide. Word: Show multiple files at the same time In the upper left corner of Word, click on the "File" menu item and select the "Open" option. Mark the desired documents with the Ctrl key and click on the "Open" button...

Bookmarks are particularly useful for longer texts such as semester papers. Setting a bookmark in Word is unproblematic and will save you the annoying and above all time-consuming search later. Better overview with bookmarks in MS Office Word The following example was created with Microsoft Office Word 2010...

You can send an Excel spreadsheet as a PDF by email. You can do this directly from the program and by first saving the table as a PDF. Our instructions will help you with this. Send Excel spreadsheet as PDF To send the table directly from the program, you need a mail program such as Outlook. Open the file menu using the button at the top left and select "Send"> "PDF E-Mail Attachment"...

When you start PowerPoint, the standard font is automatically activated. We will show you how to change this in our practical tip. Permanently change the default font in PowerPoint Unfortunately, you can only change the font in PowerPoint for individual slides. With a little trick you can still change the standard font: To do this, open PowerPoint and click on the "Draft" tab...

Lines in Excel are sometimes very annoying for graphics and tables. You can hide the grid lines quickly if necessary. Hide grid lines under Excel 2010 First, go to the "View" tab. Here you switch to the "Display" section in the ribbon. Then deactivate the "Gridlines" option and a bright white worksheet is available...

In this practical tip, we will show you how to export and import your appointments in Outlook. Outlook: export appointments In the following instructions, we will export individual appointments and the entire calendar. You can find alternative instructions for exporting the entire calendar in this practical tip...

If you want to continue where you left off each time you start Word, you can open the most recently used documents. We'll show you how it's done. Word: Open recently used documents Word 2013/2010: Click on the menu item "File" at the top left and select the category "Open"...

Excel charts are usually above the worksheet. You can use a trick to make the diagrams transparent. Make Excel charts transparent You can remove the fill in the formatting properties of the diagram: Right-click on the monochrome area around the chart and choose Format Chart Area. In the "Area" area (for Excel 2007 "Fill") select the option "No fill" and confirm with "OK"...

You can quickly rename a spreadsheet in Excel. We show you how it works. Rename Excel worksheet - this is how you do it By default, the worksheets in Excel are called "Table 1", "Table 2" ... It becomes clearer if you individually rename the worksheets in Excel. The individual tablets are arranged in tabs at the bottom left...

With Outlook, you can manage multiple email accounts at the same time. We'll show you how to add a second or third account. Add second account in Outlook 2013, 2010, 2007 and 2003 Outlook 2013 and 2010: Click the "File" tab in the upper left corner. Under the "Account information" category you will find the "Add account" button...

You would like to deactivate the automatic enumeration with the annoying paragraph indentations in Word: Here you can find out how it works. Deactivate automatic enumeration in Word Click the "Microsoft Office" button (Word 2007 or higher) and then select the "Word Options". In previous versions, click on "Tools" and then "AutoCorrect"...

If you want to share your appointments with friends or colleagues, you can send them via Outlook. Outlook: send appointment Open the calendar in Outlook and search for the desired appointment. Click on it with the right mouse button and then select the "Forward" option (see screenshot). Now a new mail opens with the appointment as an attachment...

If you want to delete all of the slide notes in your PowerPoint presentation before sharing them, you don't have to remove them one by one. This practical tip shows you how to delete all notes at once. Delete slide notes in PowerPoint With extensive PowerPoint presentations with many slide notes, it is easier to remove them at once...

For mathematical formulas in particular, it can be important to use a period symbol in documents. You can find out how to enter it in Word here. Unfortunately, this is only possible via detours. How to enter the period character in Word Go to the "Insert" tab in the Word menu. Then select "Object"...

If you want to find synonyms for a word using Word, there is a function for this directly in Word. We'll show you where to find this feature. Find synonyms for a word in Word Select the desired word and right-click to open the context menu. If you move the mouse over the "Synonyms" item, all available synonyms will be displayed...

In Excel you can count the number of columns. We'll explain how to do it. Count the number of columns in Excel Start Excel and click in an empty cell with the mouse. With the command "= COLUMN (C3: E3)" you count e.g. B. the number of columns from C3 to E3. You can of course change the two cell names as you like...

If you type quickly, double spaces can easily creep in, but you can easily remove them with Word. In this practical tip, we reveal how to do this. Remove spaces using the grammar checker In the document, open the menu "File"> "Options"> "Document review". Click "Settings" to access the grammar settings...

With Microsoft Excel you can automatically delete every second line. In this practical tip, we will explain how this works. Preliminary: Show developer tools to delete every two lines Click the Office button in the top left, then select "Excel Options". Go to "Frequently used". Under "The most common options when working with Excel", enable the option "Show developer tab in the ribbon"...

Word's line numbering can be a headache if you want to start over within a page. In this guide, we will show you how this works. Restart line numbering in Word To start the line numbering again, you first have to divide your document into sections. Select a section of text that you want to number...

If you are looking for tear-off sheets for a notice, you will find suitable templates here. Here you will find tear-off slip templates The first online template from FleamarkAd is actually a Facebook ad. However, you can adapt the template accordingly. Here is the name of the program: abreisser.de offers you free templates for simply created tear-off slips, which you only have to adjust individually...

In Access, you can set a default value for table fields and get their data-typical specification. You can find step-by-step instructions here. Microsoft Acces: Avoid incorrect data entries with default values ​​for table fields If standard values ​​can be identified for certain table fields, you should already set them in the field properties. In the...

Since Word 2013, you can easily and directly integrate YouTube videos directly into Microsoft Word documents. We'll show you how in the following article. Embed YouTube videos in Word - this is how you proceed First, click the "Insert" tab at the top of the Word menu. There you select the »Online Video« function. ...

In this guide, we show you how to turn off autocorrection in LibreOffice. Switch off auto correction in LibreOffice To disable autocorrection in LibreOffice, click on "Format" in the bar at the top of the screen. Select "Auto correction" and remove the check mark from "As you type"...

Word already has useful table of contents templates for you to help you structure the chapters of your document in a clear and uniform manner. How to find the template for the Word table of contents If you click on the "References" button in the tab, you will see the "Table of Contents" button on the left...

With your own table template, you can save a lot of formatting in Word. If you do not find a suitable template in the predefined quick tables, it makes sense to save your own format settings for the Word table. You can read how this works in our practical tip. Create template and save it as a quick table After you have formatted a table according to your own wishes, mark the entire table: To do this, move the mouse over the table, a cross symbol appears in the top left corner...

Creating a template for PowerPoint presentations is very useful. This saves you the extra work of editing the layout and other settings for each individual slide. With the slide master you can create a uniform layout for the entire presentation. How to find it: Four steps to your own template You can create your own template or edit an existing one...

You can also create a slideshow with PowerPoint. In this practical tip, we will show you how. Powerpoint: create slideshow It is best to move all of the images that you want to display in the slideshow to a separate folder in advance. Open a presentation in PowerPoint or create a new one. Go to "Insert" and here under "Illustrations" to "Photo Album"...

In Word you can connect two separate tables. In this practical tip we will show you how. Connect two tables in Word Move the mouse cursor over the table that will later be in the lower position. Now a small arrow symbol appears on the left above the selected table. Click on it and keep the left mouse button pressed...

Microsoft Word can count the characters and words of your text fully automatically. You will also learn how many pages, paragraphs and lines you have written. How to count characters and words with Microsoft Word If you have written your text and want to check the number of characters, do the following in Word 2010...

If you have the column width of a table automatically adjusted in a Word document, the width of all columns is aligned with the respective length of the content. Here we explain how you can use Word's AutoAdapt function to display data in the most orderly possible way. Automatically adjust column width in the Word table Click in the table whose column width should be adjusted automatically...

Do you work with Office 2003 and still have Windows 7? Does that work at all or is it recommended to switch to a different office suite or to Windows 8? You'll find the answer here! Office 2003 and Windows 7 In a nutshell: Yes, Office 2003 runs on Windows 7. Office 2003 and Windows 7: Fix problems In the unlikely event that problems arise when using Office 2003 and Windows 7, one thing helps: Starting Office in the so-called "XP compatibility mode"...

Finding duplicate entries in Excel 2003 by hand is extremely tedious. With a filter, Excel does the work for you. We show you how it works. Find duplicates in Excel 2003 The best way to find duplicate entries in long Excel lists is to use the duplicate filter: Select a field from the list in which you want to search for duplicate entries...

Underlining a text in Word in color is quick and easy. In this practical tip you can read how it works. How can I underline a text in Word? First of all, mark the text that is to be underlined in color afterwards. Now move the mouse into the "Font" dialog box in which the "U" for "underline" is located and click on the arrow next to it...

With bookmarks you refer to other places within your document. This practical tip shows you how to remove such a bookmark in MS Office Word. Remove bookmarks from Word document The following two steps remove a bookmark from a Word document. Click on "Insert" in the menu bar and there in the "Hyperlinks" area on "Bookmark"...

Instead of the usual advent calendars, you can use PowerPoint to create a unique copy that can then be refilled and used every year. We show how this works in our following practical tip. Create Advent Calendar with PowerPoint For your PowerPoint Advent calendar, first create a folder in which you will later save all the slides and the presentation...

In Access, a formula can be used to calculate the age from the date of birth and thus save a lot of time. You can find out how this formula works in this guide. Access: Create query for the date of birth First of all you have to create a query for the age or date of birth so that the formula also works correctly in the end: Go to the "Create" tab in Access and click on "Query Assistant"...

The form letter function in Word is certainly one of the most popular functions in word processing. If you have a little familiarization with it, you can easily create hundreds of letters in just a few clicks in the future. The path to the mass document The form letter consists of two parts, the main document - which is generally the same for all recipients, and the individual data of the individual recipients...

When importing data series, Excel likes to "unintentionally" convert numbers into the date format - but that can be changed. We show you two methods of how you can turn "May 5" back into "5.5". Solution 1: change Excel cell format The most obvious solution is via the "Format cells" menu...

Line charts in Excel often have a jagged course and look unnatural. We show you how to smooth the diagram lines. Smooth chart lines in Excel Open the file with the line diagram already inserted. The necessary changes are made individually for each line. To do this, right-click on a point on the relevant line and activate the context command »Format data series«. ...

This practical tip shows you how to add a new contact in Microsoft Office Outlook. Add new contact in Microsoft Office Outlook With the "Outlook 2013" e-mail program from Microsoft, you can manage not only your e-mails, but also appointments, tasks and contacts. In this guide, we’ll explain how to add a new contact: Start Microsoft Office Outlook. ...

In this practical tip, we will explain what the difference between "Save" and "Save As" is. Difference between "save" and "save as" If you use the "Save" function in programs, your document will be saved in the previous file path. However, if the file has never been saved, the "Save As" window opens automatically...

You can not only create a table of contents in Microsoft Word automatically, but also with your own headings. We show you how it works. Set references for the Word table of contents Position the cursor at the position in the text to which the table of contents will later refer. Go to the "Insert" tab in the ribbon, click on "Quick Components" in the "Text" area and select the "Field" command...

If you want to insert hyperlinks in PowerPoint without the text being underlined afterwards, you have to do a little trick. In this guide, we will show you how this works. Hyperlinks in PowerPoint: Avoid the underscore with a rectangle To avoid underscoring a word, cover it with a transparent rectangle or other object...

If Word starts slower than usual, there can be three different reasons. In our practical tip you can read how you can fix all three problems. Word starts slowly: Reinstall the printer driver Windows may use a printer driver on a network print server instead of a local driver. Change your default printer and check if the problem still occurs...

If you would like to save an HTML page as a Word document for further processing, you can convert it in a few simple steps. We'll show you how to do it. Convert HTML to Word The HTML document must be available on your PC. If you want to convert a page from the Internet into a Word document, save this page on your hard drive first ("File"> "Save as")...

In order to check tables and lists for duplicate data, you can quickly find all repeated or unique values ​​in newer versions of Excel without having to experiment with formulas or filters. Highlight duplicate values ​​in Excel To do this, first select the data area in question in the table. Then click on the "Conditional Formatting" icon in the "Start" tab of your ribbon. There ...

For Google Plus, you do not necessarily have to process your email traffic via GMail, you can read new messages in Outlook. We show you exactly how this works in this article. How to integrate Google+ in Outlook In order to automatically keep up to date with Google+, you can query the messages of your Gmail account with Outlook 2010 and integrate the Gmail account into Outlook: To set up this function, click on "File" and select "Add Account"...

If you want to highlight a text in Microsoft PowerPoint, you have to take a small detour because this function does not exist. We'll show you how it's done. Colored text passages in PowerPoint Open the slide with the text you want to highlight. Now go to the "Insert" button in the navigation bar before selecting the rectangle in "Shapes"...

With the right Word templates for minutes, you can easily and easily create notes of meetings and meetings. You can find out where to find such templates in this article. Protocol templates - here they are Of course you can also create a template yourself using Word, but it is also easier: Microsoft has a wide variety of protocols for Word 2003 to 20013 users...

Excel is one of the first choices for displaying a Gantt chart. We show you how to create the diagram. The bar chart provides an overview of smaller projects The bar chart, better known by the name of its inventor, the management consultant Henry L. Gantt (1861 - 1919), is often used in project management...

You want to include videos in a PowerPoint presentation. However, some videos do not work properly. It is more reliable to integrate an object from the Windows media player instead. Advantage: You can then play the video within the presentation with the usual control of the media player. Step 1: Select media player in the Powerpoint developer tools While you are in the »Insert« tab with the command »Video | Video from file «can quickly integrate videos, the connection to the media player is not immediately ready and hidden deep in PowerPoint. Fi...

If you often use the same Word documents in a slightly modified form, you can save a lot of work with a template. If you use such a template, Word automatically creates a copy of the file so that your template is not changed. For example, you can create letter templates and frequently used business forms...

When sending emails in Outlook Express, the error message "0x800ccc79 relaying denied" can occur. This means that the server cannot forward emails that come from other servers. How to solve the problem. Check Outlook email address You have to make sure that your sender address is from the provider you use...

Instead of "Times New Roman" you can set a different standard font in Excel. We'll show you how it works in just a few simple steps. How to set a default font in Excel Open a new Excel document and select the "Options" under "File". Here you will find the section "When creating new workbooks" in the "General" tab...

If you would like to use a certain text module such as your address more often in Word, you can do this using the autotext function. We'll show you how to create and insert Auotext yourself later. Create your own autotext in Word 2013, 2010, 2007 and 2003 Start Word and use the mouse to mark any sentence block that you want to use later as autotext...

There are many reasons to activate or deactivate the overwrite mode in Word, because it can be both useful and annoying. We'll show you how it's done. Word 2013 and 2010: Switch overwrite mode on and off Open Word and click the "File" button at the top left of the screen. Now select "Options" at the bottom left...

If you want to determine the highest value of a series of numbers in Excel, you can do this with a simple command. We'll show you how it's done. Find the highest value of a series of numbers in Excel Write down any series of numbers in Excel. In the cell below, type "= MAX (" without the quotation marks...

The euro symbol is on your keyboard at [E] - but where is the pound symbol hidden? There is no separate key for the British currency, we will show you which combination it works anyway. How to find the pound sign: Windows users can create the pound sign with the key combination [Alt] + 156. This works in almost all programs, from Word to Internet browsers...

This practical tip shows you how to compare two different documents in Microsoft Word. Compare documents with Microsoft Word Click Review at the top of the Word ribbon. Now click on the "Compare" tab and then on "Compare ...". Now a pop-up window called "Compare documents" opens...

If you want to cut out graphics and use them in Microsoft Word, no special image editing program is necessary. Word has now integrated a simple function that you can use to make changes to images quickly and easily. Find out where to find the tool in this practical tip. Cropping images in Microsoft Word First insert the relevant graphic in your Word document and mark it with a click of the mouse...

If you use rare fonts in a PowerPoint presentation, you should embed them. This prevents a foreign computer from displaying the presentation incorrectly. Here we'll show you how it's done. Embed fonts in PowerPoint To insert fonts into a PowerPoint presentation, follow these steps. In the gallery below, we have illustrated the instructions for Office 2007 again for you in detail...

In Outlook, the "Carbon Copy" - (Cc) field is immediately visible for e-mails, "Bcc", ie "Blind Carbon Copy", is less known and cannot be found in Outlook either. The difference to the Cc is that the recipient cannot see the addresses of the Bcc. This practical tip shows you how to display this function in Outlook...

You can create many different charts in Excel - including growth curves. You need growth curves to show a size development. Since it is not so easy to create such diagrams, we will show you how to get there quickly. Create data table for the growth curve The growth curve represents the ratio of size to time...

For a rustic look, you can use old German font in office applications. We'll show you how. Install and write new fonts Many websites offer a large selection of fonts for free to download directly as a TTF file, or archived in a ZIP file. If you install it, you can then use it in all common office applications...

The down arrow is one of the symbols you need every now and then. However, you won't find it at first glance. You can read how to insert it in this tip: Enter the down arrow using the old code If you have a keyboard with a numeric keypad, you can easily enter the arrow using the Alt code. To do this, hold down the [Alt] key and type "25" on the numeric keypad...

If you want to protect your emails in Outlook against unauthorized access, you can secure them with a password. Protect Outlook with a password Open Outlook and click on "Options" in the menu bar under "Tools" (see picture). Click on the "Data Files" button under the "E-Mail Setup" tab...

If you have to write invoices for the first time as a small business owner, it is best to download a sample. This way you can see what is on the invoice and do not have to spend a lot of time creating a layout yourself. Invoice templates for download on the Internet You can download samples of invoices free of charge from the following three websites...

Many special characters, such as the infinity symbol, cannot be found on a conventional keyboard. We'll show you how you can still write it - in MS Office programs like Word and elsewhere. Write the infinity symbol in MS Office The infinity symbol is contained in the symbol directory of the Office applications...

This practical tip shows you how to switch between the normal slide view and the outline view in Microsoft's PowerPoint. Change outline view in PowerPoint To change the normal view to the outline view, proceed as follows: Click on the "View" tab in the menu bar at the top. The menu item "Normal" should have a color background...

In Microsoft Outlook, PST files are not only used for archiving e-mail, but also for all other data such as calendar entries, contacts and tasks. They can be saved externally and thus act as a simple backup option for all of your files used in Outlook. Archive emails through PST files in Outlook To create a PST file and save your emails in it, do the following: First, create a new PST file...

There is no function with which you can create a timeline in Excel. But it is relatively easy to create yourself. We show you how it works. Download timeline template for Excel from Microsoft If you don't want to bother creating a timeline yourself, you can download a template from the Microsoft website...

3D diagrams help to prepare complex data clearly in Excel. This practical tip shows you how to create such a graphic in Excel. Create a three-dimensional diagram in Microsoft Excel. As a simple example, the screenshot shows a diagram for the precipitation amount of two regions, as well as the values ​​used for it. In...

Word provides you with a useful feature with the envelope tool: You must enter the sender and recipient address in the envelope template. Then all you have to do is empty the envelope in the printer and print it out. Customize the envelope with the template in Word After you have opened the "Shipments" tab in the menu bar, click on the "Envelopes" button...

After starting Microsoft Outlook, the search often does not work. In order to quickly find what you are looking for in all the emails, contacts and calendars, here are a few tips for you. Limit search to a folder Often the search function will only strike if you search all data. Therefore, it helps, for example, if you already preselect one of your e-mail accounts or have only a certain folder (eg "sent items") browsed...

In Word you can show the so-called navigation area to move faster and easier within a document. We show you how to display the menu and what you can do with it. Show navigation area in Word 2013 and 2016 In the Word versions 2013 and 2016, the navigation area can be selected in the same way. To activate the navigation area in Word 2013 and 2016, first click on the »View« tab. ...

You can easily convert a PDF to a Word document online, so you don't have to download any software. Instead, upload the file in the browser, it will be converted into a Word file for you and you can download it again. Online2PDF: Convert PDF to Word online You can choose from various online services on the Internet that you can use to convert a PDF document into a Word file quickly and easily...

If you want to convert a PDF document into a JPG, you can do this easily online. In this way, you do not have to download and install an additional program, but simply change the file format using your browser. You can find out how to do this here. Online2PDF: Convert PDF to JPG online While it can be difficult to edit a PDF document, it is easy to make adjustments to the JPG image format...

If you have forgotten the password for an Excel file, you have only two options: remember the password or crack the access. We can help you with that. Forgot password for Excel file: Remember Even if you have probably already tried to remember, here are a few tips on how you might still get the password...

If you would like to cancel your membership of the AvD (automobile club of Germany), you have to observe the notice periods. We show you how to do it best here. AvD (automobile club of Germany) terminate AvD membership is always one year. If you do not cancel in time, the contract is automatically extended for another year...

In this practical tip, we present the top 10 shortcuts for Word on Mac. Top 10: Shortcuts for Word on Mac The following keyboard shortcuts give you full control in Word for Mac. If you want to search for a word in the document, just press [Apple] + [F]. To print the document, press [Apple] + [P]. You can save your document with the [Apple] + [S] command...

You can not only buy postcards, but also design and print them yourself using Word. We'll show you how it's done. Step 1: Before printing - set up postcard in Word We use Word 2013 in this guide. Under other versions, the individual functions may be arranged or titled differently. If you switch to the "Page layout" tab above, you will find all the necessary options under the "Page setup" category...

Animations liven up a PowerPoint presentation, but it becomes irritating if you delete one or the other animation. Deleting individual animations is completely easy and does not change the appearance of your PowerPoint slide, except that it flashes a little less. Remove individual PowerPoint animations in three steps The following example was created with Office 2010, but the procedure is similar or the same in other PowerPoint versions...

Even a PowerPoint presentation usually doesn't get along entirely without text. This practical tip shows you how to quickly insert a text field on a slide. In four steps to the text field in PowerPoint To add a text field to a slide, first click on the "Insert" tab. In the ribbon, go to the "Text" area...

With longer documents, it is worth separating the headers from one another. This practical tip shows you how the different headers work in Word. Break the Word document down into sections If you want to separate the headers in Word documents, you must first separate the respective pages. To do this, insert a section break in front of the pages where you want to separate the headers...

With changing working hours, it is not always easy to keep an overview. An uncomplicated roster in Excel can be very useful. We show you how to quickly create a shift or work plan with Office 2010. The structure of the shift plan Our roster basically consists of only three components: The header, in which the different shift types and the associated times are listed...

You can also easily send a fax from Outlook. In this practical tip we will show you how. Send fax from Outlook - note Sending faxes from Outlook is unfortunately not possible. To do this, you need a paid fax service to send the faxes. On this page from Microsoft you will find an overview of all services...

In Microsoft Excel, you compare the values ​​of cells with a simple formula. For example, you can determine whether entered data is true or turns out to be incorrect after the comparison. In the example, the solution words of different players were recorded in rows 2 to 5 of the Excel spreadsheet. Li...

There are many standard functions available in Excel. However, you can also create and use your own. We show you how to do this. Create your own function in Excel In the first step, open Excel if you have not already done so. Click on "Extra"> "Macros" in the menu bar and open the "Visual Basic Editor"...

Word separates end and footnotes from the rest of the text by dividing lines. To remove this dividing line, you only have to make a few settings. Read exactly how this works here. Remove line from footnotes in Word - Step 1 On the ribbon, on the View tab, under Document View, click the Draft icon. Then open the "Show Notes" command in the "Footnotes" area of ​​the "References" tab. Th...

Outlook does not always remove all files from the cache, but does not offer a direct way to clear the cache. We'll show you how it works. Clear cache in Outlook Outlook data is often left in the cache, especially in the event of a crash or if you do not close mail attachments. You can clear the cache yourself so that Outlook works properly again and nobody can see your open attachments...

We explain step by step how to add a reminder in Outlook in this guide. You will automatically be reminded of an email and will no longer forget important appointments or a detailed answer. Outlook 2010 and newer: Add reminder for emails We show you how to proceed from Outlook 2010 to add a reminder...

Diacritical characters as defined are used more often on your keyboard than you might think. You can easily find the usual ones in German. With some diacritical characters, however, you search in vain. This practical tip shows you how to enter these symbols in Word. Diacritics - what is it? The small characters that are attached to letters of the alphabet are called diacritical marks...

This practical tip shows you how to enter a paragraph character in Word. Insert paragraph characters in Word using the keyboard The easiest way to copy the paragraph sign into a Word document is using the keyboard. The symbol is on the number keys in the second row of the keyboard. Simply press the SHIFT key and the [3] key...

You can easily integrate the "Om" or "Aum" character with your keyboard into Word and other writing and graphics programs. The symbol for strength and mantra is not only used by Hindus and Buddhists. It is also a popular tattoo base and is used for cover and poster designs. We show you how to write it in this article...

Here we show you how to display an inverted question mark, as is used in Spain, in Word. Using the number pad to ¿ If you have a number pad on your keyboard, do the following: Press the "ALT" key and enter the numbers "168" one after the other on the number pad. The desired "¿" already appears. ...

Unfortunately, there is no direct keyboard shortcut that you can use to cross out text in Word. In this practical tip, we will show you how you can do it with little effort. Strikethrough text in Word: Shortcut alternative Select a text in Word. Now press the key combination [Ctrl] + [D] to open the font options...

Most users start a PowerPoint presentation the traditional way using a mouse. We will show you alternatives that, among other things, have a more professional effect on the audience. Start PowerPoint Presentation - There are these ways The most intuitive, but also most striking, is still starting your presentation with the mouse...

Learn the top 10 shortcuts for Excel for Mac in this practical tip. Work faster with Excel shortcuts on Mac Use keyboard shortcuts to work faster and more effectively in Excel on Mac: You can create a new workbook with the shortcut [Apple] + [N]. If you want to open an existing workbook, press [Apple] + [O]...

In this practical tip, read the top 10 shortcuts for PowerPoint on the Mac. Powerpoint on the MacBook - you should know these shortcuts The following shortcuts for Powerpoint for Mac give you faster access to all functions: You can start a new presentation with the keyboard shortcut [Apple] + [N]. Use [Apple] + [Shift] + [N] to insert a new slide...

In Word you can insert any image material, including screenshots. We'll show you exactly how it works. Insert your own screenshot in MS Office Word If you have not yet taken a screenshot, you will find step-by-step instructions in this practical tip. If you have just created the screenshot using the key combination [Print] + [Ctrl], you can simply paste it via the clipboard...

There are two ways to buy Microsoft Office 2016: as a box product or as part of an Office 365 subscription. But it is not easy, because there are different office packages and sometimes it is even worth buying individual components such as Word 2016 or Excel 2016. Office 2016 in stores The classic purchase of Office 2016 for Windows runs through a box in retail...

If you search for the free downloads for Microsoft Office, you will find it very difficult to find it yourself at Microsoft. We'll show you where to find the files to install. Microsoft Office: where is the download? The path to free office download is not exactly easy at Microsoft. In the end, you often end up with the offer for a paid subscription to Office 365...

Occasionally, it can be very useful to print the comments on an Excel worksheet. We will briefly show you the corresponding steps below. The information provided relates to Microsoft Office 2010, but works similarly in the other versions of Excel. Print Excel worksheet with your comments To be able to print your comments in Excel, you must first make them permanently visible...

To keep your PowerPoint presentation from looking boring, you can rotate your image to loosen it up. It is even possible to set the exact angle of rotation. In the following article we present the best methods from PowerPoint 2003 onwards. Rotate an image in PowerPoint with the mouse Click the image...

If you want to import an XML file into Excel, you can choose from several functions. We will show you how to open the file correctly. Import XML file into Excel Click on "File" above and select the "Open" option. The XML file can be opened here like any other file. There are now several options for editing the XML file...

You need quotation marks below and above in Word for verbatim speech and quotes. In Word on Mac and Windows, you can easily create the quotes as we show you in this article. Insert quotation marks at the top and bottom of Word: Windows Instructions Word's settings for quotation marks at the top and bottom are easy to find...

If you make the invitation cards for school yourself, you give the cards a personal touch. Designing the card is not difficult and the invitation also looks much more individual. When designing, you can use pre-made Word templates, which you then modify accordingly. With office software, whether from Microsoft or Open Office, for example, designing your invitation cards is almost child's play...

When communion is coming, you can easily make the invitation cards yourself. We'll show you how to do it with Microsoft Word and give you design tips. How to design your own communion invitation card We will use Word 2007 to show you how to create invitation cards for communion. However, you can also use other versions of Word for this...

With Word you can make invitation cards for your wedding yourself. In this way you can create a card according to your individual wishes. This practical tip shows you how to create such an invitation with the Office program. How to design your own invitation card Using Word 2007, we will show you how to create a suitable card for your wedding...

You don't always have to buy invitation cards for a children's birthday party. Even designed, they look much more personal. You can also let your child's wishes flow into it. This practical tip shows you how to create invitation cards for a children's birthday party. How to design an invitation card for a child's birthday The easiest way is to create an invitation card for the children's birthday party using Microsoft Word...

With Microsoft Word you can design invitation cards for your 50th birthday yourself. In this practical tip, we will show you step by step how this works. How to create a 50th birthday invitation card If you still need the right invitation cards for your birthday party, you can easily design them yourself...

To always start Word with a template, you just have to copy the desired file into the "AutoStart" folder. We'll tell you where to find it and how to do it. Word: Special folder is responsible for the start template As soon as you have inserted your template into the "AutoStart" folder, Word loads it automatically each time you start the program...

If the Outlook service is down, you can no longer send or receive mails. We'll show you how to solve the problem. Outlook down: what's the problem? You can send and receive emails free of charge via Outlook (formerly Hotmail). If there are server problems with Microsoft, even the login to Outlook can no longer work...

In Outlook you can create signatures to automatically insert recurring text modules. In business, for example, it is customary to sign your message with your name, company, telephone, email and address. Typing all of the text each time is pretty tedious. Below we show you how to create such a signature with Outlook 2010...

In Microsoft Outlook 2013 you can change the design and choose between different colors and backgrounds. This practical tip shows you where you can find the appropriate option. Customize Microsoft Outlook design Open Outlook and click on the blue "File" field at the top left. Click on "Options" in the bar so that the "Outlook Options" window opens...

We present the best Outlook apps for expanding the mail program. Upgrade missing functions and adapt Outlook to your requirements. For example, archive mails or add holidays and vacation appointments to the calendar. Top extension for large mailboxes: find duplicates in Outlook The 1-click delete Outlook duplicates app finds duplicates in Outlook, regardless of whether they are e-mails, contacts or appointments...

In Outlook, you can import a contact as a VCF file - we show you how to do this in this practical tip. Import contact in Outlook via VCF file Start Outlook and click on the "File" tab in the top left. Now select "Open and export" and then click on "Import / Export" Now a new window opens...

It often makes sense to reduce the size of the attachment in Outlook so that you do not exceed the size limit of your email server. We will show you the best tips for this in this practical tip. Shrink image files as attachments in Outlook With the following steps, you can easily shrink pictures in Outlook to save space...

In order to make your documents more understandable for your audience, you can print out the inserted comments under Word. You can find out how to do this in this practical tip. Print out comments in the Word document Click the Word button in the top left. Move the mouse over the "Print" entry and select the "Print" option on the right...

If you have accidentally overwritten an important Word document, you can restore the previous version in MS Office Word. We'll show you what to do to get your Word document back in its old version. Restore previous version of Word documents Right-click on the corresponding Word document. In the menu you will find the "Properties" option...

You can easily export file names to a Word document. How to quickly create a list of all the data in a specific folder. How to export file names to a Word document Instead of writing the file names by hand, you can also export them via the command line: In Windows, click on "Start" at the bottom left and then "Run"...

If Word no longer starts, this can be due to the program itself or Windows. We'll show you how to solve the problem. Microsoft Word does not start - what to do? Troubleshooting: In many cases, Windows can solve the problem on its own. With a special troubleshooting, Windows searches for the causes and fixes them automatically...

When trying to open a Word file, the error message "An error occurred while trying to pass the command on to the program" sometimes appears. This practical tip shows you how to fix the error. Word error message "When passing the command ...": You can do that There can be several reasons for the error message...

In some documents, Word uses ActiveX controls. You can find out how to activate and deactivate it, what it is and what the risk is in our practical tip. ActiveX control: what is it? ActiveX controls are small program components of applications that you can run on the Internet with web browsers. Word uses such ActiveX controls to display animations and certain types of files, or to collect certain data...

This guide shows you how to use the formula editor in Word. It also allows you to add mathematical equations to your text document. Use formula editor in Word Note: This practical tip is based on Microsoft Word 2013. To use the formula editor in Word, click on "Insert" in the menu bar. On the right side you will find the "Formula" option...

You can get a Word template quickly and easily with which you can create a brochure. We show you various options. Create a brochure using a Word template There are various ways to get Word templates for brochures. In the first example (Word 2010) you download the desired template from Word. To do this, first click on the "File" tab and then on the "New" option on the left...

In Excel, the comma is used as a decimal point by default. You can also use a period instead. This is useful if you want to create an Excel spreadsheet with international relevance. We'll show you what settings you need to make for this to work. Dot instead of comma in Excel tables By default, Excel uses the computer's settings to decide between comma and period as a decimal point...

You cannot sync your Gmail contacts directly with Outlook. However, you can export your contacts from Gmail and then import them into Outlook. We'll show you how to do it. Step 1: export Gmail contacts First, export your contacts from Gmail as a CSV file, and then import them into Outlook. Log in to Google Contacts...

In this practical tip, we will show you how you can switch off automatic capitalization in Word. Word: Switch off automatic capitalization - how it works Open Word. Click on the "File" tab and then on "Options". Select "Document Review" from the left bar. Click on "AutoCorrect Optons" in the right window...

Quick access to Word folders saves a lot of time and you can easily activate it. We'll show you how to access your documents faster in the future. Set up quick access in Word 2010 A few mouse clicks are enough for Word to access the folder in which you usually save your documents by default. First, open a document in Word 2010 that is in the folder of your choice...

If you have created your own folders in Outlook, you can move them to any location. We'll show you how it's done. Move Outlook folder To move a folder, hold it with the mouse and drag it to the desired point. Unfortunately, this only works for each folder individually. Alternatively, you can right-click the "Move folder" option (see picture)...

It is not easy to inherit folder permissions in the Outlook email program. However, there is a little trick that can make your job a lot easier. Folder permissions inherit in Outlook Especially if you would like to inherit the permissions for many folders with subfolders, it is very annoying if this does not work and you have to assign the rights for each folder manually...

With a few tricks, you can also save a Word file as a JPG. This can then be inserted and edited in a graphics program, for example. You can find out how to do this in this practical tip. Convert Word files to JPEG files using a screenshot The fastest way to convert your Word file to a JPG is to simply take a screenshot of it...

With LibreOffice you can create and print a poster or a poster. We explain how this works in this practical tip. How to create a poster with LibreOffice The easiest way to create your poster is with the LibreOffice module "Draw". You can also use "Calc" or "Writer" to create a poster, but only up to A3 format...

This practical tip shows you how you can change the designs in the Microsoft Office products. How to change the page layout in Office You can select predefined page layouts for all Office applications. To do this, click on the "Design" tab in the menu bar at the top. Now you can see the available foil designs in the middle...

If the menu bar has disappeared in Excel, this can have two different causes. We will show you the right solution for both cases. Menu bar disappeared in Excel - minimized? In the best case, the menu bar is only minimized. How to show the menu again: Click the small arrow in the top left of the bar. This opens the quick settings for the menu (see picture)...

In order to increase the readability of a text, it can make sense to divide it into columns. We'll show you how to write in columns with Word here. Create text columns in Word With just a few clicks, you can create a page layout with text columns in Word. That's how it works: Select the "Page layout" tab...

If you want to turn a text upside down in Word, you can use the "WordArt" or a text box. We show you both options in this article. Word: Turn text upside down with WordArt First create a new WordArt via "Insert"> "WordArt" and then enter your text. Then right-click on your WordArt in the context menu and select the "Format WordArt" option...

This guide shows you how to activate the preview images for documents and other Office files in Windows Explorer. Windows Explorer: Activate thumbnails for Office Open the Office file, of which no preview image is displayed in Explorer. Click on the "Office Icon" in the top left corner and select "Save As"...

In Microsoft Outlook it is easily possible to save individual emails on the hard disk. You can choose between different file formats. You can find out how the backup works in this practical tip. Back up emails from Outlook to your hard drive Select the email you want to export to your hard drive. All you have to do is click on it in the inbox so that the message is highlighted in blue...

If you send several messages to different people via Outlook, it is often worthwhile to create a distribution list. We'll show you how it's done. Create e-mail distribution list or "contact group" in Outlook Open Outlook and go to the "Start" tab if it is not already displayed...

If your Outlook data files are damaged, you can use Inbox Repair Tool to save the data. This guide shows how to quickly repair your data. Inbox repair tool The "Inbox Repair Tool" is shipped with Outlook 2010. It checks whether the file structure of your Outlook data files is intact. If discrepancies are found, the software resets the existing data file structure and tries to fix existing problems...

You can create a phone note in Outlook using the journal. We show you step by step how to do it. Outlook: create phone note The journal is mostly hidden in the newer Outlook versions, since the average user does not use the function at all. However, the journal is ideal for telephone notes: Start Outlook and simultaneously press the [Ctrl] + [8] keys...

You can easily display a password in Microsoft Office Outlook. We show you how this works in this practical tip. Only the master password for Outlook cannot be easily read out. Outlook: Show passwords Download the free Mail PassView tool. Unzip the archive on your desktop and open the tool. Wait for the list of passwords to load and look for the forgotten password...

If you want to dictate an email in Outlook instead of typing it on the keyboard, it's very easy. All you have to do is add a small (free) tool beforehand. Dictate email in Outlook: Install Dictate extension As of version Outlook 13 and higher, you can use the Dictate add-in. The extension is not only compatible with Outlook, but also works for other MS Office products such as Word and PowerPoint...

Appointments in Outlook can usually be moved quite easily. It is more difficult with series appointments. It often happens that only a single appointment is processed and not the entire series. We show you how to use Outlook 2010 and newer versions to reliably postpone your appointment series. Outlook 2010 and newer: Postpone series appointments Open the Outlook calendar...

If you have created an appointment for a meeting in Outlook, you can also add and remove individual participants later. In this guide, we will show you how this works. Outlook appointment: add or remove participants The following guide was created in Outlook 2013. When using older versions, individual options can be arranged and titled differently...