Excel courses (Excel). Training at a simple and accessible level! Individual Excel training with a tutor Courses xl in Baumansky
During Alliance courses, exclusively qualified employees work with clients: from administrators to teachers. All our tutors undergo strict selection before joining our team. The pride of our training center is the on-site computer courses, which have brought together in their teaching staff the truly best in Moscow, competent, experienced, certified teachers who have perfect knowledge of the Excel program and love their job.
The training is carried out according to the curriculum, in the development of which professionals took part, taking into account personal and foreign experience. Therefore, all our customers have not only a quality promise based on our reputation, but also a documentary guarantee. We are proud of the training programs that have been carefully compiled with the participation of experienced methodologists, allowing even beginners to easily move to the level of a confident user of a computer program. Our tutors successfully teach both beginners and confident users the Excel program to improve their skills and receive one-time consultations. And as a final argument in favor of our training center, a service agreement is concluded with each client.
Microsoft Excel spreadsheet processor. Purpose of the program. Program interface Customize the interface: quick access panels, ribbons, column header areas. Scale.
Entering and editing information.
Entering information.
Editing data (replacing, deleting, adding, correcting errors).
Select columns, rows, cell ranges, unrelated cells, worksheet. Delete cell contents, copy, paste.
Working with sheets (inserting, moving, copying, deleting).
Changing the table structure.
Add and remove cells, rows and columns. Resizing columns and rows. Selecting cell width based on content. Setting the same width for several columns and rows.
Merging cells.
Cell formatting:
Working with fonts, aligning cell contents, rotating text, adjusting indents.
Copy format according to sample. Format clearing.
Creating borders for a table (using the borders button, the border tab, and drawing individual borders).
Ways to create a fill for cells.
Lesson 2
Creating number sequences.
Creating lists.
Restriction on data entry.
Imposing conditions on data input.
Generating an error message when entering data.
Generating a message for data entry.
Working with data formats.
Microsoft Excel data types and formats: text, numbers, dates, time, currency format. Their setup.
Problems in using formats.
Custom format.
Create a custom format for text, dates and times.
Organizing calculations in Excel.
Entering a formula into a cell. Copying formulas using autocomplete.
Formulas with percentages. Absolute and relative links. Create a formula with an absolute reference. Creating a formula with data from different sheets, different books. Named cells. Create a formula with cell names. Editing and deleting names.
Influencing and dependent cells.
Preparing a document for printing.
Setting page parameters.
Creating Headers and Footers
Setting through rows and columns.
Pre-press preparation of the document. Using Preview.
Print the selected area. Setting the print area.
Lesson 3
Functions.
Using simple functions (sum, average, minimum, maximum, number).
Ways to work with functions. Using Help. Entering functions using the Function Wizard. Categories of functions.
Logical functions: IF, AND, OR, IF ERROR. Nested logical functions.
Mathematical and static functions: SUMIF, COUNTIF, AVERAGEIF
Text functions CONCATENATE, LEFT, uppercase, lowercase, PROP.
Array functions: GPR, VPR,TRANSP.
Solving practical problems using functions.
Copying calculation results and formulas using paste special.
Review of possible errors in formulas.
Lesson 4
Diagrams. Graphics in documents.
Creating diagrams. Chart Wizard.
Setting chart properties.
Construction of various types of diagrams.
Print the chart.
Inserting graphic elements. Inserting a picture.
SmartArt objects.
Conditional formatting.
The concept of conditional formatting.
Creating conditional formatting (comparing with a value, with the result of a formula or function.
Copy conditional formatting.
Editing and removing conditional formatting.
Autoformat.
Lesson 5
Working with databases.
The concept of a database.
Sorting.
Removing duplicates.
Subtotals.
Grouping, creating structure.
Hiding and showing data.
Freeze rows and columns when viewing.
Dividing the sheet into parts when viewing.
Data consolidation.
Applying filters. Selection of data through filtering.
Advanced filter. Creating conditions for an advanced filter.
Search and replace.
Pivot tables.
Creating pivot tables.
Changing formats for pivot tables.
Setting up pivot tables.
Editing a pivot table.
Updating pivot table data.
Lesson 6
Notes (creating, editing, deleting).
Creating hyperlinks.
Data protection.
Setting a password to open a book.
Protecting the data entry sheet.
Permission to work with individual cells and prohibition of work on other cells.
The Specialist Center is the first and only Microsoft Office Specialist Authorized Testing Center certification center in Russia, and has also been Microsoft's No. 1 gold partner in Russia, Eastern and Central Europe for many years.
Today there is hardly an office worker who is not familiar with Microsoft Excel. Many people use Excel whenever they need to create a table. But most users, unfortunately, do not even imagine the full scale and variety of Excel's capabilities. At the Excel training courses at the Specialist Center, students will learn to work professionally with tables, formulas, charts and much more.
Certified teachers
More than 40 teachers of the Center are certified Microsoft trainers (MOS, MCT). The annual participation of our training center in all the most important Microsoft events (“World Partner Conference” (USA), “Platform”, “Polygon”, etc.) allows the Center’s teachers to be the first in Russia to transfer their unique knowledge and experience to students of Microsoft Excel courses. Individual approach, constant practice in the classroom, training in live dialogue - all these are Excel courses in “Specialist”. Excel training is conducted using the latest versions of the program. Excel courses are designed for both beginners and advanced users.
International certificate
Excel courses at the Specialist Center are included in the state advanced training program, which makes you a more attractive and desirable employee for employers. In addition, after training in Excel, you will receive an international certificate of a specialist in Microsoft Office from Microsoft* and a prestigious certificate from the Specialist Center.
Flexible schedule
Choose from morning, afternoon, evening, weekend or online classes. The training schedule is set for the year ahead.
Advanced level
In advanced courses you will learn how to load data from any source, create dynamic reports and complex data models. An in-depth study of Excel will be useful for analysts and anyone who works with reports.
COURSE OBJECTIVE:
- Introduce students to the full capabilities of the program
- To teach how to effectively use a multifunctional set of MS Excel tools to perform calculations of varying complexity, analyze and visualize information
COURSE PROGRAM
Module 1: Calculations in Microsoft Excel
1.1. Using named cells in formulas:
Creation of names. Editing names. Inserting names into a formula
1.2. Working with functions:
1.2.1. Mathematical functions
1.2.1.1. Rounding related: ROUND; ROUNDUP; ROUNDBOTTOM; WHOLE
1.2.1.2. Summation and conditional summation: SUMIF; SUMIFS
1.2.2. Logical: TRUE; LIE; AND; OR; NOT; IF; IFERROR
1.2.3. Statistical: AVERAGE; AVERAGE; AVERAGEIF; AVERAGEIFS; CHECK; COUNTIF; COUNTIFS; COUNTING
1.2.4. Links and arrays: VLOOKUP; GPR
Module 2: Conditional Formatting
2.1. Apply built-in rules: histogram, color scales, icon sets
2.2. Create formatting rules using formulas
2.3. Editing rules
Module 3: Data Validation and Preparation Tools
3.1. Validation of data as you enter
3.2. Find and highlight
3.3. Special insert
Module 4. Working with large table arrays
4.1. Removing duplicates
4.2. Sorting data
4.3. Search and filter data
4.4. Subtotals
4.5. Data Consolidation
Module 5: Analyzing Data Using Pivot Tables
5.1. Creating and Converting Pivot Tables
5.2. Setting up fields
5.3. Adding calculated fields
5.4. Grouping fields
5.5. Pivot charts
5.6. Updating PivotTables and Charts
Module 6. Security
6.1. Book sharing
6.2. Protect cells, sheets, and workbooks
FINAL TESTING
Working in Microsoft Excel. Level 2. Advanced
- Certificate of advanced training;
- Certificate of completion of the course.
For admission you need:- Diploma (Higher education or specialized secondary education)
*Attention! If you have a diploma in a foreign language, in accordance with 273 Federal Law “On Education” Art. 107, a translation of the diploma into Russian is required.
- Passport
Upcoming dates for face-to-face format and online broadcasts
| Volume hours |
Certificate of completion of the course | Upcoming start dates | Basic price |
Discount price | Price for legal entities | Individual. education |
Sign up for the course |
||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| 24 | Course type:
|
Weekdays: 14.05-26.05 14
00
- 18
05
Tue-Thu Out: 28.03-18.04 10 00 - 14 05 Sat |
9 990 | 7 990 | 8 789 | 25 600 | Sign up | ||||
This course can be taken in 3 formats:
1. – training Scheduled in our .
2. – training Scheduled from any place where there is Internet.
3. – training Anytime and from any place where there is Internet.
Course scope- 24 academic hours,
of which: classroom – 20 academic hours, independent practical work – 4 academic hours
Individual lessons are provided. Check with managers for details.
By purchasing the course "
"
You
save RUB 2,500
.
By purchasing the course "
"
You
save RUB 3,200
.
By purchasing the course "
"
You
save RUB 4,100
.
Take one lesson for free!
You can:
- Get to know the teaching methods and the teacher
- Get acquainted with the Center's documents and training rules
- See the learning conditions - classrooms, equipment
- Meet our friendly team.
Excel training in Moscow is carried out on the basis of the specialized center “Runo”. As part of the course, students will receive a wide range of knowledge and skills that will allow them to effectively use the program for work. To take Excel training, you need to fill out an application on the website.
The course is designed for beginners - if you do not have basic skills, specialists will help you master all the intricacies and learn how to apply knowledge in practice. Excel courses are delivered face-to-face and are suitable for representatives of the following professions:
- Company managers;
- HR specialists;
- Office workers with various job responsibilities;
- Accountants and economists;
- Logisticians.
Learning to work in Excel allows you to master:
- The structure of Excel books and features of working with sheets;
- Rules for working with data and cells;
- Features of constructing graphs, diagrams, tables;
- Working with formulas and various data;
- Program functions related to complex pivot tables;
- Data filtering work.
Confident work with the program is the result of studying in full-time courses. Excel courses are conducted under the guidance of experienced specialists who not only provide knowledge, but also motivate students to acquire new skills and abilities in their work.
Course Features
- The training course is 20 hours;
- Stationary training takes place three times a week - on Monday, Wednesday and Friday;
- Classes are held in the evening - for 3 hours;
- Allows you to learn how to work with large volumes of data, create graphs, charts, tables, filter and sort data;
- Excel computer courses aim to familiarize yourself with all the capabilities of the program;
- For admission you need a passport and a document confirming the presence of higher or secondary specialized education.
The main advantages of the course are:
- The program was compiled thoughtfully by professional specialists;
- Teachers are practicing specialists with significant experience;
- Classes are held at a convenient time, which will allow you to combine study and work;
- The training program includes a significant amount of practical work;
- Opportunity to undergo training even without basic knowledge.
Excel training lessons are offered at an affordable price - the age of the student does not matter.
Full-time training: what are its advantages?
- Opportunity to receive consultations and direct contact with the teacher;
- New acquaintances;
- Fast feedback;
- Excel courses from scratch are not only effective, but also affordable training;
- Fixed lesson time.
Course structure: program features
The Excel course in Moscow has a well-thought-out structure that allows you to quickly and efficiently master the information. The main thing is a significant amount of practical work, which allows you to better master the theory and consolidate your skills.
Each stage ends with practical work:
- Helps consolidate knowledge;
- Allows you to develop skills for working effectively with the program;
- Makes it possible to find errors and correct them at the training stage.
Final testing is carried out after completion of the course. Based on the results, the graduate receives a certificate that confirms advanced training.
Excel courses for beginners will help you gain important knowledge and skills that will definitely be useful in your work!