Excel在“管线数据管理系统”中的运用技巧

Skill in Pipeline Data Management System for Excel

管线资源数据录入系统(PCDM)有诸多缺陷,如数据调取难、批量填充、编辑功能受限多、不具备Word的局部查找替换功能。好在数据可以在Excel表格中录入并经转换后批量导入。本文将逐一说明在Excel中批量建表、分类标识,省略录入项目、巧用排序,批量填充、简化录入、批量编辑,替换等方法。

PCDM has many defects, for example, difficulty in adjusting and fetching the data , many limits in filling in batches and editing functions and without function of Word’s part seek and replace. Fortunately, the data can be inputted in Excel and channeled into PCDM in batches after changing. The article will introduce in turns some methods under Excel building forms in batches, classifying signs, omitting the inputting project, skillfully using and arranging in order , filling in batches, inputting simply, editor and replacing in batches, etc.