THE BELL

There are those who read this news before you.
Subscribe to get the latest articles.
Email
Name
Surname
How would you like to read The Bell
No spam
  • Mistake 1. The background of the slide does not match with the theme of the presentation. And we see, for example, a presentation about the revolutions in Russia against the backdrop of birches and mushrooms.
  • Error 2. Used the background that is included in the set. PowerPoint programs. Over the many years of the existence of the PowerPoint program, thousands of people have used standard templates, published their presentations on the web, and showed them at speeches. These templates are already simply tired of listeners.

Solution: It is better to abandon the standard templates. You can find a large number of new interesting templates and backgrounds on the Internet (for example, there are almost a thousand backgrounds on our website -).

The background image should not contain elements that are inconsistent with the content of the presentation. For the background, it is better to use pastel or cold colors (purple, blue, cyan, blue-green, green), red and white colors should be avoided.

  • Mistake 3. Too bright and active presentation background. Such a background, firstly, interferes with the perception of information from the slide, and secondly, it tires the listeners.

Solution: If the background should be a bright picture, then it is better to reduce its brightness. To do this, select a rectangle shape ( InsertfiguresRectangle), close the entire slide with it and select a white fill for it with a transparency of 50% (you can use a different percentage) and remove the borders ( Formatfill figuresOther colors pouring- white and transparency 50% — OK, Circuit figures- no outline).

The background image will become less active.

Or, when you insert a picture on a slide, immediately set the transparency.

  • Mistake 4. The use of inconsistent colors, the lack of a single style for the design of slides.

In this example, in one presentation, one slide uses a large font and left alignment, and the other uses small font and justification in width.

Solution: When designing a section or the entire presentation, you need to adhere to one style. The color scheme should contain no more than three primary colors (of course, exceptions are possible): backgroundheaderbasic text. The theme colors can be changed like this: DesignColors- it is possible to choose a scheme from the proposed set, or you can set your own colors: Create new colors scheme.

  • http://colorscheme.ru/ — selection of colors using the color wheel and generation of color schemes.

  • http://color.romanuke.com/ - a set of color palettes based on photographs (there is a choice of shades: warm, cold, pastel and contrast).

Errors related to text content

  • Mistake 5. Excess text on the slide, placing unstructured text on the slide, text taken from the source as is, without author's processing.

Solution: The text on the slide should be short and concise, it should not duplicate the presentation of the speaker. Abstracts should be placed on the slide.

If the presentation is intended for use by other people, then you can specify the necessary information in the slide notes - these notes will help the users of the presentation work with it.

  • Mistake 6. An attempt to fit a large amount of information on a slide uses more than 90% of the slide space.

Solution: leave indents from the edges of the slide to the content (text and pictures). Try to stick to the rule that 20% of the slide should be empty.

To make the slide take on a finished look, you can use it as a background - a background frame.

Here the text also goes beyond the borders of the frame - it was necessary to reduce the text input area by moving the resize handle to the right.

The text is very large, almost runs into the frame. It needs to be reduced.

  • Mistake 7. All text is written in CAPITAL letters. This text is hard to read.

Solution: use the traditional spellings of the text, as in your native language: the first letter of the sentence is capitalized, the rest are lowercase. A period is placed at the end of a sentence.

  • Mistake 8. Use of unreadable fonts, especially as a body text font. In layout, there is such a thing as readability of fonts. The font should be such that the reader can read the text quickly, without difficulty and discomfort. It is these fonts that are used in books, newspapers, magazines - we are used to them and read them easily. However, there are thousands of fonts with low readability - they are interesting, beautiful, but intended for headings and, most likely, for use in advertising, in design.

Solution: If the target created presentation- not to produce a “wow effect”, but to give information, then use only traditional, familiar to all of us fonts. For text, it is better to use "sans serif" fonts (Arial, Tahoma, Verdana, etc.), please note that serif fonts (Times families and others) are difficult to read from a distance.

Sans serif font and serif font. Serif font is hard to read in presentations, but works well for documents

Italics should preferably be used for a small piece of text that needs to be highlighted, but it is better to highlight individual words and phrases in bold. It is better not to use underlining, as underlined text in presentations is perceived by the user as , that is, it makes it difficult to control the presentation.

For headings, you can use decorative fonts, as long as the text is readable.

The font of the body text should be smaller than the font size of the heading.

  • Mistake 9. Extra and missing periods, spaces, brackets, etc. spelling errors.
  • There is no dot at the end of the title.
  • At the end of the sentence, a period is put, then one space, then the next sentence.
  • The quotation marks in the text of the presentation must be the same - if you have chosen quotation marks-herringbones, then use only them in the presentation (Types of quotation marks: "", "", "", „ “).
  • After the opening bracket or quotation mark, there is no space, the text immediately follows. There is no space before the closing quotation mark or bracket; after the text, a quotation mark or bracket is immediately placed. After the closing quote or bracket, or put a period (if the end of the sentence), a comma or a space, and then the text.
  • There must be one space between all words.
  • After all punctuation marks, there must be a space before the beginning of the next text.
  • Throughout the presentation, words with ё should be yo or e.
  • Different list markers on different pages.

In the first case, the markers are checkmarks, in the second case, squares.

  • Throughout the presentation, lists should have the same punctuation marks after each item in the list, or none at all. For example, put a semicolon after each list item, and a period at the end of the list.

In the first case, there is a dot after each list item, in the second case, there is no

  • There is a red line on some slides, but not on others. It is better not to use the red line in the presentation at all.

Same presentation: different font size.
One slide has , the other doesn't.

Errors related to using images in a presentation

  • Error 10. There is no alignment of shapes, text relative to the edges of the slide, or to each other. Carelessness of design.

The objects on the slide must be aligned. There is a mistake on the next slide: the same rectangles have different distances from the edges of the slide and from each other.

Solution: To fix this error, you need to use the alignment function. Select the desired rectangles (pressed key CTRL ) FormatalignAlign to Slide(in this case, the shapes will align with the borders and center of the slide) or Align selected objects(in this case, the objects will align with each other). After choosing the type of alignment, you need to set its parameters (left, right, top or bottom, center, distribute horizontally or vertically).

  • Error 11. From slide to slide, the same elements on the slide are shifted.

The following example shows two slides that have the same elements: an end presentation button, an Answer caption, and a slide title. You can notice that the same elements are offset and are at different distances from the edges of the slide. It shouldn't be.

Solution: To avoid this error, you need to create the first slide, place the necessary elements on it. After that you can:

  • copy the slide (if both slides carry the same load, as in the example considered), and then change each new slide, leaving the same elements in their places;
  • or create a second slide, then select the desired object on the first slide, copy it, and then paste it on the second slide. The object will be inserted at the same distance from the edges of the slide, i.e. it will not move. The same should be done with other objects.
  • Error 12. Image aspect ratio distortion. Using images different style on one slide (photos and a drawing, an image with a frame and without a frame, with a background and without a background).

The picture is "flattened".

Images of different heights. The white frame of the right image has not been removed (it was possible to choose white as the background of the presentation, then the white frame of the picture would not be visible).

Solution: You need to resize the image by dragging the handles located in the corners of the picture; you cannot resize using handles located on the sides of the image.

  • Error 13. The image frames do not match the theme of the presentation or its style.

Solution: A small frame around the image creates a neat effect, an image with a frame has a finished look. But don't use "mourning" frames, as in the first image on the next slide example. You should also not use image reflection effects that interfere with the perception of information on the slide.

  • Error 14. The image is "cornered".

Solution: Do not place the image on the edge of the slide or in the corner. Indent from the edges of the slide to the image (same as when placing text). If the image needs to be inserted in the corner of the slide, then it is better to step back the same distance from the vertical and horizontal edges. Also try not to place the image in the center of the slide if there is text on the slide.

If the image is a portrait of a person, then it is better to position it so that the eye is directed to the text, but not to the edge of the slide. This will give the slide a finished look.

  • Error 15. Placing multiple images on a slide in such a way that they are difficult to see. Placing two or even 10 images on a slide is acceptable if it does not contradict the logic of the presentation: for example, if images are enlarged when clicked, or these are button images. However, if the image is the main content of the slide, it is with him work in progress and it is it that carries the information load, it should be large.

Solution: If an image is the main content of the slide, insert one image per slide. If you need to use multiple pictures, create multiple slides. Or insert several images on one slide, but in such a way that when you click on the picture, the image opens in full screen.

Other errors in presentations

  • Error 16. Buttons and hyperlinks do not work. Sometimes a situation may arise when in the presentation view mode it is not possible to use the hyperlink button - it is inactive. This can happen simply due to the inattention of the author of the presentation - they forgot to set up the link. But it is also possible that the link button (bottom layer) is covered by the top layer - another image or text, and therefore does not work. This can be seen when the mouse cursor does not become a hand with a finger (like a hyperlink) in the center of the button, but changes around the edges of the button.

Solution: In the first case, just check all links and all buttons of the presentation. In particularly critical cases, test the presentation on other computers.

To solve the problem of overlapping the button with other objects, it is enough to move the interfering object to the background. To do this, right-click on the image and select from the context menu Move back. Now the button will work.

  • Error 17. Sources of sources of images and texts are not indicated. Using someone else's work and not specifying the author is a bad form.

Solution: we have prepared on the topic. More than 80% of the authors of materials on the site indicate the sources of information incorrectly and do not know about it.

  • Error 18. Excess animation, when the animation interferes with the presentation. When adding animation to a presentation, you need to adhere to the principle of minimalism. Animation should not interfere with reading the text, be colorful.

Solution: You should not choose a flickering animation, as well as a fast rotation. All this is tiring, irritating and puts a lot of strain on vision and the nervous system. Extra animation is useless. It is better not to accompany the change of slides with sound effects and active animation. You need to think about which effects will appear automatically, and which on click. If all the animation is on click, it will take a lot of time, such a presentation will be annoying.

  • Error 19. Slide transition is not configured correctly, transition on mouse click or on the keyboard is not disabled. For example, in a presentation game, the user missed the button showing the correct answer and got to the next question, bypassing the game menu. Where to go next is not clear to the user, and sometimes he simply did not understand what happened.

Solution: When creating interactive presentation containing , you need to disable the transition between slides on mouse click and using the keyboard. Many simply choose Transitions - Change slides and remove the checkbox On Click. This method avoids changing slides on click, but the ability to scroll through slides using the arrows, the space bar on the keyboard, and the mouse wheel remains.

There is a more reliable way - Automatic presentation presentation. . But when using it, you need to remember that on each slide there must be a hyperlink button to go to another slide. Otherwise, the slide preview can only be turned off by ending the presentation.

We have tried to describe the main mistakes in creating presentations and we hope that this will help all of us to avoid them in the future.

What mistakes do you know? You can comment on the article.


Most of the office tasks are solved on a computer in the MS Office environment, primarily in Word, Excel, Outlook and PowerPoint. A minimum of knowledge is enough to work with these applications, but in many situations additional tricks can save a lot of time and effort. We will consider some ways to improve the efficiency of work in the above programs in this article.

MS Word

Move text quickly up and down

This is the most fast way moving text without using the mouse. The text is moved with the up and down arrows while holding down the Shift and Alt keys. You do not need to select the text before moving it - this will happen automatically, and each press of the up or down arrow will move the text one paragraph up or one paragraph down. This method is effective not only when moving paragraphs, but also when moving rows in a table.

Removing links in a document

If links appear in the document you created and you need to make them inactive, you can select each link, select the command Insert=>Hyperlink and click on the button Remove link. This is a very long and laborious process. There is a faster way to solve the problem: select the entire document with the command Edit => Select All and click on the keyboard shortcut Ctrl+Shift+F9 links will be removed, and all other document formatting options will be preserved.

About text, text boxes, and autoshapes

When you need to make an inscription, many first create a block of inscription, and then type the text in it. You can achieve the same result by selecting the already typed text and then clicking on the toolbar Drawing button for creating an inscription the text will move inside the inscription.

You can also insert text into autoshapes (except for lines, polylines, etc.) - as a rule, this is done in several stages: create an autoshape, select it, click on the button for creating an inscription and enter text. There is also an alternative option: draw the desired autoshape, right-click on it, select Add text and enter text.

Perhaps, while working, you will change your mind and decide that the text needs to be taken out of the inscription or from the autoshape. To do this, it is not necessary to cut it to the clipboard and then paste it. You can select an inscription (or autoshape) and right-click on it while holding down the Ctrl key - the text will appear in the nearest text field.

Autoshape Lighting

By default in the panel Drawing missing button Lighting; there is no corresponding command in the context menu called when you right-click on the autoshape.

However, it is possible to change the lighting of the autoshape. To do this, add to the panel Drawing button Lighting by calling the command Tools=>Settings=>Commands by selecting from the list Categories paragraph Drawing and dragging the corresponding button from the window Teams(Fig. 1). Using the button is easy - select the autoshape, click on the button Lighting and adjust the lighting as needed (Fig. 2).

Rice. 1. Adding the Lighting Button to the Drawing Toolbar

Rice. 2. Autoshape lighting setup

Hyphenation

To avoid too sparse lines in a document, it is recommended to enable automatic word hyphenation. To do this, the menu Service select a team Language=>Hyphenation and check the box next to the corresponding option (Fig. 3). Just keep in mind that Word always tends to wrap hyphenated words in place of the hyphen. In some cases, it is desirable to avoid such a gap (for example, 10 percent, number 1, 234-345, etc.). To do this, instead of a regular hyphen, use a non-breaking hyphen by pressing the key combination Ctrl+Shift+Hyphen.

Rice. 3. Setting automatic hyphenation

At the same time, it is quite possible that in part of the document, in particular in the headings, hyphenation is not required. To disable hyphenation in a number of paragraphs, select them, use the command Format=>Paragraph=>Page Position and check the box next to the corresponding option (Fig. 4).

It must be admitted that Word cannot transfer some words correctly. In these words, in positions where you can hyphenate, you should insert a soft hyphen character by pressing the keys Ctrl+Hyphen. This hyphen will take precedence over automatically inserted hyphens.

Text with indices

If your document contains variables with indices typed directly in the text and in formulas created using the MS Equation formula editor, then by default they will look unequal (different sizes of variables and indices and different levels of their location on the line), which significantly spoils the appearance of the document (Fig. 5).

Rice. 5. Text with an index (the first option is typed in Word, the second - in MS Equation)

You can achieve almost complete identity of the appearance of variables with indices by changing a number of characteristics of manually typed variables. To do this, print all text in Times New Roman font size 12, and variables in additional italics. Also, move variables down 1.5 pixels and indexes down 3 pixels with the command Format=>Font=>Spacing by selecting in the field Bias option Down and specifying the size of the offset (Fig. 6).

Rice. 6. Offset setting

Also, make sure the size is selected in the formula editor Ordinary ( team Size=>Regular) and make it fit 12 pixels (command Size=>Determine fig. 7).

Rice. 7. Adjusting Regular Font Sizes

Breaks in tables

When working with multi-page tables, it sometimes happens that the table breaks not at the end of the sheet, but much earlier, leaving only two-thirds or even a third of the page filled (this depends on the width of the particular line of the table on which the break occurs). At the same time, subsequent rows of the table are transferred to the next page, although they could well fit on the previous one (Fig. 8). This often happens when filling table cells by regular copying, when along with the data, their formats are also copied.

Rice. 8. An example of a table in which the line break does not reach the end of the sheet

The reason for this phenomenon is that the text in the table cells has a broken paragraph setting. To change the situation, select the table, open in the menu Format command Paragraph=>Page Position and remove the checkboxes Don't break paragraph, Don't tear yourself away from the next And From a new page(Fig. 9) the table will return to its usual form.

Rice. 9. Change Paragraph Options

date in document

Most documents should have the date they were created; it is not uncommon to create or update the same type of documents daily. Therefore, it is very convenient to use automatic date insertion: you press the key combination Alt+Shift+D, and the current date, updated each time the document is opened, is inserted at the cursor position. But this method is not always suitable, since the date is inserted in the traditional format dd.mm.gggg. If this format does not suit you, then use the command Insert=>Field, in the list of fields, select the field Date and specify the desired date format (Fig. 10).

Rice. 10. Select date format

If none of the date formats suits you, for example, you need the date in the first line of the document, and the day of the week in the second (as in Fig. 11), then you will have to find a more or less similar date format and edit it. In this example, there is no problem with the date being printed in the top row of the table, since such a format is in the list of formats, and the problem is to insert the day of the week - such a field format Date does not exist. To edit the format open in the menu Insert command Field, in the list of fields specify the field Date and select the original date format, which includes the desired day of the week (Fig. 12). Click the button Field codes and edit the date format in the field Field codes, removing the unnecessary part of the format (Fig. 13). Complete the operation by clicking on the button OK, after that, every time the document is opened, the current day of the week will be printed.

Rice. 11. Document with modified date field

Rice. 12. Selecting the original date format for editing

Rice. 13. Date format after editing

Document search

The necessary documents can be searched not only in the usual way, that is, using the command Start=>Find=>Files and Folders, but also directly in Word when opening documents, and when searching in Word, you can rely on the specific properties of documents (document title, author, subject, keywords, file size, date of last update, etc.) or on words found in text.

To search for documents by a word in the text, select the command File=>Open and click on the button Tools=>Find=>Normal. Enter a search word, define the search area (Fig. 14), the types of files you are interested in (Fig. 15) and click on the button Find(Fig. 16).

Rice. 14. Determining the area to search

Rice. 15. Determining the type of files

Rice. 16. The result of the search for documents in the text or in the title of which the word "Internet" occurs

To search for documents by their properties, select the command File=>Open and click on the button Tools=>Find=>Advanced. Suppose that the computer contains not only your personal documents, but also files of other authors with whom you are working on a common project. In this case, in the field Property specify an option Author, in field Condition option Contains(it’s more reliable, because in one case the author can enter only the last name, in the other the first name and last name, etc.), in the field Meaning enter the author's last name and click on the button Find(Fig. 17).

Rice. 17. Search all documents of a specific author

However, keep in mind that searching for documents by their specific properties only makes sense if these properties are specified by all document authors - the default option to fill them, alas, will not provide the desired result. You can specify properties separately for each document by using the command File=>Properties=>Document(Fig. 18). However, it is unlikely that any of the authors will forget to do this in any document, so it is better to include the mandatory filling of the fields of the key properties of the document when it is first saved. To do this, use the command Tools=>Options=>Save and check the box Suggest filling in document properties(Fig. 19).

Rice. 18. Filling in Document Properties

Rice. 19. Setting mandatory saving of key document properties

You can search for documents by the date of their creation, and set not only specific dates, but also their intervals or a list, which is done using tokens AND or OR. In order to find all documents, for example for 2003, in the field Property specify an option Date of creation, in field Condition option Not earlier, in field Meaning enter date January 1, 2003 and click on the button Add. Then again enter in the field Property option date of creation, in field Condition option Not later, in field Meaning enter date January 1, 2004, click the button Add and then on the button Find all documents for 2003 will be found (Fig. 20).

Rice. 20. Setting up the search for documents created during a certain period

MS Excel

Assigning color to sheet tabs

Sheet labels can be multi-colored, which is convenient in books with a large number of sheets - then the color, along with the name, will be responsible for the type of information on the sheets. To assign a specific color to individual sheets, select them, right-click, select the command Label color and select the desired color.

Quick insert columns and rows

To add a row or column to a table, it is not necessary to select the column or row in front of which you want to insert, access the context menu and select the command Add Cells. You can press the key combination ctrl+shift simultaneously with the "+" sign on the numeric keypad - the result will be the same.

Mutant columns

By default, columns in Excel are denoted by Latin letters, and rows by numbers. If, having opened the table again, you find that the columns have begun to be numbered in the same way as the rows (Fig. 21), do not be alarmed - this is not the action of a virus. Use the team Tools=>Options=>General and uncheck the box R1C1 link style(Fig. 22) everything will fall into place.

Rice. 21. Table with numbered columns

Rice. 22. Return to standard column notation

Speed ​​up printing

If you need to print a large number of tables, and you are limited in time, then when printing on a black and white printer, you can speed up the process by giving up color (printing in black and white). On black and white printers, colors are displayed as shades of gray and require certain time to select a shade for a specific color. When printing in black and white, colored text and borders appear in black instead of grayscale, saving time. to install black and white printing, open in the menu File command Page Setup=>Sheet and in the group Seal check the box black and white(Fig. 23).

Rice. 23. Printing setting in black and white mode

In addition, you can print without grid lines - in this case, large sheets are printed faster. To do this, use the command File=>Page Setup=>Sheet and uncheck Net ( rice. 24).

Rice. 24. Refusal to print the grid

Entering fractional numbers

By default, fractional numbers are entered in Excel in accordance with the way it is set in the Windows settings: Control Panel=>Language and Standards=>Numbers. In other words, if a comma is intended for entering fractional numbers in Windows, then in Excel they will be entered separated by commas. However, in practice it may turn out differently. For example, on computers that have a large number of users, especially in educational institutions, where the program settings change in the most unpredictable way. If, when entering a fractional number separated by a comma, you see a number separated by a dot on the screen and have already checked that windows settings expect input separated by commas, use the command Service\Options\International and highlight the checkbox Use system separators(Fig. 25).

Rice. 25. Return to system separators

Representation

When finalizing the appearance of a table and preparing it for printing, it is often necessary to repeatedly change the formatting and printing features. Usually in such cases, sheets are copied and the features of their display on the screen and when printed are changed. However, it is more convenient to create different sheet views that allow you to view data in different modes and do not require the creation of separate sheets.

Before creating a view, the book must be fully configured: it must be given the desired appearance and set all the necessary printing options for it. When print options are entered into a view, it will automatically include certain areas print each sheet, or the entire sheet if the print area is not defined for it.

To create a menu view View select a team Representation, press the button Add and in the field Name enter a name for the view (Figure 26). In this case, it is better to include the name of the active sheet in the name of the view in order to make it easier to find the desired view in the future.

Rice. 26. Create a View

To return to one of the previously created views, if, for example, you need to print a sheet, use the command View=>Views and in the field Kinds select the view for printing (Fig. 27), then press the button Apply and click on the button Seal The sheet will be printed in black and white.

Rice. 27. Choosing the right view

Subtotals

Quite often, you have to deal with large lists that include multiple cell values ​​for which you need to know the subtotals. Excel can automatically calculate both subtotals and grand totals in any list. Usually, this is done first by sorting with the command Data=>Sort(to group rows for which you want to sum up), then calculate the grand totals, and then insert rows for subtotals and calculate them (Fig. 28).

Rice. 28. Calculating subtotals

If the table is large and there are many areas for which subtotals must be calculated, this process will take a long time. To speed up the work, you can first select a unique list, for each of the values ​​\u200b\u200bof which you need to determine the intermediate total, and only then calculate the totals themselves. To create a unique list, select the required column or row and use the command Data=>Filter=>Advanced Filter. Set the group switch Treatment to position , specify the range of cells in which you want to place the result, and enable the option Only unique records(Fig. 29, 30). As a result of such filtering, all unique objects of the original list will appear in the specified area of ​​the table.

Rice. 29. Advanced filter command window

Rice. 30. The result of creating a unique list

Then use the function SUMIF(range, criteria, sum_range) A that summarizes the cells that meet a certain criteria. The range is the range of cells that are checked against the criterion; criterion - a criterion in the form of a number, expression or text that defines the summed cells; summation range - summed cells (Fig. 31).

Rice. 31. Calculate subtotals for each of the values ​​of a unique list

Removing duplicate lines

Imagine that there is a telephone directory table (dictionary, etc.) consisting of two columns and a huge number of rows. In the first column, for example, the names of customers are entered, and in the second - their telephone numbers, while the lines can be repeated (Fig. 32). The task is to remove all duplicate lines. The first solution that comes to mind is to sort the table by the first column with the command Data=>Sort and manually remove duplicate lines.

Rice. 32. Initial table

If the table is very large, you can achieve the same result in a faster, albeit more complex way. First select a unique list of phones by using the command Data=>Filter=>Advanced Filter by setting the group switch Treatment into position Copy the result to another location, specifying the range of cells in which you want to place the result, and enabling the option Only unique records(Fig. 33).

Rice. 33. The result of creating a unique list of phones

Now we need to use the function VLOOKUP(lookup_value, table, column_number, value True or False) where lookup value is the value to be found in the first column of the table; table a table with information in which data is searched; column number number of the column in the information table in which the corresponding value is to be found. Given that the function works in such a way that the search for the desired value is possible only in the first column, you will need to swap the columns "FULL NAME" And "Telephone", and then in column D enter a formula with the VLOOKUP function (Fig. 34). According to this formula, the program will take the next value from column C, look for it in column A, and then return the value from column B, located in the found row. After that, it remains to make a copy of column D using a special paste, so that the cells contain not formulas, but values ​​(command Paste => Paste Special => Values fig. 35), and delete columns A, B and D that have become unnecessary.

Rice. 34. The result of calculations through the VLOOKUP function

Rice. 35. Appearance tables after applying Paste Special

MS PowerPoint

slides from files

When preparing a presentation, you can use pre-created Word documents and slides from other presentations.

In the first case, if we are talking about creating a new presentation, open a Word document and apply the command File=>Submit=>Microsoft PowerPoint as a result, a new presentation will be created with the text from the file. If you want to insert text from word document into an existing presentation, then open the presentation in PowerPoint and click on the tab Structure(Fig. 36). Specify the slide icon that you want the new text slide to appear behind. On the menu Insert select a team Slides from structure and select the required document. Keep in mind that the text that is inserted into the presentation is generated based on the style of the document's headings, and you can only use text from files in the *.doc, *.rtf, or *.txt formats.

Rice. 36. Structure tab

If you want to insert a slide from another presentation into an open presentation, then from the Insert menu, select the command slides from files, select the presentation and the inserted slide (Fig. 37) and click the button Insert. If you are inserting all slides, click the button Paste All.

Rice. 37. Select insert slide

Complex numbering

Page numbering in slides is done by inserting the page number in the footer with the command View=>Headers and Footers, which opens the Header and Footer window, where you need to enable the checkbox footer(Fig. 38) and click on the button Apply to all. Keep in mind that hidden slides continue to count towards numbering. To avoid this, you can put all the hidden slides at the end of the presentation - and then all the shown slides will be numbered in order.

Rice. 38. Inserting a Footer

Naturally, the slide pages are numbered in order. If you need to start pagination again in different places of the same presentation (this may be required if your presentation is still under development and consists of several separate series of slides), then, alas, you cannot do this inside one presentation . To solve the problem for each series of slides, you will need to create different presentations and link them together with hyperlinks.

Presentation template

If presentations are held frequently, it is advisable to spend time carefully preparing a non-standard presentation template - today this is no less relevant than, for example, letterhead for business letters. The template saves the logo of the organization, etc. elements that will automatically play on all created presentation slides. In addition, the template determines the format, size and relative position of objects, the fonts used, the background and other design options for the presentation elements.

Template development begins with the creation of a new presentation through the command File=>New. Then select a design template for the slide from the list of default templates. Before changing the design template in accordance with the intended plan, in the menu View select a team Master=>Slide Master. On the slide master, make changes that you want to reflect in each new presentation you create. First of all, change the design and adjust the fonts (Fig. 39), in the next step, insert the logo (Fig. 40), and after all the changes on the toolbar Sample click on the button Close Wizard View.

Rice. 39. The result of setting the main elements of the presentation template

Rice. 40. The appearance of the slide after inserting the logo

Save the presentation as a template with the command File=>Save As, select variant as the file type Presentation template and enter the template name (Fig. 41).

Rice. 41. Save a Presentation Template

To use a template when creating a presentation, click the button Slide Builder, click on the link Review in the lower right corner of the slide and select the presentation template you created.

Once you've created a template, you can add it to the list of templates in the AutoContent Wizard. To do this, the menu File select a team Create. In area Create click on the link From the autocontent wizard, press the button Further. Then select the category in which you want to place the template, click the button Add and specify the presentation template to be added (Fig. 42).

Rice. 42. Result of adding a template to the autocontent master list

Several design options in one presentation

When designing individual slides in a presentation, you can use several templates. To do this, select certain slides, right-click on the desired template and select the option Apply to selected slides. If this command is not available, use the command Tools=>Options=>Edit and in the area Disabling new features uncheck Several samples(Fig. 43).

If you use the templates you created for the design of the presentation slides, and not the default templates, then the installation of a new template for a particular slide will occur automatically when you click on the Browse link and select the previously created presentation template, unless, of course, there is a ban on the use of different design options

Rice. 44. Set up automatic spell checking

Using a data file to export contacts

All created messages, appointments, tasks and diary entries are stored in a data file on local computer. This data file is called a personal folder file and has a .pst extension. When reinstalling the system, this file can be easily saved in a separate folder on the hard drive or on a CD, and then reconnected.

In addition, the PST file allows you to access information such as contacts from another computer or share them with other users. To do this, you just need to export the data to a PST file using the Import and Export Wizard. Open in the menu File command Import and export, select as the action option Export to file, and in the next window specify that you need to create a PST file (Fig. 45). Next, select a folder Contacts and determine the features of saving the file (Fig. 46). Click the button Ready, and then your contacts will be saved in the folder you specified on the disk, which will be easy to connect on another computer using the same import and export wizard. Connecting a PST file with contacts is no different from connecting a regular PST file. In order not to forget the file's location, it's best to add it to the list of Outlook data files right away. To do this, use the command File=>Data File Processing, click the button Add and point to the generated PST file. As a result, in the list of data files, in addition to personal folders, the file with contacts you created will also appear (Fig. 47).

Rice. 45. Determining the type of file to be created

Rice. 46. ​​Determining conditions for a saved file

Rice. 47. Outlook Data Files

Working time planning

The end result depends on how well the work is planned. To sort out the list of tasks, Outlook helps to some extent, but it only reminds you that the time has come to start a particular task, that it is already overdue; in addition, Outlook can reassign the task to another employee and allow you to control its execution. And with this, by and large, the capabilities of Outlook in terms of task processing are exhausted.

However, it is very important not only to outline a number of tasks, but also to plan them in such a way that everything is done on time and that planning is as automated as possible. You need to know when you will finish a specific task, whether it is even possible to complete it by the deadline, and when it is best to start the task in order to complete it in time.

It is good to be able to assess in advance how realistic the plan you have outlined is (subject to the characteristics of your working week, availability of a lunch break, scheduled meetings, etc.). In addition, tasks should automatically appear in the calendar, and the calendar status should be automatically updated as tasks are rescheduled. All this can be done by a plug-in for Microsoft Outlook 2002/XP Taskline ( http://www.taskline.info/MAPI/TasklineSetup.exe, shareware, 1.2 MB) from ResultsWare Limited, is a handy and easy-to-use task manager that will allow you to optimize your schedule.

Before you start using the plugin, you need to configure it in accordance with the peculiarities of the working day. To do this, click on the button taskline, go to the tab working week and indicate the working days of the week, the beginning and end of the working day and all available breaks (for lunch, technical break, etc.) - fig. 48.

Rice. 48. Scheduling

Then outline the upcoming tasks for the coming days. At the same time, please note that after installing the plugin, an additional tab will appear in the task creation window taskline, on which you need to indicate the estimated duration of the work, and if the work has already begun, then the amount of time spent on it and the percentage of completion (Fig. 49, 50).

Rice. 49. Create a task

Rice. 50. List of tasks planned for the next week

After that, you can start testing the plugin. To do this, click on the button taskline, go to the tab Tasks, specify the start time (Fig. 51) and press the button OK. The result of the plug-in's work will be a brief report on the number of scheduled tasks, the total time for their execution and the deadlines for completing the work (Fig. 52). At the same time, the program will place the tasks in the calendar in the best possible way - while taking into account both all breaks in work, as well as the meetings, appointments, etc. in the schedule (Fig. 53).

Rice. 51. Determination of the start time of the analysis and distribution of tasks

Rice. 52. Taskline conclusion regarding the list of scheduled tasks (in this case, everything planned can be done on time)

Rice. 53. The result of the distribution of tasks in the calendar

Hyphenation can be placed in the entire document or in its part, which must first be selected.

To enable the hyphenation mode in the text, use the command Hyphenation(tab Page layout/ group Page settings).

This command has nested items.

    Team Auto places hyphens in the text automatically.

    Team Manual opens a dialog box offering hyphenation options for words that can be hyphenated and asks for confirmation to insert a hyphen into the text.

    Team Hyphenation Options allows you to customize your options for hyphenation in words using the dialog box (Figure 15).

Figure 15 Window Hyphenation

Transfer zone is the maximum spacing allowed between a word and the right page margin without a word break. In a wide zone, there are fewer transfers, with a narrower one, the edge of the right field is smoother.

Can be deleted automatic hyphenation using the command Hyphenation by choosing the command No.

Exercise.

    Open file Document example.docx.

    For all text, excluding uppercase words, perform automatic hyphenation with a hyphenation zone width of 0.5 cm.

    Save the document.

Working with windows

In Word 2010, you can work with multiple windows at the same time (with one or more documents) using the tab View, group Window (Figure 16).

Figure 16 Command group Window tab View

If several document windows are open at the same time, the transition from one window to another is carried out using the command Go to another window or through the Windows taskbar.

Exercise.

    Open file Document example.docx.

    Create an additional window for this document (tab View/ group Window/ team Newwindow).

    Position both windows side by side (tab View/ group Window/ team Near). Turn off synchronous scrolling (tab View/ group Window/ team Synchronous scrolling).

    Split window 1 (tab View/ group Window/ team Divide).

    Arrange windows vertically (tab View/ group Window/ team streamlineAll).

Changing the scale of a document

While working with a document, you can change its scale (document file size does not change), as well as save it with a document or template. Zooming is carried out on the tab View, group Scale(Figure 17).

Figure 17 Group Scale tab View

A more precise scale setting is made in the dialog box. Scale(tab View/ group Scale/ team Scale) (Figure 18).

Figure 18 Window Scale

Zoom slider , located in the lower right corner of the status bar (Figure 19), allows you to change the scale to the desired value by moving the slider and using the "+" and "-" buttons. To the left of the slider, the scale of the document is displayed as a percentage (Fig...).

Figure 19 Zoom slider

Exercise.

    Open file Document example.docx.

    Change the scale of the document in various ways.

    Close the document without saving.

Character and paragraph formatting Character formatting

The main property of text characters is the font, which is characterized by: typeface, style and size 6 .

Group is used to format characters. Font tab home (Figure 20).

Figure 20 Group panel Font

Also, for character formatting, you can use the Mini-Panel, which opens automatically when text is selected (Figure 21).

Figure 21 Mini panel

Using the group button Font, you can call up a dialog box Font (Figure 22).

Figure 22 Window Font

In the dialog box Font tab Additionally you can change the spacing between characters to sparse or compacted.

Most of the office tasks are solved on a computer in the MS Office environment, primarily in Word, Excel, Outlook and PowerPoint. A minimum of knowledge is enough to work with these applications, but in many situations additional tricks can save a lot of time and effort. We will consider some ways to improve the efficiency of work in the above programs in this article.

MS Word

Move text quickly up and down

This is the fastest way to move text without using the mouse. The text is moved with the up and down arrows while holding down the Shift and Alt keys. You do not need to select the text before moving it - this will happen automatically, and each press of the up or down arrow will move the text one paragraph up or one paragraph down. This method is effective not only when moving paragraphs, but also when moving rows in a table.

Removing links in a document

If links appear in the document you created and you need to make them inactive, you can select each link, select the command Insert=>Hyperlink and click on the button Remove link. This is a very long and laborious process. There is a faster way to solve the problem: select the entire document with the command Edit => Select All and click on the keyboard shortcut Ctrl+Shift+F9 links will be removed, and all other document formatting options will be preserved.

About text, text boxes, and autoshapes

When you need to make an inscription, many first create a block of inscription, and then type the text in it. You can achieve the same result by selecting the already typed text and then clicking on the toolbar Drawing button for creating an inscription the text will move inside the inscription.

You can also insert text into autoshapes (except for lines, polylines, etc.) - as a rule, this is done in several stages: create an autoshape, select it, click on the button for creating an inscription and enter text. There is also an alternative option: draw the desired autoshape, right-click on it, select Add text and enter text.

Perhaps, while working, you will change your mind and decide that the text needs to be taken out of the inscription or from the autoshape. To do this, it is not necessary to cut it to the clipboard and then paste it. You can select an inscription (or autoshape) and right-click on it while holding down the Ctrl key - the text will appear in the nearest text field.

Autoshape Lighting

By default in the panel Drawing missing button Lighting; there is no corresponding command in the context menu called when you right-click on the autoshape.

However, it is possible to change the lighting of the autoshape. To do this, add to the panel Drawing button Lighting by calling the command Tools=>Settings=>Commands by selecting from the list Categories paragraph Drawing and dragging the corresponding button from the window Teams(Fig. 1). Using the button is easy - select the autoshape, click on the button Lighting and adjust the lighting as needed (Fig. 2).

Rice. 1. Adding the Lighting Button to the Drawing Toolbar

Rice. 2. Autoshape lighting setup

Hyphenation

To avoid too sparse lines in a document, it is recommended to enable automatic word hyphenation. To do this, the menu Service select a team Language=>Hyphenation and check the box next to the corresponding option (Fig. 3). Just keep in mind that Word always tends to wrap hyphenated words in place of the hyphen. In some cases, it is desirable to avoid such a gap (for example, 10 percent, number 1, 234-345, etc.). To do this, instead of a regular hyphen, use a non-breaking hyphen by pressing the key combination Ctrl+Shift+Hyphen.

Rice. 3. Setting automatic hyphenation

At the same time, it is quite possible that in part of the document, in particular in the headings, hyphenation is not required. To disable hyphenation in a number of paragraphs, select them, use the command Format=>Paragraph=>Page Position and check the box next to the corresponding option (Fig. 4).

It must be admitted that Word cannot transfer some words correctly. In these words, in positions where you can hyphenate, you should insert a soft hyphen character by pressing the keys Ctrl+Hyphen. This hyphen will take precedence over automatically inserted hyphens.

Text with indices

If your document contains variables with indices typed directly in the text and in formulas created using the MS Equation formula editor, then by default they will look unequal (different sizes of variables and indices and different levels of their location on the line), which significantly spoils the appearance of the document (Fig. 5).

Rice. 5. Text with an index (the first option is typed in Word, the second - in MS Equation)

You can achieve almost complete identity of the appearance of variables with indices by changing a number of characteristics of manually typed variables. To do this, print all text in Times New Roman font size 12, and variables in additional italics. Also, move variables down 1.5 pixels and indexes down 3 pixels with the command Format=>Font=>Spacing by selecting in the field Bias option Down and specifying the size of the offset (Fig. 6).

Rice. 6. Offset setting

Also, make sure the size is selected in the formula editor Ordinary ( team Size=>Regular) and make it fit 12 pixels (command Size=>Determine fig. 7).

Rice. 7. Adjusting Regular Font Sizes

Breaks in tables

When working with multi-page tables, it sometimes happens that the table breaks not at the end of the sheet, but much earlier, leaving only two-thirds or even a third of the page filled (this depends on the width of the particular line of the table on which the break occurs). At the same time, subsequent rows of the table are transferred to the next page, although they could well fit on the previous one (Fig. 8). This often happens when filling table cells by regular copying, when along with the data, their formats are also copied.

Rice. 8. An example of a table in which the line break does not reach the end of the sheet

The reason for this phenomenon is that the text in the table cells has a broken paragraph setting. To change the situation, select the table, open in the menu Format command Paragraph=>Page Position and remove the checkboxes Don't break paragraph, Don't tear yourself away from the next And From a new page(Fig. 9) the table will return to its usual form.

Rice. 9. Change Paragraph Options

date in document

Most documents should have the date they were created; it is not uncommon to create or update the same type of documents daily. Therefore, it is very convenient to use automatic date insertion: you press the key combination Alt+Shift+D, and the current date, updated each time the document is opened, is inserted at the cursor position. But this method is not always suitable, since the date is inserted in the traditional format dd.mm.gggg. If this format does not suit you, then use the command Insert=>Field, in the list of fields, select the field Date and specify the desired date format (Fig. 10).

Rice. 10. Select date format

If none of the date formats suits you, for example, you need the date in the first line of the document, and the day of the week in the second (as in Fig. 11), then you will have to find a more or less similar date format and edit it. In this example, there is no problem with the date being printed in the top row of the table, since such a format is in the list of formats, and the problem is to insert the day of the week - such a field format Date does not exist. To edit the format open in the menu Insert command Field, in the list of fields specify the field Date and select the original date format, which includes the desired day of the week (Fig. 12). Click the button Field codes and edit the date format in the field Field codes, removing the unnecessary part of the format (Fig. 13). Complete the operation by clicking on the button OK, after that, every time the document is opened, the current day of the week will be printed.

Rice. 11. Document with modified date field

Rice. 12. Selecting the original date format for editing

Rice. 13. Date format after editing

Document search

The necessary documents can be searched not only in the usual way, that is, using the command Start=>Find=>Files and Folders, but also directly in Word when opening documents, and when searching in Word, you can rely on the specific properties of documents (document title, author, subject, keywords, file size, date of last update, etc.) or on words found in text.

To search for documents by a word in the text, select the command File=>Open and click on the button Tools=>Find=>Normal. Enter a search word, define the search area (Fig. 14), the types of files you are interested in (Fig. 15) and click on the button Find(Fig. 16).

Rice. 14. Determining the area to search

Rice. 15. Determining the type of files

Rice. 16. The result of the search for documents in the text or in the title of which the word "Internet" occurs

To search for documents by their properties, select the command File=>Open and click on the button Tools=>Find=>Advanced. Suppose that the computer contains not only your personal documents, but also files of other authors with whom you are working on a common project. In this case, in the field Property specify an option Author, in field Condition option Contains(it’s more reliable, because in one case the author can enter only the last name, in the other the first name and last name, etc.), in the field Meaning enter the author's last name and click on the button Find(Fig. 17).

Rice. 17. Search all documents of a specific author

However, keep in mind that searching for documents by their specific properties only makes sense if these properties are specified by all document authors - the default option to fill them, alas, will not provide the desired result. You can specify properties separately for each document by using the command File=>Properties=>Document(Fig. 18). However, it is unlikely that any of the authors will forget to do this in any document, so it is better to include the mandatory filling of the fields of the key properties of the document when it is first saved. To do this, use the command Tools=>Options=>Save and check the box Suggest filling in document properties(Fig. 19).

Rice. 18. Filling in Document Properties

Rice. 19. Setting mandatory saving of key document properties

You can search for documents by the date of their creation, and set not only specific dates, but also their intervals or a list, which is done using tokens AND or OR. In order to find all documents, for example for 2003, in the field Property specify an option Date of creation, in field Condition option Not earlier, in field Meaning enter date January 1, 2003 and click on the button Add. Then again enter in the field Property option date of creation, in field Condition option Not later, in field Meaning enter date January 1, 2004, click the button Add and then on the button Find all documents for 2003 will be found (Fig. 20).

Rice. 20. Setting up the search for documents created during a certain period

MS Excel

Assigning color to sheet tabs

Sheet labels can be multi-colored, which is convenient in books with a large number of sheets - then the color, along with the name, will be responsible for the type of information on the sheets. To assign a specific color to individual sheets, select them, right-click, select the command Label color and select the desired color.

Quick insert columns and rows

To add a row or column to a table, it is not necessary to select the column or row in front of which you want to insert, access the context menu and select the command Add Cells. You can press the key combination ctrl+shift simultaneously with the "+" sign on the numeric keypad - the result will be the same.

Mutant columns

By default, columns in Excel are denoted by Latin letters, and rows by numbers. If, having opened the table again, you find that the columns have begun to be numbered in the same way as the rows (Fig. 21), do not be alarmed - this is not the action of a virus. Use the team Tools=>Options=>General and uncheck the box R1C1 link style(Fig. 22) everything will fall into place.

Rice. 21. Table with numbered columns

Rice. 22. Return to standard column notation

Speed ​​up printing

If you need to print a large number of tables, and you are limited in time, then when printing on a black and white printer, you can speed up the process by giving up color (printing in black and white). On black-and-white printers, colors are displayed as shades of gray, and it takes a certain amount of time to match the hue to a specific color. When printing in black and white, colored text and borders appear in black instead of grayscale, saving time. To set black and white printing, open the menu File command Page Setup=>Sheet and in the group Seal check the box black and white(Fig. 23).

Rice. 23. Printing setting in black and white mode

In addition, you can print without grid lines - in this case, large sheets are printed faster. To do this, use the command File=>Page Setup=>Sheet and uncheck Net ( rice. 24).

Rice. 24. Refusal to print the grid

Entering fractional numbers

By default, fractional numbers are entered in Excel in accordance with the way it is set in the Windows settings: Control Panel=>Language and Standards=>Numbers. In other words, if a comma is intended for entering fractional numbers in Windows, then in Excel they will be entered separated by commas. However, in practice it may turn out differently. For example, on computers with a large number of users, especially in educational institutions, where program settings change in the most unpredictable way. If, when entering a fractional number separated by a comma, you see a number separated by a dot on the screen and have already checked that Windows settings require input separated by commas, use the command Service\Options\International and highlight the checkbox Use system separators(Fig. 25).

Rice. 25. Return to system separators

Representation

When finalizing the appearance of a table and preparing it for printing, it is often necessary to repeatedly change the formatting and printing features. Usually in such cases, sheets are copied and the features of their display on the screen and when printed are changed. However, it is more convenient to create different sheet views that allow you to view data in different modes and do not require the creation of separate sheets.

Before creating a view, the book must be fully configured: it must be given the desired appearance and set all the necessary printing options for it. When print options are entered into a view, it will automatically include the specific print areas of each sheet, or the entire sheet if no print area is defined for it.

To create a menu view View select a team Representation, press the button Add and in the field Name enter a name for the view (Figure 26). In this case, it is better to include the name of the active sheet in the name of the view in order to make it easier to find the desired view in the future.

Rice. 26. Create a View

To return to one of the previously created views, if, for example, you need to print a sheet, use the command View=>Views and in the field Kinds select the view for printing (Fig. 27), then press the button Apply and click on the button Seal The sheet will be printed in black and white.

Rice. 27. Choosing the right view

Subtotals

Quite often, you have to deal with large lists that include multiple cell values ​​for which you need to know the subtotals. Excel can automatically calculate both subtotals and grand totals in any list. Usually, this is done first by sorting with the command Data=>Sort(to group rows for which you want to sum up), then calculate the grand totals, and then insert rows for subtotals and calculate them (Fig. 28).

Rice. 28. Calculating subtotals

If the table is large and there are many areas for which subtotals must be calculated, this process will take a long time. To speed up the work, you can first select a unique list, for each of the values ​​\u200b\u200bof which you need to determine the intermediate total, and only then calculate the totals themselves. To create a unique list, select the required column or row and use the command Data=>Filter=>Advanced Filter. Set the group switch Treatment to position , specify the range of cells in which you want to place the result, and enable the option Only unique records(Fig. 29, 30). As a result of such filtering, all unique objects of the original list will appear in the specified area of ​​the table.

Rice. 29. Advanced filter command window

Rice. 30. The result of creating a unique list

Then use the function SUMIF(range, criteria, sum_range) A that summarizes the cells that meet a certain criteria. The range is the range of cells that are checked against the criterion; criterion - a criterion in the form of a number, expression or text that defines the summed cells; summation range - summed cells (Fig. 31).

Rice. 31. Calculate subtotals for each of the values ​​of a unique list

Removing duplicate lines

Imagine that there is a telephone directory table (dictionary, etc.) consisting of two columns and a huge number of rows. In the first column, for example, the names of customers are entered, and in the second - their telephone numbers, while the lines can be repeated (Fig. 32). The task is to remove all duplicate lines. The first solution that comes to mind is to sort the table by the first column with the command Data=>Sort and manually remove duplicate lines.

Rice. 32. Initial table

If the table is very large, you can achieve the same result in a faster, albeit more complex way. First select a unique list of phones by using the command Data=>Filter=>Advanced Filter by setting the group switch Treatment into position Copy the result to another location, specifying the range of cells in which you want to place the result, and enabling the option Only unique records(Fig. 33).

Rice. 33. The result of creating a unique list of phones

Now we need to use the function VLOOKUP(lookup_value, table, column_number, value True or False) where lookup value is the value to be found in the first column of the table; table a table with information in which data is searched; column number number of the column in the information table in which the corresponding value is to be found. Given that the function works in such a way that the search for the desired value is possible only in the first column, you will need to swap the columns "FULL NAME" And "Telephone", and then in column D enter a formula with the VLOOKUP function (Fig. 34). According to this formula, the program will take the next value from column C, look for it in column A, and then return the value from column B, located in the found row. After that, it remains to make a copy of column D using a special paste, so that the cells contain not formulas, but values ​​(command Paste => Paste Special => Values fig. 35), and delete columns A, B and D that have become unnecessary.

Rice. 34. The result of calculations through the VLOOKUP function

Rice. 35. Appearance of the table after applying Paste Special

MS PowerPoint

slides from files

When preparing a presentation, you can use pre-created Word documents and slides from other presentations.

In the first case, if we are talking about creating a new presentation, open a Word document and apply the command File=>Submit=>Microsoft PowerPoint as a result, a new presentation will be created with the text from the file. If you want to paste text from a Word document into an existing presentation, open the presentation in PowerPoint and click on the tab Structure(Fig. 36). Specify the slide icon that you want the new text slide to appear behind. On the menu Insert select a team Slides from structure and select the required document. Keep in mind that the text that is inserted into the presentation is generated based on the style of the document's headings, and you can only use text from files in the *.doc, *.rtf, or *.txt formats.

Rice. 36. Structure tab

If you want to insert a slide from another presentation into an open presentation, then from the Insert menu, select the command slides from files, select the presentation and the inserted slide (Fig. 37) and click the button Insert. If you are inserting all slides, click the button Paste All.

Rice. 37. Select insert slide

Complex numbering

Page numbering in slides is done by inserting the page number in the footer with the command View=>Headers and Footers, which opens the Header and Footer window, where you need to enable the checkbox footer(Fig. 38) and click on the button Apply to all. Keep in mind that hidden slides continue to count towards numbering. To avoid this, you can put all the hidden slides at the end of the presentation - and then all the shown slides will be numbered in order.

Rice. 38. Inserting a Footer

Naturally, the slide pages are numbered in order. If you need to start pagination again in different places of the same presentation (this may be required if your presentation is still under development and consists of several separate series of slides), then, alas, you cannot do this inside one presentation . To solve the problem for each series of slides, you will need to create different presentations and link them together with hyperlinks.

Presentation template

If presentations are held frequently, it is advisable to spend time carefully preparing a non-standard presentation template - today this is no less relevant than, for example, letterhead for business letters. The template saves the logo of the organization, etc. elements that will automatically play on all created presentation slides. In addition, the template determines the format, size and relative position of objects, the fonts used, the background and other design options for the presentation elements.

Template development begins with the creation of a new presentation through the command File=>New. Then select a design template for the slide from the list of default templates. Before changing the design template in accordance with the intended plan, in the menu View select a team Master=>Slide Master. On the slide master, make changes that you want to reflect in each new presentation you create. First of all, change the design and adjust the fonts (Fig. 39), in the next step, insert the logo (Fig. 40), and after all the changes on the toolbar Sample click on the button Close Wizard View.

Rice. 39. The result of setting the main elements of the presentation template

Rice. 40. The appearance of the slide after inserting the logo

Save the presentation as a template with the command File=>Save As, select variant as the file type Presentation template and enter the template name (Fig. 41).

Rice. 41. Save a Presentation Template

To use a template when creating a presentation, click the button Slide Builder, click on the link Review in the lower right corner of the slide and select the presentation template you created.

Once you've created a template, you can add it to the list of templates in the AutoContent Wizard. To do this, the menu File select a team Create. In area Create click on the link From the autocontent wizard, press the button Further. Then select the category in which you want to place the template, click the button Add and specify the presentation template to be added (Fig. 42).

Rice. 42. Result of adding a template to the autocontent master list

Several design options in one presentation

When designing individual slides in a presentation, you can use several templates. To do this, select certain slides, right-click on the desired template and select the option Apply to selected slides. If this command is not available, use the command Tools=>Options=>Edit and in the area Disabling new features uncheck Several samples(Fig. 43).

If you use the templates you created for the design of the presentation slides, and not the default templates, then the installation of a new template for a particular slide will occur automatically when you click on the Browse link and select the previously created presentation template, unless, of course, there is a ban on the use of different design options

Rice. 44. Set up automatic spell checking

Using a data file to export contacts

All created messages, appointments, tasks and diary entries are stored in a data file on the local computer. This data file is called a personal folder file and has a .pst extension. When reinstalling the system, this file can be easily saved in a separate folder on the hard drive or on a CD, and then reconnected.

In addition, the PST file allows you to access information such as contacts from another computer or share them with other users. To do this, you just need to export the data to a PST file using the Import and Export Wizard. Open in the menu File command Import and export, select as the action option Export to file, and in the next window specify that you need to create a PST file (Fig. 45). Next, select a folder Contacts and determine the features of saving the file (Fig. 46). Click the button Ready, and then your contacts will be saved in the folder you specified on the disk, which will be easy to connect on another computer using the same import and export wizard. Connecting a PST file with contacts is no different from connecting a regular PST file. In order not to forget the file's location, it's best to add it to the list of Outlook data files right away. To do this, use the command File=>Data File Processing, click the button Add and point to the generated PST file. As a result, in the list of data files, in addition to personal folders, the file with contacts you created will also appear (Fig. 47).

Rice. 45. Determining the type of file to be created

Rice. 46. ​​Determining conditions for a saved file

Rice. 47. Outlook Data Files

Working time planning

The end result depends on how well the work is planned. To sort out the list of tasks, Outlook helps to some extent, but it only reminds you that the time has come to start a particular task, that it is already overdue; in addition, Outlook can reassign the task to another employee and allow you to control its execution. And with this, by and large, the capabilities of Outlook in terms of task processing are exhausted.

However, it is very important not only to outline a number of tasks, but also to plan them in such a way that everything is done on time and that planning is as automated as possible. You need to know when you will finish a specific task, whether it is even possible to complete it by the deadline, and when it is best to start the task in order to complete it in time.

It's good to be able to assess in advance how realistic your plan is (subject to the nature of your work week, the availability of a lunch break, scheduled meetings, etc.). In addition, tasks should automatically appear in the calendar, and the calendar status should be automatically updated as tasks are rescheduled. All this can be done by a plug-in for Microsoft Outlook 2002/XP Taskline ( http://www.taskline.info/MAPI/TasklineSetup.exe, shareware, 1.2 MB) from ResultsWare Limited, is a handy and easy-to-use task manager that will allow you to optimize your schedule.

Before you start using the plugin, you need to configure it in accordance with the peculiarities of the working day. To do this, click on the button taskline, go to the tab working week and indicate the working days of the week, the beginning and end of the working day and all available breaks (for lunch, technical break, etc.) - fig. 48.

Rice. 48. Scheduling

Then outline the upcoming tasks for the coming days. At the same time, please note that after installing the plugin, an additional tab will appear in the task creation window taskline, on which you need to indicate the estimated duration of the work, and if the work has already begun, then the amount of time spent on it and the percentage of completion (Fig. 49, 50).

Rice. 49. Create a task

Rice. 50. List of tasks planned for the next week

After that, you can start testing the plugin. To do this, click on the button taskline, go to the tab Tasks, specify the start time (Fig. 51) and press the button OK. The result of the plug-in's work will be a brief report on the number of scheduled tasks, the total time for their execution and the deadlines for completing the work (Fig. 52). At the same time, the program will place the tasks in the calendar in the best possible way - while taking into account both all breaks in work, as well as the meetings, appointments, etc. in the schedule (Fig. 53).

Rice. 51. Determination of the start time of the analysis and distribution of tasks

Rice. 52. Taskline conclusion regarding the list of scheduled tasks (in this case, everything planned can be done on time)

Rice. 53. The result of the distribution of tasks in the calendar

Microsoft Word attracts such a large number of users because it can offer a variety of ways to automate when working with text. One of these is automatic hyphenation.

In order to set up automatic hyphenation, you need to go to the " Layout" In chapter " Page settings» select item « Hyphenation” and in the list that opens, click on “ Auto».

In this case, transfers will be placed in all necessary and possible locations. To do this, the dictionary of the language for which hyphenation will also be enabled must be installed. However, all official distributions of Microsoft Word contain them for any supported languages.

An important feature of automatic hyphenation is that if you suddenly increase the size, change the font or add any decorative elements for the text, the hyphenation will adjust itself.

If you select the “By Width” pull-out, the page will generally take on the appearance of a well-designed book.

It is also not recommended to independently set hyphens in the document using "-" and line breaks. To do this, Word uses the Soft Transfer feature. Select the desired word, set the cursor and press "CTRL" + "-". Now, if necessary, the word will wrap according to the rules you specified. Soft hyphens are not visible in the document, so to display them go to the tab " home" In chapter " Paragraph" Press " Show all signs».

Returning to the point " Hyphenation» and clicking on « Manual”, the program will search for all words that can be hyphenated and show you options on how to do it. Position the cursor where you want it and press " Yes».

The last item is the minimum settings. " Hyphenation in words..." is responsible for including hyphenation separately in those words that are written in capital letters. Without a flag, an exception will be made for them.

IN " Wrap zone width» sets the distance from the edge of the wrapped word storage to the page frame.

« Max. number…» will limit the number of repeated cases of word wrapping for a selected fragment or the entire document.

In order to remove hyphens, it is necessary in the paragraph " Hyphenation» select option « No».

Or with the activated mode of displaying all the symbols, remove manually entered ones. If there were too many of them, then you can use the "Replace" function, which is called by the F5 button.

In the replace tab, click " More>>» -> « Special”, select “ Soft transfer' and replace it with an empty string, no space.

Word 2003 also has an automatic hyphenation feature. It is installed at Service» -> « Language» -> « Hyphenation».

THE BELL

There are those who read this news before you.
Subscribe to get the latest articles.
Email
Name
Surname
How would you like to read The Bell
No spam