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
  1. Text Funcitons
     1. Combining Cells
     2. Extracting Cell Contents
     3. Changing Case of Texts
  2. Logical Functions
     1. Basic IF Statements
     2. Nested and Series IF
  3. Math Functions
     1. Math Functions
  4. Lookup Functions
     1. VLOOKUP


• MODULE II: Database Management
  1. Sorting Options
  2. Text-to-Columns
  3. Remove Duplicates
  4. Conditional Formatting
     1. Basic Conditional Formatting
     2. Data Bars, Color Scales, and Icon Sets
  5. Data Validation
     1. Modifying Error Alerts
  6. Subtotal Tool
     1. Group and Ungroup
     2. Basic Subtotal
  7. Data Consolidation
     1. Consolidate Tool


• MODULE III: Tables and Charts
  1. Charts
     1. Review of Chart Elements
     2. Basic Chart Design


• MODULE IV: Pivot Reports
  1. PivotTable
     1. Basic Pivot Features
     2. Slicers
     3. Drilling Down