How to Prepare an Employee Datasheet with EsCalc

Step-by-Step Guide

1. 1

   Step 1: Download esCalc

   Click file, choose open file in other format, following Text with Header.
   
   The imported txt file will be shown as the picture.
2. 2

   Step 2: launch it.

   First, append a blank row by press Ctrl+Enter on the final row.
   
   Second, copy the txt file (eg, sales department) without header Third, press Ctrl+B on the blank row in esCalc , Then the datasheet is ready for statistical computing and analytics.
   
   Operations such as group, filter, sort, join, align can be easily performed.
   
   For example, if need to assign employees by Hiredate, just perform sort by Hiredate.
   
   Right click on a Hiredate record, select operation
   - sort
   - Asc. , Just right click on the band need to be removed, choose Band
   - Remove band. ,,
3. 3

   Step 3: To import the following txt file from other sub-companies or departments.

4. 4

   Step 4: Copy and paste the following txt data one by one

5. 5

   Step 5: and get a total employee sheet.

6. 6

   Step 6: The result is shown as below.

7. 7

   Step 7: Expand a column

8. 8

   Step 8: enter formula =# to gain the serial number.

Detailed Guide

About the Author