Microsoft Excel. Level 2. Advanced features - course RUB 14,990. from Specialist, training, Date: December 2, 2023.
Miscellaneous / / December 05, 2023
Training takes place on the latest version of Excel 2019!
Excel is a multifunctional program that is used in almost any field of activity. Powerful tools for calculations, analysis and visual presentation of information make Excel an almost indispensable tool in any profession.
Having completed training at the Center “Specialist” course, you will gain knowledge and skills that will allow you to work effectively with large volumes of data, perform complex analysis, effectively use the built-in functions of MS Excel 2019/2016. You will learn to compare tables, be able to use the VLOOKUP function to substitute data from one table to another, and perform various calculations with both simple and complex conditions.
The course will cover both the powerful functionality of Microsoft Excel 2019/2016 versions and the new features of MS Excel 2019 that have appeared when working with pivot tables.
The course will be of interest to managers and office workers at all levels, executives, secretaries, assistant managers, accountants, economists, analysts, logisticians and many others. professionals who have a strong level 1 knowledge of Microsoft Excel and would like to expand their knowledge to perform the most commonly used tasks in Microsoft Excel 2019/2016.
This course is taught only by certified Microsoft trainers! A unique course, developed at the Specialist Training Center and authorized by Microsoft! Upon completion of training, you will receive a certificate from the Center “Specialist” and a Microsoft certificate.
You will learn:
-Most effectively use Excel tools and functions to analyze and process data
-Use functions to compare and substitute data
-Perform calculations using various conditions
-Highlight the necessary data with conditional formatting
-Protect cells, worksheets and workbooks
-Control data entry
-Calculate subtotals and grand totals in tables
-Sort and filter data by values and color
-Quickly and clearly create reports of pivot tables and charts to summarize and analyze data by year, quarter, month, both in absolute and relative values
-Create default pivot table layout
10
coursesLeading teacher of courses for Microsoft Office users, Microsoft certified trainer, holder prestigious international MOS status: Microsoft Office Specialist® Master and international application certifications MS Office. The first certified teacher of the domestic office platform R7-OFFICE
Svetlana Igorevna is a graduate of the Department of Computer Systems and Networks of Moscow State Technical University. N.E. Bauman, in teaching adheres to the style and traditions of the Bauman school. She received her second higher education at the Moscow State Law Academy (MSAL), after which she worked as an expert at VDNKh.
He is the leading teacher of the Microsoft Corporation's educational program "World of Limitless Possibilities" for the training of school teachers in Russia. Regularly develops and conducts special trainings for corporate clients.
Extensive teaching experience allows Svetlana Igorevna to find an approach to different students. She shares her knowledge and practical experience in using office programs MS Office and P7-OFFICE, and is able to explain even complex processes simply and clearly.
This is also noted by her students, many of whom actively use Office programs in their daily work, but learn all their useful capabilities only in Svetlana Igorevna’s classes. “I work with Excel all the time, but I learned a lot of new things. Techniques were shown that I didn’t even know about, and now I will use them in my work.” “The teacher planned the course so competently and provided additional material that you can train and consolidate the acquired knowledge easily,” students write in their reviews.
Everyone who studied on Svetlana Bulaeva’s course notes her friendliness and willingness again and again dwell on important or unclear points, the intensity of the course and how she manages to motivate listeners to work. It teaches you how to build logic for solving problems, understand general patterns, and then apply the acquired knowledge in practice.
Svetlana Igorevna has been teaching at the Specialist center since 2002. During this time, she successfully trained more than 11,500 students who became sought-after professionals in the labor market!
9
coursesA professional of the highest level, a talented teacher-practitioner. Holder of prestigious international certifications Quark Expert, Adobe Certified Expert, MOS: Excel and MOS: PowerPoint, and has the Adobe Certified Instructor level.
Vivid reviews from grateful graduates are the best confirmation of her qualifications. Elena Evgenievna is patient and attentive to any questions and knows how to ensure that each student leaves classes in high spirits, having fully mastered the material. Pays great attention to the practical application of acquired knowledge.
After learning “from scratch” from Elena Evgenievna, you can immediately start working with graphic programs at a professional level. All the knowledge and skills necessary for this will be obtained and practiced. There will be no problems with employment - specialists who can work with graphic programs, layout designers, and designers are in great demand on the labor market. They are expected in advertising, printing, and Internet development. In addition, they are very necessary in such a rapidly developing industry as content development for mobile devices.
She has 20 years of teaching experience and has specialized in computer graphics for more than 15 years. During this time, Elena Evgenievna successfully trained almost 6 thousand specialists!
Among its graduates are employees of the Central Department Store, designers of the Sprandi clothing stores, and employees of the publishing houses Prosveshcheniye and Marka. Citizens of the United States of America, Spain, Israel, Indonesia, and Bangladesh studied with Elena Evgenievna.
Module 1. Using built-in Excel functions (7 ak. h.)
-Different types of links
-Linking sheets and workbooks
-Application of various types of built-in functions
-Mathematical functions: summation with conditions, rounding of calculation results
-Statistical functions: calculation of counts, averages, minimum and maximum values with conditions (COUNTIFS, AVERAGEIFS, MINESIF and MAXIFS)
-Reference and substitution functions: VLOOKUP and GLOOKUP
-Logic functions: IF, IFS, AND, OR, SWITCH, IFERROR
-Text functions: concatenation (CONCATENATE, CONCATENATE, COMBINE) and data splitting, extracting the necessary characters (LEFT, RIGHT, PSTR)
-Functions for working with dates
Module 2. Conditional formatting (1 ac. h.)
-Apply built-in rules: histogram, color scales, icon sets
-Create formatting rules using formulas
Module 3. Peculiarities of teamwork (1 ac. h.)
-Protect Excel cells, sheets and workbooks
-Checking input values: Setting restrictions on data input Searching for incorrect values
-Setting restrictions on data entry
-Search for incorrect values
Module 4. Working with large table arrays (3 ac. h.)
-Creation and maintenance of tables
-Removing duplicates
-Sorting data:
-Sorting by one criterion
-Multi-level sorting
-Sort by formatting
-Data filtering:
-Autofilter
-Slices
- Summing up interim results
-Data consolidation
Module 5. Data analysis using Pivot tables (4 ac. h.)
-Creating pivot tables
-Pivot table conversion
-Data filtering: filters, slices, timeline
-Setting up pivot table fields
-Adding calculated fields to a pivot table
-Pivot table formatting
-Customize the default PivotTable layout
-Grouping fields in pivot tables
-Summary charts, drill-down charts
-Updating pivot tables and charts