Book Microsoft Office Excel is a file containing one or more sheets that can be used to organize a variety of related information. To create a new workbook, you can open an empty one. You can create a new book based on an existing book, based on a default template, or based on another template.

Intended action:

Opening a new blank book

Opening a new blank book

Make sure that Blank & Recent is selected in the Templates section, and double-click Blank Book in the right pane of the Blank & Recent list.

Keyboard Shortcuts To quickly create a blank workbook, you can press CTRL+N.

By default, a new workbook consists of three sheets, but you can change the number of sheets in a new workbook under When creating new workbooks on the Basic tab of the Excel Options dialog box ( Microsoft Button Office , Excel Options button).

You can also add or remove sheets as needed.

For more information about adding and removing sheets, see Insert or remove a sheet.

Create a new workbook based on an existing one

Click the Microsoft Office Button, and then click New.

In the Templates list, click From Existing Document.

In the Create From Existing Book dialog box, select the drive, folder, or Internet address where the book you want to open is located.

Select a book and click Create.

Create a new book from a template

Click the Microsoft Office Button, and then click New.

In the Templates list, click Installed Templates or My Templates.

Perform one of the following actions.

To use an installed template, in the Installed Templates list, click the template you want, and then click New.

To use your own template, on the My Templates tab, double-click the template you want.

29. Purpose and capabilities of spreadsheet processors

1. Appointment of the spreadsheet processor.

Microsoft has developed the Excel spreadsheet for operating system Windows. Among other similar software products, this package highlights the graphical interface and the ability to interact with other Microsoft Office products. The functionality of this package allows it to be widely used for financial data processing, scientific calculations, engineering calculations, automation of accounting and settlement activities, efficient processing of large amounts of information specified in tabular form.

2. Operating modes of the spreadsheet processor.

creation of ET;

entering text and numbers;

editing;

formatting;

copying and moving;

entering and editing formulas and functions;

creating and editing diagrams;

preview and print;

work with ET as with databases.

3. Functions of the spreadsheet processor Ms Excel.

fast construction of tables of any form of disposable and reusable use and saving on magnetic media as a separate file with subsequent reading;

the ability to process data types such as numbers, dates, formulas. You can enter text and paste graphic information;

support for file formats of a wide variety of software products (including Lotus 1-2-3);

import and export of tabular data from external databases (with pre-selection capabilities);

the ability to correct an already created table (moving rows and columns, copying them, deleting them, etc.);

use of a large library of standard functions (mathematical, trigonometric, statistical, accounting, etc.);

the ability to select the color design of the table, as well as the choice of various fonts and styles, including auto-formatting;

import of graphic objects into a table (support for OLE technology);

protection of the table from unauthorized access;

tools for generating professional reports, as well as the ability to use Microsoft Access forms for these purposes;

the presence of a wizard mechanism that allows you to automate the execution of operations (for example, a diagram wizard or a function wizard);

presentation of table data in the form of two- and three-dimensional graphs and charts. Contains a variety of tools for editing graphs and diagrams, including tools for creating mixed two-dimensional graphs;

ordering, deleting, copying, finding data in a table by condition;

simultaneous opening of several workbooks, in each of which you can create and work with different tables;

a bunch of tables, i.e. automatic transfer of information from one table to another

automated processing of tables using macros, as well as modules in the built-in Visual Basic for Application programming language;

table structure analysis: dependency trees are built between table cells. Thus, there is no need to manually track the relationship of cells, to determine why the information in a given cell has changed and, conversely, which cells change along with it;

analysis of the impact of changes in some data on others, thanks to which it is possible to predict the development of economic processes;

implementation of matrix and optimization calculations;

network support;

intelligent response to user actions - the system anticipates user actions and helps him perform them;

support for drag-and-drop technology.

The analysis pack is an add-in, that is, a program that is available when you install Microsoft Office or Excel. To use the add-in in Excel, you must first download it. How to download this package for Microsoft Excel 2013, Microsoft Excel 2010, Microsoft Excel 2007.

Using the Microsoft Excel 2013 Analysis ToolPack

When performing complex statistical or engineering analysis, you can simplify the process and save time by using the Analysis ToolPak add-in. To run an analysis with this package, you must specify input data and select options. The calculation will be performed using an appropriate statistical or engineering macro function and the result will be placed in the output range. Some tools allow you to present the results of the analysis in a graphical form.

Data analysis functions can only be used on one sheet. If data analysis is carried out in a group consisting of several sheets, then the results will be displayed on the first sheet, on the remaining sheets empty ranges containing only formats will be displayed. To analyze data on all sheets, repeat the procedure for each sheet individually.

The tools included in the analysis package are described below. Click the button to access them. Data analysis in Group Analysis tab Data. If the team Data analysis is not available, you need to download the Analysis ToolPak add-in.

Downloading and Activating the Analysis Pack

1. Open a tab File, press the button Options and select a category add-ons.
2. Drop Control select item Excel add-ins and press the button Go.
3. In the window add-ons check the box Analysis package, and then click the button OK.

• If Analysis package missing from field list Available add-ons, press the button Review to search.
• If you receive a message stating that the analysis pack is not installed on your computer, click Yes to install it.

Downloading the Microsoft Excel 2010 Analysis Pack

An analysis pack is an add-in (Add-in. An auxiliary program that adds special commands or features to Microsoft Office.) Microsoft Excel, that is, a program that becomes available when you install Microsoft Office or Excel. However, to use the add-in in Excel, you must first download it.

1. Open a tab File and select the item Options.
2. Choose a team add-ons and then in the field Control select item Excel add-ins.
3. Click the button Go.
4. In the window Available add-ons check the box Analysis package, and then click the button OK.
1. Advice. If the add-in Analysis package missing from field list Available add-ons, press the button Review to find her.
2. If you receive a message stating that the analysis pack is not installed on your computer, click Yes to install it.
5. Analysis tab Data Data analysis.

Note. To include features in an analysis package Visual Basic for Applications (VBA), you can download the Analysis ToolPak - VBA add-in. To do this, follow the same steps as for downloading the analysis package. In the window Available add-ons check the box Analysis Pack - VBA, and then click the button OK.

Downloading the Microsoft Excel 2007 Statistical Analysis Package

Analysis Pack is an add-in (Add-in. An auxiliary program that adds special commands or features to Microsoft Office.), i.e. a program that is available when you install Microsoft Office or Excel. To use the add-in in Excel, you must first download it.

1. Choose a team add-ons and in the window Control select item Excel add-ins.
2. Click the button Go.
3. In the window Available add-ons check the box Analysis package, and then click the button OK.

Advice. If Analysis package missing from field list Available add-ons, then press the button to search Review.

If a message appears stating that the statistical analysis package is not installed on the computer and offers to install it, click the button Yes.

1. After downloading the analysis package in the group Analysis tab Data command becomes available Data analysis.

Note. You can download the "Analysis ToolPak - VBA" add-in to include VBA functionality in your analysis package. To do this, follow the same steps as for downloading the analysis package. In the window Available add-ons check the box Analysis ToolPak - VBA, and then click the button OK.

Online store

Description of the Microsoft Office Application Suite

Introduction................................................. ................................................. ...................................... 3

1. Description of the composition of the Microsoft Office package .............................................. ....................................... 4

2. Comparison of different versions of the Microsoft Office suite.................................................... .................... 6

Conclusion................................................. ................................................. .................................... 15

List of references .............................................................................. .............................................. 16

Introduction

Majority ordinary users computers face various problems. For example: you use a text editor from one company, a spreadsheet program from another, a business graphics program from a third, and the performance of your electronic assistant turns out to be low in the end. What's the matter? Yes, these programs are simply not designed for joint work.

Fortunately, there is a solution to this problem: the Microsoft Office suite, which contains most of the software you need.

The interface elements of the programs included in it are designed in the same way and they “communicate” with each other in the same language.

The Office suite is more than just a collection of programs in one box. Its name already suggests that it should contain powerful applications for commercial use that easily and naturally work with texts, numbers and images.

But the most attractive thing about the Office suite is what ties these applications together: all these programs share a common menu and set of buttons that look very similar. By learning how to work with one of the applications, you thereby greatly advance in the study of the rest.

In addition, the package includes an easy-to-use control center - Microsoft Office Manager, which allows you to start and exit individual programs, or receive detailed instructions and online help with a simple click of the mouse.

1. Description of the composition of the Microsoft Office package.

The Office suite includes:

Large application programs

1. WORD is a powerful text editor that allows you to quickly create a document of any complexity from scattered notes and bring a newsletter or brochure to perfection.

This is already generally recognized - Microsoft's Word editor is today

the most popular program in the world. Word is stuffed with "quick" commands

and most modern means, such as a built-in spell checker and synonym dictionary to help you write your documents smartly, and pre-built templates that let you bring notes, letters, invoices, and brochures together effortlessly.

2. EXCEL - does with numbers what Word does with nouns and verbs. Everyone who works with numbers will feel at home in the Excel environment like a fish in water. Excel can be used to create budgets and financial reports, turn dry numbers into visual charts and graphs, and conduct "what if" analyzes. on almost any topic, and to sort the longest lists in seconds.

With Excel spreadsheets, you can type in numbers, row by row and column by column, with complete confidence that Excel will add, subtract, multiply, divide, and generally handle them properly.

3. PowerPoint - will allow you to professionally prepare a presentation, flaunting catchy graphics and spectacularly designed abstracts. But what is most remarkable, the user will be able to turn a document prepared into Word editor, into your presentation with just one click.

4. ACCESS is a powerful data management program designed primarily for programmers. Access is only available as part of the professional edition of Office.

Programs - assistants:

1. The Graph program allows you to enter a few numbers and quickly turn them into a graph.

2. The Organization Chart program will help you create the company's staffing table.

3. The Equation Editor program is designed to create mathematical formulas in the Word editor.

4. The WordArt program will help you to almost unrecognizably shape letters or numbers to use them to create attractive logos or headlines.

5. The ClipArt Gallery program can look through several hundred drawings in search of the best illustration for a newsletter or presentation.

Online help system:

1. Office and its applications are full of useful tips and step-by-step instructions on how to perform a particular operation.

2. Talented Wizards will guide you step by step to the solution challenging tasks.

3. Cards - cribs (Cue Cards) will offer detailed instructions that will constantly be in front of your eyes while you work.

4. The Preview function and Demos will demonstrate how to perform complex tasks.

2. Comparison of different versions of the Microsoft Office package.

Office 97	Office 2000	Office XP
Smart tags Smart tags are a set of buttons that work in various applications, which appear when they are needed (for example, when you insert data or an error occurs in a Microsoft Excel formula), and allow you to select the most fast way task execution.
Task areas Task panes provide centralized access to basic operations. Search, open documents, view the clipboard, format documents and presentations, download templates from the web, and more.
Paste Options Smart Tags Paste options smart tags allow you to change the formatting of copied data before pasting it into new document. You can even assign certain properties to the data you insert, depending on what it contains.
AutoCorrect Options Smart Tags AutoCorrect settings smart tags let you control AutoCorrect features in your Office applications. You can cancel or disable AutoCorrect, and also access the AutoCorrect Options dialog box without using the Tools menu.
File creation (task pane) You can now load a new document while working in another document, create a document based on a template stored on the web, and view a list of recently used templates and documents.
Office clipboard (task pane) The clipboard now has 24 cells for storing information - twice as many as was provided in the Office 2000 package. Using the thumbnails in the task pane, it has become easier to find the desired cell.
Office Document Imaging Office Document Imaging allows you to scan documents for later viewing and reuse of text in Office applications. The text search capabilities found in the Office suite are now used for scanned documents.
Speech recognition Increase productivity by dictating text and giving voice commands to change formatting and navigate menus.
handwriting The notes you take on your handheld device can be downloaded to Office applications as text. You can also ink directly in Microsoft Word (using Japanese, Chinese, and Korean in addition to English) and save your work as a handwritten document or typed text.
Image Compression To compress an image, simply specify how it will be used (for example, for the Web). Office XP uses compression to reduce file size without sacrificing image quality.
Preface to electronic messages office Emails sent from Office applications have a short preface added to them.
Asking questions Help in Office XP can be accessed by typing a question in the box located on the Office menu without downloading the Answer Wizard or Assistant.
Assistant In Office XP, the assistant is hidden by default and only appears when you access help.			Now hidden by default.
Window Help Improvements Easier access to help and helpful websites, including technical support and the Office Update node. The What's New catalog lets you learn about new features.

Access to the information
Office 97	Office 2000	Office XP
Context sensitive smart tags Using smart tags, Office XP automatically recognizes various types of data, including names, dates, addresses, phone numbers, place names, and stock numbers. You can create smart tags to recognize any kind of data.
Search task area This task pane makes it easy to find text in a document and locate files and folders while working on a document. You can also index the files on your computer to speed up the search.
Web requests Access to real-time data from the Web and their analysis is carried out by copying and pasting web pages into Excel. Smart tags automatically provide the ability to create updatable web requests.
Office Template Library The Document Creation task pane gives you direct access to hundreds of professionally designed templates found online in the Office Template Library.	Internet access.
Microsoft Design Gallery Live Layout Library Online access to thousands of images, sounds, and animations on the Office Media Gallery Web site. By performing a monthly update, you always have access to the latest resources.
My data sources This new folder, nested within the My Documents folder, keeps track of what data you have previously accessed. This ensures fast connection to databases and other sources of information…
Printing from the browser HTML files are now printed directly from the Office applications they were created in, greatly improving the quality of printed documents.
Ability to set web parameters The new Web Options drop-down menu makes it easy to create documents that are compatible with specific web browsers.
Add Hyperlink Dialog Box The enhanced Add Hyperlink dialog box makes it easy to link to files when creating and editing web pages.
Reliability, data recovery and security
Office 97	Office 2000	Office XP
Document recovery Microsoft PowerPointR, Word, Excel, and Access applications, when an error occurs in the program, allow you to save the file that you were working on at that time.
Autosave AutoSave, now available in Word, Excel, PowerPoint, and Publisher, lets you choose how often you want to save files. If an error occurs, you can save the recovered file instead of the original one or save it separately.		Supported only in the Word application.
Application error reporting Office XP applications automatically report errors directly to Microsoft or Microsoft information technologies organizations. This information can be used to fix bugs in the program or make appropriate recommendations for users.
Restoring apps and documents The Application and Document Repair tool ensures that programs that are not responding to system prompts can be safely terminated. It allows you to start restoring documents when the application ends.
Data Recovery and Extraction This document recovery tool is automatically invoked in Word and Excel every time an error occurs or a failure occurs while loading a document. It can also be called from the file open dialog box.
Safe mode Office XP lets you reduce downtime by automatically performing troubleshooting steps for common application loading problems.
Digital Signatures Allows you to sign an Office XP document. Thanks to digital signature you can find out if the source from which the document came from is trustworthy and if changes have been made to this document.
Document Password Encryption Word and Excel have improved password enforcement through the use of the CryptoAPI standard. This is the first time password encryption has been used in PowerPoint.	Office 2000 applies simple defense, based on the use of a password without encryption
Single tab "Security" In an Office XP application, security is easy to access by placing all applications' security settings in one tab.
Overview of Collaboration Tools
Office 97	Office 2000				Office XP
Submit for review New tools allow you to assign the appropriate roles to everyone involved in the document review cycle. At the same time, the necessary tools are automatically provided to each reviewer. During the check, changes can be easily made to the text of the original document.
Compare and merge fixes With Office XP, it's easy to combine the comments and revisions of multiple reviewers into a single version of a document by accepting or rejecting suggested revisions.
Markup of fixes Revisions in Word and PowerPoint are now flagged in the right margin of the document, with information about the revisions and reviewer's notes that do not impair the readability of the original document or affect its formatting.
Review panel The new Review panel provides the ability to view changes by a specific reviewer or all reviewers, as well as the ability to accept or reject changes one at a time or all at once.
Collaboration: Integration with Microsoft Sharepoint Team Services
Office 97	Office 2000				Office XP
Microsoft SharePoint Team Services A handy website builder for a centralized location for all project information, Microsoft SharePointT Team Services (in FrontPageR version 2002) provides discussion, list building contact information and tracked tasks, maintaining and creating a calendar of events and document libraries, conducting surveys - all from a web browser window.
Document Libraries Document Libraries make it easy to collaborate by providing Web users with a centralized place to store documents.
Save and Open Document Dialog Boxes The new HTML interface allows you to navigate to the document library directly from the dialog boxes for saving and opening a document.
Lists Structured review and repair lists are used in the web interface when building Microsoft SharePoint Team websites. List templates are provided for alerts, group contacts, group events, and alerts. Lists can be modified or recreated based on existing templates.
Events A centralized location for group event information, this new tool allows all group members to add event information and then export it directly to a Microsoft Outlook® calendar.
Group contacts Managing contacts, changing the columns displayed and views of contact information, exporting and importing this information, respectively, to or from the Contacts folder of the Outlook application.
Document Discussions Using Office XP, you can organize discussions based on Office document or web site.
Editing Tools in the FrontPage Application Using FrontPage, you can edit Microsoft SharePoint Team websites. You can change the theme, add FrontPage components, and insert static HTML elements.
Connecting and coordinating collaboration
Office 97	Office 2000	Office XP
File Format Compatibility Backward compatibility between Office XP, Office 2000, and Office 97 (excluding Access 97) ensures that users of all versions can collaborate on documents.
Expandable smart tags Smart tag technology provides independent developers with a convenient platform to build business solutions for Office XP users. Example. When you type in Excel application order number, using a smart tag, the customer, order and price are associated with it.
XML support in Excel and Access applications The advanced support for XML technology in Office XP allows you to load and save XML documents directly in Excel and analyze online data by requesting XML spreadsheets from the Web. IN Access application can be imported and exported XML Schemas, data, and tables both by applying the default settings and by specifying Extra options for advanced control options.
Office Web Components Excel Web Components now supports Excel-created files and named ranges, multi-sheet support, word alignment, and interactive spreadsheet publishing to the web. Component " Pivot tables» provide the ability to conditionally filter within a range of expressions. Office XP extends the object model by allowing developers to create their own technical solutions for the task of distributing information through web browsers.

Deployment, management and administration
Office 97	Office 2000	Office XP
Automated installation Enhanced Setup makes it easy to upgrade to Office XP by analyzing your system and installing Office components to match your existing configuration.
Setup Setup Wizard Now you can remove files (for example, obsolete add-ons) during installation; You can set a different security level for each program and set options for customizing the Outlook application.
Save Setting Wizard It's easy to copy settings from one computer to another by storing them in a file or uploading them over the Web (using Microsoft Passport for authentication) and then applying them to another computer.
HTTP support by installer The installer's support for HTTP, HTTPS, and FTP means that Office XP can be installed directly from a Web server or corporate network share.
Policy support Office XP provides additional policy support for most of the new Office XP features by allowing administrators to set policies that control security settings and task panes.
Support for national standards Locale support enhancements include a stand-alone installer for each language, a new Multi-Language Pack installation wizard, and automatic detection operating system language. FrontPage, now available in 26 languages ​​(FrontPage 2000 was released in 15 languages), supports Bidi character sets, Unicode, and allows you to create web pages in any of the installed languages.
Windows Terminal Server support With an update to the interface between Office and Windows® Terminal Server, Windows Terminal Server can now be installed with Office XP without using Custom Install. In addition, when connected to remote computer complex display means are not used, thereby increasing the speed of applications.

Microsoft Excel 2007 is one of the early releases of a professional spreadsheet designed to perform any mathematical calculations, analysis and operations based on built-in formulas and functions. The arsenal of Excel 2007 includes up to a thousand different formulas, and in this version of the product they have become even more convenient, practical and wider. The scope of application of formulas can relate to any mathematical branch and area: from logarithmic linear and non-linear equations to the continuation of an arithmetic, geometric sequence or the search for an average value from a number of proposed ones. In addition, the functionality of Excel 2007 provides a set of tools for visualizing numerical data using interactive graphs and charts. By the current release of the application, the assortment of diagrams also exceeds several dozen items. So, histograms, sparklines and a huge variety of direct charts are available here: bar, hierarchical, cascade, funnel, stock, surface, petal, statistical, combined and many others.

New Innovative Solutions and Findings Presented in Microsoft Excel 2007

id="a1">

In the latest implementation of their brainchild, the developers have implemented the following set of new features and tools:

• many tools (along with selection in the data table by a certain attribute and conditional formatting) have become much more convenient and flexible thanks to the new ribbon visual interface, which also contains a panel for calling quick commands
• 64 levels of data sorting are supported, among which there is sorting by color shade
• significant refinement and optimization of tabular tools for charting. In addition to additional tools, it is necessary first of all to highlight the implementation of such effects as transparency and soft shadows. In addition, changes have been made to dialog boxes settings and building the format of the chart areas. As a result, users of Excel 2007 received a special linked list with aggregated table processor parameters
• a text content auto-completion module that provides faster entry of expressions typed earlier in the current sheet. The new formula bar is also resizable.

On our resource you can easily find the latest, most stable build of the Excel 2007 bundle with official Russian localization. The portal presents distribution kits for x32-bit and x64-bit architectures. Before installing the product on a PC, you should study the system requirements of the package. All software is distributed on a completely free basis and does not require registration.

Microsoft Excel 2007 system requirements

Official system specifications for a working computer or laptop for basic operations with Excel 2007 look like this:

• storage: 1.5 - 2 GB of free space on the media
• RAM: 256 MB RAM module
• CPU and PC: 500 MHz core or more
• display: compatible with displaying images on a monitor at a resolution of 1024x768
• platform: Windows XP SP3/Vista SP2, Windows Server 2003 SP2 or any subsequent revision of the home or server generation of the system from Microsoft.

Video review of Microsoft Excel 2007

COURSE WORK

subject: Informatics

on the topic: "The purpose of the programs included in the Microsoft Office 2007 package"

Introduction Microsoft Office is an office suite that covers and is among the applications for desktop computers, servers and services for Microsoft operating system Windows systems, and Mac OS X. Microsoft Office was released by Microsoft in 1989 for Apple Macintosh 1, and then later versions of Windows in 1990.2 the first version of Office contained Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. In addition, the "Pro" (professional) version of Management includes Microsoft Access and Schedule Plus. Over time, office applications have grown significantly and closer with common features such as general spell checking, OLE data integration and Microsoft's scripting language, Visual Basic for Applications. Microsoft positions the Bureau in the development of a platform for online business software under the Office Business Applications brand (Business Applications Management or BOTH its abbreviation in English). The number was used between 1997 and 2003 by a group known as 97-2003 or 98-2004. In 2007 and 2008, with the advent of Office 2007 and Office 2008, created new group entitled open format XML (DOCX, XLSX, PPTX) stored in the most recent versions of the suite, Office 2010 and Office 2011 for Mac According to Forrester Research, June 2009 in various versions of Microsoft Office used by more than 80% of companies worldwide. The analysis says that versions of Office 2008 2007/Office then takes up 80% of the objects. Microsoft Office is currently in strong competition from OpenOffice.org, LibreOffice, IBM Lotus Symphony, Google Docs and IWORK. Chapter 1. Theoretical part 1.1. Office software 1.2. Programs for the exchange of information 1.3. Programs for business graphics and presentations Chapter 2. Practical part 2.1. Working with word processors by example Microsoft programs Office Word 2.2. Working with spreadsheets on the example of Microsoft Office Excel 2.3. Working with database management systems on the example of Microsoft Office Access Conclusion List of used literature

Introduction

Microsoft Office is an office suite covering and among desktop applications, servers, and services for Microsoft's Windows operating system and Mac OS X. Microsoft Office was released by Microsoft in 1989 for Apple Macintosh 1, and later later versions of Windows in 1990 .2 The first version of Office contained Microsoft Word, Microsoft Excel and Microsoft PowerPoint. In addition, the "Pro" (professional) version of Management includes Microsoft Access and Schedule Plus. Over time, office applications have grown significantly and closer with common features such as general spell checking, OLE data integration and Microsoft's scripting language, Visual Basic for Applications. Microsoft is positioning the office in the development of a platform for online business software under the Office Business Applications brand (Office Business Applications or BOTH its abbreviation in English).
The number was used between 1997 and 2003 by a group known as 97-2003 or 98-2004. In 2007 and 2008, with the advent of Office 2007 and Office 2008, created a new group called Open XML Format (DOCX, XLSX, PPTX) that are stored in the most recent versions of the suite, Office 2010 and Office 2011 for Mac
According to Forrester Research, June 2009 in various versions of Microsoft Office used by more than 80% of companies worldwide. The analysis says that the Office 2008 2007/Office version then occupies 80% of the objects. Microsoft Office currently faces strong competition from OpenOffice.org, LibreOffice, IBM Lotus Symphony, Google Docs, and IWORK.

The relevance of this course workconsists in studying the software package included in microsoft office.This package includes software for working with various types documents: texts, spreadsheets, databases, etc. Microsoft Office is a server OLE objects and its functions can be used by other applications as well as the Microsoft Office applications themselves. Supports scripts and macros written in VBA.

Object of studysoftware package Microsoft office 2007.

Subject of studycharacteristics of the programs, description of the main functions of the programs.

The purpose of the work is to explore all possibilities this package, ease of use in new version.

Objectives of the course work:

1. Learn to work in Office 2007
2. Analyze the pros and cons of the program.

To achieve the goals and objectives it is necessary to:

1. Complete practical tasks
2. Explore the purpose of all functions MO.

The structure of the course workconsists of introduction, conclusion, practical part and two chapters.

Information methodological supportto complete the course work are textbooks, reference books, instructions for working in Microsoft office

The topic of the course work is quite extensive and within it will be revealed in stages, depending on the goals and objectives.

Chapter 1. Theoretical part

1.1. Office software

Microsoft 1 Office 2 Access 3 2007

Desktop database management system. A convenient environment for fast and easy information tracking, reporting and data sharing over the Internet.

Office Access 2007 allows you to quickly start working with embedded databases to make changes to them and adapt these databases to your changing business needs. The user can collect data using email forms or import data from external applications. Implemented the ability to create and edit detailed reports containing sorted, filtered and grouped data that allow you to make more informed decisions. Data is shared by moving Office Access 2007 files to a Microsoft Windows Web site 4 SharePoint 5 Services 6 , where you can check the repair history, recover deleted data, set data access permissions, and perform periodic backups.

Office Access 2007 includes a built-in database library to help you get started.

Microsoft Office Excel 7 2007

Spreadsheet program. Provides the ability to analyze, share, and process data.

Microsoft Excel Spreadsheetsan extremely powerful program that allows you to achieve the desired result in various ways, even in the most seemingly simple situations. Excel offers rich options for building complex formulas. Armed with several mathematical operators and rules for entering values ​​into cells, you can turn the worksheet into a powerful programmable calculator.

Excel has several hundred built-in functions that perform a wide range of different calculations. Functions are special, pre-created formulas that allow you to easily and quickly perform complex calculations, perform financial and statistical analysis.

WITH using Excel you can create complex charts for worksheet data. Using macros in Excel worksheets allows you to interact with the user and perform cumbersome and routine operations with just a few mouse clicks.

Microsoft Office Project 8 Standard 2007

Personal version of the product for planning projects in the field of work and personnel management.

Microsoft Office Project Standard 2007 delivers robust project management tools with the perfect combination of usability, power, and flexibility so you can manage your projects smarter and more efficiently. You will receive information, manage design work, plans, and finances and keep your team aligned, while at the same time increasing productivity with integration with renowned Microsoft Office systems, powerful reporting, and guided scheduling, wizards, and flexible tools.

Microsoft Office Project Professional 2007 contains all the features found in Office Project Standard 2007. In addition, Office Project Professional 2007 when used with Microsoft Office Project Server 9 2007 provides large project management functions.

Microsoft Office Word 10 2007

A complete set of tools for working with text. Allows you to create professional-looking documents and improve the efficiency of collaboration.

Office Word 2007 is a powerful content creation tool that lets you create and share documents with a full suite of test tools in an easy-to-use Microsoft Office Fluent interface 11 . With Office Word 2007, information workers can create professional-looking content faster than ever before. A set of new tools allows you to quickly assemble documents using ready-made parts and styles, as well as compose and publish blogs directly in the Word environment. Enhanced integration with Microsoft Office SharePoint Server 2007 and new XML-based formats 12 make Office Word 2007 the ideal choice for building integrated document management solutions.

1.2. Programs for the exchange of information

Microsoft Office Communicator 13 2007

Unified communications client to work with Communications Server. Allows you to organize the interaction of employees both within corporate systems and with public networks (for example, MSN 14, AOL 15 or Yahoo! 16 ) in the mode of personal (one-to-one) or group communication.

Office Communicator 2007 R2 17 is a unified communications application that helps end users become more productive. The program allows users to communicate and collaborate with other people located in different geographical areas or time zones using

Various communication modes, including instant messaging, desktop sharing, voice and video. Integration with 2007 Microsoft Office system programs (including Word, Excel, PowerPoint, OneNote, Groove, and SharePoint Server) provides end users with many different ways to connect with other users directly from the context of their task.

The 2007 R2 version of Office Communicator includes all the features of the previous version, such as presence, instant messaging, VoIP, video, and desktop sharing. New features have also been added, including the ability to add more people to existing audio and video conferencing sessions, share a desktop to collaborate, discuss or edit documents with one colleague or an entire group.

People and workgroups are increasingly separated from each other, working in different time zones and communicating in different ways. Knowing when and how to contact a person is becoming increasingly difficult.

Office Communicator 2007 R2 introduces Presence Indicator, a key feature that improves communication efficiency with detailed information about a person's availability and status. The presence status is set automatically, based on the Outlook 2007 calendar, online status, and other information sources, or manually in the Office Communicator window.

You can also assign separate access levels to different contacts to selectively share your presence information with them. Presence information is available in all Microsoft Office applications.

If the user calls using Microsoft Office Outlook or shares a comment with the author of a business document in Microsoft Office Word, the presence indicator will reflect these changes

Office Communicator 2007 R2 uses a variety of communication methods and provides a single application that provides rich and flexible communication options at any time.

Instant messaging, audio or video all available in one app. Start an instant messaging session with a colleague, invite other interlocutors to it, turn on the sound and add a video with one click.

You can forward calls to your team, set delegates, and access voicemail using the rich features of the VoIP protocol 18 .

Also thanks to the new function public access to the desktop, you can now easily collaborate with colleagues and team members without the high costs of organizing work meetings.

All the features of Office Communicator 2007 R2 are available from anywhere with a simple Internet connection. No need for a secure tunnel (VPN 19 connection) to the corporate network. With secure VoIP, instant messaging, and desktop sharing, you're available to work and away, allowing you to communicate more effectively and stay competitive in today's fast-paced business environment.

Microsoft Office Groove 20 2007

A new collaboration tool. Allows members of a distributed team to interact through a single workspace information space, solving a variety of joint tasks from creating documents to integrating applications within various business processes.

With the spread of the Internet, the concept of a work collective has completely changed. People living in different countries and working in different organizations may well participate in the joint development of the same projects. There are employees who never visit the office at all, but go about their work without leaving home. Others constantly travel and take part in common projects while on the road.

In a virtual office, everyone works where it is convenient for him, however, if the project is joint, then general control over the progress of its implementation is simply necessary. The main problem of such an organization of labor is the common resources. For those who work remotely, there is no typical office infrastructure that includes servers that store files, conference rooms, and so on. .

Microsoft Office Groove 2007 application designed specifically to make collaboration easier. Groove provides a space for users to meet online, discuss shared projects, transfer files directly from one computer to another, store file versions, and more. In fact, Groove empowers all employees virtual office feel closer to each other, as if they are in the same room.

Working with Groove starts with creating a new account. It is necessary in order to be able to access your data from any computer, for example, from home, work, laptop, etc. .

Account can be included in the Groove public directory so that other users of the program can discover it.

The Groove launcher looks like an IM window 21 -client. A list of contacts is displayed here, and it is possible to send a message to any of them. In addition, the Groove Launchpad contains another tab, Workspaces, which shows a list of all the workspaces you have created. Areas are divided into categories: active (those that are currently open), unread (those that have changes that the user has not yet viewed), and read (those that have not had changes since the last time they were accessed).

The workspace is the core element of Groove, so the first thing to do after downloading the program is to create it. True, it may turn out that it has already been created by other participants in the joint project. In this case, it will be enough for you to join it.

Workspaces can be of two types: a standard workspace that includes multiple components, and a workspace that provides file sharing.

The default workspace includes two tools for common work: project chat and file sharing component .

Once you open a workspace, you can send messages to other project members, add collaborative files, invite new users, and add other computers you plan to use Groove from.

In addition, there is the possibility of assigning roles. Each member of the working group can be in the role of leader, member or guest. Each role has a specific set of permissions associated with it. For example, a guest cannot delete, add, or modify files and folders, a member has more permissions, and a manager has all the options, up to changing permissions for each of the groups.

Groove is tightly integrated with Outlook, MSN Messenger 22 , MS Office suite programs, as well as with popular applications from other manufacturers, including Adobe Photoshop 23, WinRar 24, WinZip 25 . Using the File menu, you can create a new Word document, Excel spreadsheet, archive, etc. directly from Groove. The advantage of working with files this way is that you do not have to waste time adding files to the workspace they will be there be immediately after creation. Naturally, all the edits that you make to the files are automatically taken into account right there, and other project participants can see the changes.

Each workspace component is presented as a tab. Additional components can be added as needed.

For example, "Notepad" can be used to write and store notes, "Album" is useful for creating various graphic elements, say, diagrams. The Pictures component will be useful if you need to add digital photos or other images, and the Question Tracker is useful for discussing important questions that need to be answered in the course of work. It is worth noting special components for working with SharePoint files and InfoPath forms.

One workspace can contain several components of the same type, which can be convenient when working on major project. Thanks to this feature, you can create your own tabs for each small task that is solved within the project. For convenience, each tab corresponding to a component can be renamed .

For projects where file sharing is the primary concern, there is a special type of workspace called File Sharing. When creating such a workspace, you must specify the folder in which all files related to the project will be saved. By default, such a folder is created on the desktop, but you can choose any other location for it.

The convenience of this type of workspace is that you can manage files directly from Explorer. Groove adds to it new panel"Folder Sync", with which you can monitor which users use the workspace, invite new users, add computers with which to synchronize, synchronize workspace data with files on the computer. By default, new versions of files are downloaded automatically, but if you wish, you can set download limits or select manual mode, in which downloads will be performed only at the request of the user.

For each file that is in the synchronized folder, you can set the alert level, and then the program will notify you when a new version of it appears.

To add to a workspace that provides file sharing, new file, just copy it to the appropriate folder. Notification about the presence of a new file will appear in all members of the workspace.

Groove works on a peer-to-peer basis, meaning that files are exchanged directly between users, without the need for an FTP server or other "middleman" to store .

You can create a workspace that provides file sharing not only from the Groove window, but also directly from Explorer. To do this, just enter the desired folder and click the "Sync Folder" button that Groove adds to the toolbar file manager. When you do this, you will see the Folder Sync panel and the new workspace will appear in the general list in the Groove window.

Microsoft Office InfoPath 26 2007

An application for creating dynamic forms for collecting and sharing data. Helps streamline business processes and improve data collection across the organization.

InfoPath lets you do the following .

Creation of form templates. INdesign modeyou can design and publish user-friendly interactive forms. In addition to the ability to insert text fields, list boxes, and other standard controls into a form template, InfoPath lets you insert controls that allow the user to add, remove, replace, and hide sections forms. You can create a variety of form templates, from simple templates for collecting data from an immediate group to complex templates that are part of a large business process. InfoPath form templates can be used on their own, but you can also create forms to work with existing databases and Web services. Form templates can be published and accessed using, for example, a shared folder on a corporate network, a Web server, or a library on a Microsoft Windows SharePoint Services Web site. Additionally, if you have access to a server running the InfoPath Forms service 27 Services, you can create a single form template that can be filled out either in InfoPath, in a web browser, or at mobile devices.

Filling out forms. Users fill out forms based on templates created in Design view. When you fill out forms in InfoPath, you have the usual tools you can find in documents, such as checking the spelling on a form or inserting rich text and graphics into certain fields. Depending on the structure of the template, it may also be possible to combine data from several forms into one or export data to other applications. If the form template isfill in browser, users who do not have InfoPath installed on their computers can fill out forms in a web browser or on a mobile device .

At the heart of InfoPath is XML language . When you design a form template, InfoPath creates an .xsn file, which is a compressed (.cab) file that contains files that the form needs to work, such as files XML Schemas (XSD) and XSL Transformations (XSLT).When you fill out a form in InfoPath, the data included in the form is saved or submitted in the industry standard XML format. However, XML knowledge is not required to design a template or fill out an InfoPath form. It should be noted that the XML format greatly simplifies the process of reusing data from forms in an organization. For example, one InfoPath form template for a travel report can be used to pass XML data to a customer relationship management system, a petty accounting system, and a travel planning system.

You can use InfoPath to collect business data from a variety of individuals, such as colleagues, partners, vendors, and customers. For example, you can create a form template for an expense report for an organization's employees.

InfoPath form templates can be simple templates that are used by multiple users in a small workgroup. For example, in a sales team of 10 people, a form can be used to fill in informal sales information and share that information. Data in such forms can be combined into a summary report that will be sent to the manager on a monthly basis.

Another option is for organizations to develop more complex form templates that are linked to existing corporate databases or integrated with existing business systems. For example, IT developers might create a form template for an organization to manage expense reports. It may include representation and business logic tools that allow various categories of users to submit expense reports, view them, and reimburse the sender.

Some of the benefits of using InfoPath are listed below.

Greater access to forms. When using InfoPath and a server with InfoPath Forms Services, you can create browser-compatible form templates and make them available to internal and external Web sites. This makes it possible to share business forms with many users, including employees, customers, suppliers, and partners. You do not need to have InfoPath on your computer to fill out forms, nor do you need to download any additional tools from the Internet. All the user needs is access to a browser such as Windows Internet 28 Explorer 29 , Apple Safari 30 or Mozilla Firefox 31 . If you have InfoPath installed on your computer, you can view and fill out forms in it instead of in your browser. You can also create form templates that users can open and fill out on mobile devices.

Integration with Office system. The InfoPath application works with a number of other applications and servers in Microsoft system Office, including Microsoft Office Outlook, Microsoft Office Excel, and Microsoft Office Access. For example, you can create and fill out forms in email messages, export form data to worksheets, submit data to a database, or query data from a SharePoint list. In addition, developers can embed InfoPath forms without menus, toolbars, or other user interface elements into custom applications.

Data reuse. The data that users enter into forms does not remain private there forever. They can be converted or reused in a variety of ways. This flexibility allows developers to integrate form data with existing business processes. For example, data collected on sales reporting forms can be used to update company systems such as enterprise resource planning and customer relationship management. This allows company employees to access data where and when they need it and make more informed decisions. Timely updates sales data makes it easier for other groups, such as operations and finance, to make accurate production and cost forecasts.

Consistent, accurate data. InfoPath includes a number of tools to help you avoid data entry errors and fill out forms faster. For example, you can use formulas to automatically calculate mathematical values, applyconditional formattingto highlight the data, or include a spell checker to check for errors before submitting the form. In addition, when users fill out a form, the input data can be data verification for errors. If the form template is associated with a database or web service, users will not be able to submit data until the errors are corrected. This approach ensures that the data collected is accurate, error-free and meets established standards. The figure below shows what the user sees on the screen when a data error is detected.

Reduction of overhead costs. Unlike paper forms, which must be reprinted every time they are modified, InfoPath form templates can be easily modified and published again. In addition, InfoPath automatically detects if a template has been updated, so users will always have the latest .

Offline support. The user does not need to be online to fill out an InfoPath form. Users can save forms on their computer, work with them offline, and then submit them to corporate network when reconnecting. This is especially useful for those who have occasional or limited access to network resources, for example, for employees whose work requires frequent travel.

Fewer forms. Instead of distributing and saving multiple paper forms for a single business process, you can create a single form template in InfoPath that includes multiple views. For example, in an expense report form template, you could create one view for employees who enter expense values, a second one for managers who approve those expenses, and a third one for employees who handle cost recovery. By default, switching between views is done using commands on the View menu. You can also create rules to automatically switch views when users open a form, submit a form, or click a button on a form.

Flexible use of controls. In addition to standard elements controls such as text boxes and list boxes, InfoPath provides a number of new controls, such asrepeating tables, selection groups and optional sections. These types of controls allow you to create form templates that meet specific user needs. For example, an expense report form template might use a repeating table that allows users to enter as many expense items as required.

You can also create form template parts that you can save and reuse across multiple templates. Usually part of the template consists of controls anddata sourceand may also include such means asdata connections, data validation and rules . Using parts of the templates will save time, as well as create uniform in appearance, structure and behavior of form templates for the organization.

Tablet PC support. When working with tablet computer possible with the help tablet pen enter entries directly into the form fields. InfoPath then converts this data to text. You can also give Tablet PC users a dedicated field on the form where they can write or draw. This can be useful if you need to sketch a complex sketch or something special, such as a mathematical formula or a diagram of a specific business process. In this case, InfoPath saves the ink with the form without converting it to text.

Microsoft Office OneNote 32 2007

A flexible software solution that provides a single place to collect information of almost any kind, tools quick search and teamwork. Particularly effective on Tablet 33 PC 34 with pen input.

Some good programs are undeservedly in the shadows. Moreover, this applies not only to products of unknown companies, but also applications created by giants like Microsoft. For example, everyone is well aware of the existence of Word, Excel and Outlook, but OneNote is almost unknown to anyone. Meanwhile, this application can be a great addition to the popular office suite. However, even if you don't use MS Office programs, OneNote might still be good for you. assistant in everyday work at the computer.

Everyone who constantly works at a computer invariably accumulates a lot of information that needs to be stored somewhere. Interesting articles from the Internet , phone numbers of customers, the recipe for the Prague Cake and the list of references for the diploma it is often difficult to understand all this. In addition, many people cannot get rid of the habit of writing down various information on pieces of paper that accidentally come to hand. As a result, it takes a lot of time to search for the necessary information in your own archives.

OneNote is a program that helps you store and organize any type of information. It can store text, images, data presented in the form of tables, audio and video fragments, links to files of various types. All this is accompanied by comfortable organization, simple interface and excellent search capabilities.

In appearance, OneNote is closest to Outlook. As in mail program, OneNote 2007 hasn't abandoned the old interface as it did in Word and Excel. All the main commands are placed on the toolbar, the rest can be accessed from the main menu.

If a work project in Word is a document, and in Excel a workbook, then in OneNote we are dealing with notebooks. Notebook is the main element of the program, which stores all the information that the user enters. Notebooks have sections, and sections are made up of pages. If desired (for example, if the page contains too much information, but you want to show that the new data applies to this page), you can also create so-called subpages.

Since OneNote allows you to work with several notebooks at the same time, the program provides the ability to easily switch between them. To do this, use the special area "Notebooks" in the left part of the program window.

If desired, this area can be expanded, then the names of the notebooks will be displayed not vertically, but horizontally, and, in addition, it will be possible to quickly jump to the desired section.

However, to navigate between sections, it is convenient to use the tabs that are located exactly above the workspace.

And to move between pages, use the panel on the right side of the program window. At the request of the user, its width can be reduced or increased.

It is worth noting the presence of a full-screen mode, in which all interface elements disappear, except for toolbars, and all space is allocated for the workspace. This mode is convenient if you work with one page for a long time, and you do not need to switch between sections or notebooks.

In order to make it easier to navigate the program, a number of templates are offered for creating your own notebook, including such as personal, work, student. These notebooks include several sections by default, each of which provides an explanation as to what information can be stored in it. However, if you are organized enough, you can create an empty notebook and fill it with the necessary sections yourself.

As mentioned above, OneNote can store the most different types data, and, at the request of the user, they can be on the same page or on different ones. The first thing to do when creating a new page is to enter its title. It is very convenient that you do not need to do any extra actions when you create a page, the cursor is already set in the field for entering the title, and as soon as you finish entering and press Enter, the title appears on the navigation bar between pages, and you go to the main note content.

Text can be entered directly into the program or pasted from other applications. A OneNote page looks nothing like a page text editor text and other data are placed here in separate blocks.

Such blocks can be dragged around the workspace, resized, partially or completely overlap other blocks with them. In other words, the user is given complete freedom in organizing the workspace.

One block does not have to contain only data of the same type a block can contain, for example, text and an image. In order to make a block active, simply hover over the text, image, or other data that it contains .

Data entry in OneNote is very well thought out. By default, Russian and English spelling works, it is possible to quickly create tables. In order to enter data in the form of a table, it is enough to use the Tab key. Just enter the data that should be in the first cell, then press Tab. The first and second cells will be created automatically. Using the same key, you can create the required number of cells and fill them in.

Another feature of data entry in OneNote arithmetic calculations as you type. Let's say you're logging your travel expenses into OneNote. Once you have a rough estimate, you can type in a simple mathematical expression such as 45+65+90=. As soon as you press the Space key after the equal sign, OneNote will automatically perform the calculation and add the result of the expression. However, keep in mind that when changing data, you need to press the space again after the equal sign, since the program does not automatically update the result.

If data copied from other Microsoft programs, such as Word or Internet Explorer, is entered into OneNote, then the source address is placed after the text or image - the path to the file on the hard drive or the address of the web page. This saves a lot of time, because when copying, for example, information for some work, you do not need to manually enter the address of the site from which it was taken. Unfortunately, this function does not work when copying information from Opera browser, but works fine with Firefox.

Each block of data can be tagged using tags, such as "critical", "source for the article", "question", "remember", "discuss with supervisor", etc. Each tag has a colorful icon that is placed on the left from the marked block. One block can be marked with several tags.

The developers took care not only of a large number of pre-installed tags, but also of the possibility of editing them. By selecting the Customize Personal Tags command from the Tag list, you can add new tags, edit existing ones, or delete unnecessary ones.

You can view tagged notes in the Tag Summary task pane. Here they are grouped by tags, so you can quickly take a look at, for example, the information that is marked as important. Using filters, you can limit the display of tagged notes to only those that apply to the current section or notebook. There are also filters by date, with which you can display notes added during the last week, month, etc. .

If you find it difficult to immediately determine in which notebook the data should be placed, that's okay. OneNote has a dedicated section called Unfiled Notes. Here you can create as many pages as you like with data that does not belong to any of the notebooks. All notes from this section can be transferred to one of the notebooks at any time. To do this, just drag the label with the page name to the area of ​​notebooks in any of the sections. Similarly, you can drag and drop pages from one notebook to another.

However, even if your notes remain "unfiled", because you will not find time to transfer them to notebooks, you are unlikely to get lost in them. OneNote has powerful search capabilities, so unorganized data is not a problem. The search window is compactly located near the section tabs.

To search, simply enter keyword. If desired, you can set the search scope only the current section, only this notebook, all open notebooks.

After the search is completed, a special panel with links will appear instead of the search box. Using it, you can navigate between pages on which the search word is found.

In addition, it is possible to view the entire list of pages that match the query in one window. To do this, just open the task area, which displays text fragments in which the search word occurs. Found fragments of text can be sorted according to different criteria: by date, by section, by title.

If you are collecting information on the Internet, then switching between browser windows and OneNote to add a note to the program is inconvenient. In this case, you can use the marginal notes feature. Just click on the OneNote icon in the system tray area, and a small window will appear on the screen where you can put notes. This window is convenient in that it can be reduced to a suitable size and placed anywhere on the screen. The marginal note window is always on top of all windows, so you don't have to worry about switching between program windows.

All data that you copy into such a window is automatically saved. Once you have closed it, the entire contents of the marginal note can be found in the Unfiled Notes section.

One of the interesting features of OneNote is taking a screenshot. Of course, you will not find powerful features here that are in specialized programs for creating screenshots, but for quickly copying some graphic information from the monitor screen, OneNote is great. To use this feature, you need to go to the program window where you want to capture the screen, right-click on the OneNote icon and select the "Create Screen Clipping" command. After that, the screen will be painted over with a translucent white color. To take a screenshot of an area, you just need to select it by outlining a rectangle. The screenshot will be automatically saved to OneNote in the Unfiled Notes section.

Among the many features of OneNote, it is worth noting the ability to recognize text in drawings. At first glance, it may seem that this feature has nothing to do with the note-taking program, but it is not. For example, some site owners install text copy protection. If you take a snapshot of the page and then recognize it, you will get text that is convenient for further work. There are other situations where the text recognition feature can come in handy for example, if a web page contains phone numbers postal addresses or email boxes placed as graphic files(this is often done to protect against spam).

To recognize text, just right-click on a picture placed in OneNote and select the "Copy text from picture" command. If it is inactive, then you must first select the "Search for text in pictures" command and specify the language English or German. Unfortunately, the Russian language is not supported.

OneNote is great for storing personal data, but it can also be used in multi-user mode if necessary. The program provides a lot of opportunities for collaboration.

First, you can create a public notebook where different users can write at the same time. This is useful if multiple people are working on the same project, because any information that one of the participants contributes will automatically appear in other users' copies of the notebook.

Secondly, you can open a note sharing session and exchange thoughts on a particular project in real time. For the convenience of visual perception, the data that is added by different participants is marked with color. In addition, during a collaboration session, you can always see a list of users connected to it.

Another handy feature worth paying attention to is highlighting a certain area with the cursor. If you activate this function, it will be possible to “draw on the screen”, drawing the attention of session participants to certain data. Drawn lines and other shapes disappear automatically after a few seconds and therefore do not clutter up the workspace.

Microsoft Office Outlook 35 2007

Messaging client. A universal tool for managing time and other data with the ability to organize, organize and search.

Microsoft Outlook personal information manager with functions mail client and Groupware 36 from Microsoft included in the office suite Microsoft office.

Beyond Functions mail client to work with email, Microsoft Outlook is a complete organizer , which provides the functions of a calendar, task scheduler, notebook and contact manager. In addition, Outlook allows you to track work with package documents. Microsoft Office for automatic compilation of a work diary.

Outlook can be used as a standalone application or as a client formail server 37 Microsoft Exchange Server , which provides additional features for collaboration between users of the same organization: General mailboxes, task folders, calendars, conferences, scheduling and reserving the time of general meetings, coordinating documents. Microsoft Outlook and Microsoft Exchange Server are a platform for organizingdocument flow, since they are provided with a system for developing custom plugins and scripts with which programming is possible additional features workflow (and not only workflow), not provided in the standard delivery.

Microsoft Office Outlook 2007 with Business Contact Manager

Small business contact management features integrated with Outlook capabilities. This allows you to manage contacts and customer data and track sales and marketing activities in one place.

Microsoft Outlook 2007 with Business Contact Manager is a powerful customer and contact management tool that helps you improve your sales, marketing, and customer service.

With a new interface, new project management and marketing tools, and more customization options Business Contact Manager for Outlook 2007allows you to manage all of your organization's customer information within the Outlook application, which is typically used for email and calendaring.

Microsoft Office SharePoint Designer 38 2007

FrontPage based tool 39 , designed for Web development and management 40 -sites.

Office SharePoint Designer 2007 offers a set of tools that let you automate business processes, build powerful applications on top of the Microsoft SharePoint platform, and tailor your SharePoint site to your needs all in a managed information technology environment.

1.3. Programs for business graphics and presentations

Microsoft Office PowerPoint 41 2007

New graphics options, formatting tools and user-friendly interface programs allow you to quickly create dynamic professional-looking presentations.

PowerPoint is a leader among systems for creating presentations. With its help, textual and numerical information is easily transformed into professionally designed slides and diagrams,data for demonstration in front of today's highly demanding audience.

Microsoft Office Publisher 42 2007

A program to prepare business and marketing materials for desktop printing, web posting, and email distribution. Contains all the tools for creating expressive materials.

Software Microsoft software Office Publisher is designed for users who want to produce their own high-quality marketing materials and business publications without the help of professional designers. With flexible wizards integrated into the task pane, project authors can quickly and easily apply design options to create newsletters, announcements, booklets, websites, and more .

Microsoft Office Visio 43 2007

A solution for building schemas and visualizing data. Provides the ability to visualize, analyze and share complex information, systems and processes .

Microsoft Office Visio 2007 is a versatile data and application modeling tool that supports both data modeling and object-oriented application modeling.

In fact, the best way to understand the positioning and capabilities of Visio is to use an analogy with Excel. After all, spreadsheets are also inferior in their capabilities to sophisticated business intelligence tools, solving accounting problems in an enterprise, or performing mathematical calculations. But at the same time, for a huge range of mass tasks, it is Excel that is not only suitable in terms of functionality, but also much more convenient due to its simplicity and accessibility.

Developing the analogy with spreadsheets, we can say that if Excel is focused on working with tabular numerical data, then Visio is designed to visualize heterogeneous information structures with various relationships. The user can apply both manual and automatic methods of drawing according to some initial data (for example, according to a tabular description of the staff of an organization or according to a description of the topology of a hierarchical system of a computer network). But anyway it gets images in some given style or standard. Visio comes with a rich set of templates business process flowcharts, network diagrams, workflow diagrams, database models, and software diagrams that you can use to visualize and streamline business processes, track project work and resource usage, optimize systems, organizational charting, network maps and building plans. However, Visio's features go far beyond just visualizing data: the professional edition of the package includes modeling and visual design tools for solving a range of common IT 44 -tasks, including the development software systems.

One of the innovations of the Visio 2007 package is that now with its help you can not only visually represent various objects, but also manage the data associated with them, including those stored in electronic Excel tables, bases Access data and SharePoint Server lists. The program can also track data trends and flag exceptions in PivotCharts, use new feature"auto-connection" for linking shapes in diagrams. Diagrams themselves can be saved in PDF formats 45 or Microsoft XPS 46 , as well as attach to e-mail messages (the recipient will be able to view them in Outlook 2007 even if Visio 2007 is not installed on their computer).

The package itself is available in two versions: Standard and Professional. The former allows users to create business-themed diagrams flowcharts, org charts, project schedules, block diagrams, basic network diagrams, and maps. The second includes templates for more schemas, as well as some additional features.

Chapter 2. Practical part

2.1. Working with word processors on the example of Microsoft Office Word

Rice. 1. Tasks No. 13, completed with the help of the program Microsoft Office Word (start)

Rice. 2. Tasks No. 13, completed with the help of the program Microsoft Office Word (continued)

Rice. 3. Tasks No. 13, completed with the help of the program Microsoft Office Word (end)

Rice. 4 . Task number 4, completed using the program Microsoft Office Word

Table 1

Table made using the program Microsoft Office Word (task #5)

2.2. Working with spreadsheets by example Microsoft Office Excel programs

Rice. 5. Tabulation of function values ​​performed using the program

Rice. 6. Function Graph f(x ) built using the program Microsoft Office Excel (task #6)

Rice. 7 . Statement of accounting for goods, made using the program Microsoft Office Excel (task #7)

Rice. 8. Data selection and sorting performed using the program Microsoft Office Excel (task #8)

2.3. Working with database management systems using an example program Microsoft Office Access

Rice. 9. Report made using the program Microsoft Office Access (task #9)

Conclusion

As a result of studying the course of computer science and information and communication technologies, I got an idea about the history of the emergence, development and areas of application of computer science and information and communication technologies.

As a result of the theoretical part of the course work, I got an idea about the history of creation, development and main characteristics of portable computers, as well as their areas of application in modern information technologies. As a result, I found out that in the first place laptop computers are used where increased mobility of computing devices is required. At the same time, they have a number of disadvantages compared to stationary devices, such as higher price, complexity of modernization and repair, lower functionality and performance.

As a result of the practical part of the course work, I learned the basic methods of using word processors, spreadsheet processors and database management systems on the example, respectively, of programs Microsoft Office Word, Microsoft Office Excel and Microsoft Office Access included in the application package Microsoft office.

Microsoft Office Word I learned how to enter, change and save on devices external memory, as well as print on the device for information output printer text documents; add different kinds of objects to them, such as pictures, tables and formulas; format symbols and paragraphs, parameters of built-in objects, pages and document.

As a result of studying the program Microsoft Office Excel I learned how to create spreadsheets using textual and numerical data; use formulas to process the entered information; build graphs of functions; perform formatting of data entered into table cells; use the possibilities of spreadsheets to select and sort the entered data.

As a result of studying the program Microsoft Office Access I gained an understanding of databases, the basics of designing and implementing basic database objects tables, as well as additional database objects such as forms, queries and reports. I learned how to design the structure of tables, forms, queries and reports; gained an understanding of the basics of the structured query language SQL and applied the acquired knowledge and skills in practice in the process of completing the tasks of the practical part of the course work.

List of used literature

1. Beshenkov S.A., Kuzmina N.V., Rakitina E.A. Computer science. Textbook 11 cells. M., 2007.
2. Beshenkov S.A., Rakitina E.A. Computer science. Textbook 10 cells. M., 2007.
3. Kuznetsov A.A. etc. Informatics, test tasks. M., 2006.
4. Mikheeva E.V. Workshop on information: textbook. allowance. M., 2010.
5. Mikheeva E.V., Titova O.I. Informatics: textbook. M., 2009.
6. Semakin I.G. etc. Informatics. Structured abstract of bases O course. M., 2007.
7. Semakin I.G., Khenner E.K. Computer science. Task book-workshop 811 cells. (in 2 t o max). M., 200 8 .
8. Semakin I.G., Khenner E.K. Computer science. Textbook 10-11 cells. M., 200 9 .
9. Krasnikova N.E., Silakova L.A., Uvarov V.M. Workshop on informat basics And ki and computer technology: textbook. allowance. M., 2007.
10. Ugrinovich N.D. etc. Workshop on informatics and information technologists And pit 1011 class. M., 2011.
11. Ugrinovich N.D. Informatics and information technologies. Uche b nickname 1011 class. M., 200 7 .
12. Ugrinovich N.D. Teaching the course "Informatics and ICT" grades 7-11. M., 2012.
13. Andreeva E.V. and other Mathematical foundations of informatics, Elective course. M., 2009.
14. Microsoft. Educational projects using Microsoft Office. M., 2006.
15. Shafrin Yu.A. Computer science. Information Technology. Volume 1-2. M., 20 1 0.

1 English MICROcomputer (“microcomputer”) and SOFTware (“software”) literally “software for microcomputers”.

2 English "office ". Microsoft Office is a suite of application programs from Microsoft ("Microsoft").

3 English. "access".

4 Microsoft's operating system with a windowed (windows) graphical user interface.

5 English Share (“general”, “available”) and Point (“point”, “node”) literally “public node”, a computer designed for centralized storage and access to information using special software.

6 English "services", software that performs server functions (centralized processing and storage of information).

7 English "excellent".

8 English. "project".

9 English "a computer on a network designed for centralized storage and access to / processing of information."

10 English "word".

11 English "smooth", "smooth".

12 English eXtensible Markup Language literally "extensible markup (data) language".

13 English "transmitting messages".

14 MSN Microsoft Network computer network"), specialized computer network Microsoft, which is part of the Internet.

15 America On-Line (English on-line “operational”, operating in real time [always available]) a specialized computer network of the American news corporation CNN, which is part of the Internet.

16 Specialized search system on the Internet.

17 R2 English “Release 2” (“option No. 2”).

18 English Voice over IP Internet telephony (IP telephony). IP Internet Protocol ("Internet Protocol").

19 English Virtual Private Network "virtual private network" (connection to one network [usually the local network of a company or enterprise] through another [public network, such as the Internet or telephone] using encryption of the transmitted information).

20 English "beaten path"

21 English Instant Messaging "instant messaging"

22 Program for instant messaging on the Microsoft Network.

23 A program for creating and processing raster graphics by Adobe.

24 A program for working with archive (compressed) RAR files in the Microsoft Windows operating system (OS).

25 A program for working with archive (compressed) ZIP files in the Microsoft Windows operating system (OS).

26 English Information (“information”) and Path (“path”) literally “the path of information”.

27 English. "forms".

28 Worldwide information-computing network Internet.

29 English "researcher", a Microsoft program (browser) for viewing hypertext documents, mainly located on the Internet.

30 English "Safari", an Apple program (browser) for viewing hypertext documents, mainly located on the Internet.

31 English fire (“fire”, “fiery”) and fox (“fox”) literally “fire fox”, Mozilla's program (browser) for viewing hypertext documents, mainly located on the Internet.

32 English One (“one”) and Note (“note”) literally “one note”.

33 English "tablet".

34 English “Personal Computer” “personal computer”.

35 English "view", "perspective".

36 English Group (“group”, “group”) and Ware (“product”) software to support group (collective) work.

37 English "exchange (of e-mail messages)."

38 English "designer".

39 English "Title page".

40 English "web". WWW World Wide Web (eng. "World Wide Web"), a set of hypertext information hosted on server computers running special software (web server) that form websites accessible via the Internet.

41 English "strong advantage".

42 English "publisher".

43 English "vision".

44 Information technologies a set of software and hardware methods, methods and means for processing, storing and transmitting information.

45 English Portable Document Format "portable document format".

46 English XML Paper Specification "XML document description", storage format electronic document, intended for group viewing and protected from modification.