Excel courses. Excel courses (excel). Learning at a simple and affordable level! ms excel courses
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 site.
The course is designed for beginners - if you do not have basic skills, experts will help you master all the subtleties and learn how to apply knowledge in practice. Excel courses are held in person and are suitable for representatives of the following professions:
- Company managers;
- HR specialists;
- Office workers with various job responsibilities;
- Accountants and economists;
- Logistics.
Learning to work in Excel allows you to master:
- The structure of Excel books and the features of working with sheets;
- Rules for working with data and cells;
- Features of constructing graphs, charts, tables;
- Working with formulas and various data;
- Program functions associated with complex pivot tables;
- Data filtering work.
Confident work with the program is the result of training in full-time courses. Excel courses are led by experienced professionals 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 amounts of data, create graphs, charts, tables, filter and sort data;
- Excel computer courses aim to get acquainted with all the features of the program;
- For admission, you need a passport and a document confirming the presence of higher or secondary specialized education.
The main benefits of the course are:
- The program is thought out by professional specialists;
- Teachers are practitioners with considerable experience;
- Classes are held at a convenient time, which will allow you to combine study and work;
- The training program provides for a significant amount of practical work;
- The opportunity to get trained even without basic knowledge.
Excel lessons are offered at an affordable cost - the age of the listener does not matter.
Face-to-face education: what are its advantages?
- Opportunity to receive consultations and directly contact the teacher;
- New acquaintances;
- Quick feedback;
- Excel courses from scratch are not only effective, but also affordable training;
- Fixed class time.
Course structure: program features
The Excel course in Moscow has a well-thought-out structure that allows you to quickly and effectively 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:
- Contributes to the consolidation of knowledge;
- Allows you to form a skill for effective work with the program;
- It makes it possible to find errors and correct them at the training stage.
Final testing is carried out after the completion of the course. Based on the results, the graduate receives a certificate that confirms the advanced training.
Excel courses for beginners will help you gain important knowledge and skills that will definitely come in handy in your work!
Only qualified employees work with clients at the Alliance courses: from administrators to teachers. All of our tutors go through a rigorous selection process before joining our team. The pride of our training center is on-site computer courses, which brought together in their teaching staff really the best in Moscow, competent, experienced, certified teachers who perfectly know the Excel program and love their job.
Training takes place 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 the promise of quality based on our reputation, but also a documented guarantee. We are proud of well-designed training programs with the participation of experienced facilitators, allowing even beginners to easily move to the level of a confident user. computer program. Both "dummies" and confident users are successfully trained by our tutors in the Excel program to improve their skills and receive one-time consultations. And as a final argument in favor of our training center - a contract for the provision of services is concluded with each client.
Spreadsheet Microsoft Excel. Purpose of the program. Program interface Interface customization: quick access panels, ribbons, column header areas. Scale.
Entering and editing information.
Entering information.
Data editing (replacement, deletion, addition, correction of errors).
Select columns, rows, cell ranges, unrelated cells, sheet. Deleting cell content, copying, pasting.
Working with sheets (insert, move, copy, delete).
Changing the table structure.
Adding and removing cells, rows and columns. Resizing columns, rows. Selection of cell width by content. Setting the same width for multiple columns, rows.
Merging cells.
Cell Formatting:
Working with fonts, aligning cell content, rotating text, adjusting indents.
Copy format according to the sample. Format cleaning.
Creating borders for the table (using the border button, the border tab, and drawing individual borders).
Ways to create a fill for cells.
Lesson 2
Creation of number sequences.
Creating lists.
Restriction on data entry.
Imposing conditions on data entry.
Formation of an error message when entering data.
Formation of a message for data entry.
Working with data formats.
Microsoft Excel data types and formats: text, numbers, dates, times, currency. Their setting.
Problems in using formats.
Custom format.
Create a custom format for text, dates, and times.
Organization of calculations in Excel.
Entering a formula into a cell. Copy 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 options.
Creating headers and footers
Setting through rows and columns.
Document prepress. Using Preview.
Printing the selected area. Set the printable area.
Lesson 3
Functions.
Use of simple functions (summation, average, minimum, maximum, number).
Ways to work with functions. Using help. Entering functions using the Function Wizard. Categories of functions.
Logic functions: IF,AND,OR,IFERROR. Nested boolean functions.
Math and static functions: SUMIF, COUNTIF, AVERAGEIF
Text functions CONCATENATE, LEFT, UPPER, LOWER, PROPER
Array functions: HLOOKUP, VLOOKUP, TRANSP.
Solving practical problems using functions.
Copying calculation results and formulas using Paste Special.
Review possible errors in formulas.
Lesson 4
Diagrams. Graphics in documents.
Create diagrams. Diagram Wizard.
Setting chart properties.
Construction of various types of diagrams.
Chart printing.
Inserting graphic elements. Inserting a picture.
Smart Art objects.
Conditional formatting.
The concept of conditional formatting.
Creating conditional formatting (comparison 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 a structure.
Hiding and displaying data.
Freeze rows and columns while viewing.
Dividing the sheet into parts when viewing.
Consolidation of data.
Applying filters. Data selection by filtering.
Advanced filter. Creating conditions for an advanced filter.
Search and replace.
Pivot tables.
Creation of pivot tables.
Changing formats for pivot tables.
Setting up pivot tables.
Pivot table editing.
Refreshing pivot table data.
Lesson 6
Notes (create, edit, delete).
Create hyperlinks.
Data protection.
Setting a password to open a book.
Sheet protection for data entry.
Permission to work with individual cells and prohibition of work on other cells.
Microsoft Excel is designed to work with spreadsheets (Sheets), which allow you to collect, calculate, analyze and visualize quantitative and textual information. Excel is an almost indispensable program in any profession.
Knowledge and practical skills in using the advanced features of Microsoft Office Excel 2010 allow you to work effectively with large amounts of data, perform complex analysis, effectively use the built-in functions of MS Excel 2010 and macros, as well as import data, protect and visualize information.
The course will cover both the powerful functionality common to versions of Microsoft Excel and the new features of MS Excel 2010.
Successful completion of this course will allow professionals to:
- Change the program interface settings.
- Use the advanced features of Microsoft Excel 2010 to analyze and process data.
- Use functions of various categories, build complex formulas
- Create, edit, and format pivot tables and charts with built-in tools and wizards.
- Quickly and visually create PivotTable reports to summarize, analyze and group data.
- Sort and filter data by value and color.
- Create dynamic lists with pivot tables.
- Calculate subtotals and grand totals in tables, combine data.
- Import and export data to other applications.
- Record, edit macros, and use ways to automate repetitive tasks with macros.
- Publish the contents of an MS Excel document both on a static Web page and create interactive pages for entering your own data.
- Organize collaboration with data, apply cell protection, worksheets and workbooks.
Purpose of the course
Improving skills in building complex spreadsheets based on Microsoft Office Excel 2010.
The target audience
- Managers and office workers of all levels.
- Heads, secretaries, assistants to heads.
- Accountants, economists, analysts, logisticians.
- Specialists of various profiles who systematically face in their activities the need to quickly and at a high level perform calculations and analyze data based on spreadsheets.
Required preparation
Knowledge and skills in the scope of the courses:
- 283 "Microsoft Office Excel 2010 User".
- 263 "Microsoft Excel 2007 User".
1. New features of Microsoft Office Excel 2010 spreadsheets.
- Interface customization.
- Using a new file format.
- Efficient data table management.
- Formatting cells and worksheets.
2. Formulas and functions.
- Creation of complex formulas.
- Assigning names to data ranges. name manager.
- Finding and correcting errors in calculations.
- Using different types of built-in functions.
3. Work with lists and databases.
- Using filters.
- Ordering data and calculating totals.
- Combining data from multiple sources.
4. Analysis of alternative data sets.
- Definition and modification of alternative datasets.
- What-if analysis and finding the optimal solution.
- Data analysis using descriptive statistics.
5. Create dynamic lists using pivot tables.
- Dynamic data analysis with pivot tables.
- Filtering, displaying and hiding data in a pivot table.
- Changing pivot tables.
- Pivot table formatting.
- Create pivot charts.
6. Automate repetitive tasks with macros.
- Introduction to macros.
- Creating and editing macros.
- Running a macro.
7. Organization of joint work.
- Sharing data.
- Managing notes and tracking revisions.
- Protection of workbooks and sheets.
Certification
The course is not associated with certificate programs
Received Document
certificate for professional development, or Certificate.
The Specialist Center is the first and only Microsoft Office Specialist Authorized Testing Center in Russia, and has also been the #1 Microsoft Gold Partner in Russia, Eastern and Central Europe for many years.
Today, there is hardly an office worker who is not familiar with the Microsoft Excel program. Many people use Excel whenever they need to create a spreadsheet. 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 how to professionally work with tables, formulas, charts and much more.
Certified teachers
More than 40 teachers of the Center are Microsoft certified trainers (MOS, MCT). The annual participation of our TC 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. An individual approach, constant practice in the classroom, learning in live dialogue mode - all these are Excel courses in the "Specialist". Excel is taught by 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 learning Excel, you will receive an international Microsoft Office specialist certificate 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 formed 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. Deep learning Excel is useful for analysts and anyone who works with reports.
