Using Information Technologies of the MS Office Application Program Pack when solving economic tasks. Where can I find a "analysis package" for Excel? Microsoft Office Package Description

Examination number 1

at the rate of "Informatics"

Subject: Work with office programs

Microsoft Word 2007 and Microsoft Excel. 2007

Option 2.

Is done by a student:

Faculty: Zagina

Course: 2

Group number: 82/3

Term of delivery:

Checked: ______________________________

______________________________

"____" _________________2008

Evaluation: _______________________

Form and fill out the accrual report of the charges of the hotel's number "Start" in March 2004. Rooms in the hotel 1-seater stand for each customer 750 rubles. per day, 2-seater - 650 rubles. from each client. The room can be booked. Booking in the hotel can be two types: group and individual and paid separately. When booking on a group, payment for the first day of residence increases by 25% of the number of rooms, in cases where there is no way or it is individual, no surcharge. The type of armor and the number of stays in each room are presented in the table. Calculate payment for the reservation for each number, if so is there. Calculate payment for all the days of living for each hotel number. Calculate the final data on the hotel: payment for the reservation, the number of days of living per month, full payment for the hotel for the month. Determine the average number of stays, the value of the maximum and minimum payment for the years of residence.

The task is made in the MSExcel tab of the Table Editor, and is in a separate file.

Accumulative statement accrual of payment of the rooms of the hotel "Start" in March 2004

Description of the package applied software Microsoft Office.

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

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

2. Comparison of various versions of the Microsoft Office package .......................................... .................... 6.

Conclusion ............................................................... .................................................. .................................... fifteen

List of used literature ............................................................. .............................................. sixteen

Introduction

Most of the usual computers are faced with various problems. For example: You use a text editor of one company, a program for working with spreadsheets - another, the program of business graphics is the third, and the performance of your electronic assistant is ultimately low. What's the matter? Yes, just these programs are not intended for collaboration.

Fortunately, this problem has a solution: Microsoft Office, which contains most of the software you need.

Elements of the interface of the programs included in it are decorated in the same way and "communicate" they are with each other in the same language.

Office package is something more than just a set of programs in one box. His name already suggests that it must contain powerful applied programs for commercial use, which are easy and easy to work with texts, numbers and images.

But the most attractive Office package is that connects these applications together: all these programs have a common menu and sets of buttons that look very similar. Having learned to work with one of the applications, you will largely promote the rest of the rest.

In addition, the package has an easy-to-use Managing Center-Dyspeptcher Microsoft Office, which allows you to run separate programs and exit from them, or receive detailed instructions and prompt help by simply clicking the mouse button.

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

The Office package includes:

Large applied programs

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

This is already generally accepted - Microsoft Word Editor is today.

the most popular program in the world. WORD Started by "fast" teams

and themselves modern meansSuch as a built-in spelling check program and a dictionary of synonyms that help you competently compile documents, and ready-made templates that allow you to bring together notes, letters, accounts and brochures without much effort.

2. Excel - produces with numbers the same as Word with nouns and verbs. Everyone who works with numbers will feel in Excel as a fish in the water. The Excel program can be used to compile budgets and financial reports, turning dry numbers into visual charts and graphs, analyzing the type "What will happen if?" Almost any question, as well as to sort longer lists in seconds.

With the help of EXCEL's spreadsheets, you can print the number of string per row and column behind the column, being quite confident that Excel will correctly fold, deductible, multiplying, divide and generally will cost them as it should.

3. PowerPoint - will allow you to professionally prepare a presentation that shook the cast by graphics and effectively decorated theses. But what is the wonderful, the user will be able to turn the document prepared in editor Word., In a presentation, just one click.

4. Access - is a powerful data management program designed mainly for programmers. Access is delivered only as part of the professional edition of the Office package.

Programs - Assistants:

1. Graph, allows you to enter several numbers and quickly turn them into a chart.

2. The Organization Chart program will help create a staff schedule of firm.

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

4. The WordArt program will help change almost unrecognizable shape of letters or numbers to use them when creating attractive logos or headers.

5. Clipart Gallery can view several hundred drawings in search of the best illustrations for the newsletter or presentation.

System operational assistance:

1. Office package and its applications are replete with useful prompts and step-by-step instructions of how to perform one or another operation.

2. Talented masters (Wizards) will step by step towards solving complex tasks.

3. Cards - Credicals (Cue Cards) will offer detailed instructions that will constantly be in front of the eyes during operation.

4. Preview (Preview) and examples (DEMOS) will demonstrate the execution of complex tasks.

2. Comparison of various versions of Microsoft Office package.

The analysis package is an add-in, i.e. the program that is available at installation Microsoft Office or Excel. To use the add-on in Excel, you must first download it. How to upload this package for Microsoft Excel 2013, Microsoft Excel 2010, Microsoft Excel 2007.

Using Microsoft Excel 2013 Analysis Package

When carrying out a complex statistical or engineering analysis, you can simplify the process and save time using the "Package Package" superstructure. To perform an analysis using this package, you should specify the input and select the parameters. The calculation will be executed using a suitable statistical or engineering macrofunction, and the result will be placed in the output range. Some tools allow us to present the results of the analysis in graphical form.

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

The following describes the tools included in the analysis package. To access them, click Data analysis in a group Analysis On the tab Data. If the team Data analysis Inaccessible, you must download the add-on "Package of Analysis".

Loading and activation of the analysis package

1. Open tab FileClick the button Parameters And select a category Superstructure.
2. In the drop-down list Control Select Excel add-in and click Go.
3. In the window Superstructure Check the box Analysis packageand then click OK.

• If a Analysis package missing in the field list Affordable superstructuresClick the button OverviewTo execute the search.
• If a message is displayed that the analysis package is not installed on the computer, click Yesto install it.

Loading Microsoft Excel 2010 Analysis Package

An analysis package is an add-in (add-in. Auxiliary program that serves to add to Microsoft Office special teams Or features.) Microsoft Excel, i.e. a program that becomes available when installing Microsoft Office or Excel. However, to use the add-in in Excel, you must first upload it.

1. Open tab File and select Parameters.
2. Select Team Superstructureand then in the field Control Select Excel add-in.
3. Press the button Go.
4. In the window Affordable superstructures Check the box Analysis packageand then click OK.
1. Council. If add-in Analysis package missing in the field list Affordable superstructuresClick the button Overviewto find it.
2. If a message appears that the analysis package is not installed on the computer, click Yes For its installation.
5. Analysis On the tab Data Data analysis.

Note. To enable function analysis package Visual Basic. For applications (VBA), you can download the add-on "Analysis Package - VBA". To do this, you need to perform the same actions as to download the analysis package. In the window Affordable superstructures Check the box Analysis Package - VBAand then click OK.

Loading Microsoft Excel 2007 Statistical Analysis Package

The analysis package is an add-in (add-in. Auxiliary program that serves to add special commands to Microsoft Office or features.), I.e., a program that is available when installing Microsoft Office or Excel. To use the add-on in Excel, you must first download it.

1. Select Team Superstructure And in the window Control Select Excel add-in.
2. Press the button Go.
3. In the window Affordable superstructures Check the box Analysis packageand then click OK.

Council. If a Analysis package missing in the field list Affordable superstructures, To search for the search, click Overview.

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

1. After loading the analysis package in the group Analysis On the tab Data The team becomes available Data analysis.

Note. To enable VBA functions in the analysis package, you can download the "Analysis Toolpak - VBA" add-in. For this, the same actions are performed as for downloading the analysis package. In the window Affordable superstructures Check the box Analysis Toolpak - VBAand then click OK.

Online store

1. INTRODUCTION

Using a package of applied pro-gram MS Office when solving economic tasks

1 tasks for coursework

2 Composition of Microsoft Office System

3 Overview microsoft features Office.

4 Task number 1 - "Analysis and development of agreed financial policies in the enterprise in MS Excel"

5 Task number 2 - "Database Development when helping Microsoft Access"

6 Task number 3 - "Creating the simplest Web page"

Conclusion

LIST OF SOURCES USED

Appendix A. Appearance Web Pages

1. INTRODUCTION

Today, in the conditions of the market and commodity-monetary relations, the need for reliable, relevant and operational information of a different nature (commercial, legal, business, etc.) is constantly increasing. In connection with these continuously increasing needs, as well as in the conditions of the incessant scientific and technological progress, an acute need for the development of labor organization facilities, that is, in such treatment, accumulation and storage facilities that could have the least costs and the greatest return to help The user to organize his work. Today it becomes possible due to the ubiquitous introduction of information technology.

Precisely because of the mutual integration of various information technology manufacturers software We began to create general integrated software packages that include the entire list of these technologies. When using information technologies, users (economists, lawyers, managers, administrators, etc.) prefer precisely such university tools.

There are not so many similar integrated packages in the world (MS Office, Cognitive Office, Coral Office, etc.), and all of them are largely very similar and do not have significant differences, although they have a number of advantages in front of each other.

Therefore, the purpose of this is term paper And it is a race-looking, lighting and assessment of the capabilities of several applications of one of the above-mentioned packages of the MS Office application software from the point of view of informative technologies and methods of their use in case of economic tasks.

Coursework contains the following sections:

Introduction; Using the package of applied pro-gram MS Office in solving economic tasks; Conclusion;

2. Using the application package of applied pro-gram MS Office when solving economic tasks

2.1 Tasks for coursework

Task number 1 - "Analysis and development of agreed financial policies in an enterprise in MS Excel.

Task number 2 - "Development of the" Phones "database using MS Access."

Task number 3 - "Creating the simplest Web page."

2.2 Composition of Microsoft Office System Package

excel access Base This

Microsoft Office Package Passed from Set office applications To the wider integrated Microsoft Office System system, which contains a greater number of user applications. The package is the key component of this system. It retains the best features of previous versions of the Microsoft Office family: ease of work with documents and information, intellectuality and close integration of applications. At the same time, it goes beyond traditional office packages: its new technologies provide more complete possibilities of interaction between people, data and business processes.

The package has implemented new ways to create any documents and organizing joint access to them, the process of collective data use is simplified, more control over documents is provided. Microsoft is committed to Office System to be perceived not as a set of applications for creating documents, but as a platform for working with information.

Users can share any Office System documents over the Internet and conduct video conferencing. The costs of travel time, business trips and meetings are reduced to coordinate various issues. All Microsoft Office System applications are closely integrated with Windows 2000 and Windows XP operating systems.

When developing a package, considerable attention was paid to solving problems related to the decline in material and temporary costs for deploying, supporting and administering Office in large organizations. FFICE System includes the following applications:

Word 2003 is a text processor designed to create professionally decorated text documents of varying complexity.

Excel 2003 - Electronic tables intended for building and analyzing tables, diagrams and graphs. They can be used to decorate personnel documents.

Outlook 2003 - Desktop Organizer, designed to help the user planning working hours and streamline meetings and other events. It is designed to work with email.

PowerPoint 2003 - helps create colorful, vividly decorated multimedia presentations.

Access 2003 is a relational database management system (DBMS) providing correct data processing. Along with Access, the Visual Basic For Applications (VBA) programming language is supplied facilitating programming programs.

Publisher 2003 - a set of designer and publishing facilities in a Web for business users who want to independently produce their own marketing and information materials of professional quality. To create marketing websites, you can use new wizards creating wizards, the support of about 20 types of web pages is built. Preparation of promotional materials, directories and booklets facilitate more than 2000 templates. Microsoft Office Publisher 2003 is also available in conjunction with the Digital Image Pro application.

Outlook 2003 With Business Contact Manager Contact Manager - allows small businesses to better manage all business contacts and sales channels.

InfoPath 2003 - a new product as part of the Microsoft Office System system, allowing groups and organizations to effectively collect the data they need using a variety of dynamic forms. It can be used as an interface for business processes In order to increase the data collection efficiency, information can be saved, for example, in a form that is compatible with the CDA medical document architecture format (Clinical Document Architecture). Work with such forms allows doctors to get convenient access to the history of patient disease, to data on medical insurance and other information.

FrontPage 2003 - full-featured tool for creating, editing and manage websites, in particular web sites for electronic commerce. Contains the Microsoft SharePoint Team Services module that facilitates publication in the corporate intranet network of general documents and data.

OneNote 2003 is a new Microsoft Office System, designed to create electronic notes. With it, it is convenient to make electronic notes about the material read, organize them and send them by email. The OneNote application provides an increase in labor productivity when working with notes and data.

Visio 2003 is a means of building a diagram that allows you to create technical and business diagrams. Visio 2003 also automates the visual representation of the data at the expense of direct synchronization with data sources.

Project 2003 - powerful platform Project management, which allows project managers to plan work, manage calendar plans and resources, draw up reports on the progress of tasks, family family. The application is intended for project managers who need a desktop system for independent project management, but strict coordination with other project managers or the ability to manage resources using a central data warehouse is required.

Table 2.1 calculates the amount of accumulation of the deposit in 15 years at 15% per annum

Table 2.1 - deposit amount

As can be seen from the table, the deposit amount after 15 years with annual payments in 10,000 p. grows with the amount of 100,000 r. in the amount of 337 902.05 p.

The chart over the amount of accumulation is shown in Fig. 2.1

Fig. 2.1 - Schedule over the amount of accumulation

2.3 Microsoft Office Opportunity Overview

Compared to previous versions in Microsoft Office added new features that provide collaboration on document members of the Group members, exchange contact information With partners and customers, receiving and using data from other organizations. Currently, a significant part of the information is stored not only on hard disks Personal computers, but also on network servers and web servers.

Increased degree of integration office programs With Internet: Web Pages and Messages email You can edit and send to other users directly from Word and Excel, Shared Workspace technology allows you to quickly download the required documents from the local network or from remote Internet nodes.

Using Office 2003 and Windows SharePoint Services over one document, several users can work together. Microsoft document Office can be saved in the overall work areas. To create workspaces for meetings required Microsoft Windows.® Server 2003 on which Microsoft Windows SharePoint services are running. Within the framework of the joint project, each user will work on a specific section of the document. At the same time, he will see what changes are made by others. The built-in Microsoft Windows instant messaging system interface automatically connects other employees to the document and allows you to instantly share ideas.

In Office 2003, the XML (Extensible Markup Language) language is wider than Office XP - a universal data exchange standard between platforms, which allows developers to create solutions that include data from different sources facilitates the exchange of information between users of different organizations. Documents presented in this format can be read through any browser or in other Internet viewing programs. (For more information about HTML and XML, see Chapter 27 "Saving and use of HTML and XML files"). Office 2003 offers new solutions in process management areas and interaction with the information system, information protection (support for Windows Rights Management), collective Workspaces and Meeting Workspaces, coordination and organization of tasks, projects (Outlook Search Folders, Quick Flags, Rules and Alerts). Users and companies can control who reads their email and documents. Pop-up notifications inform the user about receiving new email messages regardless of which program it works.

Built in Microsoft Office 2003 Information Management Rights Management System (IRM - Information Rights Management), allows you to set a circle of persons entitled to view and change the document, block copying and printing files, as well as set a specific validity period, after which others Users will not be able to view or change the document. Custom templates allow you to limit the circle of persons with access to information. For example, the template confidential allows you to create files that cannot be printed, redirect and copy.

2.4 Task No. 1 - "Analysis and Development of the agreed financial policy at the enterprise in MS Excel"

Excel is used in solving planning and economic, financial, technology-economic and engineering tasks, when performing accounting and bank accounting, for statistical information processing, for analyzing data and forecasting projects, when filling out tax declarations.

Electronic excel tables allow you to process statistical information and submit data in the form of graphs and diagrams. They can be used in everyday life for accounting and analyzing cash spending: with the daily purchase of products and household goods, when paying bills, etc.

The spreadsheet has a form of a rectangular matrix, divided into columns and strings. It can store various data: texts, numbers, dates, results of the performance of arithmetic, logical or other operations on the source information.

The ability to quickly recalculate data upon receipt of new information, racist several source data options facilitates modeling of various situations and choosing the optimal option.

The spreadsheets can be easily inserted into the document compiled in the Word text processor or other Microsoft Office application. Close integration of applications included in the package allows you to improve the efficiency of the user, create professionally decorated documents and use the possibilities of the local and global information network (World Wide Web) for collective work and publication of data.

2.5 Task number 2 - "Development of a database with assistance Microsoft Access »

is one of the most popular desktop database management systems (DBMS) that can work with text files, with spreadsheets and databases of the most popular formats.

The database stores the set of data and objects relating to a specific task. It helps us streamline information on various features and allows you to quickly make a sample with an arbitrary combination of signs. As data can be used any information stored on the computer disk; combinations of characters, words, files, drawings, objects, etc. Methods for entering and storing data define the structure of the database. It makes it possible to create relational databases in which the data is stored as a table. It can be used to analyze data, to create dynamic web pages in which data changes will automatically be displayed. With it, you can create database applications, such as client / server applications. Maybe work as:

Autonomous DBMS for desktop systems;

DBMS for file server;

As an interface client to communicate with the server's logging system, for example, Microsoft SQL Server.2003 is a powerful platform for creating desktop applications and applications client / server level of a unit or a whole company.2003 Allows you to convert Microsoft Access databases to Microsoft SQL Server Provides two-way XML support. You can integrate Access tools with MS SQL databases use high-speed access to the OLE-DB interface databases. All data in one file will start, despite the fact that they can be distributed over different tables. Tables with data, their indexes, forms, reports are stored in files with extension.mdb (Microsoft Access Database). A closed file format with extension. MDE allows you to not include the source code VBA in distributed Access applications. Files.adp (Microsoft Access Project) provide an integrated storage connections sQL data Server 2000 through the OLE DB connection, which allows you to create full-fledged applications having a client / server architecture.

By default, ACCESS uses files with extension.mdb. This format allows developers to save files as * .mde or * .ade. At the same time, any Visual Basic code is compiled, and the source code is excluded from both the Access database (.mdb) file and from the Access project (.adp) file, which ensures more reliable protection.

Create a database "Phones".

Send your good work in the knowledge base is simple. Use the form below

Students, graduate students, young scientists who use the knowledge base in their studies and work will be very grateful to you.

Similar documents

Consideration of the package microsoft programs Office 2010. Work in a text editor, the preparation of the text of the scientific article, work with merging documents. Creating a presentation S. using Power Point. Work in the Microsoft Office Excel system, table design.

examination, added 12/14/2011


Microsoft Office is a package of applications created by Microsoft for Microsoft Windows operating systems and Apple Mac OS X. Automation of the payroll procedure. Creating a presentation in Power Point. Automatic creation flowcharts.

practical work, added 14.07.2012


History of creation MS Office 365. Registration on the official website, data verification and confirmation of the purchase package. Work in the office of Office 365. Collaboration on documents. Calculation of the amount spent during the use of Office.

course work, added 19.06.2014


Changing the Microsoft Office System 2007 User Interface. Increase the functionality of applications to support collaboration ( Office Word. 2007, Office Excel 2007, Office PowerPoint 2007, Office Access 2007 and Office Outlook 2007).

examination, added 12/13/2009


Composition of Microsoft Office System package. Overview of the main features of Microsoft Office. Analysis and development of agreed financial policies in the enterprise in MS Excel. Development of a database using Microsoft Access. Creating the simplest web page.

coursework, added 01/18/2012


Description of the composition of the Microsoft Office package. Comparison of various versions of the Microsoft Office package. Large applied programs: Word, Excel, PowerPoint, Access. Assistant programs. System of operational assistance.

abstract, added 31.03.2007


Modern microprocessors, processing digital information. Data storage devices, personal computer information exchange, power supplies, monitors. Compilation of business cards, schemes, tabulation function and building graphics in Microsoft Office.

coursework, added 12.09.2013


The ability to create MDI applications, their advantages. Major techniques for recording information to a file, export data to Microsoft Office applications by using OLE technology, on the example of MS Excel an integrated MS Office package.

laboratory work, added 05.10.2010