巧用Excel高效处理数据 |
| |
引用本文: | 柏磊,龙涛.巧用Excel高效处理数据[J].河北机电学院学报,2011(1):48-51. |
| |
作者姓名: | 柏磊 龙涛 |
| |
作者单位: | [1]石家庄宝石电子集团有限责任公司,河北石家庄050035 [2]河北省电子信息技术研究院,河北石家庄050000 |
| |
摘 要: | 以电话费用的分拣、汇总为例,通过利用Excel内嵌的函数VLOOKUP以及单元格之间的引用技巧,探讨了在不同工作表之间进行大量数据传送以及快速处理数据的方法。
|
关 键 词: | Excel 工作表 VLOOKUP函数 |
Efficient data processing by using Excel sheet |
| |
Authors: | BAI Lei LONG Tao |
| |
Affiliation: | 1.Shijiazhuang Baoshi Group Corporation Limited,Shijiazhuang Hebei 050035,China;2.Hebei Research Institute of Electronic Information and Technology,Shijiazhuang Hebei 050000,China) |
| |
Abstract: | This paper gives an example about sorting and summarizing the telephone expenses on Excel sheet.It discusses the method of a large amount of data transmission between different Excel sheets and fast data processing,by using inner-inlaying VLOOKUP function in Excel sheets and referencing skills between the cells. |
| |
Keywords: | Excel sheet VLOOKUP function |
本文献已被 维普 等数据库收录! |