Excel + PowerPoint для HR: отчёты, графики, анализ

Course Overview

• Course Title: Excel + PowerPoint для HR: отчёты, графики, анализ
• Instructor: Viktor Pritula
• Target Audience: HR specialists, professionals looking to enhance data visualization and reporting skills
• Prerequisites:
  • Basic computer skills and familiarity with Microsoft Office
  • Installed Excel and PowerPoint programs (preferably versions 2016 and above)
  • Willingness to learn how to visualize HR data and prepare presentations
  • HR work experience is a plus but not mandatory
  • Readiness to complete practical assignments and apply tools in practice

Curriculum Highlights

• Key Topics Covered:
  • Basics of Excel and PowerPoint for HR
  • Automating reports and using formulas, pivot tables, VLOOKUP
  • Presenting ideas and reports in PowerPoint
  • Formatting reports, budgets, and analytical documents in corporate style
  • Data visualization: charts, diagrams, trends, forecasts
  • Using Excel and PowerPoint in daily HR work
  • Preparing project, idea, or budget presentations for management
  • Making HR analytics understandable, visual, and convincing for decision-making
• Key Skills Learned:
  • Confident data handling in Excel
  • Automating reports and utilizing formulas, pivot tables, VLOOKUP
  • Effective presentation of ideas and reports in PowerPoint
  • Formatting reports, budgets, and analytical documents in corporate style
  • Visualizing data with charts, diagrams, trends, and forecasts
  • Integrating Excel and PowerPoint in daily HR tasks
  • Preparing presentations for management
  • Creating understandable, visual, and convincing HR analytics

Course Format

• Duration: 4.5 hours on-demand video
• Format: Self-paced online course
• Resources:
  • Access on mobile and TV
  • Closed captions
  • Audio description in existing audio
  • Certificate of completion