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...