In application package Microsoft Office In addition to Outlook, it also includes such common applications as text editor Word, editor spreadsheets Excel, an application for preparing electronic PowerPoint presentations and an application for working with databases Access data.
All of these applications are independent and self-sufficient, but their joint use opens up truly unlimited possibilities in organizing office work. Using Outlook with other applications included in the Microsoft Office suite allows you to:
- create messages using the full power of the Word text editor. Compared to the relatively poor (albeit sufficient) capabilities provided by the Outlook formatting panel, Word is capable of creating full-fledged documents that feature a variety of styles and design templates, containing built-in objects, etc. The interaction of Outlook and Word will be discussed in the first section of this chapter . Moreover, this section will discuss a tool common to all Office applications - distribution along the route;
- create messages using the full power of the Excel spreadsheet editor. The created table can be easily sent not only as an attached file, but also saved as a message. This possibility will be discussed in the second section of this chapter. In addition, in this section we will talk about a tool common to all Microsoft applications - placing documents in a shared folder;
- create meetings to participate in an electronic conference held using PowerPoint. Creating an electronic conference is directly related to the use of the Microsoft NetMeeting application discussed above (See section 11.5 “Net Meeting”). How PowerPoint works with Outlook will be discussed in the third section;
- create messages using Microsoft Access, capable of connecting to a remote database to display information. Joint using Outlook and Access allows you to quickly export and import data from Outlook folders into Access tables. This possibility will be discussed in the fourth and final section of this chapter.
The interaction between Outlook and Word is perhaps the most typical example of collaboration. I already mentioned above that the user can specify as a message editor Microsoft Word.
Example 18.1. Word as a message editor
(Using Outlook application)
> Tools >Options Message
Use Microsoft Word as a message editor
Use Microsoft Word to read messages in RTF format
As an example of using Word, consider creating a message containing curly text and a diagram demonstrating the structure of a given book.
Create a message using WordThere are two ways to create a message using Word:
- Launch the Word application, create a document and select the command > File > Send > Message.
- Directly in Outlook by selecting the command > Actions > New message using > Microsoft Word (Figure 18.1).
As can be seen from the figure, the essence of the message has not changed, fields for entering recipients and the subject of the message remain, a signature and the Drawing panel have been automatically added, but the Formatting toolbar has been noticeably enriched.
Rice. 18.1. Outlook message (Microsoft Word editor)
Inserting curly text
So, let's first create a nice title for our message using a WordArt object.
Example 18.2. Inserting a WordArt Object
> Insert > Drawing > WordArt
Select the desired text style OK
Text:= Book structure Bold OK
(Format Panel) Centered
As a result of our actions, a beautifully designed text with a yellow gradient fill in the center will appear (Fig. 18.2).
To change the properties of this object, you can use the buttons on the toolbar of the same name. In our case, let's change the fill color from yellow to blue.
Rice. 18.2. WordArt text in message
Rice. 18.3. Fill Methods dialog box
Example 18.3. Changing WordArt Object Properties
(On the WordArt toolbar)
WordArt Object Format Color and Lines
Color Filling methods...
Gradient
One color Color1 Blue
Hatch type From center
Options (Fig. 18.3)
Inserting a chartThe next step we are considering is inserting a diagram, which, by the way, is one of the innovations in Word.
Example 18.4. Inserting a chart
> Insert >Organization Chart…
Select chart type (Fig. 18.4)
Rice. 18.4. Chart Library Dialog Box
A placeholder will appear in the message body, displaying the selected chart. But it consists of one “root” and only three “branches”, while this book has four parts. Let's add another branch and change the chart style.
Example 18.5. Adding a branch to a diagram
(Highlight the root of the diagram)
(In the Organization Chart panel) Add a shape
Autoformat
Select a chart style: Embossed Gradient
Now all that remains is to enter the diagram text. To do this, left-click once on one of the chart stubs and enter the appropriate text. The final version of the message, edited and formatted using Word, is shown in Fig. 18.5.
Rice. 18.5. Final message
After the message has been created, all you have to do is fill in the To and Subject fields, and then click the Send button.
Comment
Since our message is saved and sent to HTML format, some formatting may be lost or modified. Keep this in mind when creating messages in Word! Sometimes it is better to simply attach created messages as an attachment.
Let us remind you once again that we are considering here only general principle collaboration between Outlook and other Office applications. In addition to inserting objects (of which there are many more than two), there are also forms, frames, styles, tables, fields... The list goes on and on. The world of Microsoft Office applications is wide and truly multifunctional. Learn it in parallel with Outlook and other existing applications. In the end, the road will be mastered by the one walking...
Distributing a document along the routeDistribution of a document along the route(Routing) is called sending a document via email colleagues in a certain sequence. The mailing sequence is called document route.
Having received the document, the addressee can make his changes and comments and send the document further along the route. At the end of the route, after the document has been viewed by all recipients specified in the routing list, you can request the return of the document or specify the user for whom it is intended, for example, a project manager.
Example 18.6. Sending a document along a route
> File > Open… (open the required document)
> File > Send > Along route. . .
Nashatyrev Anton To whom
Mokhovikov Oleg Komu
Message text:= Dear colleagues! Read the attached document and express your thoughts and comments about what was written. Thank you in advance, Egor Usarov.
one by one
Return upon completion
Track status
Send
Comment
While running this program, Outlook security dialog boxes may appear warning you about third party tampering and access to Outlook data. In this case, always agree to allow access (after all, this request comes from your actions, and you expect it).
You can attach a designated route to a document so that you do not send it immediately, but do so later. To do this, at the last step of the program you need to click the Add Slip button.
> File > Send > Next recipient...
Send the document Nashatyrev Anton
To refuse to send a document along a route and disconnect the route altogether, you need to click the Clear button.
Let's go back to the example. After the Send button is clicked, a message will be automatically created with the text specified in the Message Text field and with the attached document that needs to be sent (Fig. 18.6). Let’s assume that the first recipient (in our example, this is Anton Nashatyrev) is configured responsibly, i.e. he will not leave the received message unattended or delete it without reading it, but will react to it properly: he will read not only the mailing message, but and the attached document itself, and will not only read it, but also add his wishes and comments to it, and then send it to the next correspondent. Let's try to follow how this happens.
To open the sent document itself, the recipient only needs to do double click mouse over the icon of the attached document in the message. Next, the recipient makes his changes to the document in the usual way. At the end of the work, he must send the document further along the route.
>File>Send>Next recipient...
Send document "Oleg Mokhovikov"
Rice. 18.6. Message with document distribution
What happens after this? Firstly, the message will be sent to the next recipient on the mailing list - Oleg Mokhovikov. He will be able to read the document with changes already made and make his own. Second, the original sender will be notified of the document's movement through the distribution list because the Track Status check box has been selected in the Routing Slip dialog box.
If everything goes well, the document will be promoted through the mailing list until the entire mailing list for that document is exhausted. The last recipient in the route will be asked to return the modified document to the initiator of the mailing, and thus the circle will be closed.
To speed up the process, you can send the document not one by one, but to everyone at once. In this case, merging changes falls on the shoulders of the sender.
Outlook and ExcelFrom the very beginning of the book, when creating a message, we set out to convey as the body of the message not just text, but a table. Using Excel tools allows you to easily solve not only the problem of inserting tables, but also related components (for example, Excel charts).
As an example of how Outlook and Excel work together, consider sending a message that contains a table with data on the number of pages of each part of the book, and an Excel chart that graphically displays the percentage of each part in the book.
Creating a message using ExcelAs with Word, you can create a message in two ways. But if in Word we chose the second option (creating a message from Outlook), now let's look at sending a table directly from Excel.
Rice. 18.7. Outlook Message (editor Microsoft Excel)
Example 18.9. Creating a message using Excel
>File > Send > Message
Include current sheet in message body
Subject:= Statistics
Introduction:= This message contains...
Comment
In the Introduction field, the user can enter text message(comment) preceding the table.
As mentioned above, we will consider sending the table shown in Fig. 18.10. At this stage, the table contains only text and has no additional formatting.
Working with a tableBefore sending a message containing a table, it is advisable to format it: highlight the header, emphasize the borders, etc. But Outlook features allow you not only to format the table, but also to work on its logic. In example 18.10, we added another row - “Total”, containing the sum of all pages in the book, and then styled the table accordingly.
If the text of the message does not fit in the cell, its borders can be expanded. To do this, move the mouse pointer to the junction with the name or numbering of cells (the pointer will take the form of a double-headed arrow) and, while holding down the left mouse button, move the boundaries of the column or row to the required distance.
Example 18.10. Working with an Excel table
(Editing)
A6:= Total
Wb AutoSum (Formatting)
A1:Вб (Select while holding down the left mouse button)
> Format > Autoformat...
Rice. 18.8. Formatted message with Excel spreadsheet
Comment
In addition to using the automatic style, you can apply additional formatting using the buttons on the toolbar of the same name.
Inserting an Excel ChartThe next step to demonstrate the capabilities of Excel and the use of this application with Outlook is to create a chart that visually represents graphical form data on the worksheet.
Example 18.11. Inserting an Excel Chart
> Insert > Chart... Standard
Type Circular
Chart title:= Outlook in original
Data Signatures Shares
Rice. 18.9. Constructed diagram
Comment
If we had not selected the range A2:B6 before starting to construct the chart, we could have set it later, at the second step of the Chart Wizard. In this case, it is absolutely not necessary to manually enter a complex formula into the Data Range field. It is enough to select the desired range on the worksheet with the mouse, the wizard dialog box will collapse so as not to interfere with the selection, and the formula will appear automatically.
Once a chart is inserted, it may overlap the table you are using. In order to move a diagram, just select it and, holding the left mouse button, drag it to the desired location.
Now let's look directly at the diagram itself. All elements are displayed clearly and beautifully, with the exception of the data circle itself, which is very small in size. To enlarge the area for constructing the diagram, you need to click on the invisible square in which the circle and text explanations are inscribed (Fig. 18.9). A square frame will appear with selection handles at the corners. Hook these handles and drag, stretching the selection frame until the circle is the size you need.
So, the message is completely ready to be sent, all that remains is to enter the address of the message recipient and click the Send this Sheet button.
Of particular interest is how our message will be displayed to the user, because, firstly, it is converted to HTML format, and secondly, not every recipient may have Excel installed. After sending and receiving messages, go to V folder Inbox and open the created message (Fig. 18.10).
Rice. 18.10. Received message with table and chart
First, as you can see, the text entered in the Introduction field precedes the table and is separated from it by a line. Secondly, the table format is preserved. And finally, we are proud - the diagram completely matches the created one (format, data, etc.). The only thing missing is there is no signature since we created our message from Excel and not Outlook. This shortcoming could be corrected by executing the command > .Insert > Signature > Sincerely before sending.
Example 18.12. Inserting a signature
> Insert > Signature > Best regards
Comment
Generally speaking, additional editing and formatting of posts is sometimes necessary, if not required. After creating a table (using Excel), the user can always open the message and edit: insert a signature or a series of additional comments, as well as add a background, add a picture, etc.
Exchange folderWorking with Exchange folders is the same common means for all Office applications, as well as route distribution. The essence of this feature is to place the active document in shared folders servers Microsoft Exchange. Thus, the user, as it were, opens access to this document to all participants working group.
Example 18.13. Send to Exchange folder
> File > Send to > Exchange Folder…
Select folder < Общая папка>
After the document is placed in a shared folder, each user can open it by clicking on the appropriate link in the information viewing window (Fig. 18.11).
Microsoft PowerPoint is universal remedy preparing presentations. After creating a presentation, the user can show it as local computer, and make a presentation online for the entire working group. The PowerPoint presentation is delivered in HTML format, so participants only need a browser to view it Internet Explorer 4.0. Thus, the presentation can be carried out both throughout the company and between members of a small group located in different places. The number of participants is not limited, but if more than 16 listeners participate in the presentation, a special server must be used to conduct it Microsoft application NetShow Server.
The problem with any meeting is its planning. Of course, to hold a conference, in addition to the desire of the speaker, the consent of the participants is also required. In the case of a regular conference, the participation of all participants is confirmed by the fact that they all gather together and at approximately the same time in the room designated for the conference. The presenter can schedule a PowerPoint electronic conference like any other meeting using Outlook.
Rice. 12.18. Presentation and the Schedule a Presentation Broadcast dialog box
Example 18.14. Planning to Broadcast a PowerPoint Presentation
> Slide show > Live broadcast > Set up and schedule...
Description:= "Microsoft Outlook 2002 in original"(Fig. 18.12)
Parameters... Setting up broadcasting (Fig. 18.13)
Display mode Resizable
Assign…
Enter or select a name:< presentation participants
Required
Send
(A dialog box will appear notifying you that a broadcast is scheduled)
Rice. 18.13. Broadcast Settings Dialog Box
Comment
It makes sense to set the Audio only and Video and Audio switches if the presenter’s computer is equipped with a microphone and video camera, and the participants’ computers are equipped with equipment for playing audio and video. In our example, we do not assume this, so the None checkbox is selected.
The automatically filled meeting form (Fig. 18.14) is identical to those discussed earlier, See Chapter 2, Calendar, and Chapter 10, Collaborate in Outlook.
Comment
The only mandatory condition for live broadcasting of a presentation to a wide audience is a computer connection to the network (global or local). Additional features may not be used if technical conditions do not allow it.
After agreeing on the time and composition of participants, you can proceed directly to the demonstration itself.
Rice. 18.14. Meeting form
Example 18.15. Live broadcast of the presentation
> Slide show > Live broadcast > Start broadcast...
When holding a scheduled conference, the presenter plans to broadcast it using the meeting scheduling interface in Outlook 2002. At the specified time, a meeting reminder window will appear on the participants’ computer screens, on which the participant will see a button, after clicking on which the introductory page of the presentation will be loaded (Fig. 18.15 ). The presenter controls the change of slides. On the participants' computer screens, the slides are shown exactly as in normal mode slide show.
Rice. 18.15. Main page for live presentation
During the presentation, participants can have private discussions, ask questions to the presenter, and receive answers via email via Outlook.
Outlook and AccessMicrosoft Access is a universal database management system, and Outlook is a universal information management system. Based on these definitions, it is natural to assume that these applications have some means of exchanging information among themselves. But in addition to exchanging information, Outlook, like Word or Excel, is capable of creating messages using Microsoft tools Access. Only in this case, these tools are not in the area of formatting or editing, but in the area of providing data for sending and publishing.
IN this section We'll look at an example of importing information from your Outlook address book into an Access database, and creating a message containing the information you just imported.
Exchange of informationFirst of all, open Access and create a database. Our goal will then be to create a table containing data from the Outlook address book.
Example 18.16. Import data from Outlook to Access
> File > External Data > Import...
Type Outlook files(The Exchange/Outlook Import Wizard will start automatically)
> Address Books > Outlook Contacts Address Book
In a new table
(At this step you are asked to define the parameters of the imported data and find out whether it needs to be imported at all)
Do not import
Import to table:= Contacts
Rice. 18.16. Microsoft Access table with imported data
After import, as expected, Access will appear new table Contacts, containing information from your Outlook address book. The import result is shown in Fig. 18.16.
Working with Access Data PageConsider the following example. Let's say that one of the project participants has created a database, the information of which is interesting, and perhaps necessary, for other team members. There are several solutions for this problem, but we will focus on the option of sending a message containing an Access Data Page. In fact, the message simply contains an HTML page with an ActiveX object that connects to the database and displays data.
Example 18.17. Create a message with Access Data Page
> Actions > New message using... > Microsoft Office >Microsoft Access Data Page
(Access will open with a wizard New page data access)
Constructor
Select data source:=< Database>
After completing the procedures, a page with a data grid will open. So, first of all, you need to place the information fields that will be on the page. To do this, drag the required fields onto the table grid and replace its name, for example, with Contacts. Then enter the name of the message recipients and click the Send a copy button.
Before sending a message, the user can see how it will be displayed to the recipient. To do this, select the command > File > web page preview. A Web browser will open with a loaded page, which will be displayed in the same way for the recipient of the message.
Rice. 18.23. Web page with data from Access
Using the Back and Next buttons, you can navigate through the data in the Contacts table. Also, by specifying the appropriate access parameters, you can edit the table (add or delete records), organize data filtering, etc. But this is beyond the scope of this book.
ResumeSo, in this chapter we looked at the possibility of Office and Outlook applications working together. Truly, using Outlook together with the tools provided by Word, Excel, PowerPoint, and Access allows you to create rich messages and make it easier to share and access information.
- Word. Formatting a message. Using Word as your default editor. Distribution of the document along the route.
- Excel. Create a post with a table and chart. Placing documents in public folders on the Exchange server.
- PowerPoint. Organize an online meeting to present a presentation.
- Access. Import data from Outlook to Access. Create a message containing an Access Data Page.
Excel for Office 365 Word for Office 365 Outlook for Office 365 PowerPoint for Office 365 Publisher for Office 365 Access for Office 365 Visio Plan 2 Visio Professional 2019 Visio Standard 2019 Visio Professional 2016 Visio Standard 2016 Visio Professional 2013 Visio 2013 Visio Premium 2010 Visio 201 0 Visio Standard 2010 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 OneNote 2016 Publisher 2019 Access 2019 OneNote 2013 OneNote 2010 Project Professional 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Publisher 2016 Access 2016 Language Options 2013 Project Professional 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013 Publisher 2013 Access 2013 Excel 2010 Word 2010 Outlook 2010 PowerPoint 2010 Access 2010 Publisher 2010 Project 2010 Language Options 2010 Excel Starter 2010 Language Options Language Options 2016 Office 2010 Project Online Desktop Client Project Professional 2013 Project Standard 2010 Project Standard 2013 Project 2016 Project standard 2019 Less
You can use Office language settings to add a language, select a display language user interface and set the creation and verification language.
Language options are found in the Office Options dialog box under , which you can access by choosing File > Options > Language. Display and creation languages can be set independently. For example, you can have everything that matches the language of your operating system, or you can use a combination of languages for your operating system, Office user interface development, and display.
Adding a languageYou can add a display language or author language. The display language determines the language that Office uses in the user interface—the ribbon, buttons, dialog boxes, and so on. The design language affects the direction of text and the layout for vertical, right-to-left, and mixed text. Author languages also include spell checkers such as spelling and grammar checking dictionaries. (Your preferred development language appears at the top of the list in bold. You can change this by selecting your preferred language and selecting .)
To add a display language:
Select File > Options > Language.
In the Office display language section, select Install additional display languages from Office.com.
Set the display language and then select Install.
The added language appears in the list of Office display languages.
Open an Office application such as Word.
Select File >Options >Language.
Under Office Development and Review Languages, select Add a language....
Select the language you want in the Add Display Language dialog box and then select Add.
The added language will appear in the list of Office development languages.
If you see next to the language name Available check, you can get language pack with verification tools for your language. If Check is not available next to a language name, then check tools are not available for that language. If you see Check Installed next to the language name, you're done.
Available testing.
Set your preferred display or author language
Your preferred language is shown in bold at the top of each language list. The order of languages in the list is the order in which the languages are used by Office. For example, if you are using a display order of Spanish, German, and Japanese, and the Spanish language resources are removed from your computer, the preferred display language will be German.
To set your preferred language:
Open an Office application such as Word.
Select File > Options > Language.
In the Set Office language settings section, do one or both of the following:
Under Office display language, select your preferred language from the list, and then select Set as preferred.
By adjusting Office language settings, you can add new language or select the language for displaying help and tooltips.
Language options are found in the Set Office Language Options dialog box, which you can open by choosing File > Options > Language. The interface and help languages can be set independently of each other. For example, you can set the same language everywhere as in the operating system, or use different languages for the operating system, editing, interface and help.
The available languages depend on the language version of Office and the additional language pack, User Interface Pack, and ToolTip languages installed on your computer.
Adding a languageTo add a language to your Office programs, you must add an editing language. An editing language consists of a type direction and spell checkers for that language. Checkers include language-specific features such as dictionaries for spelling and grammar checking. (The default editing language appears at the top of the list in bold. You can change this by selecting the language you want and selecting Set as default.)
Open an Office application such as Word.
Select File > Options > Language.
In the Set Office Language Preferences dialog box, under Select editing languages, select the editing language you want to add from the Add additional editing languages list and click Add.
The added language will appear in the list of editing languages.
If the Keyboard Layout column says Not Enabled, do the following:
Windows Settings will open to the Language page. In the Add Languages dialog box Windows settings select Add a language, select the desired language from the list and click the Add button.
Close the Add languages to dialog box Windows settings. In the Office dialog box, your language should show as Enabled under Keyboard Layout under Select editing languages.
If the Proofing column shows Not Installed, you may need to obtain a language pack or user interface pack to install the spell checker for your language.
To go online and get the language pack you need, select the Not installed link.
Setting the default interface and help language
Display and Help languages are used in Office to display interface elements, such as menu options, commands, and tabs, in addition to the language in which the Help file appears.
The default language is shown at the top of the list and in bold. Office uses display and help languages in the order they appear in the display and help language lists. For example, if the display languages are Spanish, German, and Japanese, and the language tools for Spanish have been removed from your computer, the default display language will be German.
Setting the default language
Open an Office application such as Word.
Select File, Options, and then Language.
In the Set Office Language Preferences dialog box, under Choose display and help languages, select the language you want to use, and then select Set as default.
Determine the interface language used in each Office application
If you use multiple languages and Office is customized to suit your needs, you can poll all Office applications to see which language is used as the default display language in each one.
In the Set Office Language Options dialog box, under Choose display and help languages, select View display languages for each Microsoft programs Office.
Setting the tooltip language
Note: This feature is only available for the following Office applications: Excel, OneNote, Outlook, PowerPoint, Publisher, Visio, and Word. It is not supported for Office 2016 programs.
Tooltips are small pop-up windows that provide quick contextual help when you hover over an on-screen element, such as a button, tab, control dialog box or menu. When you set the tooltip language in one Office program, the selected language remains the same in all installed programs Office.
Open an Office application such as Word.
Select File > Options > Language.
In the Set Office Language Preferences dialog box, under Select ToolTip Language, select your ToolTip language.
Notes:
This feature is not available in Office 2016.
If the language you want is not listed, you may need to add additional language services. Select How to get more on-screen display languages from Office.com and follow the download and installation instructions.
Once the new tooltip language is installed, it will become the default tooltip language.
For more information about tooltips, see the article
Depending on the version of Word or Outlook you are using, you may be able to paste into Word document and add various objects (such as PDFs, charts, or Excel sheets) or an email message to it using linking or embedding. To insert an object, on the Insert tab, click the Object button.
Inserting a new objectTo create new file To insert into a Word document or email:
Adviсe:
The information in the Result section is determined by the selected object type and the state of the As Icon check box (checked or not). This information will help you decide what exactly needs to be inserted and in what form.
To change the data in an inserted object, double-click it.
To link or embed an already created object:
Embedded objects and related objects Embedded objects become part of the Word file or email message and, once inserted, are no longer associated with the original file.
Related objects may be updated as changes occur source file. The associated data is stored in the source file. IN Word file or mail message (target file), only the location of the source file is stored and a view of the associated data is displayed. If file size matters, use linked objects.
The possibility of electronic processing of various documents can be called one of the main reasons for the mass distribution of personal computers, both among home users and in the corporate sector. Typewriters are a thing of the past, manuscripts are a thing of the past, and even ordinary letters are increasingly rarely seen written by hand. Nowadays, almost any printed matter and documents: be it diplomas or abstracts, magazines or books, statements or notes, reports or presentations, are created on a computer. After all, an electronic document can be corrected, altered, supplemented, sent by e-mail, printed on paper, or posted online for collaboration on it at any time. I probably won’t be wrong if I say that almost every person who has ever sat down at a computer has had to deal with processing text documents, and for many this was the reason for their first acquaintance with a PC.
Despite the fact that all modern operating systems have built-in tools for working with text data, their capabilities still cannot be compared with special software, so-called office applications. They are designed to process all kinds of electronic documentation on the user's computer and therefore, as a rule, consist of several components with a similar interface and good interaction among themselves. The most well-known office suites include Microsoft Office, OpenOffice.org, Corel WordPerfect Office, StarOffice, Lotus SmartSuite, Ashampoo Office and iWork (for Mac OS). Each of the products in this area has its own set of components, design solutions and of course functionality. In our article today, we will get acquainted with one of the most popular office solutions for users, developed by Microsoft - MS Office.
HISTORY OF DEVELOPMENT
This one is the most popular office suite first saw the light back in 1992 and at the beginning of its journey it included 4 applications, which still remain fundamental for it: Word, Excel, PowerPoint and Mail. Access was added to this group in 1994, and Shedule+ in 1995. In 97, the Mail application and Shedule+ calendar replace the Outlook organizer and add an editor Photos Editor. In 1999, the Publisher application for preparing publications, the FrontPage website creation program appeared, and PhotoEditor was replaced by PhotoDraw. After the release of Office XP in 2001, the PhotoDraw image editor finally disappeared from the office suite, and in 2003, FrontPage. At the same time, a new data collection and management application appears in Office 2003 - InfoPath.
In general, the 2003 office suite for Microsoft is becoming a very successful product. It was there that it was presented new design icons in the WindowsXP style, which undoubtedly influenced the attractiveness of this solution.
And on their own office applications over the years of development they have matured, and some formats (.doc, .xls) have become a standard in the document flow of most enterprises. Even today, 8 years later, many users continue to use MS Office 2003, not wanting to master the revolutionary interface first introduced by the developers in early 2007.
With Office 2007, the software giant decided to abandon the usual system menu, replacing it with a Ribbon interface based on toolbars separated by tabs. Buttons on ribbons, unlike toolbars, can be different sizes, for example, those that are needed more often may be larger, and inside them there may be samples of the styles used.
The buttons themselves are grouped by topic. Rarely used buttons are usually hidden, but still accessible via a drop-down menu.
Microsoft says this innovative approach brings all the features into one place, improving the user experience and helping you use Office more efficiently. True, the users themselves greeted such radical changes coolly, and a lot of criticism was expressed towards the developers.
However, the ribbon interface allows users to use many more functions of the office suite, since most of them are now in plain sight, rather than hidden deep in the menu. At Microsoft itself new system management sees the future, and this is confirmed by the company's latest development in this area - Office 2010.
With the release of Microsoft Office 2010, Ribbon was radically redesigned and improved, which is recognized even by opponents of the ribbon interface. In addition, changes were made to the design style of the feed, which was also positively received by users. Therefore, now few people have any doubts that the office suite from Microsoft will continue to develop in this direction.
Currently, Microsoft's office suite of applications is being created for operating systems Windows family and Apple Mac OS X and has 32-bit and 64-bit editions.
APPLICATION COMPONENTS
Now let's take a closer look at the applications that are part of MS Office using the example of the latest version This package is Office 2010. It should be noted that for the convenience of positioning the product on the market, the office package has several editions, which directly determine the presence of certain applications in it. For example, the latest Office has six of them: “Starter”, “Home and Study”, “Home and Business”, “Standard”, “Professional” and “Professional Plus”.
As can be seen from the table, a modern office suite can contain from 2 to 10 different applications, depending on its edition.
Microsoft Word (Word) - an application for working with text documents. This word processor has been the most popular one in use for many years now. at the moment. That is why the “doc” document format has become the de facto standard for modern document management, and many competing programs support compatibility with this format.
With Word, you can easily create beautifully designed, professional-quality documents and organize them. In addition to multiple text styling options, you have a variety of supporting tools at your disposal: a table designer, image editing tools, inserting ready-made shapes, a chart and bar graph designer, inserting SmarArt graphic objects for visual presentation of information, and many others. At the same time, users can collaborate on projects and documents, as well as simultaneously edit them.
Microsoft Office Excel (Excel) is an application for working with spreadsheets. As in the case of Word, it occupies a leading position in the market and therefore the “xls” format for this type of document is also a de facto standard.
The Excel application opens up wide possibilities for data analysis, as well as for managing and exchanging them. Powerful data visualization tools, summarizing data using small charts that fit into a cell with text (sparklines), and quickly filtering large volumes of data help you effectively compare results, tracking and highlighting important trends. Spreadsheet files can be easily sent to the Internet to be shared with other users.
Microsoft OneNote (VanNote) is an application for storing notes and collaborating with them in a single, easily accessible location. Allows you to work with both text and images, as well as video and audio notes.
Sharing notebooks makes it possible to create and edit notes simultaneously with remote users or simply synchronize data, ensuring it is up to date. You can also take notes while working in other Office applications or Internet Explorer, and OneNote will provide a link to the location in the original document you were viewing when you added the note, allowing you to automatically link ideas to the content you create.
Microsoft PowerPoint (PowerPoint) is an application for preparing presentations. Allows you to create and manage high-quality dynamic presentations. Using sound and visual effects(adding video and animation) you can present viewers with a clear, powerful picture that is as easy to create as it is fun to watch.
Using PowerPoint, you can not only add, but also edit multimedia content, using a variety of artistic and video effects. The application also allows you to use dynamic volumetric slide changing effects and realistic animation effects.
Microsoft Outlook (Outlook) is a personal organizer, which includes: a calendar, task scheduler, notes, email manager and address book. This application allows you to manage multiple email accounts in one place, which is much more convenient than checking messages in several mailboxes separately. You also have at your disposal a single means of managing all calendars, because in Outlook you can create any number of them for each category of events, so as not to get confused in one large schedule filled with events.
Outlook 2010 allows you to connect to your favorite social networks and centrally track various events happening there. In addition, you can transfer all your contacts from Hotmail or Gmail services, and all updates to the contact information of your friends with whom you are in the same social network, such as Facebook, are also automatically reflected in Outlook contacts.
Microsoft Publisher is an application for creating, customizing and distributing all kinds of professional-quality publications and marketing materials. Even without experience in the field graphic design, with a variety of templates, you can create brochures, newsletters, business cards, postcards, email materials and other publications.
Users have professional image editing tools at their disposal, modern technologies object alignment, the ability to create dynamic publications, advanced typographic options for text design and a convenient tool preview created material and its distribution. The opportunity is also not forgotten sharing and distribution of publications.
Microsoft Access (Access) - applications for creating and managing databases. This effective personal data management tool is primarily aimed at the corporate sector, small businesses and non-profit organizations, although ordinary users can find use for it, for example, for cataloging home audio-video libraries.
Access 2010 adds new ways to access and share databases. Viewing and editing databases can be done directly via the Internet, and users who do not have this application can open web forms and reports through a browser.
Microsoft InfoPath (InfoPath) is an application for collecting and managing data. As a rule, it is used by organizations to optimize their own business processes, is intended for experienced business users or developers, and is unlikely to be of interest to home PC users.
InfoPath allows you to create complex electronic forms to quickly and cost-effectively capture information based on the type of solution your organization needs and connect them to business systems.
SharePoint Workspace (Sharpoint Workspace) is an application that expands the capabilities of collaboration on documents and their libraries in a single special SharePoint Workspace environment.
This tool is more aimed at business groups in medium-sized organizations and large enterprises that need a single workspace with extensive capabilities public access to data, as well as their joint editing and is unlikely to be useful to home users.
Microsoft Lync (Link) is an application that combines common means of communication. Positioned as a solution for medium-sized businesses and large enterprises. Combines the capabilities of instant messaging, organizing meetings and voice communication. The client has a toolbar that makes it easy to find and access frequently used features such as the dialer, visual voicemail, as well as lists of contacts and active conversations.
CONCLUSION
Having considered all the components that make up the modern Microsoft Office 2010 suite, it's time to take stock.
There is no doubt that such a set of versatile solutions can satisfy almost any user. The quality level of the created electronic documents with the tools included in this office suite is really very high and accessible even for beginners. That is why some formats from Microsoft Office are accepted as de facto standards for most of the world's document flow.
Many people probably know (or guess) that this office suite is paid, and its cost and distribution directly depend on its edition. Of the 6 available possible options Only 4 are available for home users: “Elementary”, “For home and study”, “For home and office” and “Professional”. It should be noted that the “Initial” edition, containing the two most popular applications - Word and Excel, is distributed free of charge, and only with new computers that have pre-installed operating system Windows. The “Standard” and “Professional Plus” editions are distributed only to corporate clients.
The most budget option for home users there will be an Office suite for home and study. Today its cost is 2990 rubles. It includes four applications: Word text editor, Excel spreadsheet editor, applications for OneNote notes and a PowerPoint presentation application. We can say that such a gentleman's set is suitable for most users working with documents at home. Please also note that the office suite of applications for home and study is not intended for use for commercial purposes (for profit) and non-profit organizations, as well as in government agencies.
And yet, the absence in this edition of such a component as Outlook - a personal organizer and a good mail client, for some it will be a reason to turn their attention to the Office edition for home and business. True, for this set of components, there are no longer any restrictions on the purpose of its use (as indicated by the business prefix), which is immediately reflected in the cost of the product, which more than doubles and currently amounts to 6990 rubles. I think that for many, overpaying 4,000 rubles for Outlook will seem unreasonable and purchasing this edition for the home remains the prerogative of enthusiasts.
Office Professional contains two additional components - Publisher and Access, applications for creating publications and working with databases, respectively. But the price of 17,990 rubles clearly indicates that this product is aimed at business use.
So if you liked Microsoft product Office, then the most optimal set of applications for use on a home PC will be Office for Home and Study. Well, for all those who are just starting to master office applications, we will soon prepare more detailed materials on each of the applications included in this edition.
