Table processor Microsoft Excel. 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 various types 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.
If you are thinking about learning MS Excel, then one of the main questions is “Which form of study should I choose?” There are many options, but we are confident that the most effective is live communication with a professional in an individual format.
We offer individual training at your home in Moscow
In this case, you will not adapt to the process, but the training will be adjusted to you.
The teacher will come to your home, find out your needs and adapt to your current level of training. Moving through the program at your pace, you will not linger on the material you already understand and will not leave gaps in topics that require understanding.
What if not at home?
We can come to any address convenient for you.
For some it is convenient to meet at the workplace, for others we meet in a public area.
A common practice is to conduct classes in a cafe. You decide which one is closer and more convenient for you, and a 3-hour meeting can easily be held, for example, over a cup of coffee.
Our advantages
All time is given only to you
In group courses, participants are forced to adjust to the overall pace. This is not always comfortable and effective. In our courses, the entire process is focused on you, which undoubtedly has a positive effect on the perception of the material and the quality of assignments.
Ability to study on your own computer
You are at home, and if you are more comfortable studying on your own computer, this will not affect the learning process in any way
Visual work materials
You will have working materials and reminders that you can refer to at first, until you gain sufficient experience and bring your skills to automaticity
Versions of the program in two languages
If you plan to work in an international company, studying the English version of the program may be very relevant. In this case, in addition to the interface elements, the differences also lie in the recording of the English-language analogues of the functions. We know this, we can do it and we will teach you
Courses are preparation for work
We have personal experience work in large trading companies, due to this, the course was prepared and based on examples of actual work tasks. At the end of the course, you will have an idea in which areas of problems certain techniques are applicable. We don’t just share knowledge with you, we prepare you for work
What materials will you receive?
COURSE CURRICULUM
"Working in MS Excel spreadsheets"
The Excel training course is designed for students seeking to master the techniques and techniques of working with modern databases and performing complex calculations in spreadsheets. Course includes general information(purpose, capabilities), terminology, information about the functions of control elements, objects and menu commands. In addition, it includes procedures to solve the most common problems. Students perform a number of practical tasks under the guidance of highly qualified teachers with extensive practical experience, and with their help, their advice, recommendations and a set of useful techniques reinforce the acquired material. In the future, this allows you to independently create and administer Excel spreadsheets.
Teaching methods are based on the active involvement of students in the educational process using high-quality teaching materials. Classes are held in a relaxed atmosphere at a time convenient for you.
Upon completion of training, graduates receive a standard certificate and can be employed in the specialty “Electronic operator” Excel tables", "Excel Spreadsheet Administrator".
1. Basic elements of the Excel program interface
1.1. Main menu, toolbars, work area
1.2. Cell name panel, formula bar, scroll bars
1.3. System status bar
1.4. Data entry and editing
1.5. Inserting and deleting cells, rows, and columns
2. Visual design of the project
2.1. Formatting cell contents, font settings.
2.2. Various styles of drawing and design of tables
2.3. Ways to align text in cells
2.4. Built-in Excel data formats
2.5. Tools for creating and designing projects
3. Forms for entering data into Excel tables.
3.1. Creating a Database in Excel
3.2. Managing the Data Form Window
3.3. Changing an entry
3.4. Entering a new entry
3.5. Deleting entries
3.6. Search records
3.7. Sorting a list
4. Formulas and functions.
4.1. The concept of formulas and functions in Excel.
4.2. Standard Excel functions.
4.3. Moving and copying formulas in cells.
4.4. Fixed and floating cell names in spreadsheet formulas.
4.5. Function Wizard.
4.6. User-defined names.
4.7. A practical example of creating a complete project for calculating shareholder income.
5. Charts and graphs.
5.1. Chart Wizard.
5.2. Designing a diagram. Automatic chart format.
5.3. Editing a diagram.
5.5. Creation, editing, grouping and linking of graphic objects to Excel sheets.
6. Pivot tables.
6.1. Pivot Table Wizard.
6.2. Data consolidation.
6.3. Methods for changing the structure of a spreadsheet sheet
Pass. Interview.
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 take place in person and are suitable for representatives of the following professions:
- Company managers;
- HR specialists;
- Office workers with different 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 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 efficient work 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!
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 program Excel. Many people use Excel whenever they need to create a table. But most users, unfortunately, do not even imagine the full scale and diversity Excel 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 the unique knowledge and experience they have acquired to students Microsoft courses Excel. Individual approach, constant practice in the classroom, training in live dialogue - all these are Excel courses in “Specialist”. Excel training is conducted using latest versions programs. 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 as a specialist in Microsoft Office from Microsoft* and the prestigious certificate of 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. In-Depth Study Excel is useful for analysts and anyone who works with reports.
