Excel: rule of three count

A rule of three, you can use Excel very quickly solve. As the formula in Excel and tasks, calculate, we show you in this Tip.

The rule of three in Excel

1. In Excel, click a cell in which you want to display the result. Tap your The rule of three formula, as an example, "=A1*B1/C1".
2. If you then press the enter key, no result is displayed. The cells A1, B1 and C1 are not yet filled.
3. Enter in the respective cells of the values. Imagine for example, the following rule of three: Three programmers need for a program 24 hours. How long will it take five programmers?
4. To solve this task, type in A1 and the value 3, and in B1 24. In C1 specify a value of 5.
5. In the cell with the formula you will see the result displayed.

Excel MS Office

Excel: rule of three count

By David Amoyal → Saturday, May 24, 2014

A rule of three, you can use Excel very quickly solve. As the formula in Excel and tasks, calculate, we show you in this Tip. The rule of ...

Excel: fields automatically mark in color

We will show you how to fields in Excel automatically mark in color.

Fields in Excel automatically highlight - for what?

Excel: fields Highlighted Excel: fields Highlighted With the automatic selection of cells in Excel, it is still easier, documents, and plans to evaluate and errors or problems to be detected. For example, you can create task lists and get a colored Feedback, who has his number of hours has passed.

Cells automatically mark in color: create rules
Through the so-called rules, you can define values for which a cell can be marked.

• First, select the rows and/or columns, the rule should be taken into account. Drag the Cursor over the corresponding cells.
• Then select the "Start"tab, the Option "Conditional formatting".
• Under the Option "rules to Highlight cells", you will find different ways to define rules, including, for example, "greater than", "less than" or between two values.
• Depending on which option you select in the new dialog box, enter numeric values. Then you can click on the right side of the window, choose a color. The Change will be broadcast live on the selected area will be updated.
• Confirm your rule by clicking on the button "OK" button.

Excel rules edit or delete
If you want a rule to edit or even delete, proceed as follows.

• Under the tab "Conditional formatting" select the bottom Option "manage rules".
• Then a window opens in which all active rules. Select the appropriate rule.
• Click on the Minus button to add the rule to delete, or click on "edit rule"to the values or the rule to edit.

Excel MS Office

Excel: fields automatically mark in color

By David Amoyal → Friday, May 23, 2014

We will show you how to fields in Excel automatically mark in color. Fields in Excel automatically highlight - for what? Excel: fields Hi...

Word: delete page

A page in Word to delete, this may seem awkward, but is really quite simple. Like a page out of your document, remove, we show you in this Tip.

Page in Word delete: design view to set

Paragraph mark delete - delete page, paragraph, delete - delete page when you Delete a page, always make sure that you are in the design view. In the design view is a page break with a paragraph marker. This is not the case, follow these steps:

1. Go in the Word menu, click on "view" and locate the point of "draft".
2. Click on the "draft", and you are in the design view.
3. If the mark is still not visible, open the menu.
4. Click on "Start" and then select "paragraph".
5. Under "paragraph", click on "Show/Hide".

To delete a blank page in Word

You have a one-page document is created, but at the end of the last page opens a blank page.

• This can be by Deleting the page break to remove.
• Go to the bottom of the page and remove the page break with the [DEL]key.

Deleting a page with information in Word

• You delete a filled-in page, by the complete content of the page to remove it.
• Select any of the characters in the page.
• Press [Ctrl]+[A], to the entire contents of the mark.
• Now press the [DELETE]button, which brings you to the complete content eliminate.

MS Office Page in Word delete design view to set To delete a blank page in Word Word

Word: delete page

By David Amoyal → Wednesday, May 21, 2014

A page in Word to delete, this may seem awkward, but is really quite simple. Like a page out of your document, remove, we show you in this T...

Templates folder back - where do I find them?

Whether office or Home Office: Binders are also allowed in times of computers is not missing. As in Word templates folder back to find, we show you in this tip.

With this Word templates for folder back works’s

• Open Microsoft Office Word and click on "New"to the templates catalog.
• In the templates, you will find the sub-item "labels". Select it, and click on the following page, click Other labels". In this division you get the folder back.
• In the first number is the template "folder shared folders". This can be for a large folder back.
• For small folder back is, however, more of the template "folder narrow meeting", also in the first row.
• If you are one of the templates to choose from, you can of course still continue to edit, for example, the fit Text as well as images and other add or remove items.

MS Office

Templates folder back - where do I find them?

By David Amoyal → Sunday, May 18, 2014

Whether office or Home Office: Binders are also allowed in times of computers is not missing. As in Word templates folder back to find, we s...

Photo album with PowerPoint

A photo album, you can in PowerPoint easy to create. Read in this Tip, how to do this.

Create PowerPoint your personal photo album

PowerPoint: photo album With just a few clicks, you can Microsoft Office Power Point your photo album to compile:

1. Start PowerPoint and go to the Insert tab.
2. Click on the "photo album" and then "New photo album".
3. Press on the Button "file/disk"to select images.
4. On the right side you can see the images still need to edit. For example, you can adjust the brightness and contrast, or rotate the image.
5. If you have a text box, click on the Button "New text".
6. Section, select "Albumlayout" the representation for the Album. So you can choose among a variety of different Layouts and the corresponding shape to choose.
7. With a click on "Create" a new presentation with your photo album open.

MS Office PowerPoint PowerPoint creating the photo album

Photo album with PowerPoint

By David Amoyal → Saturday, May 17, 2014

A photo album, you can in PowerPoint easy to create. Read in this Tip, how to do this. Create PowerPoint your personal photo album PowerP...

PowerPoint: wrapping to prevent

The wrapping is in PowerPoint enabled by default. As the function to prevent, we will explain in this Tip.

Wrapping clear: the formatting of the Form edit

1. Click with the right mouse button on the text field, the text wrapping want to prevent.
2. Select them in the opened menu "format shape".
3. On the left select the "text box".
4. Remove the check mark in the "Text in the Form wrap".

MS Office PowerPoint PowerPoint Text Wrapping

PowerPoint: wrapping to prevent

By David Amoyal →

The wrapping is in PowerPoint enabled by default. As the function to prevent, we will explain in this Tip. Wrapping clear: the formatting ...

Word: insert cross-reference

Do you want the reader of your Word document to guide, manage the best by you add cross-references. We will show you how it's done.

Microsoft Word - insert cross-reference

1. Word: insert cross-reference Word: inserting a cross reference In this Note we use the Word 2013. Under other versions of Office can each function differently labeled and arranged.
2. Open your Word document and go up to the "references".
3. Under the category "labels" now you can find the Option "cross-reference".
4. First mark the text as a Link, and then click the Option "cross-reference".
5. Under "reference type" choose, on what type of object you want to reference. Of the Heading down to the footnote, you can make all the different types.
6. Under "References to" you can also choose where exactly should link.
7. Then select the desired Heading, a footnote or other type from the list and confirm with "Paste".
8. The cross-reference is now as a Hyperlink on the selected area will be inserted.

Microsoft Word - insert cross-reference MS Office Word

Word: insert cross-reference

By David Amoyal → Tuesday, May 13, 2014

Do you want the reader of your Word document to guide, manage the best by you add cross-references. We will show you how it's done. Mi...

Word: insert WordArt

Word: insert WordArt cool fonts with shadow and glow effect - we will explain how you WordArts in MS Word insert.

WordArt via the Insert menu, select

1. WordArt paste into Word WordArt paste into Word
2. Click in the Word menu bar, click "Insert".
3. In the Word toolbar is further to the right is a large A Symbol with the signature "Word Art". Click on the icon.
4. Make a double click on the style of the WordArts.
5. In the following "edit WordArt Text"window, you can change the Font and the font size you select. Your desired Text, tap Text:".
6. Confirm with "OK".

MS Office Word Word: insert WordArt

Word: insert WordArt

By David Amoyal → Monday, May 12, 2014

Word: insert WordArt cool fonts with shadow and glow effect - we will explain how you WordArts in MS Word insert. WordArt via the Insert m...

MS Office Word: the words search and replace

In this article we show you how in MS-Office, Word, words search and replace. So you will always find the same words or character combinations, and these can in the entire document change.

Word documents for words search

Words in MS-Word search words in MS-Word search With the Word-search browse all files. You can optionally, the entire document search, the query for individual pages or start your search on the Headings:

1. To do this, click on the "home" tab and choose "edit" the entry "Search".
2. Alternatively, open the search with the key combination [Ctrl] + [F].

Text or Numbers in Word find and replace

Words in MS-Word replace words in MS-Word to replace While you are using the pure search, your results can only find it faster, you can use the function "Replace", words, Numbers or character combinations change. So obliterate, for example, common misspellings:

1. Open the "home" tab and choose "edit" select "Replace".
2. In the document appears to be a two-line search bar: In the upper field, enter your search query and in the lower area of the term, by what you are Looking for want to replace.
3. Under the "Advanced" button, you will find options that you can use the search still continues to Refine.
4. Click "Replace"to the currently highlighted word to change. With "replace All" to improve, you have all of the appropriate words in the document.

MS Office Word Word documents for words search

MS Office Word: the words search and replace

By David Amoyal →

In this article we show you how in MS-Office, Word, words search and replace. So you will always find the same words or character combinatio...

Epub from Word file

If you are from a Word file Epub document want to create, you have a small Trick. We will show you how to do this.

Epubs from Word-files - what you need to do

1. Epub from a Word file to create Epub from Word file
2. Copy the entire Text in your Word document to the clipboard. Best to do this, use the key combination [Ctrl] + [C].
3. The Word itself stores unfortunately, no files as HTML. So you need to an Online Converter such as "word2cleanhtml" to fall back on.
4. Add on the website of the copied Text with [Ctrl] + [V] in the field, and then click on the "Convert to clean " html".
5. Make sure that you have the first two and the last box (see photo).
6. Download then the free Ebook Editor "Sigil", download and install it.
7. Open the HTML view in Sigil, by clicking on the Symbol "<>" button.
8. Paste the generated HTML Code of the web page. Then activate the book mode by clicking on the book icon. Check here whether the formatting is correct and whether it may contain errors.
9. Now you have your Ebook still validate. To do this, click on the top of the green arrow. If there are no issues, you have done everything correctly!

Epub Epubs from Word-files - what you need to do MS Office Word

Epub from Word file

By David Amoyal →

If you are from a Word file Epub document want to create, you have a small Trick. We will show you how to do this. Epubs from Word-files -...

Outlook: read E-Mails to set up

In Outlook, you can in a few steps to a read receipt. We will show you exactly what they need to do.

So, here goes: read receipt for E-Mails in Outlook set up

1. Read receipts in Outlook, read in Outlook
2. Start Outlook, and then, under "file" on the item "options".
3. On the left, select the Option "E-Mail".
4. Scroll down a little, until the setting is "history".
Set the hook in "read receipt, the Display of a message by the recipient confirmed".

Read receipt for selected contacts - what you need to do Instead of the read receipt generally to activate, you can also only individual contacts to assign:

1. Call in Outlook sent Mail to.
2. Maximize the options tab in the "follow up"by clicking on the icon in the bottom right corner of the window.
3. Set the hook in "read this message, confirm".
4. Repeat this process for the contacts of your choice.

MS Office Outlook Outlook: read E-Mails to set up

Outlook: read E-Mails to set up

By David Amoyal →

In Outlook, you can in a few steps to a read receipt. We will show you exactly what they need to do. So, here goes: read receipt for E-Mai...

Business Contact Manager for Outlook

Business processes and customers, the "Business Contact Manager" in Outlook to manage. We will explain how you can take advantage of.

Business Contact Manager

Business Contact Manager Business Contact Manager In the following steps we will explain how the CRM Software in Outlook.

• Download the extension from the Microsoft Store, download and install them.
• Start Outlook, and on the left, click below on "Business Contact Manager".
• Now you are in the so-called Dashboard. Here you have an Overview of all functions.
• Thanks to the advanced contacts function in the BCM, you have all your business contacts in view, and also illustrate representations such as graphics, diagrams or Reports.
• In the communication history, you have an Overview of all tasks, notes and E-Mails, regardless of whether they have already completed or are still pending.
• Sales of the employees can be in contact management visualized.
• In the tasks you can manage all the projects. Here you can see which employees which project has been assigned and the current Status. This will get you in a concise tabular view.
• Using this function, you have a sense of figures, sales and sales opportunities. The BCM includes a variety of report templates, which you according to your Wishes individually design.

Business Contact Manager Business Contact Manager for Outlook MS Office Outlook

Business Contact Manager for Outlook

By David Amoyal →

Business processes and customers, the "Business Contact Manager" in Outlook to manage. We will explain how you can take advantage ...

Outlook 2010: export contacts

Your contacts from Outlook 2010, you can be in various formats. We show you where you can find this Option.

Kontaket Export in Microsoft Outlook 2010

1. Contacts from Outlook to export contacts from Outlook export
2. Open Outlook and click on the top left of "file".
3. Below you go to "Open" > "Import".
4. In the new window, select "export To a file" and click "Next".
5. Then select the desired file type. For a CSV file take, for example, "Comma separated values".
6. After clicking "Next", you need to select what should be exported. In this case, select "contacts" and go on "Next"again.
7. Click on "Browse" and select the location and the name of the file. Then click again on "Continue".
8. About "map Custom fields..." can you still need to decide what contact information in the exported file should be included. Then click "Finish" and the file will be created.

Kontaket Export in Microsoft Outlook 2010 MS Office Outlook Outlook 2010: export contacts

Outlook 2010: export contacts

By David Amoyal →

Your contacts from Outlook 2010, you can be in various formats. We show you where you can find this Option. Kontaket Export in Microsoft O...

Interferes with the automatic Save of Word, you can do it in the settings and disable it. We will show you precisely how this goes.

Word: disable Auto-Save

1. Word: Auto-Save Word: Auto-Save
2. Start Word and click the top left of the window, click the file tab (Word 2013). You can use Word 2007, instead, click on the "Windows"Button.
3. Now select the "options" to open it in a new window.
4. Go to the left in the menu bar to the point "Save" and search for the category of "saving documents".
5. Remove the check mark in front of the Option "AutoRecovery information every 10 minutes to save".
6. Then click the Button "OK"to apply the settings.

MS Office Word Word: disable Auto-Save

Word: disable Auto-Save

By David Amoyal →

Interferes with the automatic Save of Word, you can do it in the settings and disable it. We will show you precisely how this goes. Word: ...

Guides in Word map

If you want images, text and objects on the centimeter in Word order, you should show guides. We show you how to enable them.

Word: show guides

1. Word: show guides Word: show guides
2. Open Word and switch to the tab "view". In older versions of Office, select "Format".
3. Under the category "View" you will find the "grids".
4. Enable this Option, set the lines about the document and you can have objects just position.

Guides in Word map MS Office Word Word: show guides

Guides in Word map

By David Amoyal →

If you want images, text and objects on the centimeter in Word order, you should show guides. We show you how to enable them. Word: show g...

Excel: line break in cell insert

How to enter a line break in a cell in Excel insert, we show you in this guide.

Line break in Excel cell insert

Excel: insert line break in Excel: insert line break To a line break in Excel insert, you have two options.

• Manual line break: If you have a line break manually insert want to press you to the appropriate location, the key combination Alt+Enter. You can now available in a new line within the cell continue to write. Pressing Alt+Enter generates multiple line breaks in a row.
• Automatic line break: Click with the right mouse button on the corresponding cell, and select "format cells". Click on the Tab "orientation" and put a check mark in front of the "word wrap". Then confirm by clicking on "OK".

Excel Excel: line break in cell insert Line break in Excel cell insert MS Office

Excel: line break in cell insert

By David Amoyal →

How to enter a line break in a cell in Excel insert, we show you in this guide. Line break in Excel cell insert Excel: insert line break ...

Wrap text in Word prevent

The line break in the Word prevent you with a few settings. We show you where to find them and break off.

Microsoft Word: word wrap to prevent

Word: word wrap to prevent Word: word wrap to prevent, In some cases, Word inserts a line break, although this is not desired, for example, with the indication of sizes, street names or units. The line break, however, can be quite easy to prevent, here are two simple methods:

1. If you break behind a space to avoid this, you can use a so-called "non-breaking space" type. Use the key combination [Ctrl] + [Shift] + [space] instead of a normal space.
2. Similarly, you can use a protected dash insert. This works by using the key combination [Ctrl] + [Shift] + [dash].

• Through these key combinations are in each case the words before and after the space or hyphen jointly moved to the next line. The unwanted line break is thus removed.

Microsoft Word: word wrap to prevent MS Office Word Wrap text in Word prevent

Wrap text in Word prevent

By David Amoyal →

The line break in the Word prevent you with a few settings. We show you where to find them and break off. Microsoft Word: word wrap to pre...