MS Excel. Module 2: Advanced level - course 17,900 rub. from IBS Training Center, training 15 hours, Date: December 3, 2023.

1. Managing workbook options and settings (1.5 h theory, 1.5 h practice)
Workbook management;
Preparing workbooks for sharing;
Using and customizing language options.

2. Data management and formatting (1.5 h theory, 1.5 h practice)
Filling cells based on existing data;
Data formatting and verification;
Application of advanced conditional formatting and filtering.

3. Using advanced formulas and macros (3 hours theory, 3 hours practice)
Perform logical operations using formulas;

Searching for data using functions;
Application of advanced functions for working with dates and times;
Perform data analysis;
Troubleshooting formulas;
Create and edit simple macros.

4. Create advanced charts and tables (1.5 h theory, 1.5 h practice)
Creating and editing advanced diagrams;
Creating and modifying pivot tables;
Create and edit pivot charts.