Justifiez facilement la participation de vos apprenants grâce à nos attestations et rapports certifiés. Découvrez nos solutions pour organismes. Prochaine promo dans 4 j 1 h 7 min
Compare with 1 courses

Excel In English Intermediate Level

Excel In English Intermediate Level

80 €

📈 Excel Intermediate English ! Improve your skills : advanced calculations, data tables, conditional formatting. Complete training !

En savoir plus
A une remise
Période d'expiration À vie
Créé en
Dernière mise à jour le Mon Apr 2025
Niveau
Débutant
Total lectures 0
Total quizzes 0
Durée totale Heures
Total des inscriptions 3
Nombre d'avis 0
Évaluation moyenne
Description courte 📈 Excel Intermediate English ! Improve your skills : advanced calculations, data tables, conditional formatting. Complete training !
Résultats
  • Introduction
  • Create Named Ranges
  • Create Named Ranges From Selection
  • Round Off Decimal Values
  • Using Date Functions
  • Performing Basic IF function
  • Combine IF function With Formulas
  • Combine IF AND functions
  • Combine IF OR functions
  • Perform Nested IF_IFS_Functions
  • How To Structure A Database
  • How To Sort Data
  • How To Filter Data
  • Lock Columns And Rows_Freeze And Split Panes
  • Working With Table Tool
  • Create Drop Down Menu_Use Data Validation Tool
  • Create V LOOKUP function
  • Combine V LOOKUP with IF ERROR
  • TRUE argument With V LOOKUP
  • Introduction To Conditional Formatting
  • Define Icon Set Rules With Conditional Formatting
  • Create A Pivot Table Part1
  • Create A Pivot Table Part2
  • Manage Date Values In Pivot Table
  • Change Type Of Functions
  • Using The Filter Area And The Slicers
  • Design Pivot Table
  • Manage AXIS_Chart
  • Managing Series And Categories
  • Create PIE chart
  • Create LINE chart
  • Create COMBO chart_Add Second Axis To Chart
  • Save Chart As Template
  • Create Sparklines
  • How To Protect Worksheet
  • Allow Ranges To Be Edited
  • Conclusion
Prérequis
  • Aucun prérequis