Home / Course catalog / Introduction to Microsoft Excel (KIPL)

Internal KIBUs

Introduction to Microsoft Excel (KIPL)


Description
This is a training course about writing formulas and functions in Excel, creating PivotTables and charts with the aim to perform different types of analysis. Throughout the training, you will work through interactive training, videos and one Excel file for further practice, which will help you apply the information you have learned.
Content
  • Introduction files
  • General Guidelines for Trainees
  • Course Specifications
  • Pre-training Self-assessment
  • Unit 1: Formulas & Functions
  • Description of the unit: Formulas & Functions
  • Learning course: Formulas & Functions
  • Assessment: Formulas & Functions
  • Unit 2: Formatting & more tips
  • Description of the unit: Formatting & more tips
  • Learning course: Formatting & more tips
  • Assessment: Formatting and more Tips
  • Unit 3: Charts & Sparklines
  • Description of the unit: Charts & Sparklines
  • Learning course: Charts & Sparklines
  • Assessment: Charts & Sparklines
  • Unit 4: Pivot Tables
  • Description of the unit: PivotTables
  • Learning course: PivotTables
  • Assessments: PivotTables
  • CLOSE - EXIT TASKS
  • Post-training Self-assessment
  • Survey/ Feedback
Completion rules
  • You must complete the units "Assessment: Formulas & Functions, Assessment: Formatting and more Tips, Assessment: Charts & Sparklines, Assessments: PivotTables"
  • Leads to a certificate with a duration: Forever