Japanese laws and regulations are so easy! How to use Excel macros to automate social and labor consultant work V213 4976075910390

Order number V213
Specifications DVD instructor: Hideyuki Kato
Size DVD tall case
Quantity: 1 set
ISBN 9784539772850
JAN code 4976075910390

overview
A detailed explanation of the basics of Excel macros and how to create macros using VBA using practical examples!
Also includes (VBA) sample code for automation!

Excel macros require programming, but programming is not that difficult. This DVD explains how social insurance and labor consultants can use Excel macros to improve work efficiency.
As examples, we provide a demo and explain how to build the system, using the topics of extracting employees with less than 5 days of paid employment and creating individual files for appointment forms.
The material is all related to the work of social insurance and labor consultants, so it is very easy to understand.
Furthermore, the basics of Excel macros are structured so that everyone from beginners to advanced users can enjoy them.
The accompanying materials on the DVD include sample code and Excel files for the macros explained.
By using this DVD, social insurance and labor consultants can use Excel macros to improve work efficiency and productivity, allowing them to run their business more efficiently.
detail
[Lecturer]
Meito Social Insurance and Labor Consultant Office Social Insurance and Labor Consultant Hideyuki Kato
　
[Main table of contents]
1. Excel macro basics
2. Macro creation using VBA
　
[Recording format]
Lecture resume (PDF)
Extract less than 5 days of paid leave (Excel)
Extraction of less than 5 days of paid leave (text)
Appointment PDF output (Excel)
Appointment PDF output (text)
Create email draft (Excel)
Create email draft (text)
　
[Video recording time]
Approximately 105 minutes
　
*The recorded content has been created based on the content as of April 2020.
　

【Note】
●To watch this product, you will need ① a DVD video compatible player for DVD discs, and ② a web browser for online video sites.
●If you want to play a DVD on a computer, the computer must be equipped with a DVD drive and DVD playback software.
●This product (DVD and online video site) includes lecture texts in PDF files. Please print it using your printer. For details, please refer to the instruction manual included with this product.
●This product (DVD and online video site) includes lecture texts (PDF) as well as formats. Microsoft EXCEL (2016/2019/2021) is required to view and edit the format.
*PC operating environment: Playback may not be possible depending on the computer environment. In that case, please contact the computer manufacturer.
*Adobe Acrobat Reader is required to view the lecture text (PDF). Additionally, to view and edit online videos, Microsoft Edge 44 or higher, Google Chrome 80 or higher, and Safari 12 or higher are required.
*The EXCEL macro code included with this product is a sample and does not guarantee operation in all computer environments. Also, there is no support.
*DVD publishers and DVD instructors are not responsible for any failures or defects that may occur as a result of running the included sample code.
*Please do not misuse the included sample code.