The foundation of Excel Macro, how to make macros by VBA is in a detailed description using an institutional example.
Also includes sample code for automation (VBA).
Excel Macro needs to be programmed, but the program is not so difficult. This DVD describes how social insurance workers use Excel Macro to help work efficiently.
Examples include extraction of employees under 5 days and creating individual files on dictionary papers to demonstrate and construct.
It is very easy to understand because it is made entirely of what is associated with the work of a social insurance person.
In addition, the fundamentals of Excel macro are built to be enjoyed by a wide range of beginners and advanced players.
DVD attachments include sample code for macro and Excel files described.
This DVD allows social insurance workers to use Excel Macro to make work more efficient, productivity, and operate more efficiently.
[TEACHER]
Maito Social Insurance Office; Social Insurance Office; Hideyuki Kato
[Main Table of Contents]
1. Excel Macro Base
2. Macro creation by VBA
Recording Type:
Lecture Resume (PDF)
Extracts less than 5 days (Excel)
Extracts (text) less than 5 days
Dictionary PDF Output (Excel)
Dictionary PDF output (text)
Create Your Mail Draft (Excel)
Make a Draft Mail (text)
Video Recording Time:
About 105 minutes
The contents of this collection are created based on the content as of April in 2015.
[Note]
● To view this product, 1) For DVD disk, DVD video compatible player, 2) Web browser is required for online video sites.
When playing DVD on a PC, the computer must have a DVD drive and DVD playback software.
● This product (DVD and online video sites) includes lecture text in PDF files. Print and use your printer. For more information, please refer to the instruction manual included with this product.
● This product (DVD and online video sites) includes lecture text (PDF), as well as formats. Microsoft EXCEL(2016/2019/2021) is required to view and edit the format.
PC operation environment: Depending on your computer environment, it may not be able to play back in this case, so please consult your computer manufacturer.
Adobe Acrobat Reader is required to read lecture text (PDF). You also need Microsoft Edge 44 or above, Google Chrome 80 or above, Safari12 or above to view and edit online videos.
The EXCELL macro code included with this product is a sample and does not guarantee that it will work in all computer environments. It also has no support.
DVD publishers and DVD teachers will not be responsible for any chances of failure or failure due to the execution of the included sample code.
Please do not use the included sample code.