The basics of working in ms office. A detailed guide to using Microsoft Word. Merge Start, Document and Field List Compose, Result View, and Finish toolboxes

The tenth office today is one of the most popular versions of the standard set of programs for document management. Unfortunately, the full professional version of this software product is paid (you can find out the prices and buy it), but there are collections that can be installed on your computer absolutely free of charge even today.

Of course, the functionality will be somewhat limited, there will not be a complete set of fonts, designs, formulas and animations. But the main properties will be preserved in full.

How to install a software package for free

The most the best option will download the trial version on the official website of the developer. Among other programs, you can choose not only the office of this option, but also a huge number of other programs that are freely available. You will need:

How the free option differs from the paid one

As is clear from the description, you will receive an introductory version of the office, which has some work restrictions. But in general, Current Package perfect for document management.

You can use it for one year, after which you will need to either purchase a paid license, or carry out this installation procedure free version again. During use, you will be shown a record that you are using the trial version. But don't worry, all files can be used on standard licensed versions of this program. There are no problems with re-saving and further use of files. After the end of the trial period, the files will not need to be re-saved and there will be no restrictions on their use.

The legality of this method of using free software

Many people and small companies use this method, wanting to save some money on purchasing licensed software, which can be quite expensive from intermediaries. It should be clarified separately that this method is absolutely legal. This is due to the fact that you are not using a pirated version, but absolutely legal software that can be downloaded for free from the developer. You have free key developer who confirms the legality of the use of this software. Therefore, you should not worry about this aspect.

The ability to electronically process various documents can be called one of the main reasons for the massive distribution of personal computers, both among home users and in the corporate sector. Gone are typewriters, manuscripts, and even ordinary letters are less and less handwritten. Nowadays, almost any printed matter and documents: whether they are diplomas or abstracts, magazines or books, statements or notes, reports or presentations, are created on a computer. After all, an electronic document can be corrected, altered, supplemented at any time, sent by e-mail, printed on paper or posted on the network for joint work on it. Probably, I will not be mistaken if I say that almost every person who has ever sat down at a computer had to deal with the processing of text documents, and for many this was the reason for the first acquaintance with a PC.

Despite the fact that all modern operating systems have built-in tools for working with text data, nevertheless their capabilities cannot be compared with special software, the so-called office applications. They are designed to process all kinds of electronic documentation on the user's computer and therefore, as a rule, consist of several components with a similar interface and good interaction with each other. The most famous office suites include Microsoft Office, OpenOffice.org, Corel WordPerfect Office, StarOffice, Lotus SmartSuite, Ashampoo Office, and iWork (for Mac OS). Each of the products in this area has its own set of components, design solutions and of course functionality... In our today's article, we will get acquainted with one of the most popular office solutions for users, developed by Microsoft - MS Office.

THE HISTORY OF DEVELOPMENT

This most popular office suite first saw the light of day back in 1992 and at the beginning of its journey included 4 applications that are still fundamental for it: Word, Excel, PowerPoint and Mail. Access was added to this group in 1994, and Shedule + in 1995. The 97th Mail and Calendar Shedule + replaces the Outlook organizer and adds the Photo Editor. 1999 saw the introduction of Publisher, a publishing application, and FrontPage, and PhotoEditor was replaced by PhotoDraw. After the release of Office XP in 2001, the PhotoDraw image editor finally disappears from the office suite, and in 2003, FrontPage. At the same time, Office 2003 introduces a new data collection and management application, InfoPath.

In general, the office suite of 2003 is becoming a very successful product for Microsoft. It was in it that the new icon design in the style of WindowsXP was introduced, which undoubtedly influenced the attractiveness of this solution.

And the office applications themselves have matured over the years of development, and the formats of some (.doc, .xls) have become the standard in the workflow of most enterprises. Even today, after 8 years, many users continue to use MS Office 2003, not wanting to master the revolutionary interface first introduced by the developers in early 2007.

In Office 2007, the software giant decided to abandon its usual system menu, replacing it with a Ribbon interface based on tabbed toolbars. Buttons on ribbons, unlike the toolbar, can be different sizes, for example, those that are needed more often, can be larger, and inside them there can be samples of applied styles.

The buttons themselves are grouped by topic. Infrequently used buttons are usually hidden, but can be accessed via a drop-down menu.

Microsoft says this innovative approach brings all the functionality in one place, improving the user experience and helping you use Office more effectively. True, the users themselves, such radical changes were greeted coolly, and a lot of criticism was expressed to the developers.

Nevertheless, the ribbon interface allows users to use many more functions of the office suite, because most of them are now in plain sight, not hidden deep in the menu. In Microsoft itself, they see the future in the new management system, and this is confirmed by the latest development of the company in this area - Office 2010.

With the release of Microsoft Office 2010, Ribbon has been radically redesigned and improved, which is recognized even by opponents of the Ribbon interface. In addition, changes were made to the style of the ribbon design, which was also positively received by users. Therefore, now very few people have doubts that the office suite from Microsoft will continue to develop in this direction.

Currently, the office suite of applications from Microsoft is being created for operating systems of the Windows and Apple Mac OS X family and has 32-bit and 64-bit editions.

APPLICATION COMPONENTS

Now let's take a closer look at the applications that are part of MS Office using the example of the latest version of this package - Office 2010. It should be noted that for the convenience of positioning the product on the market, the office suite has several editions, which directly affect the availability of certain in it applications. For example, the last Office has six of them: "Basic", "Home and Study", "Home and Business", "Standard", "Professional" and "Professional Plus".

As you can see from the table, a modern office suite can contain from 2 to 10 different applications, depending on its edition.

Microsoft Word(Word)- application for working with text documents. This word processor has been the most popular word processor used in this moment... That is why, the document format "doc" has become the de facto standard for modern document flow, and many competing programs have support for compatibility with this format.

WITH using Word, you can easily create beautifully designed professional-quality documents and organize them. In addition to the multiple possibilities of styling text, various auxiliary tools are provided at your disposal: table designer, image editing tools, insert ready-made shapes, chart and bar chart designer, insert SmarArt graphic objects for visual presentation of information, and many others. At the same time, users can work together on projects and documents, as well as their simultaneous editing.

Microsoft Office Excel (Excel)- application for working with spreadsheets. As in the case of Word, it occupies a leading position in the market and therefore the xls format for this type of document is also the de facto standard.

Excel application opens up wide possibilities of data analysis, as well as data management and exchange. Powerful data visualization tools, summarizing data using small charts that fit into a cell along with text (sparklines), as well as fast filtering of large amounts of data help you effectively compare results, tracking and highlighting important trends. You can easily upload spreadsheet files to the Internet to share with other users.

Microsoft OneNote (VanNote)- An application for storing and collaborating with notes in a single, easily accessible location. Allows you to work with both text and images, as well as video and audio notes.

Sharing to notebooks allows you to create and modify notes at the same time with remote users, or simply sync data, keeping them up to date. You can also take notes while working in other Office applications or Internet Explorer, and OneNote will provide a link to the location in the original document that you were viewing when you added the note, allowing you to automatically link ideas to the content you create.

Microsoft PowerPoint (PowerPoint)- application for preparing presentations. Allows you to create and manage high quality dynamic presentations. With sound and visual effects (adding video and animation), you get the opportunity to present viewers with a clear and effective picture that is as easy to create as it is fun to watch.

With PowerPoint, you can not only add, but also edit multimedia content with a variety of art and video effects. The application also allows you to use dynamic volumetric slide transition effects and realistic animation effects.

Microsoft Outlook (Outlook)- personal organizer, which includes: calendar, task planner, notes, manager Email and The address book... This application allows you to manage multiple email accounts at once in one place, which is much more convenient than checking messages in several mailboxes separately. You also have a single tool for managing all calendars, because in Outlook you can create any number of them for each category of events, so as not to get confused in one large and crowded schedule.

Outlook 2010 allows you to connect to your favorite social networks and centrally track various events taking place there. In addition, you can transfer all your contacts from Hotmail or Gmail services, and all updates to the contact information of your friends with whom you are in the same social network such as Facebook are also automatically reflected in Outlook contacts.

Microsoft Publisher- an application for creating, customizing and distributing all kinds of professional quality publications and marketing materials. Even with no graphic design experience, the various templates can help you create brochures, newsletters, business cards, postcards, e-mails and more.

Users have at their disposal professional image editing tools, modern technologies alignment of objects, the ability to create dynamic publications, advanced typographic possibilities of text design and a convenient tool for previewing the created material and its distribution. Also, the possibility of sharing and distributing publications has not been forgotten.

MicrosoftAccess- applications for creating and managing databases. This powerful personal data management tool is more targeted at the corporate sector, small businesses and non-profit organizations, although it can also be used by ordinary users, for example, for cataloging home audio-video libraries.

Access 2010 adds new ways to access and share databases. The databases can be viewed and edited directly over the Internet, and users who do not have this application can open web forms and reports through a browser.

MicrosoftInfoPath (Infopas)- application for collecting and managing data. Typically used by organizations to optimize their own business processes, it is aimed at experienced business users or developers, and is unlikely to be of interest to home PC users.

InfoPath lets you create sophisticated electronic forms to quickly and cost-effectively collect information based on the type of solution your organization needs and connect them to business systems.

SharePoint Workspace - an application that enhances collaboration on documents and their libraries in a single dedicated SharePoint Workspace environment.

This tool is more aimed at business groups in medium-sized organizations and large enterprises that need a single workspace with extensive data sharing and co-editing capabilities and is unlikely to be useful for home users.

MicrosoftLync (Link) - an application that brings together familiar means of communication. It is positioned as a solution for medium-sized businesses and large enterprises. Combines instant messaging, meeting and voice communication capabilities. The client has a toolbar that makes it easy to find and access commonly used features such as the dialer, visual voicemail, and contact and active conversation lists.

CONCLUSION

Having reviewed all the components that make up the modern Microsoft Office 2010 suite, it's time to summarize.

There is no doubt that such a set of versatile solutions can satisfy almost any user. The quality level of the created electronic documents with the tools included in this office suite is really very high and accessible even for beginners. That is why some of the formats from Microsoft Office are accepted as de facto standards for most of the world document flow.

Probably, many people know (or guess) that this office suite is paid, and its cost and distribution directly depend on its edition. Of the 6 available options for home users, only 4 are available: "Beginner", "Home and Study", "Home and Office" and "Professional". It should be borne in mind that the "Initial" edition, containing the two most popular applications - Word and Excel, is distributed free of charge, and only with new computers that have an operating system preinstalled. Windows system... Editions "Standard" and "Professional Plus" are distributed only among corporate clients.

The most affordable option for home users is Office Home and Student. To date, its cost is 2990 rubles. It includes four applications: a Word text editor, an Excel spreadsheet editor, OneNote note-taking applications, and an authoring application. PowerPoint presentations... We can say that such a gentleman's set will suit most users working with documents at home. Also, please note that the office suite of applications for home and study is not intended for commercial use (for profit) and non-profit organizations, as well as in government agencies.

And yet, the absence in this edition of such a component as Outlook - personal organizer and a good email client, for some it will be a reason to turn their attention to the Office Home and Business edition. True, for this set of components, there are no longer any restrictions on the purpose of its use (as indicated by the prefix business), which immediately affects the cost of the product, which more than doubles and currently amounts to 6,990 rubles. I think for many, an overpayment of 4000 rubles for Outlook will seem unreasonable and buying this edition for a home remains the prerogative of enthusiasts.

Office Professional also contains two additional components, Publisher and Access, publishing and database applications, respectively. But the cost of 17,990 rubles clearly indicates that this product is focused on business use.

So, if you liked the Microsoft Office product, then the most optimal set of applications for use on a home PC would be Office for home and school. Well, for all those who are just starting to master office applications, we will soon prepare more detailed materials on each of the applications included in this edition.

In the section for professional skills or additional information, many indicate knowledge of the computer. But not everyone can make a list of computer programs for a resume. Of course, it is best to specify only the software that you really know how to work with. After all, a recruiter may ask you to show your skills right at the interview.

Writing rules

HR specialists advise even those people who apply for a position not related to work at a PC to write about computer skills. Describing the level of proficiency in this technique, you can indicate a list of programs that you know how to use. You also need to write at what level you know the computer. This can be indicated as follows:

• confident PC user;
• average level;
• initial level of computer skills.

But it is not worth describing in detail the knowledge of certain programs. Each applicant can use the following example of writing this column:

Advanced user. Ability to work with basic MS Office programs (Access, Excel, Power Point, Word, WordPad), graphic editors ( Picture manager, CorelDRAW), programs for sending and receiving e-mail (Outlook Express). I can quickly search for the necessary information on the Internet, I can work with different browsers (Opera, Firefox, Chrome, Amigo, Internet Explorer). Good knowledge of the features of the Windows operating system.

The universal version of this section may look somewhat different:

PC skills are average. Ability to work with MS Office programs (experience with Excel, Word), search and download the necessary information via the Internet (worked with the browsers Opera, Firefox), I can send emails.

Specificity of professions

There are a number of specialties for which it is necessary to list knowledge of programs that help to work. Of course, it is better to start the description with general information about the level of computer skills and the ability to work with basic programs. For example, in an accountant's resume, this graph might look like this:

Confident computer user. Knowledge of basic Microsoft programs Office, such as MS Access, Word, PowerPoint, Excel, the ability to work with e-mail (including Outlook Express, Mirramail, EmailOpenViewPro). Excellent Internet skills in various browsers (worked in Opera, Google chrome, Mozilla Firefox and others). Knowledge of specialized computer programs: 1C: Accounting 7.7 and 8, Parus, Client-Bank systems.

Too long a list listing all kinds of software can backfire: the employer will think that your knowledge is very superficial.

It will be nice if the applicant for the position of sales manager, in addition to the list of basic PC programs, also indicates knowledge of specialized ones. In his resume, the specified section of the column "professional skills" may look like this:

Skilled user level. Skills of searching for specialized information on the Internet, experience of working with various browsers (including Explorer, Opera, Chrome and others). Knowledge of the basics of working with operating systems Linux and Windows, basic office programs, text and graphics editors (Word, WordPad, PowerPoint, Access, Paint, Excel, Photoshop). Skills of working with specialized systems "BEST", 1C: Enterprise (specification "Trade and Warehouse"), experience with the CRM system that regulates customer relationships.

If the position requires deeper knowledge of certain programs, then they must be indicated. So, for the position of PHP-programmer, in addition to the ability to work with a PC, you may need the following: knowledge of PHP, API of social networks, WordPress API, CSS, HTML, JS, CSS.

In the latter case, you need to focus on your knowledge and on the requirements of the employer.

If mastering new programs does not cause any difficulties for you, it should be noted at the end of the section.

Today we will look at the most popular collections Microsoft applications Office and tell you how to get them for free, as well as show a few other ways to get a set of office applications without a paid subscription.

1. Free trialMicrosoftOffice365

Microsoft Office 365 offers users a free trial for 30 days with the following software package: Word, Excel, PowerPoint, Outlook, Publisher, OneNote, Access, OneDrive, Skype. To connect, you need Account Microsoft.

• For storing files and sharing documents, the service provides 1 TB of OneDrive storage per user.
• Unlimited access to all available features.
• 30-day grace period upon expiration, for Reserve copy files stored in the cloud.

• After trial version The user loses access to Office 365 apps and features unless they purchase the full product.

2. VersionOffice 365 ProPlusTrial

Microsoft Office 365 ProPlus - Enterprise edition with advanced controls and latest versions full-featured installed applications.

Office Enterprise Toolkit comes in combination with integrated collaboration services. The trial version includes applications: Word, PowerPoint, Excel, Outlook, OneNote, Access, Publisher, Skype for Business, and Lync.

• Additional cloud services.
• Work on various devices.
• Top-notch apps with exclusive new features every month.

• When you end your trial, you will no longer have access to Office 365 apps and features.

3. MicrosoftOfficeMobile

If you don't want to buy an extended version of Microsoft Office, then just download the mobile application of this service on Android or the App Store.

Available for Android are Word, Excel, PowerPoint, OneDrive, Outlook, OneNote, and SharePoint. For IOS users, to get started with any Office program, you will first need to download it from iTunes.

• Quickly edit and create documents on the go.
• Access your cloud files whenever you want.
• Transfer of documents between users.

• To subscribe to Office 365, you must unblock additional functions editing.
• The main features of the Office mobile apps - viewing, creating and editing documents are available on devices with a screen size of 10.1 inches or less.

4. Free appsOfficeOnline

Another convenient way to use Office for free is online. To get started, you only need a browser installed on your computer. Go to the Microsoft website, then click on the "Office Online" category, select the application you need and get started.

• Unlimited access. Collaborate in your favorite web browser from anywhere in the world.
• Standard user interface, nothing more.
• Easily move from Office Online to full-featured apps without leaving your document.
• Files are saved automatically.
• No software installation required.
• Free templates.

• Absence automatic check spelling for Excel applications and PowerPoint.
• Files are not saved in their original formats.

5. ProgramOffice 365 Education

Students and teachers are eligible to use Office 365 Education for free. The package includes Word, Excel, PowerPoint, OneNote, Microsoft Teams, Outlook. To get started, you will need to enter a valid email address in your school's system.

• New technologies. Create engaging lessons with Sway.
• Collaborate in real time without losing formatting with programs such as Word, Excel, PowerPoint and OneNote.
• Free training to work with « Office ". Tools, tips, and training materials for educators.
• OneDrive storage is available unlimitedly.

• Many educational institutions allow teachers and students to install Office 365 applications free of charge on up to five computers.

6. Registration in the Grade Center programTechNet

The TechNet Assessment Center is unique opportunity try to work with new Microsoft products before their official launch.

After registering with the TechNet Assessment Center, Microsoft will periodically invite you to test some of the company's new products for a period of 30-60 days. After registering with the service in the near future, you will have a chance to receive an offer to test Office 2019 applications for free, preview copies of which will be released in the second quarter of 2018.

• An opportunity to work with new Microsoft Office products for free before the official release.

• Waiting period before receiving a free trial.

7. Buy the equipment supplied withMicrosoftOffice.

Some users do not sit and do not think how it is more profitable for them to subscribe to Microsoft Office, because in the past they were lucky and they purchased a personal computer with a full installation of office applications version 2016, without the need for a subscription.

• Longer or more free subscription period complete installation application package.

• Circulation hardware bundled with Microsoft Office is small, so it is not a fact that you will purchase the right one.

Possession of a set of office applications, especially word and excel, today is a necessary, and in some cases, a mandatory skill in many professions in the field of life. Our word and excel training program for beginners is designed primarily for those who need to master these programs comprehensively and thoroughly, with detailed description all the necessary tools and settings. Word and Excel courses, this is the minimum, having mastered which, you can work independently in almost any industry performing the main office tasks for the circulation of documents and different types reporting. Many people believe that learning Word and Excel for dummies is not enough to quickly advance in training and in the profession, but under this somewhat humorous name, there is a well-developed program for training Word and Excel, which allows you to master the subject easily and effectively. and most importantly, the Excel training program for beginners step by step allows you to clarify the mastered direction at each stage.

Features and capabilities of Microsoft Excel

MS Excel is a versatile and multifunctional spreadsheet editor whose functions are not limited to creating and editing spreadsheets. By using of this application you can significantly increase the efficiency and speed of solving a wide range of professional tasks - from creating databases, analyzing and grouping them using filters to complex calculations with various coefficients, visualization and forecasting.

Excel skills are indispensable for professionals working in the following areas:

• Financial and economic analytics;
• Accounting;
• Marketing and sociological research;
• Scientific activity;
• Banking and work with loans;
• IT-sphere, SEO-optimization and promotion;
• Working with databases in various fields.

In the above areas, you will need to know Excel at the advanced level, but for managers and other office workers, in most cases, basic skills in using a spreadsheet editor are sufficient. Firstly, it will be a great advantage in employment, and secondly, it will really help you to cope with work easier and faster.

Demand for Word and Excel Specialists

Despite the fact that it is now possible to learn how to work in Excel from scratch in almost any training center for computer technologies, there are not enough specialists who own these programs at the proper level. Most people who come to ms office excel courses and think that they know how to work more or less in these programs, in fact, do not reach the very basic level. But, the correct understanding of our skills allows us not only to choose the right training course, but also to be able to apply for a certain job. The demand for specialists Word and Excel is one side of the coin, the other side is their professionalism and skill. Therefore, everyone needs to go through Excel for dummies training, at least in order to understand at what level of proficiency in word and excel programs we are, and whether we are doing the right thing that we learn Excel from scratch or we need higher level ms excel training. And even if you have an initial level of proficiency in Excel and Word programs, but you did the study yourself, then in the courses you will be able to systematize your knowledge and find a lot of new things in seemingly understandable things. Well, if you undergo training on more complex levels of mastering office programs, then it is better to immediately resort to the services of specialized centers - you will save not only time and money, but also your nerves.

Knowledge of the following MS Excel tools will come in handy:

• Data storage - creating tables, databases, lists, sheets and books;
• Data processing methods - search, filtering, formatting and grouping by parameters;
• Methods of calculations, analysis and forecasting based on available data;
• Data visualization in graphs and charts;
• Logical, textual, mathematical and statistical functions;
• Formulas for fast computational operations with large amounts of data;
• Macros, pivot tables and other tools.

Where to start learning, with Word or Excel

Traditionally, the study begins with word, the program allows you to fundamentally master the keyboard and basic skills of working with text and information of various nature. After mastering the Word program, Excel program it is easier to master, if only because you have a confident typing skill on the keyboard. Working in excel, training for dummies implies computer skills not only at the basic level, but also at the level of confident use. If Word is a program that almost everyone needs, as a tool for creating, editing, sending and receiving any document, then Excel is a specialized program that may not be necessary for everyone, but possession of this tool, even at an elementary level, will open before you a lot of possibilities. Therefore, in addition to Word, it is highly recommended to go through Excel for dummies training. This combination - word and excel, is very popular as a popular skill of any specialist.

How to quickly master Word and Excel

For advanced computer users, applying the basic components of a software package at a superficial level is straightforward. Opening a file, reading or typing text, saving a document - these are actions that absolutely every person working with a computer faces. Having mastered any application included in Microsoft Office, you will be able to understand the logic of the interface and menus, and basic operations will become intuitive in the future.

The situation is quite different if you are a novice PC user or you need Office tools for professional purposes. In the first case, the lack of skills in using office applications, in particular, text editor Word is a serious obstacle to further development of all the possibilities personal computer... Therefore, the study of Office for beginners should be conducted on a systematic basis with a detailed mastery of the basic functions, menus and toolbars.

It is even more difficult to master MS Office for professional use - most ordinary users do not know about 95% of the capabilities of the Word text editor and Excel spreadsheet editor, if their work does not require it.

Self-study requires a lot of time, self-discipline and the ability to concentrate, so training in specialized courses dedicated to teaching Word and Excel from scratch would be the best solution. This will help you Computer literacy courses (Windows, Word, Excel) and Excel courses (Excel) - basic level, which take place in the State Center for Children's Education. If you aspire to become a professional in using a spreadsheet editor, at your service