Advanced training program "​MS Excel and MS PowerPoint: tools for working effectively with data and presentations"

Program content:

SECTION 1. Process modeling in MS Excel (12 training hours)
Setting up the Excel work environment. Creating a table and working with its main parameters
Using built-in functions
Optimization problems. Add-on “Search for a solution”
Developer tab. Form controls

SECTION 2. Working with a table as a database (4 training hours)
Sorting and filtering data
Document merging technology

SECTION 3. Graphical presentation of data in Excel (4 training hours)
Construction of graphs and diagrams of varying complexity
Using Macros

SECTION 4. Modern data analysis capabilities: Power Query and Power Pivot (8 training hours)
Data transformations in Power Query
Data Analysis and Modeling in Power Pivot

SECTION 5. Creating presentations in MS PowerPoint (8 training hours)
Basic elements of a presentation. Working with slide designs
Various presentation modes
Setting up animation. Setting up actions
Types of presentations. Rules for preparing an effective presentation

Preliminary class schedule:

• May 18 (Mon) 9.00 – 16.00 (8 hours);
• May 19 (Tue)  9.00 – 16.00 (8 hours);
• May 20 (Wed) 9.00 – 16.00 (8 hours);
• May 21 (Thursday) 9.00 – 16.00 (8 hours);
• May 22 (Fri) 9.00 – 12.00 (4 hours) + test.