Microsoft office training. Office programs
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 highlight 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.
By learning these basic computer applications, you can expand the scope of your activities. Even if you have already been able to master the basic functions by trial and error Microsoft programs Office, we can assure you that more detailed training will allow you to work much more productively. Standard work can be done much faster and easier if you know how.
We know how to make learning effective and convenient
Microsoft Office courses from Alliance will provide the basis on which you can build your studies, career and other areas of activity. Our training center has the best specialists who have vast experience in teaching at leading universities in Moscow, high qualifications and the required level of knowledge in a particular area. Permanent updates of MS Office versions are taken into account when updating curriculum. Therefore, our customers receive only up-to-date knowledge. An important aspect of our courses, such as Word or Excel, are workshops occupying a significant part of the study time. Thanks to the practice bias, after the completion of the training, the client will be able to independently work with Office computer programs without outside help.
With us you will receive up-to-date knowledge, skills in working with MS Office programs on the best terms. Efficiency and comfort - this is about us!
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 offsite MS Office courses pay special attention to this area of study and offer at your service individual training in any computer programs with a personal tutor.
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 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 work is taken Training Center"PC Lesson"! We train and advise in any district of Moscow on all programs of the package.