HR Special Practical Course

HR Special Practical Course

Number of lessons 15

Time spent on a lesson 1h

Number of Lessons: 15

Lesson Duration: 1 Hour

Course Format։ Face-to-face learning

Course Fee։ 85․000 AMD (Individual)

Venue։  IBT Educational Center, Citadel Business Center, 105/1 Teryan, Yerevan

Who is the course intended for?

The HR Special Practical course is designed for HR (Human Resource Management) professionals and recruiters who want to deepen their knowledge of Word Excel PowerPoint Access programs. During the course, such tools and formulas are going to be studied, which will allow the following:

• save time
• automate a number of work processes
• minimize work errors and miscalculations
• compile literate documents
• make presentable presentations and spreadsheets

Course benefits

• 4 program research: Word, Excel, PowerPoint, Access,
• The course includes practical tasks, theoretical materials, video lessons,
•  Free consultation on your work files,
• Small groups: maximum 5 people,
• Individual approach to each participant,
• Each student is provided with a computer;
• There is no age restriction and no prior knowledge is required for the participation in the course. 

Course Content

MS Word Course

Lesson 1.

• Text Parameters and Formatting
• View Modes
• Numbering/Bullets
• Find, Replace
• Picture Importing  
• Creation of Headers and Footers
•  Page Numbers
• Insert Footnote
•  New Comments
•  Table Creation

MS PowerPoint Course

Lesson 2․

• MS PowerPoint Interface, elements
• Slide creation and import of the required elements
• Import of pictures
•  Music installation
• Slide Formatting
• Selection of the general slide and individual image animations
• Page Numbers
• Header and Footer Creation
• Presentation 
• Photo album creation

Lesson 3․

• Table Insertion
• Insert Shapes
• Creating Graphic Images (SmartArt)
• Insert Chart
• Templates Application
• Custom Slide Creation
• View Application

MS Access Course

Lesson 4․

• MS Access interface, elements
•  Table insertion
• Query
•  Form Creation
• Report Creation

MS Excel course

Lesson 5․

• MS Excel interface, elements, its regulation  
• Workbook structure, elements
• Worklog Creation Adding
• Formulas and Functions   
• Percentage, share calculation
• Formatting of cells, ranges, and tables
• Relative and absolute links, links to the other newspapers and other files

Lesson 6.  

• Data types and formats in Excel (Cells format)
• Conditional formatting
• Data Filter, Sorting
• Find & Replace
• Copy-paste special types

Lesson 7.

• Data analysis Pivot Table
• Data consolidation

Lesson 8.  

• Mathematical functions: Sum, Sumifs, Subtotal, Round
• Conditional formatting (New Rule)
• Link insertion types with the Hyperlink tool  
• Combining Word and Excel Programs
• Sparklines

Lesson 9.  

• Logical Functions: If, Iferror, Or, And
• Salary calculation
• Bonus system calculation
• Calculation with 1 and 0․4 and 0․5 coefficient
• The importance of an asterisk in formulas

 Lesson 10.  

• Vlookup, Hlookup (Searching and linking functions)
• Statistical functions Count, Counta, Countifs, Max, Min, Average
• Spreadsheet printing, additional settings (Print)
• Strengthening and loosening of rows, columns, sections
• View modes

Lesson 11.  

• Protecting cells, ranges, sheets, and workbook
• Data Validation
• Duplicates Removal
• Dynamic Smart Tables
• Diagram insertion, types, data sources

Lesson 12.

• Data and Time Functions: Datedif, Today, Edate, Eomonth, Weekday, Networkdays, Networkdays.intl, Workday, Workdat.intl
• Patient Volume Calculation
• Lists Comparison
• Text to columns
• Examples of Data Validation using different categories of formulas

Lesson 13.

• Text Functions: Concatenate, Proper, Upper, Lower, Left, Right, Mid, Trim, Clean, Len
• Grouping and disgrouping
• Go to tool application
• Google sheets application

Lesson 14․

• Formatting Saturdays and Sundays in the worklog with the conditional formatting tool
• Contract termination reminder with the If formula
• Find out the current date after working days from the given date If - Workday - Today  
• Identify age groups by date of birth using Datedif - Countifs formulas
• Calculation of salaries of different rates according to the Countifs formula
• Specifying birthdays with the Conditional Formatting tool
• Calculation of the shift work with the Sumifs formula
• Determining the number of payable working days due to inability to work using the If formula

Lesson 15.   

• Testing
• Summary

Attention։  The practical HR special course was developed as a result of consultation with Julia Vardanyan an experienced HR specialist and the author of the book ‘’Human Resource Management as Customer Service’’, a recruiter Anahit Aleksanyan and a qualified chief accountant Lilit Melkonyan.   

Thank you for sharing your work experience.