{"product_id":"絶対に知っておきたい-社労士のための-業務が効率化できるexcel活用術-実践編-日本法令dvd-ｖ１７３","title":"Absolutely Must-Know Excel Utilization Techniques for Social Insurance and Labor Consultants to Improve Work Efficiency [Practical Edition] Japanese Laws DVD V173","description":"\u003cp\u003eOverview\u003cbr\u003e\nContains Excel files for \"work time management\" and \"salary\/bonus calculation\" to improve the work efficiency of social and labor consultants!\u003c\/p\u003e\n\n\u003cp\u003eSocial 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.\u003cbr\u003e\nTherefore, 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.\u003cbr\u003e\nBy 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.\u003c\/p\u003e\n\n\u003cp\u003eAdditionally, 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.\u003c\/p\u003e\n\n\u003cp\u003e*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]''.\u003cbr\u003e\nDetails\u003cbr\u003e\n[Lecturer]\u003cbr\u003e\nMeito Social Insurance and Labor Consultant Office Hideyuki Kato\u003cbr\u003e\n　\u003cbr\u003e\n[Video table of contents]\u003cbr\u003e\nConvenient functions for managing working hours\u003cbr\u003e\n(SUM, COUNT\/COUNTA, EDATE, display format\/serial value, TEXT, conditional formatting, IF, TIME\/VALUE, MIN, CEILING\/FLOOR\/MROUND, functions useful for salary\/bonus calculations)\u003cbr\u003e\n(DATEDIF, TODAY, ROUNDUP\/ROUND\/ROUNDDOWN, MAX, EXACT, VLOOKUP, IFERROR, SUMIFS, pivot table)\u003cbr\u003e\n　\u003cbr\u003e\n[Recording format]\u003cbr\u003e\n01_労働時間管理_練習用.xlsx\u003cbr\u003e\n02_労働時間管理_完成版.xlsx　\u003cbr\u003e\n03_給与・賞与計算_練習用.xlsx\u003cbr\u003e\n04_給与・賞与計算_完成版.xlsx\u003cbr\u003e\n　\u003cbr\u003e\n[Video recording time]\u003cbr\u003e\nApproximately 140 minutes\u003cbr\u003e\n　\u003c\/p\u003e\n\n\u003cp\u003e[Caution]\u003cbr\u003e\n● To watch this product, please be sure to play it on a DVD video compatible player.\u003cbr\u003e\n● To play on a computer, the computer must be equipped with a DVD drive and DVD playback software.\u003cbr\u003e\n● 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.\u003cbr\u003e\n● For details on how to print, please refer to \"How to retrieve lecture resumes\" included with this product.\u003cbr\u003e\n*PC operating environment: Playback may not be possible depending on the computer environment, so please contact the computer manufacturer in that case.\u003cbr\u003e\n*Adobe Acrobat Reader is required to view the lecture text (PDF).\u003cbr\u003e\n*This DVD contains Excel files. Microsoft Excel (2013\/2016\/2019\/2021 Windows version) is required to view and edit files.\u003c\/p\u003e","brand":"officejapan","offers":[{"title":"Default Title","offer_id":42572096340190,"sku":"horei-4976075129624","price":11220.0,"currency_code":"JPY","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0562\/9335\/9809\/products\/horei-4976075129624_ce49c278-b79a-46c5-9d14-950b0faaf785.jpg?v=1757301795","url":"https:\/\/office-japan.jp\/en\/products\/absolutely-must-know-excel-utilization-techniques-for-social-insurance-and-labor-consultants-to-improve-work-efficiency-practical-edition-japanese-laws-dvd-v173","provider":"OfficeJapan オフィスジャパン","version":"1.0","type":"link"}