• What is MS Office? Description of the Microsoft Office package

    MICROSOFT OFFICE. COMPOSITION, PURPOSE, MAIN APPLICATION PROGRAMS

    To perform the main tasks of computer data processing in modern offices, it is advisable to use not separate programs, but integrated office service packages, since they implement not just the combination of large stand-alone programs into packages, but their integration into application program complexes, meaning their complete unification. The programs in them have a common user interface and uniform approaches to solving typical problems of file management, formatting, printing, working with by email etc.

    Currently, the market for applied office software products is dominated by Microsoft Office 97 and 2000 packages. The latest versions of these office suites contain tools for teamwork, closer integration of components, as well as tools for interacting with the Internet.

    Microsoft (MS) Office 2000 can run under the operating systems Windows 95, Windows 98, Windows NT, Windows 2000. The computer configuration required for effective operation depends on the operating system used, but the minimum sufficient set includes:

    • Pentium microprocessor of any type;
    • RAM with a capacity of at least 32 MB;
    • free disk space 300 MB;
    • video adapter with at least 4 MB of memory.

    Microsoft Office 2000 comes in several flavors, including different numbers of core applications:

    Office 2000 Standard - designed for users who need basic set tools for office work, calculations and information analysis, as well as for creating and publishing documents on the Internet;

    • Office 2000 Professional - additionally provides tools for working with large databases in desktop publishing systems, as well as for managing small businesses;
    • Office 2000 Premium - the most complete universal delivery option;
    • Office 2000 Small Business - focused primarily on solving small business problems;
    • Office 2000 Developer - designed for professional developers, includes a large number of additional tools and software development applications, additional electronic and printed documentation.

    Basic Microsoft Office applications:

    • Word is a word processor designed for creating and editing text documents;
    • Excel is a spreadsheet processor designed to process tabular data and perform complex calculations;
    • Access is a database management system designed to organize work with large volumes of data;
    • Power Point - a system for preparing electronic presentations, designed for preparing and conducting presentations;
    • Outlook is a personal information manager designed to provide unified access to corporate information;
    • FrontPage is a Web site editing system designed for creating and updating Web sites;
    • Photo Draw - a graphic editor designed for creating and editing drawings and business graphics;
    • Publisher is a desktop publishing system designed for creating professionally designed publications;
    • Small Business Tools - specialized tools designed to work with information and carry out business analysis;
    • Internet Explorer.- A Web browser for the Internet, designed to search for various types of data.

    In addition to the main applications, Microsoft Office also contains many auxiliary programs used to create and include various objects in basic documents in the form of diagrams, drawings, formulas, etc. These include:

    • MS Graph - designed for creating various graphs and charts based on number series and tables;
    • MS Equation Editor - designed for creating and editing scientific formulas;
    • MS Office Art - graphic editor, designed for creating drawings, geometric shapes, flowcharts, etc.;
    • MS Word Art - designed for creating and colorfully designing headings and other text elements;
    • MS Photo Editor- designed for processing and converting tone patterns, photographs, objects read by the scanner;
    • MS Clip Gallery - designed to include existing pictures, pictos in a document graphic images, sound objects;
    • MS Organization Chart - designed for building hierarchical block diagrams and block diagrams.

    Microsoft Office 2000 provides:

    • ease of operation and support. There is a convenient interface and help system, an expanded set of wizards and templates, improved capabilities for collective document processing;
    • an expanded set of intelligent tools. Microsoft Office includes easy-to-use, intelligent applications that automate the user's work, reducing the time it takes to complete tasks;
    • support for advanced Internet technologies. The possibilities of interaction with the Internet and intranets have been significantly expanded;
    • automatic interface adjustment. Microsoft Office applications can automatically adjust the set of menu commands for a specific user during operation;
    • ease of installation and restoration of system functionality. New program Windows Installer simplifies Office 2000 deployment and support.

    List of programs included in the Microsoft Office 2010 suite

    Microsoft Office 2010 Components

    The list of programs differs for different packages. In order to understand the specifics of the configuration different versions supplies of Microsoft Office 2010, first we will briefly list what programs may be included in these packages.

    Microsoft Word 2010 - New version word processor with advanced capabilities for creating documents. Support for co-authoring document processing, formatting using OfficeArt, enhanced search and navigation functions.

    Microsoft Excel 2010- a dynamic business tool that allows you to make the right decisions based on the results of analyzing existing data using improved tools and functions. Excel 2010 allows you to calculate a variety of business development options and present them in a convenient and easy-to-read form using rich visualization tools.

    Microsoft PowerPoint 2010- A powerful program for creating presentations, including portable ones, with advanced transition capabilities, support for animation, audio and video - even in high resolution.

    Microsoft Outlook 2010 - An email client with an expanded set of new tools, support for various Web services and social networks.

    Microsoft Outlook 2010 with Business Contact Manager- Business version mail client, which allows you to significantly reduce the working time of corporate users.

    Microsoft Publisher 2010- An easy-to-use utility for creating and communicating professional-quality marketing materials and publications for print and mail distribution. Improved interface, photo editing, document navigation.

    Microsoft Access 2010- An improved version of the database with improved programming logic, integration with the business data catalog (BDC, Business Data Catalog), 25 high-quality templates.

    Microsoft Communicator- A simple, intuitive interface with numerous communication capabilities, a single identification for any communication needs (mail, Internet pager, voice, conferences) with indication of subscriber availability, the ability to distribute documents and conference plans.

    Microsoft SharePoint Workspace 2010- Replacing Office Groove 2007, SharePoint Workspace is a client software for efficient online and offline access to SharePoint content, portability of SharePoint development to the user's PC, fast automatic synchronization between PC and SharePoint sites, local access to SharePoint content via Windows Desktop Search.

    Microsoft InfoPath 2010- An application for creating rich, dynamic forms for distributing and managing information in an organizational environment.

    Microsoft OneNote 2010- new Fluent user interface, improved navigation, new organizational tools to ensure that all your notes, ideas and thoughts are not lost, organized and easily accessible. OneNote 2010 supports cross-user sharing and versioning.

    Microsoft Visio Standard 2010- A modern, intuitive tool for working with diagrams and transforming insights into final ideas. Lots of basic shapes, pictures, templates, automatic drawing and visualization tools.

    Microsoft Visio Professional 2010- An extended version of the tool for working with diagrams, with support for distribution via the Web. Processing large images and real-time data from various sources, including Excel, Microsoft SQL Server and SharePoint.

    Microsoft Visio Premium 2010- The most advanced version for professionals and management, includes templates for Business Process Management Notations (BPMN), The Microsoft Accelerator for Six Sigma and SharePoint Workflow. Supports subprocess class control processes, logic checks, etc. SharePoint documents developed in Visio 2010 Premium can be exported to Microsoft SharePoint Server 2010 for execution and real-time monitoring.

    Figure 1 shows a list of the main components of MS Office 2010.

    Figure 1 - Main components of MS Office 2010

    In addition to the set standard programs Testers also have access to a number of additional utilities for download, such as Business Contact Manager for Microsoft Outlook 2010 Language Pack on Japanese, Business Contact Manager for Outlook 2010 Database Tool; various language packs Office Language Pack 2010 for 32/64-bit versions (English and Japanese), Business Contact Manager for Outlook 2010, InfoPath 2010, SharePoint Designer 2010, SharePoint Workspace 2010, Outlook Connector 2010, Visio 2010.

    It should also be noted that office applications for the Internet - Office Web Apps, which allow you to work with various Microsoft Office files (Word 2010, Excel 2010, PowerPoint 2010 and OneNote 2010) by viewing and editing through a computer or smartphone browser, support Internet Explorer, Safari and Firefox and also require SharePoint 2010 or access through a Windows Live account.

    Microsoft came to the conclusion that it was necessary to optimize the number of Office packages: if Office 2007 is available in eight versions, then the number of Office 2010 has been reduced to five. Expansion of each of them is available through additionally purchased applications and functions. Office 2010 web applications will be available in three flavors.

    I will teach you how to repair your computer!

    Today, the work of every second of us is directly related to the use of computer technology. We study all kinds of application programs, use them to perform certain functions, process documentation and manage certain production processes.

    And the Microsoft Office software package plays a significant role in all this. It has long taken root in the computers of those users who process a large flow of electronic documents every day.

    This package contains a list of the most unique programs that are sometimes irreplaceable by any other resource. Its versatility is confirmed by the practical compatibility of existing software units with other alternatives software.

    MS Office - what is it?

    This is a package of programs aimed at working with text format files containing tabular data, presentational advertising and informational information, e-mail and significant databases of various indicators. The initial project was improved over time with the addition of additional utilities.

    In other words, Microsoft Office is a practical and multifunctional software tool for creating and working with documents of various formats, contents and types.

    Many PC users, without delving into the capabilities of this software package, significantly underestimate it, performing only a standard set of commands. But those who have long studied the full potential of Microsoft Office successfully use it in their activities, achieving mobility and creativity in creating electronic documentary masterpieces, especially since the programs in this package allow you to work not only with text, but also with video and sounds.

    Activating Office functionality

    Microsoft Office programs are not free applications. Therefore, many today are looking for free options for activating many of its functions and finding them, since the desire to work with a large potential software resource overcomes standardized laziness.

    To activate Microsoft Office, many people choose a program such as Mini KMS-Activator; it allows you to activate almost all the functions of each of the Office programs. This is the official activation version.

    However, many in their practice also use unofficial software products such as Windows XP Zver DVD, these are utilities that hack the Office software or quickly activate it and offer the user already unwrapped candy.

    Unofficial activation has its disadvantages compared to the first option. Not all functionality software applications“Offices may be available.” However, for the average user this resource will be quite enough to master the benefits of the package. This option is not suitable for professional people and businesses who need full functionality to implement all design decisions using the software itself.

    List of standard Office tools

    The Office package includes a set of standard programs that all users can use.
    The familiar Microsoft Office 2007 includes the applications from the original design, but in a more graphically updated version, making them more powerful and attractive to the user. This package naturally includes MS Word for creating text documents, MS Excel - for working with tabular data and calculations, MS Power Point - for working with images, illustrations and photographs, MS Access - for creating electronic databases and planned projects, MS Outlook - for optimized work with email and messages.

    The updated modern Microsoft Office 2010 and subsequent versions contain the same standard set that we listed above plus new software utilities such as MS NoteOne, MS Publisher, MS SharePoint Workspace, MS InfoPath Designer. It is these utilities that have great potential and are equal to innovative IT technologies.

    That is, these utilities are already present in later versions after 2010.
    Well, with the list of Microsoft Office software applications, everything is more or less clear. Let's look at the specifics of what they can be used for, that is, what kind of work can be done using their functionality.

    So, His Majesty MS Word. What can it offer its user? Firstly, this software tool allows you to work with various types of texts and graphics. But few people use this functionality to calculate mathematical formulas, work with images and photos, as well as create slide presentations, to create and design web pages, using huge variations of the proposed templates. Wow, many who use this resource only for typing will think. So there is something to really be interested in, the main thing is to find the time and test out this entire software potential in practice.

    The king of numbers, MS Excel, exceeds all user expectations. The initial idea of ​​its developers was to provide standard simple calculations of a mathematical nature, but they were so carried away that today this application is used to create graphical charts, histograms, three-dimensional images, complex computing projects in business, industrial and scientific activities.

    The indispensable MS Power Point was created for creating advertising and information presentations, in which you can use sound reproductions and graphic images. Its analogues are very resource-intensive, but Power Point itself is filled with an excellent selection of templates, which distinguishes it by its efficiency and mobility. With the help of this resource, photo catalogs, promotional materials, audio books, tutorials, portfolios are created... whatever your heart desires, and most importantly, all this can be filled with photographs, sounds, and web links.

    The MS Access tool is rarely used in practice by those who have no idea about databases. But those users who daily have to work with many specific lists appreciated this resource, because its functionality is simply amazing.

    The promising MS Publisher is used for mass publication of information materials for wide distribution. Its potential is often used by marketers and businessmen who care about the prestige of their company and who develop large-scale image projects.

    Mobile MS Outlook is, of course, many people’s favorite resource for working effectively with email. This resource is not installed automatically, to evaluate all its capabilities, you must first install it, following the application prompts.

    As mentioned above, all software elements of Microsoft Office are paid. So many PC users are finding a cheaper alternative to all these products. And not even cheap, but completely free.

    Many people, even before the release of the Microsoft Office software package, used a package such as Lotus Symphony. Oddly enough, its functionality is still relevant today.

    Of the newer and more modern versions, users like applications such as Kingsoft Office, Libre Office, Google Docs, SoftMaker Free Office. This is a free app and you don't have to activate any features. But, nevertheless, they are not as extensive as in Microsoft Office. Therefore, they cannot compete with him.

    Well, what can I say, each user is free to choose what he will use in practice, what software tools. Let's just say one thing: the Microsoft Office software package allows you to develop and bring the most seemingly impossible projects into reality. But each user has his own level of optimization and needs.

    Today, the Microsoft Office software package is the most functional and has no perfect analogues to offer computer technology users. Microsoft's only competitor, Google, is practically on the same level with it, but even then, if you evaluate its software offerings, you can find many of the missing convenient features available to the leader in software application development.

    So for many, Microsoft Office is the most promising option for developing their professional skills and qualities on the path to building a career ladder.

    It is impossible to explore the full potential of Microsoft Office; even the most advanced users discover something new and useful for themselves every day, using it for different purposes. We invite you to join the group of those who truly understand the fact that there cannot be better software potential, and if it can, then its developer will certainly be Microsoft.

    Free products do not provide as many opportunities for self-realization and new knowledge as official versions of programs. So think for yourself what you save on, on a one-time activation of promising capabilities of modern software applications or on your development and establishment as an indispensable employee, provider or marketer.

    Use the best in your work and you will not notice how your professional rank will increase significantly. After all, the Microsoft Office package is not the limit of functional electronic capabilities.

    Basic Microsoft Office programs

    Surely, you have encountered a problem when programs from more than one package are installed on your computer. You use one graphics editor, another program for creating tables, and it often happens that different applications do not function well with each other. There is a solution for this problem. You can download the package Microsoft Office, which has all the most necessary programs for efficient computer work. It contains programs that are necessary to work with documents, numbers, tables, images and texts. This package is very convenient to use, since all its component programs have a common user-friendly interface. You won't need to waste precious time getting used to each application separately. Also, all programs have a single Manager Microsoft Office, if you have any problems, with the help of this manager you can solve almost any problem. Plastic bag Microsoft Office from the following programs:

    Microsoft Word- one of the best text editors that will help you create a document and edit it. This program has a built-in dictionary of synonyms, and Microsoft Word will also help you correct errors in your document and bring it to perfection.

    Microsoft Excel- a program that provides effective work with tables. If you are good with numbers, then Microsoft Excel will be indispensable for you. application in the preparation of financial reports and lists of any complexity. This application will automatically add, subtract, multiply and divide numbers of any size!

    Microsoft PowerPoint- an excellent application for creating presentations into which you can add audio, video files, pictures and other documents. With the help of this program, you can design any project and make even the driest report interesting, because people are always interested when there is something to look at and evaluate.

    Microsoft Access- a program designed to manage system data; it is the main assistant in the work of programmers.

    Microsoft Outlook- a communicator program with which you can use a calendar, notes, task planner, etc. Very useful application for efficient organization of work.

    All of these programs are a prerequisite for high-quality work on the computer; each of them performs its own function, making it easier for you to use the PC and perform any tasks.

    Moreover, for the lucky ones who have Apple devices, namely the iPad, Microsoft Office has developed special applications Microsoft Office for HYPERLINK " http://ru.wikipedia.org/wiki/IPad " o "IPad" iPad, which includes Word, Excel and PowerPoint. Such applications make it possible to conveniently work with documents on your device anywhere in the world.

    In the 21st centuries programs Microsoft Office is the key to the successful operation of your personal computer, its security and efficiency.

    Scroll Microsoft programs Office. Free programs

    The Microsoft Office software package has long gained popularity among users of all levels who use office documents. It is not surprising, because each program included in the standard set not only has unique capabilities that are unique to it. Applications of this type are compatible with each other and with other alternative software products.

    It is known from history that the Microsoft Office suite was initially developed taking into account the then trends for working with text documents, tabular data, presentations, databases and e-mail. Later, it began to include some additional utilities.

    Microsoft Office itself is a collection of applications for processing documents of almost any type. Many users who use the standard functions of a particular application included in the list of Microsoft Office programs often underestimate its capabilities. The fact is that almost every program is capable of working not only with standard, so to speak, template documents. It is absolutely simple to insert graphics and sound into any document and in any program.

    The only thing I would like to note is that the list of Microsoft Office programs is not included in the list of free software and is quite expensive. However, this does not stop our users. To activate this software package, you can use, for example, Mini KMS-Activator, which works with almost all versions of Office.

    In some cases, you can use unofficial releases of an operating system installation distribution like “Windows XP Zver DVD”, in which Microsoft Office is already “hacked” or activated.

    When using an unofficial package, difficulties may sometimes arise due to the lack of a full set of capabilities in each program. It is clear that such a software product will be suitable for the average user. But for people or businesses who are serious about business, the best option there will be a purchase of the official release.

    List of Microsoft Office programs included in the standard set

    So, let's try to look at the standard set of any office suite offered by Microsoft.

    As a rule, the list of Microsoft Office programs includes several standard applications. They are found in any package and can meet the user's needs in any situation.

    Microsoft Office 2007: Applications and Programs

    It is natural for Microsoft Office 2007 programs to include various applications that were not included in earlier versions of the package. In addition, it is worth paying attention to the fact that not only the functionality of the applications themselves included in the list of Microsoft Office programs is changed (or supplemented). The graphical shell of each user is also subject to the update. software product. However, the standard set itself remains unchanged.

    For example, it includes several basic applications. These are MS Word, MS Excel, MS Power Point, MS Access and MS Outlook. These are, so to speak, the basic office programs of Microsoft Office. They are also the most necessary.

    Microsoft Office 2010 and higher software package

    New releases of Microsoft Office may also contain additional utilities. True, very often users do not pay attention to them. For example, programs like MS Publisher, MS InfoPath Designer, MS SharePoint Workspace and MS NoteOne look very interesting. These utilities are capable of a lot and can compete with many professional software products present on the market. modern market IT technologies.

    As is already clear, these applications have become available since Microsoft versions Office 2010. While MS Publisher was present in some releases earlier, other programs appeared only starting in 2010.

    Now a few words about the main components included in the list of Microsoft Office programs.

    Working with text and graphics is perhaps the most common and in demand. This is why the Microsoft Office Word application was created. The program has enormous capabilities not only in terms of text processing. Many people don’t even realize that here you can even write mathematical formulas of any level of complexity, insert graphic objects in the form of single files or slide shows, supplement all this with audio, or even create web pages using the program as a fast and effective tool based on templates.

    Working with tabular data is difficult. But MS Excel copes with this quite simply. Initially, the application was created in order to perform mathematical, algebraic and geometric calculations. Over time, the program's functions have expanded greatly. For example, it became possible to build graphs or create charts or histograms even in three-dimensional form. Without talking about all the capabilities of the application, it is worth noting that this is one of the most powerful tools in its field of application.

    Microsoft Office PowerPoint was designed specifically for creating presentations that use graphics and sound. It is clear that such processes are resource-intensive, but the application itself has many templates and standard solutions in order not to load the system. If you think about it, you can insert absolutely everything into a presentation. Do you want a photo? Please! Do you want sound? Cheers! Would you like a link to an Internet resource? No problem! In general, you can even create interactive training manuals.

    This application is simply not familiar to many ordinary users, because they almost never work with databases. But for knowledgeable people, this application is simply a godsend, because it allows you not only to create or edit such data, but also has close integration with numerous development tools and supports many language applets, including Visual Basic, Java, working with SQL databases and etc. Well, there are enough tools for data processing here.

    This application is a universal tool for quick publishing. It is primarily focused not even on checking the text part, but on creating, say, your own, so to speak, corporate symbols, conducting marketing research customized to the personal needs of a company or businessman. Naturally, this is not all that this program is capable of, although it belongs to entry-level applications.

    Finally, Outlook. This is a program designed to work with email. Compared to the standard Outlook Express utility, this application looks much more preferable because it has more functions and capabilities. Unfortunately, Outlook Express is installed on the system by the client by default (when installing the Windows OS itself). And not many people would think of changing it. But in vain! MS Outlook has much more possibilities. But here it’s worth assessing for yourself what this program is capable of. After the initial test, I think many will simply forget about Outlook Express, considering it practically a child's toy.

    All this is good. But, as mentioned above, the Microsoft Office package is paid. What do free programs offer us?

    Here it is worth paying attention to alternative software developments. The Lotus office suite (particularly Lotus Symphony) was once very popular. Nowadays it is found almost nowhere, but nevertheless it has not lost its relevance.

    You can also use completely free software products such as Google Docs, Zoho Office, Libre Office, SoftMaker Free Office, Kingsoft Office, etc. The most important difference from the Microsoft product is that all these packages are not only free, but also still have open source code. So any developer can optimize them for their own needs.

    However, it is worth noting that all these “Offices” are clearly behind what was created by Microsoft. Even despite the declared freeness and open source code, they have not received much distribution in the world. The only competitor is Google. Moreover, the office programs of this IT giant are mainly used only on mobile devices, and then on the Android platform. However, each user is free to choose what to use in his work and what will be most convenient for him.

    On the other hand, if you look at it, the average user can use free programs - alternatives to the Microsoft Office office suite. However, as practice shows, few people manage to “outdo” Microsoft Corporation. Even its biggest competitor, Google, is unable to cope with this. It is clear that to develop office applications of any type, not one person is involved, but the brightest minds of our time. So it turns out that Microsoft Office stands head and shoulders (if not two) above its competitors.

    In conclusion, it is worth noting that any user, even one who does not thoroughly know all the capabilities of the Microsoft Office software product, can simply “dig” into the menu of any of the above programs and find something new for themselves. As a last resort, you can use the built-in help system or read about the main features and functions on the Internet. Fortunately, this is not a problem now.

    Windows 10 Pro ("Professional")– version for computers, laptops and tablets with functions for small businesses (protection of important data, remote and mobile work scenarios, support for cloud technologies).

    Windows 10 Home– your partner in any business. Enjoy fast launch, a familiar (but much improved) Start menu, and exciting new experiences across devices.

    Windows 10 Enterprise– version for larger businesses with advanced management functions corporate resources. It contains options required by medium and large businesses.

    Microsoft Office Standard 2016 offers new cloud technologies that allow you to work with your mail, text documents, spreadsheets and publications from any device.

    Microsoft Office Professional Plus– an office suite that provides an effective platform for business communications and collaboration. The benefits this product provides provide more opportunities for increased productivity and advanced technical services.

    Microsoft Office Home and Business 2016– a software package for organizing work in household tasks and with documents in small businesses. The Home and Business edition of Office supports tools and features for viewing, creating, editing, and printing presentations and text documents, notes, and spreadsheets.

    Microsoft Office Professional 2016– a multifunctional office software package for fast work with documents, convenient communication through the use of functions that save your time. With a comprehensive suite of Microsoft Office Professional productivity applications, you can efficiently create, complete, and perfect everyday and everyday tasks.

    Microsoft Access 2016 allows you to easily create database applications.

    Microsoft Excel 2016

    Microsoft Outlook 2016 helps to organize the work being done and do everything on time.

    PowerPoint 2016 provides a convenient opportunity to generate, discuss and successfully present your ideas.

    Publisher 2016 is a simple tool for creating professional publications that readers will love.

    Microsoft Word 2016– Create and publish professional-looking documents using advanced editing, reviewing, and collaboration tools.

    Skype for Business, formerly known as Microsoft Lync, Microsoft Office Communicator is a communications client program that allows users to communicate with each other in real time using various types of communications: instant messages, video and voice communications, desktop sharing, conferencing, file transfers .

    Achieve professional excellence with up-to-date Office tools and collaboration services.

    Achieve professional excellence with a full suite of Office apps across multiple devices, plus access to online storage with the ability to sharing files.

    Expand your reach with cloud Office: modern business You can’t do without such tools.

    Office will now always be with you, wherever you go. It gives you the latest tools for effective collaboration, compliance, and business intelligence. They are distinguished by functionality, flexibility, as well as fast downloads and updates without unnecessary complications.

    Office Standard 2016 for Mac– a new package of Microsoft office products, includes updated Word versions, Excel, PowerPoint, OneNote and Outlook.

    Office Home and Business 2016 for Mac– a new suite of Microsoft office products that includes updated versions of Word, Excel, PowerPoint, OneNote and Outlook.

    Excel 2016 for Mac allows you to understand the essence of the data and present it in the form of a report.

    Outlook 2016 for Mac Helps you focus on the tasks that matter most with easy-to-use views of email, calendars, and contacts.

    PowerPoint 2016 for Mac makes it easy to generate, discuss and successfully present your ideas.

    IN Word 2016 for Mac you can create even more attractive and interestingly designed documents.

    Microsoft Visio 2016

    Microsoft Visio 2016– a program for creating graphical diagrams and diagrams with a wide range of visualization tools for visually representing complex data such as circuit diagrams, complex systems of multi-level processes, flowcharts or diagrams.

    Microsoft Visio Pro for Office 365, offered as a subscription from Microsoft Office 365, contains the same features, stencils, and shapes as Visio Professional 2016.

    Visual Studio 2017 is a powerful integrated development environment for creating stunning apps for Windows, Android, and iOS, as well as modern web apps and cloud services.

    Editorial Standard Windows Server 2016 is an OS edition with full capabilities and the right to run up to two virtual copies.

    Editorial Essentials Windows Server 2016 is designed for small businesses (supports up to 25 users and 50 connected devices).

    Editorial Datacenter Windows Server 2016 is the most complete edition of the OS with unlimited rights to launch virtual instances.

    CAL (Client Access License) is a license that gives the user the right to access server services.

    Windows Remote Desktop Services CAL 2016– a type of client access license that provides access to Remote Desktop Services Windows Server 2016.

    SQL Server 2017 is an important step towards creating a universal SQL Server platform that will allow developers to freely choose development languages, data types, local or cloud environments and operating systems, ensuring compatibility with Linux, Docker containers on Linux based and with Windows.

    SQL Server 2017 is an important step toward creating a universal SQL Server platform that gives you freedom to choose your development languages, data types, on-premises or cloud environments, and operating systems, while providing compatibility with Linux, Linux-based Docker containers, and Windows.

    An introductory article before you start learning about Microsoft Office. The most widespread product in the area computer technology. Everyone reading this article, ask yourself a question - why was the computer created? Right! So that working on a computer is firstly convenient, secondly accessible and thirdly automated. Let's figure it out.

    Convenient work on a computer consists of a minimum of actions to obtain a certain result. For example, you need to make a thirty-slide presentation. And all this must be done manually!!! How much time will it take you to draw a background for 30 slides, write text, insert graphics and photographs? I would guess at least a week. In order to insert a background for all thirty slides, you will have to spend less than a minute! The same goes for writing or inserting text, photos and graphics. And at the same time, you receive a copy in electronic form and in printed form, if you need to print it on a printer. In this case, the electronic version can be edited as much as you like. This is it convenient work on the computer. You may ask, what does manual work and convenient work on a computer have to do with it? Given that without Microsoft Office or analogs, if you are not a programmer, then it will be much longer and more difficult for you to do it on a computer than manually. The answer, I think, is clear.

    Availability means that the Microsoft Office software package is paid or free analogues, can be purchased at any computer store or downloaded from the Internet. Everything is clear here.

    Automation. The most important thing is that many people do not use it when working on a computer. Example: you need to do calculations and reporting every week. I’ll tell you a secret that will be discussed in much more detail in the following articles of this section: TEMPLATES, spreadsheets, macros and many other useful things. Which in turn will significantly save your time and effort, if used correctly.

    Microsoft Office is an office software package designed for working with text, calculations, tables and images. This package is paid, but there are free analogues. Currently this package at such a level that it can be installed not only on a computer, but also on a phone, communicator or tablet. This makes the product much more functional. Microsoft Office is the main tool, the knowledge of which is required almost everywhere. At school, at college, at home, at work... And good and high-quality knowledge will bring you the ability to apply all three qualities that we discussed in this article.

    Let's look at the programs that are included in Microsoft Office:

    1. Word – text editor

    2. Excel - spreadsheets

    3. PowerPoint – creating presentations

    4. OneNote - taking notes

    5. Outlook – email service

    We have listed a list of the main programs that you need to be able to work with in order to have a complete knowledge of Microsoft Office. I would also like to mention that this product is an international format for work in all areas of human activity related to a computer.

    The ability to electronically process various documents can be called one of the main reasons for the massive proliferation of personal computers, both among home users and in the corporate sector. Gone are typewriters, manuscripts, and even ordinary letters are increasingly rarely seen written by hand. Nowadays, almost any printed matter and documents: be it diplomas or abstracts, magazines or books, statements or notes, reports or presentations, are created on a computer. After all, an electronic document can be corrected, altered, supplemented, sent by e-mail, printed on paper, or posted online for collaboration on it at any time. I probably won’t be wrong if I say that almost every person who has ever sat down at a computer has had to deal with processing text documents, and for many this was the reason for their first acquaintance with a PC.

    Despite the fact that all modern operating systems have built-in tools for working with text data, their capabilities 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 well-known office suites include Microsoft Office, OpenOffice.org, Corel WordPerfect Office, StarOffice, Lotus SmartSuite, Ashampoo Office and iWork (for Mac OS). Each of the products in this area has its own set of components, design solutions and, of course, functionality. In our article today, we will get acquainted with one of the most popular office solutions for users, developed by Microsoft - MS Office.

    HISTORY OF DEVELOPMENT

    This popular office suite first saw the light back in 1992 and at the beginning of its journey it included 4 applications, which still remain fundamental for it: Word, Excel, PowerPoint and Mail. Access was added to this group in 1994, and Shedule+ in 1995. In '97, the Mail email application and Shedule+ calendar replace the Outlook organizer and add the Photo Editor. In 1999, the Publisher application for preparing publications, the FrontPage website creation program appeared, and PhotoEditor was replaced by PhotoDraw. After the release of Office XP in 2001, the PhotoDraw image editor finally disappeared from the office suite, and in 2003, FrontPage. At the same time, a new data collection and management application appears in Office 2003 - InfoPath.

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

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

    With Office 2007, the software giant decided to abandon the usual system menu, replacing it with a Ribbon interface based on toolbars separated by tabs. Buttons on ribbons, unlike toolbars, can be of different sizes, for example, those that are needed more often can be larger, and samples of the styles used can be located inside them.

    The buttons themselves are grouped into groups by topic. Rarely used buttons are usually hidden, but still accessible via a drop-down menu.

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

    However, the ribbon interface allows users to use many more functions of the office suite, since most of them are now in plain sight, rather than hidden deep in the menu. Microsoft itself sees the future in a new management system, and this is confirmed by the company’s latest development in this area - Office 2010.

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

    Currently, the office suite of applications from Microsoft is 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 package has several editions, on which the availability of certain applications in it. For example, the latest Office has six of them: “Starter”, “Home and Study”, “Home and Business”, “Standard”, “Professional” and “Professional Plus”.

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

    Microsoft Word (Word)- an application for working with text documents. This word processor has been the most popular among all those used in at the moment. That is why the “doc” document format has become the de facto standard for modern document management, and many competing programs support compatibility with this format.

    WITH using Word, you can easily create beautifully designed, professional-quality documents and organize them. In addition to multiple text styling options, you have a variety of supporting tools at your disposal: a table builder, image editing tools, inserting ready-made shapes, a chart and histogram builder, inserting SmarArt graphic objects for visual presentation of information, and many others. At the same time, users can collaborate on projects and documents, as well as simultaneously edit them.

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

    The Excel application opens up wide possibilities for data analysis, as well as for managing and exchanging them. Powerful data visualization tools, summarizing data using small charts that are placed in a cell along with text (sparklines), as well as fast filtration large volumes of data help you effectively compare results, tracking and highlighting important trends. Files table processor can be easily sent to the Internet to work with other users.

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

    Notebook sharing lets you create and edit notes at the same time remote users or simply synchronize data, ensuring it is up to date. You can also take notes while working in other Office applications or Internet Explorer, and OneNote will provide a link to the location in the original document you were viewing when you added the note, allowing you to automatically link ideas to the content you create.

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

    Using PowerPoint, you can not only add, but also edit multimedia content, using a variety of artistic and video effects. The application also allows you to use dynamic volumetric effects of changing slides and realistic effects animation.

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

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

    Microsoft Publisher- an application for creating, customizing and distributing all kinds of professional-quality publications and marketing materials. Even without graphic design experience, you can use a variety of templates to create brochures, newsletters, business cards, postcards, email newsletters, and other publications.

    At the disposal of users professional products image editing, modern technologies object alignment, the ability to create dynamic publications, advanced typographic capabilities for text design and a convenient means of previewing the created material and distributing it. The possibility of sharing and distributing publications has also not been forgotten.

    MicrosoftAccess- applications for creating and managing databases. This effective personal data management tool is primarily aimed at the corporate sector, small businesses and non-profit organizations, although ordinary users can find use for it, for example, for cataloging home audio-video libraries.

    Access 2010 adds new ways to access and share databases. Viewing and editing databases can be done directly via the Internet, and users who do not have this application can open web forms and reports through a browser.

    MicrosoftInfoPath- an application for collecting and managing data. As a rule, it is used by organizations to optimize their own business processes, is intended for experienced business users or developers, and is unlikely to be of interest to home PC users.

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

    SharePoint Workspace (Sharpoint Workspace) - an application that enhances the ability to collaborate on documents and their libraries in a single special SharePoint Workspace environment.

    This tool is more aimed at business groups in medium-sized organizations and large enterprises that need a single workspace with ample opportunities for sharing data, as well as their joint editing, and is unlikely to be useful to home users.

    MicrosoftLync - an application that combines common means of communication. Positioned as a solution for medium-sized businesses and large enterprises. Combines sharing capabilities instant messages, organizing meetings and voice communication. The client has a toolbar that makes it easy to find and access frequently used features such as the dialer, visual voicemail, and lists of contacts and active conversations.

    CONCLUSION

    Having considered all the components that make up the modern Microsoft Office 2010 suite, it's time to take stock.

    There is no doubt that such a set of versatile solutions can satisfy almost any user. The quality level of electronic documents created using the tools included in this office suite is indeed very high and accessible even to beginners. That is why some formats from Microsoft Office are accepted as de facto standards for most of the world's 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, only 4 are available for home users: “Elementary”, “For home and study”, “For home and office” and “Professional”. It should be taken into account that the “Initial” edition, containing the two most popular applications- Word and Excel, distributed free of charge, and only with new computers that have the Windows operating system preinstalled. The “Standard” and “Professional Plus” editions are distributed only to corporate clients.

    The most budget option for home users would be Office package for home and study. Today its cost is 2990 rubles. It includes four applications: word processing Word, spreadsheet editor Excel, note-taking applications OneNote and presentation application PowerPoint. We can say that such a gentleman's set is suitable for most users working with documents at home. Also note that office set applications for home and study are not intended for use for commercial purposes (for profit) and non-profit organizations, as well as in government agencies.

    And yet, the absence in this edition of such a component as Outlook - a personal organizer and a good email client, for some, will be a reason to turn their attention to the Office edition for home and business. True, for this set of components, there are no longer any restrictions on the purpose of its use (as indicated by the business prefix), which is immediately reflected in the cost of the product, which more than doubles and currently amounts to 6990 rubles. I think that for many, overpaying 4,000 rubles for Outlook will seem unreasonable and purchasing this edition for the home remains the prerogative of enthusiasts.

    Office Professional contains two additional components - Publisher and Access, applications for creating publications and working with databases, respectively. But the price of 17,990 rubles clearly indicates that this product is aimed at business use.

    So, if you like the Microsoft Office product, then the most optimal set of applications for use on your home PC will be Office for Home and Student. 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.

    Back in the early 60s, the American scientist Joseph Licklider (who today is rightfully considered one of the fathers of the Internet) expressed the idea that the main purpose of computers should be the automation of routine human work. At a time when many had no idea about the existence of computer technology, this idea seemed like just a professional joke. It was believed that computers were intended exclusively for solving some fundamentally new and very complex mathematical problems.

    Science and life // Illustrations

    In the main PowerPoint window you can see a set of slides (a fragment of a presentation) prepared using the tools of this package. On top of it is the "Slide Show" menu, in which all possible demonstration options are visible. And this is not all the possibilities

    One of the functions of the OUTLOOK program is planning your activities (Calendar).

    Today, many people still think that creating Web pages is the domain of only “cool” Web designers. However, using a modern HTML editor, creating a Web page is as easy as writing a business letter. The picture shows a Web page created by the author.

    However, the scope of application of computer technology was rapidly expanding, precisely due to the advancement towards traditional practical problems in various fields of human activity. At first, these included various economic calculations, storage and processing of archival data, and technological process management.

    With the advent of personal computers in the mid-80s, accessible not only to businesses, but also to individuals, the range of practical issues solved by computers began to grow exponentially. Today, at least 40 percent of PCs are used by home users, and 90 percent of the computing power of all computers (including in enterprises) is used to automate a variety of routine work. At the same time, an increase in labor productivity is achieved not only by increasing the speed of performing certain operations, but, mainly, by combining several disparate functions together. This allows even an inexperienced user to solve problems that were previously only accessible to professionals.

    OFFICE SOFTWARE PACKAGES

    Among the abundance of application software, one can distinguish a group of programs that solve problems of a wide variety of purposes and therefore, to one degree or another, are needed by every computer user, regardless of his profession. In recent years, such software packages have been called office software.

    Although many global developers (for example, Corell and Sun) are involved in the creation of office programs, Microsoft Corporation (Microsoft) is the leader in this area, actually setting the standards for such software. It is worth noting that in order to achieve market success, Microsoft products about ten years ago had to enter into fierce competition with the then favorites, for example text editor WordPerfect and Lotus 1-2-3 spreadsheets.

    Starting development office packages, Microsoft immediately set the goal of creating not individual programs, but a whole complex of interconnected and mutually complementary applications called Microsoft Office (Microsoft Office). As the system developed, new applications appeared in it, and the functions of previously created programs were expanded, satisfying the growing requirements of the “average” user. Over the past six years, Microsoft has released four versions of MS Office: 4.0 (1996), 95, 97 and 2000. The latest version (MS Office 2000) is sold in five editions with different programs: Standard, Small Business, "Professional", "Advanced" and "For Developers". The “For Developers” kit (more precisely, the Developer Edition, since it is supplied only in the English version), unlike other editions, contains additional programming tools. The "Advanced" edition includes the following applications: Word (Word), Excel (Excel), Access (Exes), PowerPoint (PowerPoint), Outlook (Outlook), FrontPage (Frant Page), Publisher (Publisher), PhotoDraw (PhotoDraw) , Small Business Tools. Let's give a brief description of these programs.

    1. WORD - TEXT PROCESSOR

    Word processor- historically the very first and most widely used office application: everyone needs to write and format texts. Ten years ago, such programs were called “editors,” but today this term no longer reflects their increased capabilities.

    The advent of word processors radically changed not even the technology, but, if you like, the very approach to creating a variety of texts, from a report to the boss about a vacation to a literary work. Previously, preparing a lengthy document, such as a 100-page research report, took up to a month of work by several people (not counting the preparation of the handwritten version). At the same time, the lion's share of time was spent on explaining to the typist how to understand the manuscript (remember the interlude performed by Vladimir Vinokur: “we play here, we don’t play here, don’t look at this at all, but this piece - back side", etc.), then to check what happened, and repeat explanations to the typist about what needs to be corrected. And when the report was ready, it turned out that one section and several paragraphs were missing. How many problems the preparation and insertion of illustrations caused - it’s not worth it and remember...

    Today, the functions of word processors go far beyond the scope of working with texts themselves (typing, editing, formatting, automatic spell checking, writing abstracts, etc.). Word allows you to create various tables, graphs, illustrations, formulas, etc. in the text with their automatic numbering and cross-referencing. As a result, the user can prepare a complex document of almost unlimited volume using graphics and a variety of formatting.

    And yet we emphasize that there are quite enough opportunities for preparing “purely text” documents WordPad programs supplied with the Windows operating system.

    2. EXCEL - WORKING WITH ELECTRONIC TABLES

    This program is necessary for anyone who deals with data presented in the form of tables. It is in this form that most of the information about our daily activities can be presented: address books, video cassette files, recording household expenses, etc.

    Tables can contain data in a variety of formats (character strings, dates, etc.), but in general, of course, the Excel package is focused on processing numerical data. The simplest example is summing over the columns and rows of a table. It is not much more difficult to calculate the value of user-specified functions (say, the percentage increase in household expenses by item). One of the most attractive features of the package is the quick and visual presentation of data in the form of a variety of graphs, charts, and maps.

    COMPOSITION OF APPLICATIONS IN VARIOUS MICROSOFT OFFICE EDITIONS

    Applications

    Purpose

    Standard

    For small business

    Professional

    Advanced

    Database management system

    Spreadsheets

    FrontPage (English)

    Tool for creating and maintaining Web sites

    Email and Work Scheduling Manager

    Business graphics editor

    Presentation preparation program

    Desktop publishing

    Word processor

    Small Business Tools

    Contact and customer manager

    Spreadsheets are an ideal tool for organizing accounting, processing experimental data, and drawing up reports of a wide variety of forms.

    3. ACCESS - DATABASE MANAGEMENT SYSTEM

    The appearance of Access as part of office programs in 1992-1993 can rightfully be called a significant event, because before that it was believed that the creation of database management systems (DBMS) was the domain of exclusively experienced professionals.

    There is no need to be scared: a DBMS is not at all as scary as it might seem. In fact, the electronic Excel tables- this is also actually a small database management system, that is, an ordered set of structured information. But spreadsheets have two limitations: the size determined by the computer's RAM capacity, and the two-dimensional representation of data in the form of rows and columns.

    Relational DBMSs (almost all systems actually used today, including Access, belong to the “relational” category) work with the same tables, but the data is stored on external media information, and the tables are interconnected by cross-references.

    The simplest example of such data organization is maintaining a catalog of a collection of audio CDs. One table can store complete information about songwriters, another about artists, and a third about individual songs. In this case, the last table will have the necessary links to the first two, so that the user can easily find out, for example, the birthday of its author by the title of the song.

    Access is a very popular and useful DBMS that can be used to create both small local and very serious professional systems. By the way, studying Access and DBMS development technology is very useful for moving from the basics of programming to solving complex production problems.

    4. POWERPOINT - PREPARATION OF VISUAL PRESENTATIONS

    Programs like PowerPoint have appeared relatively recently, but today they have become a reliable assistant for anyone who at least sometimes has to give lectures or reports in front of an audience (which sometimes can be represented by only one listener).

    Previously, it was believed that illustrative material was required only for reports in which it was necessary to show complex tables, graphs and mathematical formulas. Today, visual display of the main points of even a simple text report is becoming a generally accepted style.

    Anyone who has ever made technical reports (the defense of a thesis project or a report at a scientific and technical council) can remember that preparing the text of a 15-minute message took a maximum of one or two days. And the creation of a dozen posters or slides took at least a month of work, and first the speaker himself drew the sketch, and then a professional draftsman worked. In recent years, the number of “speakers” has increased sharply (for example, due to the appearance of sales managers), and they have to speak not once every six months, but almost weekly, constantly changing the content of their presentations and illustrations.

    Using programs like PowerPoint, a dozen slides can be made in just one or two hours by one person - the author himself. And if you need to make any corrections in the future, it will only take a matter of minutes.

    For listeners, the demonstration of prepared materials is approximately the same as with a traditional slide show, but in addition to static images, you can use sound, video, and various visual effects.

    By the way, PowerPoint can be used not only for speaking in front of an audience. Many home users work with this program, for example, when creating graphic screensavers for their videos.

    5. OUTLOOK - YOUR PERSONAL DISPATCHER

    Although Outlook was introduced just a few years ago, it has already become a necessity for many users. Outlook includes an address book, a diary for current entries, a weekly planner for planning activities, communicates with the outside world through e-mail, and also performs many other useful functions.

    Most people carry with them all the time notebook and if they forget it somewhere, they find themselves without any hands. Once you start using Outlook, you will immediately realize how much time you have wasted working without it.

    One of the most impressive features of this application is the completely new automated capabilities for scheduling and monitoring tasks. When you turn on your computer in the morning and load Outlook, you will immediately receive reminders about all the tasks planned for the day. And even that one of your loved ones needs to be congratulated on their birthday, which you completely forgot about in the whirlwind of everyday life. Throughout the day, the program will remind you of planned events down to the second.

    Outlook can also be used effectively for planning group activities. For example, when working on the same computer network of an enterprise, you can use Outlook to look at the schedule of free time of employees whom you would like to invite to a meeting, automatically select the most convenient time for everyone and “stake out” it in the plans of the invitees (each of them will immediately have relevant notice).

    In addition, Outlook includes a feature-rich system for managing email and telephone communications.

    If, of all the functions of Outlook, you only need the mail system, you can limit yourself to the capabilities of the Outlook Express program included in Windows.

    6. FRONTPAGE - TOOL FOR CREATION AND SUPPORT OF WEB NODES

    Anyone who has visited the Internet at least several times has a good idea of ​​what Web sites are: they are a set of specially designed Web pages interconnected by cross-links. Just five years ago it was believed that creating Web sites was the province of a narrow caste of professionals. And 99.99...% of Internet users remained “readers”, but not “writers” and certainly not “layout designers”.

    But the situation is changing quickly. Today, no one can be surprised by the appearance of personal Web sites. As one of the jokes on this topic says, “You are sick of the Internet: your dog also has his own Web page.” However, now this statement is no longer a joke for many, but a reality. Try to create your own personal Web site about your work, hobbies, travel, etc. Many Internet providers provide free required address and up to 50 MB for storing your information, which is more than enough to get started. You will immediately see that this is not only an exciting, but also a useful activity. Your page may not contain information that will be of interest to the whole world, but it will undoubtedly attract the attention of your friends and family. With the help of your Web site, you can, for example, bring together numerous relatives scattered around the world. And this is already a lot.

    FrontPage will help you create and develop your Web site. To use it, you do not need to know programming - you only need the desire to master the program. By the way, the profession of a Webmaster today is one of the scarce and most prestigious. And FrontPage will help you master it.

    If you're wondering whether it's worth spending money on purchasing additional programs, keep in mind that Windows includes FrontPage Express, which can help you take quite a few first steps in mastering Web design.

    7. PUBLISHER - DESKTOP PUBLISHING SYSTEM

    As already mentioned, Word helps you create fairly complex text documents with a variety of graphic designs. But it is impossible to obtain high printing quality with its help. To do this, you should use the Publisher desktop publishing system, which recently appeared as part of MS Office.

    Although many Word functions and Publisher overlap, but still the main task of Word is the formation of the content of the document, and Publisher is the implementation of the document in the form of a high-quality printed publication. Publisher is most often used to produce colorful brochures, catalogs, invitation cards, menus for parties, greeting addresses, etc. The program contains all the tools, templates and blanks necessary for this. A large library of layouts provides an opportunity to get acquainted with the experience accumulated by professional publishers and designers.

    One of the main functions of the PhotoDraw program is the processing of images obtained from photographs. From a real photo of your dog, you can make an almost square monster to scare the bullies, or a very slender Giant Schnauzer.

    8. PHOTODRAW - BUSINESS GRAPHICS AND IMAGE EDITOR

    For fairly simple editing of graphic images, the Paint and Imaging programs included in Windows may be sufficient. But more complex operations will require more serious tools.

    Previously, image processing was also the field of activity of highly qualified professionals, and the leading position here has long been occupied by the famous Adobe PhotoShop and Corell Draw systems. However, today such problems increasingly need to be solved by “ordinary” users. For example, if you are engaged in photography, then computer processing can significantly improve the quality of images, “pull out” seemingly completely spoiled, but very dear to you frames. Working with graphics is absolutely necessary for the beautiful and original design of your Web site, printed publications or PowerPoint presentations.

    Although PhotoDraw is still somewhat inferior to the capabilities of the above-mentioned products from Adobe and Corell, its functions are quite sufficient to solve many useful tasks on high level. It should be borne in mind that one professional graphics package costs about the same as the entire MS Office 2000 program package.

    9. CONTACT AND CUSTOMER MANAGER

    This program first appeared as part of MS Office 2000. It is designed to manage a database with information about business partners (suppliers and customers), to monitor transactions and the financial condition of a small enterprise.

    In principle, these tasks can be performed using other programs included in Office, but it is still more convenient to use a specialized tool. In addition, the problem is that such information is often accumulated in different programs (some is in Outlook, some in the accounting system), and the head of a small business needs to collect all the necessary information for analysis and control.

    By the way, the Dispatcher includes a filter that allows you to transfer and process data from the most popular accounting system in our country, 1C:Enterprise.

    THERE ARE MANY FUNCTIONS BUT... NOT ENOUGH

    So, we see: there are quite a lot of office packages and each of them has enormous capabilities. But in practical work it often turns out that you are still missing some functions. Or it turns out that the proposed information processing scheme is not very suitable for you.

    It turns out that an office program can be made more convenient by implementing functions in it that were not originally there, or by combining several disparate programs into a single complex. Such capabilities are provided by the Microsoft Office Extensions program (or add-ons for Microsoft Office).

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

    Writing rules

    HR officers advise writing about computer skills even to those people who are applying for a position not related to working on a PC. When describing your level of proficiency in this technique, you can indicate a list of programs that you know how to use. You also need to write down at what level you know the computer. You can indicate this as follows:

    • confident PC user;
    • average level;
    • entry level computer skills.

    But it’s not worth describing in detail about your knowledge of certain programs. Each applicant can use this example of writing this column:

    Experienced 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 electronic correspondence (Outlook Express). I can search quickly 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 slightly different:

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

    Specifics of professions

    There are a number of specialties for which it is necessary to list knowledge of programs that help 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 column might look like this:

    Confident computer user. Knowledge of basic Microsoft Office programs, such as MS Access, Word, PowerPoint, Excel, ability to work with email (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 large a list listing all kinds of software can have the opposite effect: the employer will decide that your knowledge is very superficial.

    It would be nice if an 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 “professional skills” column may look like this:

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

    If the position requires more in-depth knowledge certain programs, then they must be specified. 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, social media API, WordPress API, CSS, HTML, JS, CSS.

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

    If mastering new programs does not cause you any difficulties, this is worth noting at the end of the section.