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.
Microsoft Excel is one of the world's most famous spreadsheet programs. This course is suitable for beginner to intermediate levels. Through 10 flexible lessons, you'll learn how to design a table to better present information, how to handle simple and complex formulas, how to insert charts, how to use functions like IFERROR, and much more.
Our Excel Expert course will provide you with the knowledge and skills to use this spreadsheet program at an advanced level. You can choose to study the 2013 or 2010 version, and you'll also learn how to perform conditional formatting, write and use macros, work with pivot tables, and use statistical functions.
In the process of studying this 3-module course on Microsoft Office 2010, you will master the new interface and capabilities of Word, Excel and PowerPoint 2010; Working with the latest version of Microsoft Office, you will take your existing skills to the next level and update your knowledge.
As the title suggests, this is a short course for those who already have experience using Microsoft Word, Excel and PowerPoint in versions 2010 and 2013, and want to improve their knowledge of the software to version 2016. You will learn how to navigate the updated interface of each program and be able to navigate the new features of the latest release of this globally acclaimed application suite.
During this seminar you will learn how to work in Microsoft Project, how to create, implement, manage and complete projects of any size. You will receive simple tips and tasks that will help you optimize your time spent on the project. The seminar takes the form of a one-day course under the guidance of a teacher.
This one-day instructor-led workshop will teach you how to use Microsoft PowerPoint and create impressive and interesting presentations. After completing a series of practical tasks, you will gain skills in working in the Microsoft program, which you can immediately apply in your work.
The Level 2 Workshop builds on the knowledge presented in the Level 1 Workshop and aims to take your presentation skills to a higher level. By completing tasks such as working with multimedia files, working with presentations, and so on, you will feel confident that you can create a truly impressive presentation.
This one-day workshop will help you learn how to create and modify databases using Microsoft Access. You'll learn how to work with data, mine it, and report on the data. This is a hands-on activity suitable for beginners in Access. This way you will gain real skills.
This Level 2 workshop builds on the program skills already acquired and is designed to take them to the next level. The lesson is conducted under the guidance of a teacher. Thanks to its practical orientation, you will gain real work skills.
A one-day workshop led by qualified teachers to learn Microsoft Outlook. This seminar has a practical orientation. You will be given a series of exercises on how to best use a general program - organizing mail, managing contacts, managing your calendar, tasks and records.
The Level 1 Microsoft Excel Workshop is a hands-on, instructor-led training session. It is suitable for entry level and will teach you how to create, manage and work with spreadsheets. The seminar is held in various training centers in the UK. You can find out detailed information about upcoming classes at your nearest center.
The Excel Level 2 Workshop is suitable for those who already have experience with this popular spreadsheet editor. During the one-day workshop, you will master topics such as advanced formulas, creating and editing tables, presenting data using charts, working with graphical objects, etc.
Excel Level 3 workshop is conducted over 1 day under the guidance of a teacher. The seminar has a practical orientation. You'll learn how to use the advanced features of Microsoft Excel to streamline your workflows, ensure security and collaboration in your workbook, and validate your worksheets.
This one-day, instructor-led workshop will help you quickly master Microsoft Word, the world-famous word processing program. According to your requirements, we can provide training with versions 2013 and 2010. This workshop is suitable for beginners. You'll start from scratch and learn how to create, navigate, and save documents. Then you'll master document formatting, working with lists and tables, and much more!
One-day intermediate level workshop on Microsoft Word Level. Level 2 is guided by a teacher and builds on your existing knowledge of the popular Word Processing program. You'll gain in-depth knowledge of features such as styling and themes, working with tables and charts, merging, and macros.
This is an advanced Microsoft Word workshop that will help you master the program at an expert level. You'll learn topics such as working with footnotes, references, notes, indexes and tables of contents, setting up document security, and working with forms; We are confident that this one-day instructor-led seminar will give you new knowledge and skills in working with the Microsoft Office program.
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 is necessary for almost everyone, 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:
Knowledge of office programs today is a mandatory requirement for the vast majority of vacancies related to office work. Secretary, manager, clerk - these are just the most common examples of such professions, but in reality there are many more of them. But we all have gaps in certain competencies. So if you are not sure that you know Microsoft Excel, PowerPoint, Word, Access, Draw LibreOffice perfectly, then take advantage of the unique opportunity provided by the educational portal SmotriUchis.ru - take training in office programs online.
Loading...
