MS Excell

Module 1/3

• Interface
• Navigation
• Formatting
• Charts
• Arithmetic Actions
• Ribbon Customization

.

Module 2/3

• Basic Concepts
• Data Entry
• Pivot Tables
• Collaboration

.

Module 3/3

• Basic options for printing and exporting to PDF
• Password protect sheet

.

Module 1/3

• Formulas
• Conditional Formatting
• Forms

.

Module 2/3

• Dependency Tracking
• Data Sorting and Filters
• Subtotals
• Basic Data Validation

.

Module 3/3

• Working with Charts
• Workbook Management
• Pivot Tables and Pivot Charts

.

Module 1/3

• Advanced Formulas
• Naming Cells
• Advanced Working with Cells
• Advanced Filters

.

Module 2/3

• Subtotals by several categories
• Share workbook
• Change management
• Data protection

.

Module 3/3

• Pivot Tables and Pivot Charts
• Database Connection
• Database Queries
• Macros
• Scenario Manager

.