[{"NUM":79,"bookMap":{"种次F":"","标准编码":"7-115-14858-9","可外借数":2,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":1,"索书号2":"","种次数据":"","内容介绍1":"","语种":"","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":342837,"出版日期":"2006","已外借数":0,"COVERPATH":"http://img3.douban.com/lpic/s5662871.jpg","题名2":"EXCEL VBA基础入门","采编审核员":"","分类号":"","出版地":"北京","索书号":"TP391.13/Z46.2","价格":0,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":150175,"索书号7":"","索书号8":"","SUMMARYS":"《Excel VBA基础入门》在安排内容时,充分考虑到大多数初学者几乎没有编程基础的实际情况,在文字表述方面尽量避开专业术语,用通俗易懂的语言,教读者如何学习Excel VBA。为了方便学习和理解,《Excel VBA基础入门》附赠光盘中还配有原声视频演示,读者可以在看书的同时打开视频文件参照学习。","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"TP391.13/Z46.2","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"赵志东编著","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"人民邮电出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"赵志东编著","索书号10":"","全文地址":"","题名":"EXCEL VBA基础入门","翻译题名":"","处理日期":1216609263000,"分类字母":"","题名缩写":"Excel VBAJCRM","丛书名":"","册数":2,"索书号16":"","累计外借册数":79,"调配员":"","修改人员":1,"出版者":"人民邮电出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"66c0c9b92d545235f6d5d7e43d327855"},{"NUM":54,"bookMap":{"种次F":"","标准编码":"7-121-02987-1","可外借数":3,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":1,"索书号2":"","种次数据":"","内容介绍1":"","语种":"","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":351325,"出版日期":"2006","已外借数":0,"COVERPATH":"http://img3.doubanio.com/lpic/s1938707.jpg","题名2":"EXCEL VBA应用开发从基础到实践","采编审核员":"","分类号":"","出版地":"北京","索书号":"TP391.13/M17","价格":0,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":161668,"索书号7":"","索书号8":"","SUMMARYS":"本书面向不同层次的Excel VBA开发者,系统讲解了Excel VBA开发的基本概念;Excel对象模型;应用Excel和VBA进行数据处理;Excel图表的VBA编程;用户窗体和Excel工作表界面设计;开发效率、互操作、API调用等高级话题;并结合3个实际案例,介绍了如何在工作实际中使用VBA和Excel提高工作效率,设计Excel VBA应用程序。本书还对VBA语言进行了一个简短的概述,涵括了基本的编程概念、错误处理及面向对象编程等内容。 除了对VBA语言的讲解,本书还以数据处理、界面设计、Excel图表等为专题,将Excel功能、编程知识和实际应用衔接起来,并通过3个较大的实际案例,以达到理论联系实际的作用。 本书无论对想通过Excel VBA来提高工作效率,使用Excel和VBA作为数据处理平台的读者,还是对使用Excel作为开发平台的读者,都将是学习Excel VBA开发的首选。","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"TP391.13/M17","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"马维峰编著","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"电子工业出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"马维峰编著","索书号10":"","全文地址":"","题名":"EXCEL VBA应用开发从基础到实践","翻译题名":"","处理日期":1216609343000,"分类字母":"","题名缩写":"Excel VBAYYKFCJC","丛书名":"","册数":3,"索书号16":"","累计外借册数":102,"调配员":"","修改人员":1,"出版者":"电子工业出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"687ed5725abd044f3efb318e6116bcf0"},{"NUM":42,"bookMap":{"种次F":"","标准编码":"978-7-121-07697-8","可外借数":6,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":52,"索书号2":"","种次数据":"","内容介绍1":"","语种":"chi","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":0,"出版日期":"2009","已外借数":0,"COVERPATH":"http://img3.douban.com/lpic/s24420472.jpg","题名2":"金融财务建模与计算:基于 VBA 与 MATLAB 实现","采编审核员":"","分类号":"","出版地":"北京","索书号":"F830.9-39/Z67","价格":0,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":550406,"索书号7":"","索书号8":"","SUMMARYS":"《金融财务建模与计算:基于VBA与MATLAB实现》向读者介绍投资组合、资产定价、期权定价、固定收益证券等金融财务模型的建立及其在VBA和MATLAB中的计算方法。主要内容包括:现代金融财务理论与模型概述;投资组合收益率和方差计算及其VBA实现;投资组合有效边界及其VBA实现;投资组合风险优化决策模型及其VBA实现;投资组合风险价值模型及其VBA实现;资本资产定价模型的建立及其VBA实现;Black-Scholes期权定价模型及其VBA实现;二叉树(二项式)期权定价模型及其VBA实现;期货的套期保值计算的VBA信息化实现;投资项目决策与理财模型及其VBA实现;固定收益证券计算的MATLAB实现;投资组合计算的MATLAB实现;金融衍生品计算的MATLAB实现;期权定价有限差分计算的MATLAB实现;期权定价蒙特卡罗模拟计算的MATLAB实现,上市公司信用度量模型及其MATLAB应用。","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"F830.9-39/Z67","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"朱顺泉编著","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"电子工业出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"朱顺泉编著","索书号10":"","全文地址":"","题名":"金融财务建模与计算基于 VBA 与 MATLAB 实现","翻译题名":"","处理日期":1251681638000,"分类字母":"","题名缩写":"","丛书名":"","册数":5,"索书号16":"","累计外借册数":67,"调配员":"","修改人员":90,"出版者":"电子工业出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"fc17ef764985783ca898e327c541f916"},{"NUM":38,"bookMap":{"种次F":"","标准编码":"7-121-03688-6","可外借数":3,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":1,"索书号2":"","种次数据":"","内容介绍1":"","语种":"","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":401784,"出版日期":"2007","已外借数":0,"COVERPATH":"http://img4.doubanio.com/lpic/s25800639.jpg","题名2":"EXCEL VBA应用高效开发:案例精华版","采编审核员":"","分类号":"","出版地":"北京","索书号":"TP391.13/W79","价格":0,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":202902,"索书号7":"","索书号8":"","SUMMARYS":"本书主要是针对有一定Excel应用基础的办公人员编写的。全书以实例形式详细介绍了在Excel中使用VBA的方法和技巧。全书共分12章,前3章介绍Excel VBA的基础知识,第4~12章分别以实例形式讲解VBA的具体应用,主要的实例有:员工管理、工资管理、商场销售管理、库存管理、固定资产管理、财务报表分析、学生成绩管理、图书出租管理、彩票号码生成器等内容。 本书从实际应用出发,对每个实例都介绍了设计思路和关键技术,避免读者在学习过程中走弯路。无论是VBA初学者还是有一定程序设计基础的读者,通过学习本书,都能在Excel中使用VBA编写实用的应用程序。 本书附赠CD光盘一张,光盘中赠送了150个常用的Excel模板,读者稍加修改,就可以应用于实际。还附赠价值150元的“Office实用技巧速查宝典(基础+办公全集)”软件。 本书适合有大量数据处理需求的办公管理人员阅读,也适合大中专院校的学生阅读,还可作为VBA的培训教材。","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"TP391.13/W79","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"伍云辉编著","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"电子工业出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"伍云辉编著","索书号10":"","全文地址":"","题名":"EXCEL VBA应用高效开发案例精华版","翻译题名":"","处理日期":1216609612000,"分类字母":"","题名缩写":"Excel VBAYYGXKF:","丛书名":"","册数":3,"索书号16":"","累计外借册数":77,"调配员":"","修改人员":1,"出版者":"电子工业出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"c6bedfcf82f0f3e27909642d87e759ae"},{"NUM":28,"bookMap":{"种次F":"","标准编码":"978-7-5058-6646-1","可外借数":6,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":1,"索书号2":"","种次数据":"","内容介绍1":"","语种":"","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":422564,"出版日期":"2007","已外借数":0,"COVERPATH":"","题名2":"市政债券发行规则与制度研究","采编审核员":"","分类号":"","出版地":"北京","索书号":"F832.51/Y48.3","价格":0,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":220170,"索书号7":"","索书号8":"","SUMMARYS":"","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"F832.51/Y48.3","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"杨辉著","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"经济科学出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"杨辉著","索书号10":"","全文地址":"","题名":"市政债券发行规则与制度研究","翻译题名":"","处理日期":1226545992000,"分类字母":"","题名缩写":"SZZQFXGZYZDYJ","丛书名":"","册数":5,"索书号16":"","累计外借册数":33,"调配员":"","修改人员":41,"出版者":"经济科学出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"8caa0b0465ce1b6ed0df149b45ea0af2"},{"NUM":27,"bookMap":{"种次F":"","标准编码":"978-7-121-08779-0","可外借数":6,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":52,"索书号2":"","种次数据":"","内容介绍1":"","语种":"chi","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":0,"出版日期":"2009","已外借数":0,"COVERPATH":"http://img3.douban.com/lpic/s24638435.jpg","题名2":"精通MATLAB金融计算","采编审核员":"","分类号":"","出版地":"北京","索书号":"F830.49/J53","价格":0,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":602232,"索书号7":"","索书号8":"","SUMMARYS":"《精通MATLAB金融计算》讲述MATLAB在金融计算方面的应用。首先深入浅出地介绍相关的金融理论及模型,然后重点讲述MATLAB的金融、衍生品、固定收益工具箱中的函数,并通过大量的应用实例,帮助读者快速、熟练掌握使用MATLAB来解决金融中的计算和分析问题。 《精通MATLAB金融计算》由MATLAB入门篇、MATLAB金融计算及实例篇和MATLAB金融类工具箱函数详解篇组成,MATLAB入门篇介绍MATLAB软件、基本运算、数据可视化和数据获取及编程基础;金融计算及实例篇讲述MATLAB金融计算的主要内容,具体包括金融类工具箱的介绍、金融数据的处理、固定收益证券计算、利率期限结构和利率模型、金融衍生品计算、投资组合管理与风险控制、奇异期权和利率期权定价等;MATLAB金融类工具箱函数详解篇对金融、衍生品和固定收益这3个工具箱中的全部函数一一进行详解,包括函数的功能、输入和输出参数的说明,以帮助读者快速掌握工具箱中函数的使用。 《精通MATLAB金融计算》实例丰富、语言简练、上手快,可供金融、经济等专业的大学本科和研究生作为辅助教材和参考书,也可供金融机构从业人员参考使用。","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"F830.49/J53","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"金龙, 王正林编著","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"电子工业出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"金龙, 王正林编著","索书号10":"","全文地址":"","题名":"精通MATLAB金融计算","翻译题名":"","处理日期":1261020329000,"分类字母":"","题名缩写":"","丛书名":"","册数":5,"索书号16":"","累计外借册数":142,"调配员":"","修改人员":72,"出版者":"电子工业出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"b70e0be071151c120efb629ef7d68215"},{"NUM":27,"bookMap":{"种次F":"","标准编码":"978-7-80179-813-8","可外借数":3,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":52,"索书号2":"","种次数据":"","内容介绍1":"","语种":"chi","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":0,"出版日期":"2009","已外借数":0,"COVERPATH":"","题名2":"博弈论的智慧:社会万象的博弈解读","采编审核员":"","分类号":"","出版地":"北京","索书号":"O225/Z36","价格":0,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":612191,"索书号7":"","索书号8":"","SUMMARYS":"","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"O225/Z36","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"张影著","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"中国致公出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"张影著","索书号10":"","全文地址":"","题名":"博弈论的智慧社会万象的博弈解读","翻译题名":"","处理日期":1261552228000,"分类字母":"","题名缩写":"","丛书名":"","册数":3,"索书号16":"","累计外借册数":49,"调配员":"","修改人员":55,"出版者":"中国致公出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"a3df3105204a18aca1e7c2b55b06dc5b"},{"NUM":26,"bookMap":{"种次F":"","标准编码":"978-7-5086-1810-4","可外借数":8,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":112,"索书号2":"","种次数据":"","内容介绍1":"","语种":"chi","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":0,"出版日期":"2010","已外借数":0,"COVERPATH":"http://img3.douban.com/lpic/s6106203.jpg","题名2":"高盛帝国.下","采编审核员":"","分类号":"","出版地":"北京","索书号":"F837.123/A20.2-2/2","价格":0,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":663058,"索书号7":"","索书号8":"","SUMMARYS":"作为为高盛提供战略咨询服务超过30年的专家,查尔斯·埃利斯与高盛现任和以前的多位合伙人保持密切联系。在本书中他深入描述了高盛历史上最重要的时期,并通过揭示那些关键的人和事件来讲述成就高盛今日地位的色彩丰富而且引人入胜的故事。 《高盛帝国》一书充分展现了为高盛播下成功种子的伟大人物:西德尼·温伯格——对市场具有高度敏感性;格斯利维——到将强烈的野性带入日常工作的每一部分;约翰·怀特黑德——对公司重新定位并书写了高盛以客户服务为导向的团队精神的核心价值;约翰·温伯格——非常杰出而又极其谦逊;罗伯特·鲁宾和汉克?保尔森——他们后来担任了美国财政部长;乔恩·科尔津——后来成为美国新泽西州州长;劳尔德·布莱克费恩——现任的CEO和董事会主席。","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"F837.123/A20.2-2/2","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"(美) 查尔斯·埃利斯著","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"中信出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"(美) 查尔斯·埃利斯著","索书号10":"","全文地址":"","题名":"高盛帝国下","翻译题名":"","处理日期":1273113302000,"分类字母":"","题名缩写":"","丛书名":"","册数":6,"索书号16":"","累计外借册数":97,"调配员":"","修改人员":52,"出版者":"中信出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"92662fe669540bd7bb99ca4f4d939ce7"},{"NUM":26,"bookMap":{"种次F":"","标准编码":"978-7-115-15796-6","可外借数":8,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":1,"索书号2":"","种次数据":"","内容介绍1":"","语种":"chi","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":382560,"出版日期":"2007","已外借数":1,"COVERPATH":"http://img4.douban.com/lpic/s2145026.jpg","题名2":"Excel实战技巧精粹","采编审核员":"","分类号":"","出版地":"北京","索书号":"TP391.13/B80","价格":69,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":185679,"索书号7":"","索书号8":"","SUMMARYS":"目 录 第一篇 绪论:最佳Excel学习方法 技巧1 成为Excel高手的捷径 技巧2 使用Excel联机帮助系统 技巧3 通过互联网搜索学习资源和解题方法 技巧4 在新闻组或BBS中学习 第二篇 基本功能 第1章 操作Excel 技巧5 设置不同的Excel启动效果 技巧6 Excel启动时自动打开指定的工作簿 技巧7 实用的Excel选项设置 技巧8 更新Excel到最新状态 技巧9 Excel 2000中的赛车游戏 技巧10 解决双击XLS文件无法打开的问题 第2章 工具栏和菜单 技巧11 让Excel始终显示完整的菜单 技巧12 自定义菜单和工具栏 技巧13 共享自定义工具栏 技巧14 备份自定义工具栏和菜单 第3章 操作工作簿 技巧15 显示工作簿的完整路径 技巧16 自定义默认工作簿 技巧17 预览工作簿 技巧18 多用途的文档属性 技巧19 查看最后打开文件的人 技巧20 使用工作区文件 技巧21 一次关闭多个文件的技巧 技巧22 简繁转换不求人 技巧23 保护Excel文件 技巧24 为工作簿减肥 技巧25 修复受损的Excel文件 技巧26 Excel文件转化为PDF文档 第4章 操作工作表 技巧27 选取单元格区域的高招 技巧28 轻松选择“特殊”区域 技巧29 快速填充所有空白单元格 技巧30 改变撤销的步数 技巧31 省心省力的重复操作 技巧32 快速切换工作表 技巧33 重置工作表中的已使用范围 技巧34 改变工作表标签颜色与字号 技巧35 更改Excel默认的行列标签的颜色 技巧36 隐藏秘密数据 技巧37 快速插入多个单元格 技巧38 快速插入多个行或列 技巧39 隔行插入的绝招 技巧40 在非空行之间自动插入空行 技巧41 快速删除所有空行 技巧42 快速改变行列的次序 技巧43 快速设置最适合的列宽 技巧44 限定工作表中的可用范围 技巧45 彻底隐藏工作表 技巧46 自定义默认工作表 第5章 数据处理 技巧47 输入数据后向不同方向移动单元格指针 技巧48 在单元格区域中移动 技巧49 方便查看标题的“冻结窗格”功能 技巧50 多窗口协同作业 技巧51 定义自己的序列 技巧52 自动填充的威力 技巧53 巧用右键和双击填充 技巧54 输入分数的方法 技巧55 使用语音校验输入准确性 技巧56 控制自动超链接 技巧57 取消现有的超链接 技巧58 提取超链接信息 技巧59 输入特殊字符 技巧60 输入身份证号码 技巧61 自动更正的妙用 技巧62 为文本添加拼音 技巧63 替换掉所有单元格中的换行符 技巧64 模糊查找数据 技巧65 查找替换单元格格式 技巧66 神奇的选择性粘贴 技巧67 Excel的摄影功能 第6章 单元格格式 技巧68 奇妙的自定义数字格式 技巧69 随心所欲设置日期格式 技巧70 自定义数字格式的经典应用 技巧71 把自定义数字格式的显示值保存下来 技巧72 合并单元格的同时保留所有数值 技巧73 同一个单元格里的文本设置不同格式 技巧74 制作斜线表头 技巧75 单元格里的文字换行 技巧76 工作表背景图片的妙用 第7章 名称的奥妙 技巧77 定义名称的3种方法 技巧78 名称命名的为与不为 技巧79 在名称中使用常量与函数 技巧80 名称的作用范围 技巧81 编辑名称引用 技巧82 创建动态名称 技巧83 图片自动更新 技巧84 快速选择定义名称的区域 技巧85 创建名称表格 技巧86 以图形方式查看名称 技巧87 快速删除所有名称 第8章 活用条件格式 技巧88 美丽的数据区域 技巧89 永恒的间隔底纹 技巧90 快速比较不同区域的数值(一) 技巧91 快速比较不同区域的数值(二) 技巧92 自动醒目的小计 技巧93 在工作日历中突显周休日 技巧94 突显活动单元格的坐标 技巧95 生日提醒 技巧96 特殊数值提醒 技巧97 标记重复值 技巧98 标记含有公式的单元格 技巧99 标记匹配目标数值的单元格 技巧100 八种颜色区分不同数值 技巧101 无限条件的条件格式 第9章 数据有效性绝技 技巧102 在单元格中创建下拉列表 技巧103 另类的批注 技巧104 快速切换有效性的来源 技巧105 动态源的数据有效性 技巧106 只能录入某种特征的数据 技巧107 限制重复值的录入 技巧108 杜绝负数库存 技巧109 强制序时录入 技巧110 多级选择录入 第10章 打印 技巧111 控制需要打印的内容 技巧112 重复打印顶端标题行和左侧标题行 技巧113 在同一页上打印不连续的区域 技巧114 控制打印输出的比例 技巧115 克隆工作表的页面设置 技巧116 在报表的每一页上打印公司Logo 技巧117 在页眉或页脚增加分隔线 技巧118 Excel的双面打","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"TP391.13/B80","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"EXCEL HOME编著","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"人民邮电出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"Excel Home编著","索书号10":"","全文地址":"","题名":"EXCEL实战技巧精粹","翻译题名":"","处理日期":1338267245000,"分类字母":"","题名缩写":"","丛书名":"","册数":8,"索书号16":"","累计外借册数":196,"调配员":"","修改人员":112,"出版者":"人民邮电出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"266c97818d8b94ba89ab6be27c9745d4"},{"NUM":23,"bookMap":{"种次F":"","标准编码":"7-300-07429-4","可外借数":6,"上月外借册数":0,"去年外借册数":0,"封面":"","采编审核":0,"分类字符数据":"","全文服务器ID":0,"操作员":1,"索书号2":"","种次数据":"","内容介绍1":"","语种":"","本月外借册数":0,"排架号":"","库键码":1,"ILAS记录号":356082,"出版日期":"2006","已外借数":0,"COVERPATH":"http://img3.doubanio.com/lpic/s24637916.jpg","题名2":"基于EXCEL和VBA的高级金融建模","采编审核员":"","分类号":"","出版地":"北京","索书号":"F830-39/J47","价格":0,"索书号5":"","索书号6":"","种次字母":"","索书号3":"","责任者一":"","索书号4":"","索书号9":"","翻阅次数":0,"主键码":164886,"索书号7":"","索书号8":"","SUMMARYS":"本书将大部分金融模型用电子制表软件实现。这些模型覆盖了整个金融领域,包括股票、股票期权和债券期权。本书在纵览金融领域的基础上,将资产定价中的假设、数学问题、数值方法和Excel 的解法连接起来,总结出一般性规律,然后详细介绍如何应用Excel中的宏和函数来实现股票、期权和债券内容的计算。 本书的特点是将计算机应用与金融计算有机地结合起来。通过学习本书内容,既可以熟悉并巩固金融领域的大部分经典理论,又可以学习到Excel的编程知识。读者能够轻松使用Excel来实现有关金融计算。 本书可作为金融专业本科高年级学生和研究生的教材,也可作为金融从业者的参考工具。","今年外借册数":0,"编目审核员":"","调配时间":"","索书号A":"F830-39/J47","责任者三":"","责任者二":"","分类":"","编目审核":0,"预约数":0,"编目审核日期":"","封面地址":"","内容介绍":"","责任者四":"","文献类型":0,"图象页数":0,"责任者":"玛丽·杰克逊, 迈克·斯汤顿著 MARY JACKSON, MIKE ST","版次":"","下载":0,"种次字符数据":"","分类数据":"","出版者2":"中国人民大学出版社","MARC类型":"","封面服务器ID":0,"首馆键码":1,"索书号15":"","采编审核日期":"","索书号14":"","索书号13":"","索书号12":"","索书号11":"","责任者2":"玛丽·杰克逊, 迈克·斯汤顿著","索书号10":"","全文地址":"","题名":"基于EXCEL和VBA的高级金融建模","翻译题名":"","处理日期":1216609365000,"分类字母":"","题名缩写":"JYExcelHVBADGJJR","丛书名":"","册数":5,"索书号16":"","累计外借册数":97,"调配员":"","修改人员":1,"出版者":"中国人民大学出版社","创建时间":"","卷标":"","种次":"","下载服务器ID":0,"下载地址":""},"ID":"f297e5d1132a1ff5933cf077ee23f2d6"}]