Microsoft Excel. Level 1. Working with Excel spreadsheet editors - course RUB 11,990. from Specialist, training, Date: November 19, 2023.
Miscellaneous / / December 05, 2023
Excel is a powerful set of tools for working with spreadsheets: calculations, processing, analysis, data provision. Knowledge of the program will allow you to receive the necessary data in a timely manner and be able to present it in a visual form, which is extremely important when working with tables in a modern office.
The course will cover both the functionality common to versions of Microsoft Excel 2019/2016, as well as new features of MS Excel 2019, such as quick analysis of tables and customization of charts.
The course will be of interest to managers and office workers at all levels, executives, secretaries, assistant managers, accountants, economists, analysts, logisticians, college and university students and many other specialists who are taking their first steps in mastering the Microsoft Excel program 2019/2016.
To prepare for the MOS Core level exam, you need to take 2 Excel courses (Microsoft Excel 2019/2016. Level 1. Working with Excel and Microsoft Excel 2019/2016. Level 2. Extended capabilities) .
-Understand the structure of an Excel workbook
-Enter data correctly, use filling cells with lists and data progressions
-Carry out calculations using formulas using data located both on the same and on different sheets
-Receive results of data calculation by functions
-Design tables in accordance with any requirements
-Build charts for visual presentation of tabular data
-Sorting and filtering data
-Prepare and print both a table and a diagram
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!
Practical teacher, certified business trainer, coach and consultant.
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:
A 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. Working with book sheets. Data entry (4 ac. h.)
-Microsoft Office Excel interface: ribbon, tabs, groups, icons, assistant
-File tab, Quick access panel
-Structure of the book. Operations with sheets: renaming, inserting, deleting, moving, copying
-Basic actions with sheet elements: cells, rows, columns
-Features of data entry. Editing
-Setting data formats
-Cleaning contents and formats
-Automatic filling of sheet cells with data:
-Progressions: arithmetic and geometric
-Lists: built-in and custom
Module 2. Calculations in Microsoft Excel (4 ac. h.)
-Creating and editing formulas
-Copying formulas
-Use of different types of links in calculations:
-Relative links
-Absolute links
-Links to cells of other sheets
-Using named cells in formulas
- Built-in Excel functions: Logical function IF Mathematical and Statistical: SUM, MIN, MAX, AVERAGE, COUNT
-Logical IF function
-Mathematical and Statistical: SUM, MIN, MAX, AVERAGE, COUNT
-Errors in formulas: causes and corrective actions
Module 3. Design of tables. Construction of diagrams (4 ac. h.)
-Cell design: number format, borders, fill, data alignment
-Auto table formats
-Conditional formatting
-Adding notes to cells. Edit, copy, view, and display notes
-Copying formats. Clear formatting
-Working with diagrams:
-Building: recommended charts, combination charts
-Chart customization: chart elements, chart styles, filtering series and categories
-Editing and deleting a diagram
Module 4. Table processing. Printing tables (4 ac. h.)
-Quick table analysis: formatting, charts, totals, tables, sparklines
-Sorting data:
-Sorting by one column
-Multi-level sorting
-Filtering (selection) of data
-Pinning areas to permanently display rows/columns on the screen
-Preparation for printing: Headers and footers: creation and formatting. Setting page parameters: margins, size, orientation Printing Continuous rows/columns Setting the print area Printing tables and charts
-Headers and footers: creation and formatting.
-Setting page parameters: margins, size, orientation
-Printing continuous rows/columns
-Setting the print area
-Print tables and charts
G
GolubevVM
07.02.2021 G.
Computer knowledge is not a bug, but a feature
Advantages: Information content, accessibility, quality, presentation, professional self-development. Disadvantages: Not found. Current global trends show us that computer knowledge is not a bug, but a feature. Correct and competent use of all tools (calculations, processing, analysis, data provision) of Microsoft Excel greatly simplifies working with this software product...