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.
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+PowerPointWe 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 casesYou will receive ready-made example files and company cases that you can adapt to your needs
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
Compare Pricing – Best Value for Your Career
See why our annual "The Netflix of HR" subscription is the smartest investment in your career!
Subscripion form
Leave your contact details to activate your subscription
You will be redirected to a secure payment gateway.
Corporate Subscription Request
Provide your details, and we’ll create a tailored offer for your team.
Our team will contact you within 24 hours to discuss your needs and finalize your subscription.
Course registration
Leave your contact details for registration
We will be in touch shortly
Регистрация на курс
Оставьте ваши контакты для регистрации
Мы скоро с вами свяжемся
Регистрация на курс
Оставьте ваши контакты для регистрации
Мы скоро с вами свяжемся
Регистрация на курс
Оставьте ваши контакты для регистрации
Мы скоро с вами свяжемся
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
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 workIn 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 -
ToolsYou 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 solutionsYou 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 -
ExamplesWe 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 assignmentsIn 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 roomAll 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.
For communication and support, all participants communicate in a dedicated Telegram chat room.
Contact us in any way you like: