Microsoft Excel. Level 3. Data analysis and visualization - course RUB 17,990. from Specialist, training, Date: November 20, 2023.
Miscellaneous / / December 07, 2023
Leading 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!
From the very beginning of classes, Svetlana Vasilievna captures the group’s attention. He knows how to motivate the audience for successful learning, easily finds an individual approach to each student and answers in detail any questions that arise during the course of study.
She has extensive experience in personal sales and has worked her way up from a marketer to a commercial director of an industrial holding. Svetlana Vasilyevna has successful experience in providing comprehensive support to organizations: consulting, designing a sales department, developing motivation systems, training and personnel adaptation, preparation and implementation of corporate standards, corporate scripts for sales, marketing, logistics departments, as well as an internal book sales
Author of a number of trainings aimed at developing sales, management and communication skills. Consultant on system changes aimed at increasing sales. Included in the unified register of financial directors.
Today, Svetlana Vasilievna is a co-owner of a consulting business. She has been successfully conducting business training for over 5 years. Experience in sales is more than 12 years, 9 of which as a head of commercial service and commercial director. Effectively uses his wealth of professional experience in the learning process.
Training:
Grateful graduates in their enthusiastic reviews invariably note the vividness of the presentation, the clarity of the examples and the ability to find an approach to everyone. He doesn’t leave a single question about the program without an exhaustive answer and always gives his listeners the most complete knowledge.
Economic education, comprehensive knowledge in vector and raster graphics allowed Inna Vitalievna become an excellent marketer, a highly qualified specialist in the field of advertising, sales promotion and PR
She taught economic disciplines in marketing, management and organization theory at the university. Author of more than 20 guidelines and teaching aids. Inna Vitalievna conducts successful advertising campaigns on a freelance basis. Engaged in the development of logos, outdoor advertising concepts (signs, stands, advertising posters), creation of layouts of printed products, advertising videos, etc.
At the Specialist Center, Inna Vitalievna has already successfully trained more than 1,300 people. Among her listeners are employees of such companies as TetraPak, Deloitte, Samsung Electronics Rus Company LLC, and a representative office of Celgene International Holdings Corporation (USA).
Inna Vitalievna is convinced: “The transition from practice to theory is a conscious step! After all, giving people knowledge and turning users into specialists is also the meaning of life!”
Watch an exclusive interview with Inna Romanova about why she studied to be an economist, but preferred teaching at the “Specialist”, what kind of students come to her classes and is it possible to teach Excel cat.
» Teacher's articles:
" Reviews:
Module 1. Application of the category of built-in functions “Links and Arrays” and array formulas (5 ac. h.)
-Array formulas Use in simple calculations Use of functions in array formulas
-Use in simple calculations
-Using functions in array formulas
-Use of named ranges in calculations
-Solving problems of extracting data from a data array: Two-way search Search using several criteria Two-way multi-criteria search Using the functions ROW, COLUMN
-Two-way search
-Search by multiple criteria
-Two-way multi-criteria search
-Using the functions ROW, COLUMN
-Use of the INDIRECT function in solving problems: Processing data from one or several sheets Creating dependent lists with a constant source-
-Processing data from one or more sheets
-Creating dependent lists with a constant source
-Working with the OFFSET function
Module 2. Custom formats (1 ac. h.)
-Creation of custom formats:
-Number formats
-Date and time formats
-Groups of custom formats
-Editing, applying and deleting formats
Module 3. Diagrams (4.5 ac. h.)
-Sparklines
-Combination charts
-Histogram showing totals
-Project Gantt chart
-Tornado Comparison Chart
-Funnel chart
-Waterfall chart
-Cartogram
-Hierarchical Diagrams: Sunburst Hierarchical
-Sun rays
-Hierarchical
-Statistical Charts: Pareto Chart Box and Whisker Chart Frequency Chart
-Pareto chart
-Box with mustache
-Frequency diagram
-Thermometer
-Charts with custom controls: Chart with data series on/off Chart with selection of values and display of average, minimum and maximum values
-Chart with data series on/off
-Chart with selection of values and display of average, minimum and maximum values
Module 4. Data Forecasting (1 ac. h.)
-Trend highlighting:
-Moving average
-Regression analysis functions: PREDICTION, TREND, GROWTH
-Building trend lines
-Taking into account seasonality in forecasts
-Quick forecast using forecast sheet
Module 5. Variational analysis “What If” and Optimization (2 ac. h.)
-Use of the Data Table tool to analyze the development of the situation with 2 variables
-Assessing the development of the situation and choosing the optimal strategy using Scenarios
-Solving a single-criteria optimization problem using parameter selection
-Solving multicriteria optimization problems using the Search for Solution add-in
-Module 6. Processing of external Databases (2.5 ac. h.)
-Import data using PowerQuery from a text file, Access database and Web page
-Query to Excel file
-Features of analyzing an OLAP data cube in Excel pivot tables
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 2021/2019/2016.
4