0
Views
MS Excel. Module 1: Intermediate level - course 12,900 rub. from IBS Training Center, training 11 hours, Date: December 3, 2023.
Miscellaneous / / December 09, 2023
The course covers the basic functionality of MS Excel, including the skills of creating and editing workbooks and sheets in a spreadsheet processor, changing and formatting content individual cells, aggregating and organizing data, presenting data in tables and charts, performing operations using formulas, inserting and formatting objects in MS Excel.
After completing the training, training participants will be able to correctly apply the basic functionality of MS Excel and independently complete the proposed tasks. The course will also be useful in preparing for the MO-200 certification exam.
1. Managing workbooks and sheets (1.5 hours theory, 1.5 hours practice)
Importing data into workbooks;
Navigation in workbooks;
Formatting workbooks and sheets;
Customization of options and appearance of MS Excel;
Configure content to interact with other users.
2. Managing data in cells and cell ranges (1 hour theory, 1 hour practice)
Manipulating data in sheets;
Formatting cells and cell ranges;
Creating named ranges of cells;
Visualization of final data.
3. Managing tables and tabular data (1 hour theory, 1 hour practice)
Creating and formatting tables;
Modification of tables;
Filtering and sorting tabular data.
4. Perform operations using formulas and functions (1 hour theory, 1 hour practice)
Inserting links in formulas;
Carrying out calculations and transforming data using functions;
Formatting and changing text using functions.
5. Chart management (1 hour theory, 1 hour practice)
Creating diagrams;
Changing diagrams;
Formatting charts.
Subscribe
YOU MIGHT ALSO LIKE
-
-
19/12/2019 -
