Excel + PowerPoint

Recordered online course with homework checked by Mike Pritula
6 lessons to complete the course and obtain a diploma
✍︎ Homework check and ⎆diploma after the course
We open 1 lesson per week
Excel + PowerPoint are two of HR's friends that help to work with data and justify decisions.
The ability to analyse data and visualise decisions is crucial to the success of HR.

How this course will be useful
  • A complete set of information on Excel+PowerPoint
    We will learn how to perform simple and complex operations with data in Excel and present ideas in PowerPoint. How to prepare reports, research results, present your projects, strategy and much more
  • Working tools and cases
    You will receive ready-made example files and company cases that you can adapt to your needs
Join the course participants' Telegram chat ⇢⇢⇢⇢

Course programme

The course is recorded, with homework check and chatting
Recorded class with a feedback on the homework
Recorded class with a feedback on the homework
Class 1. Why HR needs Excel and PowerPoint
  • Key cases of tool use
  • A set of the most useful features for HR
  • Making your first report and first presentation
Recorded class with a feedback on the homework
Recorded class with a feedback on the homework
Class 2. Preparing an HR report in Excel and PowerPoint
  • Table formatting
  • Formulas
  • Totals
  • Master Slides in PowerPoint
  • Tables, graphs in PowerPoint
Recorded class with a feedback on the homework
Recorded class with a feedback on the homework
Class 3. Preparing a presentation of a project or idea
  • Main sections for the project
  • Calculating data for the project in Excel
  • Pivot tables and the VLOOKUP function
  • Presentation design
Recorded class with a feedback on the homework
Recorded class with a feedback on the homework
Class 4: Preparing educational or informative content in PowerPoint
  • Rules for attractive presentations
  • How to engage the audience through a presentation
  • How to make a presentation without a designer
Recorded class with a feedback on the homework
Recorded class with a feedback on the homework
Class 5. Preparing a budget in Excel
  • Sums, averages and median
  • Advanced Pivot Tables
  • Value substitution
  • Using multiple sheets and tables
Recorded class with a feedback on the homework
Recorded class with a feedback on the homework
Class 6. Making graphs, charts and forecasts
  • Types of graphs and charts
  • How to add a trend line to a forecast
  • Visualisation of complex data
  • What is the best way to transfer a diagram to PowerPoint

Early birds

Start your development on the course
Standard
$350
Per 1 participant
Do you want to be the part of the global HR group?
Join the Telegram chat, where we post all updates and free webinars
Join chat

How is the course taught?

1
Webinar recording
You watch the recorded sessions at your own pace and study the material. We open 1 lesson per week
2
Homework checked by the course author
Each webinar has a practical task that you must do to get a diploma
3
A case study of the participants
We chat on Telegram and discuss participants' cases remotely
4

Getting a diploma

Students who successfully complete the course assignments will receive a diploma at the end of the course
Diploma of HR Professional after completing the course
So coveted and valuable
  • Integrates into Linkedin and HH profiles
  • Each diploma has a unique code
  • QR code on the diploma leads to the online version
  • Impossible to forge
  • Issued on a certified Accredible platform (the same place where Rosetta Stone, Google, Udacity, Kaplan University and others issue certificates), look at an example

Who leads?

Course author and facilitator Mike Pritula

  • Founder of Mike Pritula Academy
  • No.1 Opinion Leader in HR for 2019
  • 15 years in HR Wargaming, Preply, iDeals, Starlightmedia, Alfa-Bank
  • Top 10 HR in CIS
  • Since 2010 engaged in online training
  • HRCI representative in CIS
  • PHRi certified
  • Was the first to launch HRCI online certification preparation courses in Russian
  • HR-soft author and startup consultant
  • Over 5000 trained HR professionals
  • Author of HR competency model
  • Author of the most comprehensive HR audit checklist
  • HR person of the year in Ukraine (2018) and Belarus (2017)
  • Over 100 published articles and presentations
  • Over 2 million views on articles
  • Author of a column on Lifehacker.ru
  • Author of the book "Resume for a million"

HR-persona

by Headhunter Ukraine and Belarus
TOP-20

HR leaders by Headhunter
TOP-5 HR

by delo.ua
#1

HRCI CIS representative

What's inside the course

Here is what you will get on the course
Intensive course work
In the course you are not a passive listener, but actively participate in chat during the class and between classes, and practice all the knowledge you have learned and receive feedback from the course author
Tools
You will receive a large number of proven tools that the author has tested in a wide variety of companies, many of which have been developed personally, as well as examples from top companies
Ready-made solutions
You don't have to develop all the solutions yourself. You will get ready-to-use solutions straight away, on a "take-it-or-leave-it" basis. Your only task is to adapt all the tools you receive to your company
Examples
We will have many examples and cases from companies in a wide variety of industries of how they have solved business problems using sourcing tools. You are sure to find many ideas for yourself
Homework assignments
In your homework, you will adapt all the tools and solutions to your business, and the course author will personally check how you did it.
Chat room
All students are added to a dedicated Telegram-chat where they can ask questions and get help, share experiences and find like-minded people and friends.
CONVENIENT STUDENT ACCOUNT

How does training work?

All resources: webinar recordings, presentations, supplementary materials, are stored in your personal account.

For communication and support, all participants communicate in a dedicated Telegram chat room.
Contact us in any way you like: