Must-know Excel usage techniques for social and labor consultants to streamline their work [Basic Edition] Japanese Laws DVD V165

Overview
Simple but effective Excel basics to increase the work efficiency of social and labor consultants that can be easily understood in 60 minutes!

Social insurance and labor consultants have many opportunities to use Excel to compile employee information into lists, manage time, calculate payroll, etc. However, sometimes they are unable to use Excel effectively and end up spending an unexpected amount of time.
Therefore, in this DVD, we will use short videos of 1 to 5 minutes per item to explain the basic functions of Excel that can improve work efficiency, even though they are basic, using the employee list, which is one of the Excel files that social insurance and labor consultants see most.

By watching this DVD, you can solve problems such as ``It's hard to see or find the information you need in Excel,'' ``Copying a simple formula doesn't work,'' and ``Can't create a CSV file that matches your system.''
The DVD includes the instructor actually setting up an Excel file, so you can deepen your understanding by watching the video and working with the Excel file.

Details
[Lecturer]
Meito Social Insurance and Labor Consultant Office Hideyuki Kato

[Table of contents]
1 Extension/CSV
2 Line break within cell
3 Undo/Redo
4 Shortcut keys
5 Search/Replace
6 Filter
7 Fixing the window frame
8 Open a new window
9 Autocorrect
10 Print
11 String concatenation
12 Four arithmetic operations
13 Copying formulas (relative reference/absolute reference)
14 Select format and paste
15 Save/Open CSV

[Recording format]
01_基本機能_練習用.xlsx
02_基本機能_完成版.xlsx
03_シフトJIS.csv
04_utf8.csv

[Video recording time]
Approximately 60 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: Depending on the computer environment, playback may not be possible. In that case, please contact the computer manufacturer.
*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.