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

Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
Ok