Absolutely Must-Know Excel Utilization Techniques for Social Insurance and Labor Consultants to Improve Work Efficiency [Practical Edition] Japanese Laws DVD V173

Overview
Contains Excel files for "work time management" and "salary/bonus calculation" to improve the work efficiency of social and labor consultants!

Social insurance and labor consultants often have the opportunity to use Excel to manage working hours, calculate payroll, etc. However, there are times when they are unable to use Excel effectively and end up spending an unexpected amount of time.
Therefore, in this DVD, for teachers who want to make better use of the Excel they use in their work, we will focus on and efficiently explain Excel functions that will save time when managing working hours and calculating salaries and bonuses, which are directly related to social and labor consultant work.
By watching this DVD, you will be able to answer questions such as 1) wanting to know about functions that make labor management easier, 2) wanting to automatically tally working hours, and 3) wanting to check salary and bonus calculations.

Additionally, this DVD includes the instructor actually setting up an Excel file, so you can deepen your understanding by watching the video and setting it up together.

*It will be more effective if you watch it together with V165 ``Must-Know: Excel Utilization Techniques for Social and Labor Consultants to Improve Work Efficiency [Basic Edition]''.
Details
[Lecturer]
Meito Social Insurance and Labor Consultant Office Hideyuki Kato
　
[Video table of contents]
Convenient functions for managing working hours
(SUM, COUNT/COUNTA, EDATE, display format/serial value, TEXT, conditional formatting, IF, TIME/VALUE, MIN, CEILING/FLOOR/MROUND, functions useful for salary/bonus calculations)
(DATEDIF, TODAY, ROUNDUP/ROUND/ROUNDDOWN, MAX, EXACT, VLOOKUP, IFERROR, SUMIFS, pivot table)
　
[Recording format]
01_労働時間管理_練習用.xlsx
02_労働時間管理_完成版.xlsx　
03_給与・賞与計算_練習用.xlsx
04_給与・賞与計算_完成版.xlsx
　
[Video recording time]
Approximately 140 minutes
　

[Caution]
● To watch this product, please be sure to play it on a DVD video compatible player.
● To play on a computer, the computer must be equipped with a DVD drive and DVD playback software.
● The DVD contains lecture texts as PDF files. Insert the DVD into your computer (a computer equipped with a DVD drive that can read DVDs), open the PDF file in the DVD data, and print it using your printer.
● For details on how to print, please refer to "How to retrieve lecture resumes" included with this product.
*PC operating environment: Playback may not be possible depending on the computer environment, so please contact the computer manufacturer in that case.
*Adobe Acrobat Reader is required to view the lecture text (PDF).
*This DVD contains Excel files. Microsoft Excel (2013/2016/2019/2021 Windows version) is required to view and edit files.