Microsoft office on-site training. Office courses - full or selective training for the programs of the package
Training courses for office programs
Especially for you, we have collected training courses on the most important office programs - several blocks of useful lectures are devoted to each. So you can move from simple to complex, from zero to the heights, and at the same time set yourself the rhythm of mastering knowledge - depending on employment, free time, strength and other resources. Such education for beginners will be dosed current knowledge, and for experienced users it will become the basis for retraining, advanced training. Many of the courses included in the online office software training block are free, the cost of others is purely symbolic. All lectures are recorded by experienced specialists and instructors. After completing the training in office programs at SmotriUchis.ru, you will receive a certificate. And if you are already ready to share your knowledge with others, then you can record the training course online, publish it on the portal and receive income.Here are indicative lesson plans broken down into LESSONS (24 ac.h)
*********************************
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.
Ways to select a cell, row, column, entire table.
Insert, delete row, column. Resizing methods.
Cleaning up content and formats.
Autocomplete, lists are standard.
Formulas: ways to create.
Occupation 2. Calculations
Autosummation
Functions. Function Wizard.
Errors in formulas. Methods for reconciling tables for the correctness of calculations.
Occupation 3. Diagrams. Sheets.
Building a diagram. Chart types.
Editing, formatting chart fragments
Chart printing. Copying to other programs
Sheets. Rename. Copy/Move. Create/Delete
Ways to select sheets. Simultaneous work with sheets.
Use in formulas of references to cells of other sheets, books
Lesson 4. Sorting and filtering data. Pivot tables.
Sorting. sort levels. Sort by cell format.
Filtering (selection) of data. Advanced filter
Creation of pivot tables. Setting the fields of the pivot table. Update
Subtotals
Conditional formatting. Data import
Lesson 5: Using Built-in Excel Functions
Application of various types of built-in functions.
Math functions. Statistical functions
Text functions. Date and time functions
Lesson 6. Printing. Protection
Page Options. Numbering. Headers and footers
Preview and print a document
Print through lines, columns.
Lists are custom. Freezing regions in a large table
Copies the format of sheet elements. Hyperlinks. Graphic objects
Special insert. Adding notes to cells.
The concept of macros. Protect Cells, Sheets, and Excel Workbooks
Microsoft Word 2007/2010/2013
Basic and advanced opportunities (course 24 academic hours)
Lesson 1. Entering, editing text. Working with multiple documents
Typing rules. Ways to select text
Ways to move and copy text
Spell check and error correction
Document modes. 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.
Copy formats. Clear formatting
Printing a Document
Lesson 3. Working with tables
Selection methods in the table. Resizing a table
Insert, delete rows, columns
Border and shading of table cells. Split, merge cells
Sorting in the table and without the table. Duplicate table header.
Convert table to text, text to table.
Table formatting styles
Lesson 4. Lists. Font, paragraph, page (continued)
Lists: bulleted, numbered, layered
Border and shading: for text, paragraph
Inserting special characters
Page background settings: borders, color, background
Changing the orientation for individual pages in a document
Dividing the document into pages, into sections. Title page
Occupation 5. Large document. Automatic table of contents. Fixes
Create an automatic table of contents. Update
Fields. Field codes. Field update
Recording corrections. Accepting and Rejecting Changes
Comparing documents and merging revisions
Fast work with the document by means of "hot keys".
Lesson 6. Inserting graphic objects
Ways to insert images from different sources
Object wrap modes
Inserting WordArt, SmartArt, Charts
Inserting mathematical formulas with the formula editor
Using styles and effects
*******************************************************************************
Microsoft power point 2007/2010/2013/2016
Basic and advanced opportunities (course 12 academic hours)
Lesson 1. Principles of creating a presentation.
Sequence of preparation of the presentation. Presentation Modes
Working with slides: creating a new slide, deleting, moving, copying, hiding. Slide content: text, pictures.
Marker, numbered lists. Template slide design.
Change, restore slide layouts
Insert WordArt, SmartArt, tables, diagrams, diagrams.
Drawing with AutoShapes
Presentation display. Animation of text and slide objects.
Setting animation effects.
Setting transitions and slide timings
Lesson 2. Big presentation. Processing of graphic objects. printout
Photo processing: correction, color, cropping
AutoShapes: format, alignment, grouping
Insert audio and video files into a presentation
Slide numbering. Adding headers and footers
Samples: Slide Master, Handout Master, Notes Master
Custom Slide Layout
Presentation printout: types of printing.
Training handouts. Notes, structure
Presentation view modes
Lesson 3. Presentation demonstration.
Work during a presentation slide show.
Creating a slide film: options.
Recording a sound file and inserting it on a slide.
Animation options for text and slide objects.
Saving a presentation in various formats
*******************************************************************************
Computer courses Word, Excel, Power Point at the basic and advanced levels of 36 acad. 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 the 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 features of Excel, Power Point, Word 1400 rubles.
Author's teaching methodology. Real hands-on training for beginners and advanced 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 construction of the course - the choice of classes by topic.
Call and get started today!
Choose a day, time, sign up and come! You will see the advantages of our courses, get acquainted with the effectiveness of a unique teaching method, see high-tech computer classes. We will show you how to ensure that you acquire strong computer skills. You can sign up for a training schedule that is convenient for you.
One of priority areas Our training center is the organization and conduct of comprehensive training for employees of organizations. Thanks to highly qualified teaching staff and many years of experience in conducting such training, we offer a truly high-quality training. information technology. To ensure a guaranteed level of qualification of your organization's employees, our Training Center holds corporate trainings on all Microsoft Office products in Moscow, St. Petersburg, as well as on-site training in the regions of Russia and the CIS countries.
Training is provided for all versions Microsoft programs office. The training is possible both in Russian and in English.
Levels of study
We provide training to students with different levels of training. You can choose a level based on your knowledge − a basic level of , advanced level, Master Class.
- Basic course will allow you to master not only the most simple features of the program. It can be useful for every employee to close knowledge gaps, empower and improve skills in the use of program resources.
If you already have a fairly good command of the program's capabilities, you can reduce the duration of training. - Advanced Course is designed to improve the knowledge gained in the basic course and contains topics that, unfortunately, not everyone uses in everyday practice, but the use of these features will significantly increase the efficiency of work, reduce the time to complete it.
- Non-standard course. It is often difficult to understand which course to choose - basic or advanced. We can provide training that will “level up” the knowledge of employees, even if the level of knowledge of the trainees is not the same. Also prepare special program training, taking into account all the features of each individual group and the goals of the company.
- Special Education Programs. If you did not find a suitable course on our website, please contact us by phone and we will try to arrange exactly the course you want. Nothing is impossible for us!
The difference between corporate trainings and standard computer courses is that trainings are always compiled and adapted to the specifics of a particular company - for some products of the MS Office package, as a rule, the basic working methods are understood, while for others, more relevant to the company, the emphasis is on advanced features programs. In addition, all trainings are aimed at the practical application of the program's capabilities in professional activities.
Individual training is the best way to improve the skills of executives and top managers of companies. You get knowledge in the most comfortable environment for you, at a convenient time. You can shorten your learning time and make it more intense if you choose private lessons with a teacher. Individual sessions, unlike classes in a group, are aimed at solving your problems. You can study according to the standard program, or you can order a fragment of the course that interests you at the moment. At the same time, you pay only for the real time of classes, and not for the entire course. The teacher can conduct training in your office or at your home. You can also order an individual consultation on a predetermined topic.
One of the priorities of our training center is the quality of education, so all teachers have only highest level qualifications. All our teachers are professional practitioners with vast experience in corporate training, these are Microsoft certified instructors, PhDs, teachers with extensive teaching experience for students with different levels of training - from beginner computer users to professionals. They will be able to clearly and easily explain not the most simple themes, as well as open the secrets of programs for listeners.
The site presents standard programs for Microsoft Office courses. Especially for your company, we can prepare any program, taking into account all your wishes. Training programs may also vary in duration and content for different groups of trainees.
Get more detailed information, as well as answers to all your questions,
You can call 8 495 796-40-21.
You can take training in any place convenient for you - in your office or classroom | We can also invite you to be trained in our training classes | ||
When conducting classes at the customer's premises, we can conduct classes at any time convenient for you. | The cost of education includes copyright study guides, coffee break. Optional lunch can be ordered | ||
We run classes on weekdays and weekends. | Upon completion of training, students receive a certificate from the Training Center “Success-M” |
- In the first lessons, you will get acquainted with the structure of a personal computer, its components, PC software, operating system of the Microsoft Windows family.
- Further, the curriculum of the PC course includes training in creating, saving, renaming, deleting files and folders, working in the Microsoft Word text editor and the Microsoft Excel spreadsheet editor.
- Knowledge of the MS Word application will allow you to create, edit and save text documents, add tables and pictures to them, work with text and print text documents.
- With the help of MS Excel, you can build and edit charts, tables of varying complexity, prepare and print this information.
- We will devote a sufficient number of training hours to work on the global Internet. Learning the Internet from scratch is an acquaintance with the World Wide Web and its capabilities. You will learn how to create your own mailbox, send and receive emails, and search for the information you need.
Why is learning to work with a computer in the "IT-course" convenient and beneficial for you?
- The PC courses offered for beginners are built on a close fusion of theory and practice. At each lesson, the theoretical part is first studied, and then practical exercises are performed to consolidate computer skills. A set of carefully designed homework assignments helps to reliably assimilate the material covered.
- Classes are held in equipped classrooms using modern computer technology.
- You can always choose the time of study that is convenient for you. We regularly recruit students for PC courses for beginners in morning, afternoon and evening groups, weekend and intensive training groups.
- Having mastered curriculum course, you can continue studying computer technology by choosing the direction you are interested in (for continuing education, a 10% discount is provided). Our Education Centre offers you computer courses for confident PC users, courses in computer design, graphics, layout and animation, courses in web technologies and it technologies.
- Graduates of courses for beginners to work with a personal computer are issued a document on completion of training: a certificate of the established form with the qualification of a PC operator. If you wish, you can use the help of our training center in further employment in the following specialties: PC operator, office manager, secretary.
MS office- how many new, useful, informative and interesting things this phrase hides in itself. For many novice users, these words are even associated with the capabilities of the computer itself. And this opinion is not without foundation, because Office is a suite of application programs developed by Microsoft for most tasks. That is, the most common types of work related to a PC are solved using the programs of this package.
Learn MS Office - and you are welcome in any organization!
That is why our MS Office field courses pay special attention to this area of study and offer you individual training in any computer programs with a personal teacher.
What unites the programs of the MS Office package?
- they all have a universal user interface;
- many identical tools;
- and, of course, the results obtained in the course of work in one program can be easily integrated into another.
Precisely for these reasons, our courses offer training in MS Office package programs as a set.
Learning MS Office with our teachers 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 at all that we impose training on all programs at once, including those that you do not need, as many do.
We have a radically different approach! We offer individual training according to personal curriculum, so what programs are needed - only you decide!
If you need knowledge of office programs, but you are new to the world of computers, we will be happy to help you by compiling comprehensive program personal training, including a course "Computer for beginners", which subsequently turns into the study of 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 favorably distinguishes this offer.
MS Office courses in Moscow are always of high quality, convenient and efficient, if the training center "PC Lesson" takes up the work! We train and advise in any district of Moscow on all programs of the package.