StationX
Start free

← All labs

Excel Expert Productivity

Essential IT · 12 labs · ≈ 8 h of hands-on labs · Infrastructure Labs add-on — 3 attempts per lab in any 12 months

🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab in any 12 months · Already have it? Sign in with StationX

  1. Create a Script with Parameters in Windows PowerShellLevel: AdvancedDuration: 45 min
  2. Use Data and Macros Across Workbooks to Streamline Data CollectionLevel: GuidedDuration: 30 min
  3. Protect a Workbook by Restricting EditingLevel: GuidedDuration: 30 min
  4. Use Rules to Apply Conditional FormattingLevel: GuidedDuration: 30 min
  5. Use Functions to Create Advanced FormulasLevel: GuidedDuration: 30 min
  6. Create and Modify Advanced Chart TypesLevel: GuidedDuration: 30 min
  7. Create and Modify Pivot TablesLevel: GuidedDuration: 30 min
  8. Can You Prepare Workbooks for Collaboration?Level: GuidedDuration: 45 min
  9. Can You Create Custom Conditional Formatting Rules?Level: GuidedDuration: 45 min
  10. Can You Perform Data Analysis by Using Advanced Functions and Features?Level: AdvancedDuration: 45 min
  11. Can You Create Advanced Charts and Tables?Level: AdvancedDuration: 45 min
  12. Can You Create a Comprehensive Workbook that Contains Data Analysis, Advanced Formulas, Macros, and Charts?Level: GuidedDuration: 1 h