Course Duration
8 hours, 1-day training workshop
Delivery
Face to face training or online training
Course Inclusive
Training materials & certificate of completion
Course Content
- MODULE I: Excel Functions
- Text Funcitons
- Combining Cells
- Extracting Cell Contents
- Changing Case of Texts
- Logical Functions
- Basic IF Statements
- Nested and Series IF
- Math Functions
- Math Functions
- Lookup Functions
- VLOOKUP
- MODULE II: Database Management
- Sorting Options
- Text-to-Columns
- Remove Duplicates
- Conditional Formatting
- Basic Conditional Formatting
- Data Bars, Color Scales, and Icon Sets
- Data Validation
- Modifying Error Alerts
- Subtotal Tool
- Group and Ungroup
- Basic Subtotal
- Data Consolidation
- Consolidate Tool
- MODULE III: Tables and Charts
- Charts
- Review of Chart Elements
- Basic Chart Design
- MODULE IV: Pivot Reports
- PivotTable
- Basic Pivot Features
- Slicers
- Drilling Down