Example training content

  • Example content for Excel courses

    TopicIntermediateAdvancedExpert
    Concepts
    • Data import
    • Efficient data and formula entry
    • Adding navigation structure to workbook
    • Conditional Formatting
    • Advanced Pivot Tables
    • Worksheet protection
    • Dynamic Named Ranges
    • Understanding/debugging complex formulas
    • Advanced Conditional Formatting
    • Volatily of functions
    • Custom Data Validation
    • Dynamic dropdowns
    Features
    • AutoFilter
    • Pivot Tables
    • Row/column grouping
    • Data validation
    • Excel Tables
    • Remove duplicates
    • Pivot Charts
    • Goal Seek & Solver
    • Cell styles
    • Sparklines
    • Slicers
    • Database connections
    • Advanced filter
    • Circular references
    Formulas
    • SUMIFS, COUNTIFS
    • VLOOKUP
    • INDEX/MATCH
    • IFERROR
    • Named Ranges
    • INDIRECT, OFFSET, ADDRESS, ROW, COLUMN
    • RANK, FREQUENCY
    • Array formulas
    • R1C1 style formulas
    • Advanced array formulas
    • Advanced text handling
    • Fast VLOOKUP/MATCH
  • Example training schedule for 1 day Excel training for Procurement Consultants

    TimeTopicContent
    9:00 Efficient working in Excel
    • Speed up frequent tasks with advanced keyboard shortcuts
    9:30 General modeling principles
    • Best practise modeling principles
    10:00 Advanced lookups and data consolidation
    • Usage of lookup formulas (INDEX, MATCH, INDIRECT, VLOOKUP, OFFSET) to combine, aggregate and clean data
    • Exercises: Data aggregation to clean product table, consolidation of multiple filled RFQs for central analyses
    12:00 Lunch break  
    12:30 Pivot Tables
    • Advanced pivot table concepts and exercises (e.g. % of previous item, calculated fields, GETPIVOTDATA function)
    13:30 PowerPoint/thinkcell integration
    • Best practices integrating Excel models into PowerPoint/thinkcell
    14:00 PowerPivot
    • Introduction of PowerPivot including data import, setting up of hierarchies, calculations and report generation
    • Exercise to rebuild an existing complex procurement analyses with PowerPivot
    16:00 Q&A and additional topics
    • Coverage of additional topics requested by participants, e.g. workbook protection, usage of styles, database connections