免费下载书籍地址:PDF下载地址
精美图片

Microsoft Office Excel 2007 Visual Basic 应用进阶指南(光盘)Microsoft Office Excel 2007 Visual Basic for书籍详细信息
- ISBN:9780735624023
- 作者:暂无作者
- 出版社:暂无出版社
- 出版时间:2007-05
- 页数:354
- 价格:238.50
- 纸张:胶版纸
- 装帧:平装
- 开本:16开
- 语言:未知
- 丛书:暂无丛书
- TAG:暂无
- 豆瓣评分:暂无豆瓣评分
内容简介:
Experience learning made easy, and quickly teach yourselfMicrosoft Office Excel 2007 Visual Basic for Applications (VBA)--one stepat a time! Work at your own pace through the easy numbered steps andpractice files on CD, and master the fundamentals for using VBA to createcustom software solutions and automating tasks in Excel 2007--no developerexperience required! You'll learn how to automate spreadsheets, write yourown functions and procedures, and customize menus and toolbars. You'lldiscover Excel Objects, including workbooks, range objects, graphics, andPivotTables-. Plus, you'll learn how to chart data from databases andother information sources. With STEP BY STEP, you can take just the lessonsyou need or work from cover to cover. Either way, you drive theinstruction--building and practicing the skills you need, just when youneed them! Includes a companion CD with hands-on practice files.
书籍目录:
About the Author
Features and Conventions of This Book
Using the Book's CD
What's on the CD?
Minimum System Requirements
Step-by-Step Exercises
2007 Microsoft Office System
Installing the Practice Files
Using the Practice Files
Removing and Uninstalling the Practice Files
Getting Help
Getting Help with This Book and Its Companion CD
More Information
1 Make a Macro Do Simple Tasks
What's the Difference Between VBA and a Macro?
Sidebar: VBA and the .NET Framework
Creating a Simple Macro
Format Currency by Using a Built-In Tool
Record a Macro to Format Currency
Run the Macro
Assign a Shortcut Key to the Macro
Look at the Macro
Save the Macro Workbook
Changing Multiple Properties at Once
Create Sidebar Headings with a Command
Record a Macro to Merge Cells Vertically
Eliminate Unnecessary Lines from the Macro
Manipulating Recorded Properties
Record a Macro to Remove Window Elements
Run the Macro from the Visual Basic Editor
Use a Macro to Toggle the Value of a Property
Eliminate Repeated Objects in a Recorded Macro
Run a Macro from the Quick Access Toolbar
Recording Methods in a Macro
Convert a Formula to a Value by Using Menu Commands
Convert a Formula to a Value by Using a Macro
Make a Long Statement More Readable
Trusting Macro-Enabled Workbooks
Designate a Trusted Location for Macros
Designate a Trusted Publisher for Macros
Key Points
2 Make a Macro Do Complex Tasks
Task One: Opening the Report File
Open a Text File
Watch a Macro Run by Stepping Through It
Select a File While Running a Macro
Task Two: Filling In Missing Labels
Select Only the Blank Cells
Fill the Selection with Values
Record Filling In the Missing Values
Watch the FillLabels Macro Run
Task Three: Adding a Column of Dates
Add a Constant Date
Step Through the Macro
Prompt for the Date
Task Four: Appending to the Database
Append Data to a Master List
Step Through the Append Data Macro
……
3 Explore Workbooks and Worksheets
4 Explore Range Objects
5 Explore Data Objects
6 Explore Graphical Objects
7 Control Visual Basic
8 Extend Excel and Visual Basic
9 Launch Macros with Events
10 Use Dialog Box Controls on a Worksheet
11 Create a Custom Form
Appendix: A Complete Enterprise Information System
Index
作者介绍:
暂无相关内容,正在全力查找中
出版社信息:
暂无出版社相关信息,正在全力查找中!
书籍摘录:
暂无相关书籍摘录,正在全力查找中!
在线阅读/听书/购买/PDF下载地址:
在线阅读地址:Microsoft Office Excel 2007 Visual Basic 应用进阶指南(光盘)Microsoft Office Excel 2007 Visual Basic for在线阅读
在线听书地址:Microsoft Office Excel 2007 Visual Basic 应用进阶指南(光盘)Microsoft Office Excel 2007 Visual Basic for在线收听
在线购买地址:Microsoft Office Excel 2007 Visual Basic 应用进阶指南(光盘)Microsoft Office Excel 2007 Visual Basic for在线购买
原文赏析:
暂无原文赏析,正在全力查找中!
其它内容:
书籍介绍
Experience learning made easy, and quickly teach yourselfMicrosoft Office Excel 2007 Visual Basic for Applications (VBA)--one stepat a time! Work at your own pace through the easy numbered steps andpractice files on CD, and master the fundamentals for using VBA to createcustom software solutions and automating tasks in Excel 2007--no developerexperience required! You'll learn how to automate spreadsheets, write yourown functions and procedures, and customize menus and toolbars. You'lldiscover Excel Objects, including workbooks, range objects, graphics, andPivotTables-. Plus, you'll learn how to chart data from databases andother information sources. With STEP BY STEP, you can take just the lessonsyou need or work from cover to cover. Either way, you drive theinstruction--building and practicing the skills you need, just when youneed them! Includes a companion CD with hands-on practice files.
书籍真实打分
故事情节:3分
人物塑造:6分
主题深度:4分
文字风格:9分
语言运用:6分
文笔流畅:7分
思想传递:3分
知识深度:8分
知识广度:5分
实用性:4分
章节划分:4分
结构布局:5分
新颖与独特:4分
情感共鸣:8分
引人入胜:5分
现实相关:4分
沉浸感:4分
事实准确性:9分
文化贡献:7分
网站评分
书籍多样性:4分
书籍信息完全性:9分
网站更新速度:8分
使用便利性:9分
书籍清晰度:4分
书籍格式兼容性:7分
是否包含广告:7分
加载速度:3分
安全性:4分
稳定性:9分
搜索功能:6分
下载便捷性:9分
下载点评
- 下载快(597+)
- 好评(383+)
- 一般般(535+)
- 二星好评(422+)
- 藏书馆(438+)
- 章节完整(213+)
- 三星好评(349+)
- 无水印(504+)
- 少量广告(390+)
- 小说多(299+)
- 目录完整(418+)
下载评价
网友 孙***夏:中评,比上不足比下有余
网友 沈***松:挺好的,不错
网友 邱***洋:不错,支持的格式很多
网友 訾***晴:挺好的,书籍丰富
网友 印***文:我很喜欢这种风格样式。
网友 师***怡:说的好不如用的好,真心很好。越来越完美
网友 冉***兮:如果满分一百分,我愿意给你99分,剩下一分怕你骄傲
网友 孙***美:加油!支持一下!不错,好用。大家可以去试一下哦
网友 冯***卉:听说内置一千多万的书籍,不知道真假的
网友 焦***山:不错。。。。。
网友 宫***玉:我说完了。
网友 仰***兰:喜欢!很棒!!超级推荐!
网友 习***蓉:品相完美
网友 曹***雯:为什么许多书都找不到?
网友 石***烟:还可以吧,毕竟也是要成本的,付费应该的,更何况下载速度还挺快的