Program Overview

Program Overview

The program "Analysis and Visualization of Data in MS Excel" aims to improve existing and acquire new competencies for specialists in the field of analytics who work with data processing and forecasting, analytical tables, graphs, plans, using the Microsoft Excel spreadsheet processor.

Program Details

• Level of Complexity: Not specified
• Duration of the Course: 0 academic hours
• Training Schedule: 16 academic hours

Annotation

The goal of the program is to enhance the skills of specialists in analytics, enabling them to effectively handle data and create forecasts, analytical tables, graphs, and plans using Microsoft Excel.

Instructors

• M Valeria Viktorovna

Related Courses

• Office technologies
• Microsoft Excel
• Microsoft Office
• Microsoft (for users)
• Data analysis

Schedule

The course is scheduled from 20.04.2026 to 23.04.2026, with classes held from 18:30 to 21:50.

Detailed Schedule

Cost

• For Individuals: 10,500
• Discounts:
  • 10%: 9,400
  • 15%: 8,900
• For Legal Entities: 10,500
• Discount Policy: Discounts are provided based on the number of listeners, the sum of the contract, and other conditions agreed upon with the customer.

Requirements

The course is oriented towards listeners with experience working in MS Windows. Basic knowledge and practical skills in MS Excel (any version) are required.

Entrance Testing

• Test -145: Work in MS Excel. Advanced capabilities.
  • Knowledge of the main interface elements.
  • Operations with files. Concept of a workbook, worksheet, cell.
  • Cell formatting. Using styles.
  • Working with formulas. Relative, absolute addressing.
  • Using functions: text, mathematical, statistical, date, and time, logical.
  • Special insertion.
  • Conditional formatting.
  • Working with lists: sorting, filtering, intermediate totals.

Course Content

1. Means of Visualizing Reports in Excel

1.1 Conditional formatting
1.2 Custom format
1.3 Creating and formatting tables
1.4 Pivot tables and pivot charts

2. Diagrams and Sparklines

2.1 Building diagrams
2.2 Forecasting data using diagrams
2.3 Sparklines
2.4 Inserting an Excel diagram into a PowerPoint presentation

3. Control Elements and Interactive Diagrams

3.1 Data validation
3.2 Control elements
3.3 Dynamic ranges

4. Array Formulas. WHAT IF Analysis

4.1 Array formulas
4.2 WHAT IF analysis
4.3 Solver add-in

Final Assessment

The final assessment is part of the program to evaluate the learners' understanding and application of the skills acquired during the course.