Training courses for office programs
Especially for you, we have collected training courses on the most important office programs - each is devoted to several blocks of useful lectures. This way you can move from simple to complex, from zero to the top, and at the same time independently set the rhythm of learning for yourself - depending on your availability, free time, energy and other resources. Such education for beginners will provide up-to-date knowledge in doses, and for experienced users it will become the basis for retraining and advanced training. Many courses included in the online office software training block are free, while the cost of others is purely symbolic. All lectures are recorded by experienced specialists and instructors. After completing training in office programs at SmotriUchis.ru, you receive a certificate. And if you are already ready to share your knowledge with others, then you can record an online training course yourself, publish it on the portal and receive income.Proficiency in a set of office applications, especially word and excel, today is a necessary, and in some cases, mandatory skill in many professions and areas of life. Our Word and Excel training program for beginners is intended primarily for those who need to master these programs comprehensively and thoroughly, with a detailed description of all the necessary tools and settings. Word and Excel courses are the minimum, after mastering which you will be able to work independently in almost any industry, performing basic office tasks on document circulation and various types of reporting. Many people believe that learning Word and Excel for dummies is something insufficient to quickly advance in education and in the profession, but under this somewhat humorous name lies a well-developed program for learning 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 direction you are mastering at each stage.
Microsoft Excel Features and Capabilities
MS Excel is a universal and multifunctional spreadsheet editor whose functions are not limited to creating and editing spreadsheets. Using 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 specialists working in the following fields:
- Financial and economic analytics;
- Accounting;
- Marketing and sociological research;
- Scientific activity;
- Banking sector and work with loans;
- IT sphere, SEO optimization and promotion;
- Working with databases in various fields.
In the above areas, you will need advanced Excel skills, but for managers and other office workers, in most cases, basic skills in using a spreadsheet editor are sufficient. Firstly, this will be a big advantage when finding a job, and secondly, it will really help you cope with your work easier and faster.
Demand for Word and Excel specialists
Despite the fact that you can now learn to work in Excel from scratch in almost any computer technology training center, there are not enough specialists who know these programs at the proper level. Most people who come to MS Office Excel courses and think that they can more or less work in these programs, in fact do not reach the very beginning level. But having a 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 Word and Excel specialists is one side of the coin, the other side is their professionalism and skill. Therefore, Excel for Dummies training is necessary for everyone, at least in order to understand what level of proficiency in Word and Excel programs we are at, and whether we are doing the right thing by learning Excel from scratch or whether we need ms excel training at a higher level. And even if you have an initial level of proficiency in Excel and Word, but studied on your own, then in the courses you will be able to systematize your knowledge and find a lot of new things in seemingly clear things. Well, if you undergo training in more complex levels of proficiency in 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.
You will need knowledge of the following MS Excel tools:
- Data storage - creating tables, databases, lists, sheets and books;
- Data processing methods - searching, filtering, formatting and grouping by parameters;
- Methods of calculations, analysis and forecasting based on available data;
- Visualization of data in graphs and charts;
- Logical, text, mathematical and statistical functions;
- Formulas for fast computational operations with large data sets;
- Macros, pivot tables and other tools.
Where to start learning, with Word or Excel
Traditionally, learning begins with Word; the program allows you to fundamentally master the keyboard and basic skills in working with text and information of various types. After mastering the Word program, the Excel program becomes easier to master, if only because you have confident typing skills on the keyboard. Working in Excel, training for dummies, implies computer proficiency not only at a 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 mastery of this tool, even at an elementary level, will open up a lot of possibilities. Therefore, in addition to Word, it is highly recommended to take Excel for Dummies training. This combination - word and excel, is very popular as a popular skill for any specialist.
How to quickly master Word and Excel
For experienced computer users, using the main components of the software package at a superficial level is not difficult. Opening a file, reading or typing text, saving a document - these are actions that absolutely every person who works with a computer faces. Once you master 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 completely 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 the Word text editor, is a serious obstacle to further mastering all the capabilities of a personal computer. Therefore, learning Office for beginners should be carried out on a systematic basis with a detailed mastery of basic functions, menus and toolbars.
Mastering MS Office for professional use is even more difficult - most ordinary users do not know about 95% of the capabilities of the Word text editor and Excel spreadsheet editor, unless their work requires it.
Self-study requires a lot of time, self-discipline and the ability to concentrate, so the optimal solution would be to take specialized courses dedicated to learning Word and Excel from scratch. They will help you with this Computer literacy courses (Windows, Word, Excel) And Excel courses (Excel) - basic level, which take place at the State Center for Postgraduate Education. If you want to become a professional in using a spreadsheet editor, here is your service:
MS Office- how many new, useful, educational and interesting things this phrase hides in itself. Many novice users even associate these words with the capabilities of the computer itself. And this opinion is not without foundation, because Office is a package of application programs developed by Microsoft to solve most problems. That is, the most common types of work related to PCs are solved using the programs of this package.
Learn MS Office - and you will be welcome in any organization!
That is why our on-site MS Office courses pay particular attention to this area of training and offer individual training in any computer programs with a personal teacher at your service.
What do the MS Office programs have in common?
- they all have a universal user interface;
- many identical instruments;
- and, of course, the results obtained while working in one program can be easily integrated into another.
It is based on these considerations that our courses offer training in MS Office programs included.
With our teachers, learning MS Office is a pleasure!
During the lessons, our teacher will help you learn all the intricacies of working with office programs. However, this does not mean that we impose training on all programs at once, including those you do not need, as many do.
We have a radically different approach! We offer individual training according to a personal curriculum, so only you decide which programs you need!
If you need knowledge of office programs, but are new to the world of computers, we will be happy to help you by putting together a comprehensive personal training program that includes a course "Computer for Beginners", which subsequently turns into studying the programs you have chosen from the Microsoft Office package. At the same time, the same teacher will work with you, which is very convenient and advantageous to this offer.
MS Office courses in Moscow are always high-quality, convenient and efficient if the PC Lesson training center gets to work! We train and advise in any district of Moscow on all programs of the package.
Here are indicative lesson plans broken down into CLASSES (24 academic hours)
*********************************
Microsoft Excel 2007/2010/2013/2016
Basic and advanced features(course 24 academic hours)
Lesson 1. Data entry, formatting, editing. Formulas
Data input. Editing methods.
Cell formatting: borders, fill, alignment, number.
Methods for selecting a cell, row, column, or entire table.
Inserting, deleting a row or column. Ways to resize.
Cleaning contents and formats.
Autocomplete, standard lists.
Formulas: methods of creation.
Class 2. Computations
Autosummation
Functions. Function Wizard.
Errors in formulas. Methods for checking tables for the correctness of calculations.
Class 3. Diagrams. Sheets.
Constructing a diagram. Types of charts.
Editing and formatting diagram fragments
Print the chart. Copying to other programs
Sheets. Renaming. Copy/Move. Create/Delete
Methods for selecting sheets. Simultaneous work with sheets.
Using references to cells of other sheets and workbooks in formulas
Lesson 4. Sorting and filtering data. Pivot tables.
Sorting. Sorting levels. Sorting by cell format.
Filtering (sampling) of data. Advanced filter
Creating pivot tables. Setting up pivot table fields. Update
Subtotals
Conditional formatting. Import data
Lesson 5: Using Excel Built-in Functions
Using different types of built-in functions.
Mathematical functions. Statistical functions
Text functions. Date and time functions
Lesson 6. Printing. Protection
Page options. Numbering. Headers and footers
Preview and print your document
Printing continuous lines and columns.
Lists are custom. Freezing areas in a large table
Copying the format of sheet elements. Hyperlinks. Graphic objects
Special insert. Add notes to cells.
The concept of macros. Protect Excel cells, sheets, and workbooks
Microsoft Word 2007/2010/2013
Basic and advanced capabilities (course 24 academic hours)
Lesson 1. Entering and editing text. Working with multiple documents
Typing rules. Ways to highlight text
Ways to move and copy text
Spell checking and error correction
Modes of working with a document. Window.
Simultaneous work with several documents.
Lesson 2. Document formatting: font, paragraph, page. Seal
Formatting Standards
Font formatting. Paragraph formatting
Page settings. Pagination. Headers and footers.
Copying formats. Clear formatting
Printing a document
Lesson 3. Working with tables
Methods for highlighting in a table. Resizing a table
Inserting, deleting rows, columns
Border and fill of table cells. Split, merge cells
Sorting in a table and without a table. Duplicating the table header.
Convert table to text, text to table.
Table formatting styles
Lesson 4. Lists. Font, paragraph, page (continued)
Lists: bulleted, numbered, multi-level
Border and fill: for text, paragraph
Inserting special characters
Setting the page background: borders, color, background
Changing the orientation of individual document pages
Dividing the document into pages and sections. Front page
Class 5. Large document. Automatic table of contents. Corrections
Create an automatic table of contents. Update
Fields. Field codes. Update fields
Recording corrections. Accepting and rejecting corrections
Compare documents and merge corrections
Quickly work with a document using hot keys.
Lesson 6. Inserting graphic objects
Ways to insert images from different sources
Object flow modes
Inserting WordArt, SmartArt, Diagrams
Inserting mathematical formulas using the formula editor
Using styling styles and effects
*******************************************************************************
Microsoft Power Point 2007/2010/2013/2016
Basic and advanced capabilities (course 12 academic hours)
Lesson 1. Principles of creating a presentation.
Sequence of presentation preparation. Presentation modes
Working with slides: creating a new slide, deleting, moving, copying, hiding. Slide content: text, pictures.
Bullet points, numbered lists. Slide design using templates.
Changing, restoring slide layouts
Inserting WordArt, SmartArt objects, tables, diagrams, charts.
Drawing with AutoShapes
Show presentation. Animate text and slide objects.
Setting up animation effects.
Setting transitions and slide timing
Lesson 2. Big presentation. Processing of graphic objects. Printout
Photo processing: correction, color, cropping
Autoshapes: format, alignment, grouping
Inserting audio and video files into a presentation
Slide numbering. Adding headers and footers
Samples: sample slides, sample handouts, sample notes
Custom slide layout
Printing the presentation: types of printing.
Preparation of handouts. Notes, structure
Presentation viewing modes
Lesson 3. Presentation demonstration.
Work while showing presentation slides.
Creating a slide movie: options.
Record an audio file and insert it onto a slide.
Options for animation of text and slide objects.
Save your presentation in various formats
*******************************************************************************
Computer courses Word, Excel, Power Point at basic and advanced levels, 36 academic. hours. You only pay for the classes you complete!
Professional training in MS Office programs:
These are Word, Excel, Power Point 2010/2013/2016 programs at basic and advanced levels.
For each program listed there is a course of 9 lessons.
There is also a course in which 9 lessons cover all of the listed programs:
Excel – 4 lessons, Word – 4 lessons, Power Point -1 or 2 lessons.
The cost of any of the listed courses of 9 lessons is 8550 rubles.
One practical training session in a group (from 2 to 5 people) on the advanced capabilities of Excel, Power Point, Word RUB 1,400.
Author's teaching methodology. Real practical training for beginners and experienced users with lots of examples and exercises.
Features of training: small groups of 2-5 students, flexible training schedule.
You are guaranteed to attend all classes, the maximum effect of the course is solid skills and abilities. Modular course design - selection of classes by topic.
Call and start practicing today!
Choose a day, time, sign up and come! You will see the benefits of our courses, get acquainted with the effectiveness of the unique teaching methodology, and see high-tech equipped computer classes. We'll show you how to ensure you acquire strong computer skills. You can sign up for a training schedule convenient for you.
With this article I plan to open a series of lessons on the Microsoft Word text editor. Previously, I often had to do tutoring, that is, learning how to use a computer and application programs. People have different levels of training, so there were often cases when it was necessary to teach a person from scratch, including various programs from the Microsoft Office package, which also includes Word.
And I think that I did it quite successfully, judging by the reviews. At least, my clients continued to quite successfully keep in touch with me and consulted me on various issues. When teaching any program, I tried first of all to imagine myself in the user’s place and explain it taking into account all those nuances that may be incomprehensible. In the case of the Word program, you must also take into account and know what keys are on the keyboard for and what they are for. Therefore, I will also take this point into account, and this lesson will even cover such an aspect as training in working with the keyboard. There is no way without this, since these are the very basics that you need to know.
And I think it’s normal when a person doesn’t understand something. The reasons may be different. Some didn’t have computer science at school, others did, but they didn’t explain exactly what was needed. So, for example, I studied computer science at school, but we mostly did what we drew in the Paint program. That is, not even in Photoshop, which could really be useful in life. However, this topic can be discussed for a very long time.
All examples will be considered using the Microsoft Office 2010 package as an example. But everything said is also true for Office 2007 and newer packages. Since version 2007, which differed from previous versions by a redesigned interface, subsequently from the release of software products of this family, the interface remained essentially the same.
Beginning of work.
Actually, after launching Microsoft Word, you can already start typing text. What might be incomprehensible to a novice and inexperienced user who is new to computers? Here are some nuances:
To make a letter capitalize, you need to hold down the Shift key and press the letter you want to make capital.
To switch the language from Russian to English and vice versa, the key combination Alt + Shift is usually used. What does this designation mean? While holding down one of these 2 keys, press the other.
If you want to end a paragraph, use the Enter key to do this. When typing text, you don’t need to press anything specifically to move a line. Because the transition is carried out independently.
If you need to make a red line in the text (paragraph indent), then use the Tab key for this.
At the very top of the main program window is the main menu. There are tabs File, Home, Insert, Page Layout, Links, Mailings, Review, View, Settings. Depending on the version of the package you are using, your tabs may be arranged differently. But the essence does not change in any case.
We are now on the Home tab.
If we want to change the font typeface and font size, then we indicate the corresponding values (in the figure they are highlighted with a red frame). After this, if you suddenly want to cancel the selected style, you just need to press the Ctrl + Space key combination.
If, when choosing a font, you get a crappy text while typing, keep in mind that this only means that the font you have chosen does not contain Russian letters.
To make the typed text bold, you need to select the Zh, K button on the toolbar - the text will be printed in italics, H - underlined.
You started typing text, but then decided to return to the normal style, press Ctrl + Space. I recommend that you remember this combination in the future. Saves time, reduces unnecessary movements and generally makes life easier.
What else might be useful in the future? Well, these are first ways to select text. And it is selected either by moving the mouse over the selection area with the left mouse button pressed. Or using the Shift key and arrow keys. Well, or another very universal way. Hold down the Shift key and click the area where the selection begins, and then do the same by left-clicking where the selection area should end.