OFFICE_办公自动化_计算机类_最新资料_得益网

Office 2007 Business Intelligence

2008-11-10 21:05:26

Extract and analyze mission-critical enterprise data using Microsoft
Office 2007

This authoritative volume is a practical guide to the powerful new
collaborative Business Intelligence tools available in Office 2007.
Using real-world examples and clear explanations, Microsoft Office 2007
Business Intelligence: Reporting, Analysis, and Measurement from the
Desktop shows you how to use Excel, Excel Services, SharePoint, and
PerformancePoint with a wide range of stand-alone and external data in
today's networked office. You will learn how to analyze data and
generate reports, scorecards, and dashboards with the Office tools
you're already using to help you in your everyday work.
- Create Excel PivotTables and PivotCharts and apply Conditional
Formatting
- Convert Excel spreadsheets into Excel Tables with Conditional
Formatting and Charting
- Connect external data to Excel using Office Data Connections and
SharePoint
- Create SharePoint dashboards that display data from multiple sources
- Add Key Performance Indicators and Excel Services reports to your
dashboards
- Harness advanced SQL Server 2005 data analysis tools with the Excel
Data Mining Add-In and Visio Cluster Diagrams
- Generate integrated PerformancePoint Scorecards
目录是：

Excel实战技巧精萃视频教程

2008-11-09 11:47:45

通过对Excel技术论坛上上百万提问的分析与提炼，本书汇集了用户在使用Excel过程中最常见的需求，提供过几百个实例的演示，将Excel高手的过人技巧手把手教给读者，并帮助读者发挥创意，灵活有效地使用Excel来处理工作中遇到的问题。书中介绍的Excel应用技巧覆盖了Excel的各个方面，全书分为7篇30章，内容涉及Excel基本功能、数据分析、函数应用、图表与图形、VBA等，附录中还提供了Excel常用快捷键、常用函数、各种规范与限制的说明等内容，方便读者随时查看。
　　本书内容丰富、图文并茂、可操作性强且便于查阅，能有效帮助读者提高Excel的使用水平，提升工作效率。

中文版Excel.2003实例与技巧

2008-11-06 13:59:04

简介
中文版Excel 2003是美国微软公司发布的Office 2003软件家族中优秀的表格制作软件。本书匠心独具，全面讲解了中文版Excel 2003的基础知识、经典范例和应用技巧。
本书从中文版Excel 2003的基础知识入手，精选了文秘办公实例、家庭理财实例、教学管理实例、财务应用实例及综合应用实例，详细介绍了制作这些实例的具体操作步骤，最后附上60个专业技巧，供读者学习、参考，以使读者能在实际生活与工作当中更方便地使用中文版Excel 2003。
本书内容翔实、图文并茂，采用了由浅入深、实战演练的方式进行讲述，是自学者和培训班的首选教材，同时对于财会人员、家庭理财人员、教学管理人员、电脑办公人员和Office软件的其他用户来说也是一本很有价值的参考书。

目录
第一篇基础知识篇
第1章中文版Excel2003基础知识
第1节中文版Excel2003的新增功能
第2节中文版Excel2003的安装过程
第3节中文版Excel2003的后动与退出
第4节中文版Excel2003工作窗口
第2章中文版Excel2003基本操作
第1节创建工作表
第2节编辑工作表
第3节公式和函数
第4节应用图表
第二篇文秘办公篇
实例1 客户信息管理
实例2 文件档案管理
实例3 会议日程表
实例4 考勤记录
实例5 公司职员业绩表
实例6 组织结构图
实例7 员工档案管理
实例8 员工工资管理
实例9 保护公司数据
实例10 创建和发送书目
实例11 创建传送人名单
第三篇家庭理财篇
第四篇教学管理篇
第五篇财务应用篇
第六篇综合应用篇
第七篇应用技巧篇

Visio 2003 Bible

2008-10-24 23:52:42

* Providing comprehensive coverage of Visio's large feature set for technical and engineering professionals, the book begins with a quick introduction to the intuitive interface
* This book quickly moves into the specialized stencils, shapes, and templates used in software and network design and documentation, engineering disciplines, and project management
* Features strong coverage of Visio's tight integration with other Microsoft Office products and as well as its interoperability with related products from other vendors, including AutoCad
* Explores how users in various fields can customize Visio with add-ons to meet their specific needs
* The author is a structural engineer and Visio user with twenty years of experience in project management

Table of Contents

Part I: Understanding Visio Fundamentals.

Chapter 1: Getting Started with Visio.

Chapter 2: Getting Started with Drawings.

Chapter 3: Working with Visio Files.

Chapter 4: Working with Shapes.

Chapter 5: Connecting Shapes.

Chapter 6: Working with Text.

Chapter 7: Formatting Visio Elements.

Part II: Integrating Visio Drawings.

Chapter 8: Inserting, Linking, and Embedding Objects.

Chapter 9: Importing, Exporting, and Publishing Visio Data to the Web.

Chapter 10: Linking Shapes with Data.

Part III: Using Visio for Office Productivity.

Chapter 11: Collaborating with Others.

Chapter 12: Building Block Diagrams.

Chapter 13: Constructing Charts and Graphs.

Chapter 14: Working with Organization Charts.

Chapter 15: Working with Flowcharts.

Chapter 16: Documenting Business Processes.

Chapter 17: Scheduling Projects with Visio.

Chapter 18: Documenting Brainstorming Sessions.

Part IV: Using Visio in Information Technology.

Chapter 19: Modeling and Documenting Databases.

Chapter 20: Building UML Models.

Chapter 21: Building Software Development Diagrams.

Chapter 22: Mapping Web Sites.

Chapter 23: Creating Network Diagrams.

Part V: Using Visio for Architecture and Engineering.

Chapter 24: Working with Scaled Drawings.

Chapter 25: Creating Scaled Plan Drawings.

Chapter 26: Laying Out Architectural and Engineering Plans.

Chapter 27: Planning Space and Managing Facilities.

Chapter 28: Integrating CAD and Visio.

Chapter 29: Working with Engineering Drawings.

Part VI: Customizing Templates, Stencils, and Shapes.

Chapter 30: Creating and Customizing Templates.

Chapter 31: Creating and Customizing Stencils.

Chapter 32: Creating and Customizing Shapes.

Chapter 33: Customizing Shapes Using ShapeSheets.

Chapter 34: Formatting with Styles.

Chapter 35: Customizing Toolbars and Menus.

Chapter 36: Automating Visio.

Part VII: Quick Reference.

Chapter 37: Installing Visio 2003.

Chapter 38: Visio 2003 Help Resources.

Chapter 39: Additional Resources for Templates and Stencils.

Chapter 40: Keyboard Shortcuts.

Chapter 41: Template and Stencil Reference.

Index.

Word2003图书排版视频教程

2008-10-09 17:05:37

视频教程

EPSON C8000彩色激光打印机粉盒再生拆解图

2008-09-04 11:08:25

EPSON C8000彩色激光打印机粉盒再生拆解图

Sybex.Mastering.VBA.for.Microsoft.Office.2007

2008-08-27 15:00:31

Contents at a Glance
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxxiii
Part 1 ? RecordingMacros and Getting Started with VBA . . . . . . . . . . . . . . . . 1
Chapter 1 ? Recording and Running Macros in the Microsoft Office Applications . . . 3
Chapter 2 ? Getting Started with the Visual Basic Editor . . . . . . . . . . . . . . . . . . . . . . 29
Chapter 3 ? Editing Recorded Macros . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
Chapter 4 ? Creating Code from Scratch in the Visual Basic Editor . . . . . . . . . . . . . . 81
Part 2 ? Learning How to Work With VBA. . . . . . . . . . . . . . . . . . . . . . . . . . 99
Chapter 5 ? Understanding the Essentials of VBA Syntax . . . . . . . . . . . . . . . . . . . . 101
Chapter 6 ? Working with Variables, Constants, and Enumerations . . . . . . . . . . . . 115
Chapter 7 ? Using Array Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135
Chapter 8 ? Finding the Objects, Methods, and Properties You Need . . . . . . . . . . . 155
Part 3 ? Making Decisions and Using Loops and Functions . . . . . . . . . . . . . 177
Chapter 9 ? Using Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179
Chapter 10 ? Creating Your Own Functions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211
Chapter 11 ? Making Decisions in Your Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 227
Chapter 12 ? Using Loops to Repeat Actions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247
Part 4 ? UsingMessage Boxes, Input Boxes, and Dialog Boxes . . . . . . . . . . . 273
Chapter 13 ? Getting User Input with Message Boxes and Input Boxes . . . . . . . . . 275
Chapter 14 ? Creating Simple Custom Dialog Boxes . . . . . . . . . . . . . . . . . . . . . . . . 295
Chapter 15 ? Creating Complex Dialog Boxes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 359
xiv CONTENTS AT A GLANCE
Part 5 ? Creating Effective Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 405
Chapter 16 ? Building Modular Code and Using Classes . . . . . . . . . . . . . . . . . . . . . 407
Chapter 17 ? Debugging Your Code and Handling Errors . . . . . . . . . . . . . . . . . . . . 433
Chapter 18 ? Building Well-Behaved Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 461
Chapter 19 ? Securing Your Code with VBA’s Security Features . . . . . . . . . . . . . . . 475
Part 6 ? Programming the Office Applications . . . . . . . . . . . . . . . . . . . . . . 495
Chapter 20 ? Understanding the Word Object Model and Key Objects . . . . . . . . . . 497
Chapter 21 ? Working with Widely Used Objects in Word . . . . . . . . . . . . . . . . . . . 525
Chapter 22 ? Understanding the Excel Object Model and Key Objects . . . . . . . . . . 555
Chapter 23 ? Working with Widely Used Objects in Excel . . . . . . . . . . . . . . . . . . . . 579
Chapter 24 ? Understanding the PowerPoint Object Model and Key Objects . . . . . 593
Chapter 25 ? Working with Shapes and Running Slide Shows . . . . . . . . . . . . . . . . 613
Chapter 26 ? Understanding the Outlook Object Model and Key Objects . . . . . . . . 633
Chapter 27 ? Working with Events in Outlook . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 655
Chapter 28 ? Understanding the Access Object Model and Key Objects . . . . . . . . . 671
Chapter 29 ? Manipulating the Data in an Access Database via VBA . . . . . . . . . . . 693
Chapter 30 ? Accessing One Application from Another Application . . . . . . . . . . . . 713
Chapter 31 ? Programming the Office 2007 Ribbon . . . . . . . . . . . . . . . . . . . . . . . . . 739
Appendix ? The Bottom Line Solutions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 767
Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 809
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 819

Visual.Microsoft.Office.Excel.2007.Data.Analysis.Jul.2007

2008-08-24 17:03:15

CHAPTER 1: GETTING STARTED . . . . . . . . . . . . . . . . . . . . .2
Introduction to Data Analysis with Excel ..............................................................2
Understanding the Excel Window..........................................................................3
Enter Data ............................................................................................................4
Format Numbers....................................................................................................6
Format Cells ........................................................................................................10
Select Data ..........................................................................................................14
Copy, Cut, and Paste Cells....................................................................................16
Copy with the Office Clipboard ............................................................................18
Insert and Delete Cells ........................................................................................20
Find and Replace ................................................................................................22
Find and Replace Formats ..................................................................................24
CHAPTER 2: CREATING FORMULAS . . . . . . . . . . . . . . . . .26
Understanding Formulas ....................................................................................26
Create Formulas ..................................................................................................28
Edit Formulas ......................................................................................................30
Name Cells and Ranges ......................................................................................32
Define and Display Constants ..............................................................................34
Create Formulas that Include Names....................................................................36
Check Formulas for Errors ..................................................................................38
Trace Precedents and Dependents ........................................................................40
CHAPTER 3: CREATING AND USING FUNCTIONS . . . . . .42
Understanding the Function Wizard ....................................................................42
Round a Number ................................................................................................44
Determine the Nth Largest Value ........................................................................46
Create a Conditional Formula ..............................................................................48
Calculate a Conditional Sum ................................................................................50
Calculate Products and Square Roots ..................................................................52
Look Up Information ..........................................................................................54
Determine the Location of a Value ......................................................................56
Perform Time Calculations ..................................................................................58
Perform Date Calculations....................................................................................60
vii
CHAPTER 4: USING FINANCIAL FUNCTIONS . . . . . . . . . .62
Calculate Future Value ........................................................................................62
Calculate Present Value........................................................................................64
Calculate Loan Payments ....................................................................................66
Calculate Principal or Interest ..............................................................................68
Calculate the Interest Rate ..................................................................................70
Calculate the Internal Rate of Return ..................................................................72
Calculate Straight-Line Depreciation ....................................................................74
Calculate Declining Balance Depreciation ............................................................76
Calculate Double-Declining Balance Depreciation ................................................78
Calculate Sum-of-the-Years-Digits Depreciation ..................................................80
CHAPTER 5: USING STATISTICAL FUNCTIONS
AND TOOLS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .82
Calculate an Average ..........................................................................................82
Calculate the Median or the Mode........................................................................84
Calculate Rank ....................................................................................................86
Calculate Frequency ............................................................................................88
Calculate Variance and Standard Deviation..........................................................90
Find the Correlation ............................................................................................92
Install Excel Add-Ins ..........................................................................................94
Calculate a Moving Average ................................................................................96
Compare Variances ..............................................................................................98
Using the Data Analysis Toolpak to Determine Rank and Percentile ................100
Calculate Descriptive Statistics ..........................................................................102
CHAPTER 6: ORGANIZING WORKSHEET DATA . . . . . . .104
Enter Data with a Form ....................................................................................104
Filter Duplicate Records ....................................................................................106
Perform Simple Sorts and Filters ......................................................................108
Perform Complex Sorts ......................................................................................110
Sort by Cell Color, Font Color, or Icon ................................................................112
Perform Complex Filters ....................................................................................114
Enter Criteria to Find Records............................................................................116
Filter by Multiple Criteria ..................................................................................118
Subtotal Sorted Data..........................................................................................120
Count Filtered Records ......................................................................................122
Define Data as a Table ......................................................................................124
Modify a Table Style ..........................................................................................126
CHAPTER 7: WORKING WITH PIVOTTABLES . . . . . . . . .128
Create a PivotTable ............................................................................................128
Modify PivotTable Data and Layout ..................................................................132
Compute Subtotals and Grand Totals ................................................................134
Create a PivotTable Calculated Field ..................................................................136
Hide Rows or Columns in a PivotTable ..............................................................138
Sort a PivotTable................................................................................................139
Retrieve Values from a PivotTable ....................................................................140
CHAPTER 8: CHARTING DATA . . . . . . . . . . . . . . . . . . . . .142
Create a Chart ....................................................................................................142
Add Chart Details ..............................................................................................144
Change the Chart Type ......................................................................................148
Add a Trendline ................................................................................................150
Add and Remove Chart Data ............................................................................152
Add Error Bars ..................................................................................................154
Create a Histogram ............................................................................................156
Chart Filtered Data ............................................................................................158
Create a PivotChart ............................................................................................160
Create a Combination Chart ..............................................................................162
CHAPTER 9: WORKING WITH EXTERNAL DATA . . . . . .164
Paste Link into Word ........................................................................................164
Embed a Worksheet ..........................................................................................166
Hyperlink a Worksheet ......................................................................................168
Query a Web Site ..............................................................................................170
Import a Text File ..............................................................................................172
Import an Access Database................................................................................176
Query an Access Database ................................................................................178
viii
TABLE OF CONTENTS
ix
CHAPTER 10: USEFUL DATA ANALYSIS TOOLS
AND TECHNIQUES . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .182
Perform What-If Analysis ..................................................................................182
Optimize a Result with Goal Seek ......................................................................184
Solve a Formula with a Data Table ....................................................................186
Extend a Series with AutoFill ............................................................................188
Work with Multiple Windows ............................................................................190
Let Excel Read Back Your Data..........................................................................192
Add a Calculator ................................................................................................193
Change Text to Numbers....................................................................................194
Convert a Row to a Column ..............................................................................195
Consolidate Worksheets ....................................................................................196
Conditionally Format Your Worksheet ..............................................................198
Change Conditional Formatting Rules................................................................200
Paste with Paste Special ....................................................................................202
Insert Photographs into Your Worksheet ..........................................................206
CHAPTER 11: SHARING YOUR WORKBOOK
WITH OTHERS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .208
Validate with a Validation List ..........................................................................208
Validate with Data Entry Rules ..........................................................................210
Add Comments to Your Worksheet ....................................................................212
Track Changes ..................................................................................................214
Protect Your Worksheet ....................................................................................216
Save Your Workbook as a Template ..................................................................218
Choose a Format When Saving a Workbook......................................................220
Print Your Workbook ........................................................................................222
Print Multiple Areas of Your Worksheet ............................................................226
Add a Form Control to a Worksheet ..................................................................228
Assign Values to a Form Control ......................................................................230
Add a Macro to a Form Control..........................................................................232
CHAPTER 12: AUTOMATING WITH MACROS . . . . . . . . .234
Introducing Macros............................................................................................234
Set Macro Security ............................................................................................236
Create a Digital Signature ..................................................................................237
Record a Macro..................................................................................................238
Assign a Digital Signature to a Macro ..............................................................240
Run a Macro......................................................................................................242
Create and Launch a Keyboard Shortcut............................................................244
Assign a Macro to the Quick Access Toolbar ....................................................246
Delete a Macro ..................................................................................................248
APPENDIX A: EXCEL KEYBOARD SHORTCUTS . . . . . . . .250
APPENDIX B: EXCEL FUNCTION
QUICK REFERENCE . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .256
APPENDIX C: FORMULA BASICS . . . . . . . . . . . . . . . . . . .272
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .276

OReilly.Excel.Hacks.2nd.Edition.Jun.2007

2008-08-08 18:02:34

Contents
Credits . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Chapter 1. Reducing Workbook and Worksheet Frustration . . . . . . . . . . . . . 1
1. Create a Personal View of Your Workbooks 5
2. Enter Data into Multiple Worksheets Simultaneously 8
3. Prevent Users from Performing Certain Actions 11
4. Prevent Seemingly Unnecessary Prompts 15
5. Hide Worksheets So That They Cannot Be Unhidden 19
6. Customize the Templates Dialog and Default Workbook 21
7. Create an Index of Sheets in Your Workbook 23
8. Limit the Scrolling Range of Your Worksheet 26
9. Lock and Protect Cells Containing Formulas 30
10. Find Duplicate Data Using Conditional Formatting 34
11. Find Data That Appears Two or More Times Using Conditional
Formatting 35
12. Tie Custom Toolbars to a Particular Workbook 36
13. Outsmart Excel’s Relative Reference Handler 38
14. Remove Phantom Workbook Links 39
15. Reduce Workbook Bloat 42
16. Extract Data from a Corrupt Workbook 45
Chapter 2. Hacking Excel’s Built-in Features . . . . . . . . . . . . . . . . . . . . . . . . . 48
17. Validate Data Based on a List on Another Worksheet 48
18. Control Conditional Formatting with Checkboxes 50
viii | Contents
19. Identify Formulas with Conditional Formatting 54
20. Count or Sum Cells That Meet Conditional Formatting Criteria 56
21. Highlight Every Other Row or Column 58
22. Create 3-D Effects in Tables or Cells 60
23. Turn Conditional Formatting and Data Validation On and Off
with a Checkbox 62
24. Support Multiple Lists in a ComboBox 64
25. Create Validation Lists That Change Based on a Selection from
Another List 66
26. Use Replace... to Remove Unwanted Characters 68
27. Convert Text Numbers to Real Numbers 68
28. Extract the Numeric Portion of a Cell Entry 70
29. Customize Cell Comments 71
30. Sort by More Than Three Columns 73
31. Random Sorting 74
32. Manipulate Data with the Advanced Filter 75
33. Create Custom Number Formats 79
34. Add More Levels of Undo to Excel for Windows 84
35. Create Custom Lists 84
36. Boldface Excel Subtotals 85
37. Convert Excel Formulas and Functions to Values 89
38. Automatically Add Data to a Validation List 91
39. Hack Excel’s Date and Time Features 94
40. Enable Grouping and Outlining on a Protected Worksheet 98
41. Prevent Blanks/Missing Fields in a Table 100
42. Provide Decreasing Data Validation Lists 101
43. Add a Custom List to the Fill Handle 102
Chapter 3. Naming Hacks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
44. Address Data by Name 105
45. Use the Same Name for Ranges on Different Worksheets 106
46. Create Custom Functions Using Names 108
47. Create Ranges That Expand and Contract 112
48. Nest Dynamic Ranges for Maximum Flexibility 118
49. Identify Named Ranges on a Worksheet 121
Contents | ix
Chapter 4. Hacking PivotTables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124
50. PivotTables: A Hack in Themselves 124
51. Share PivotTables but Not Their Data 129
52. Automate PivotTable Creation 131
53. Move PivotTable Grand Totals 135
54. Efficiently Pivot Another Workbook’s Data 137
Chapter 5. Charting Hacks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140
55. Explode a Single Slice from a Pie Chart 140
56. Create Two Sets of Slices in One Pie Chart 142
57. Create Charts That Adjust to Data 144
58. Interact with Your Charts Using Custom Controls 148
59. Four Quick Ways to Update Your Charts 152
60. Hack Together a Simple Thermometer Chart 157
61. Create a Column Chart with Variable Widths and Heights 160
62. Create a Speedometer Chart 164
63. Link Chart Text Elements to a Cell 171
64. Hack Chart Data So That Empty or FALSE Formula Cells Are
Not Plotted 173
65. Add a Directional Arrow to the End of a Line Series 175
66. Place an Arrow on the End of a Horizontal (X) Axis 177
67. Correct Narrow Columns When Using Dates 180
68. Position Axis Labels 181
69. Tornado Chart 184
70. Gauge Chart 186
71. Conditional Highlighting Axis Labels 188
72. Create Totals on a Stacked Column Chart 190
Chapter 6. Hacking Formulas and Functions . . . . . . . . . . . . . . . . . . . . . . . . 193
73. Add Descriptive Text to Your Formulas 193
74. Move Relative Formulas Without Changing References 194
75. Compare Two Excel Ranges 195
76. Fill All Blank Cells in a List 197
77. Make Your Formulas Increment by Rows When You Copy
Across Columns 199
78. Convert Dates to Excel Formatted Dates 202
x | Contents
79. Sum or Count Cells While Avoiding Error Values 203
80. Reduce the Impact of Volatile Functions on Recalculation 205
81. Count Only One Instance of Each Entry in a List 206
82. Sum Every Second, Third, or Nth Row or Cell 208
83. Find the Nth Occurrence of a Value 210
84. Make the Excel Subtotal Function Dynamic 212
85. Add Date Extensions 214
86. Convert Numbers with the Negative Sign on the Right
to Excel Numbers 215
87. Display Negative Time Values 217
88. Use the VLOOKUP Function Across Multiple Tables 219
89. Show Total Time As Days, Hours, and Minutes 221
90. Determine the Number of Specified Days in Any Month 222
91. Construct Mega-Formulas 224
92. Hack Mega-Formulas that Reference Other Workbooks 226
93. Hack One of Excel’s Database Functions to Take the Place
of Many Functions 227
94. Extract Specified Words from a Text String 233
95. Count Words in a Cell or Range of Cells 234
96. Return a Worksheet Name to a Cell 236
97. Sum Cells with Multiple Criteria 239
98. Count Cells with Multiple Criteria 243
99. Calculate a Sliding Tax Scale 246
100. Add/Subtract Months from a Date 251
101. Find the Last Day of Any Given Month 253
102. Calculate a Person’s Age 255
103. Return the Weekday of a Date 256
104. Evaluate a Text Equation 258
105. Lookup from Within a Cell 259
Chapter 7. Macro Hacks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263
106. Speed Up Code While Halting Screen Flicker 263
107. Run a Macro at a Set Time 264
108. Use CodeNames to Reference Sheets in Excel Workbooks 266
109. Connect Buttons to Macros Easily 267
110. Create a Workbook Splash Screen 268
Contents | xi
111. Display a “Please Wait” Message 270
112. Have a Cell Ticked or Unticked upon Selection 271
113. Count or Sum Cells That Have a Specified Fill Color 273
114. Add the Microsoft Excel Calendar Control to Any Excel
Workbook 274
115. Password-Protect and Unprotect All Excel Worksheets
in One Fell Swoop 276
116. Retrieve a Workbook’s Name and Path 279
117. Get Around Excel’s Three-Criteria Limit for Conditional
Formatting 280
118. Run Procedures on Protected Worksheets 282
119. Distribute Macros 283
120. Delete Rows Based on a Condition 289
121. Track and Report Changes in Excel 293
122. Automatically Add Date/Time to a Cell upon Entry 297
123. Create a List of Workbook Hyperlinks 298
124. Advanced Find 300
125. Find a Number Between Two Numbers 306
126. Convert Formula References from Relative to Absolute 310
127. Name a Workbook with the Text in a Cell 315
128. Hide and Restore Toolbars in Excel 316
129. Sort Worksheets 319
130. Password-Protect a Worksheet from Viewing 320
131. Change Text to Upper- or Proper Case 322
132. Force Text to Upper- or Proper Case 324
133. Prevent Case Sensitivity in VBA Code 328
134. Display AutoFilter Criteria 329
Chapter 8. Cross-Application Hacks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331
135. Import Data from Access 2007 into Excel 2007 331
136. Retrieve Data from Closed Workbooks 336
137. Automate Word from Excel

Microsoft Word 2003 标准教程

2008-07-02 09:25:44

WORD 2003是微软公司推出的大型办公软件OFFICE 2003中的重要而独立组成部分，也是目前市场上最流行的办公应用软件之一。

　　本书从实用的角度出发，通俗地讲解了WORD 2003的使用方法和技巧。全书共分为10章，内容涵盖了WORD 2003的主要功能。本书不但是微软授权培训中心的统编教材，同时也可以作为各类计算机培训班的培训教材，大，中专院校非计算机专业学生的参考资料。
http://www.VeryCD.com/members/@u318176/
目录

第一章了解WORD 2003
第二章利用WORD 2003书写通知
第三章利用表格功能制作简历
第四章利用图文混排制作贺卡
第五章让文档版面变得更加美观
第六章利用模板和样式快速修饰文档
第七章长文档的处理技巧
第八章利用邮件合并制作通信信封
第九章其他常用的功能
第十章分工协作修订文档

Excel 2000 从入门到精通

2008-06-17 03:45:36

Excel 作为Microsoft Office套件产品中的旗般，几经考验与更新，已日趋成熟。而今，Excel 2000用它大量的改进和新增加功能，如改进的用户定制功能，方便的HTML转换，新的Internet和报告功能，新的数据分析工具等，更是开创了新的通往千年之路。本书分成多个部分，如：第一部分Excel 2000入门；第二部分工作表；第三部分函数等等。其中的内容包括：Excel 环境、管理文件、使用窗口和工作簿、工作表基础、输入和编辑数据、格式化工作表、排版与打印等等。

Microsoft Office Excel 2007 Data Analysis (Office 2007 数据分析)

2008-06-14 03:18:50

Welcome to the only guidebook series that takes a visual approach to
professional-level computer topics. Open the book and you'll discover
step-by-step screen shots that demonstrate over 110 Excel data analysis
techniques, including:

* Identifying trends in your data
* Sorting, filtering, and identifying lists
* Creating, editing, and checking formulas
* Calculating interest rates and depreciation
* Performing simple sorts and filters
* Hiding rows or columns in a PivotTable
* Adding and removing chart data
* Querying an Access database
* Assigning digital signatures
* Solving a formula with a data table

http://www.amazon.com/exec/obidos/tg/detail/-/0470132299/

Recommended Sites

o Computer Rentals

Friends

o Free Stock Photos
o Free eBooks Download
*

Categories
o Business and Investing
o Certification Central
o Database
o Game
o Graphic Design
o Hardware
o Internet
o Microsoft
o Networking
o Operating System
o Other
o Professional and Technical
o Programming
o Software
o Web Development
o
o Magazine

Microsoft Office Excel 2007 Programming(Office 2007 程序设计)

2008-06-14 03:11:48

Microsoft? Office Excel? 2007 Programming Welcome to the only guidebook
series that takes a visual approach to professional-level computer
topics. Open the book and you'll discover step-by-step screen shots that
demonstrate over 140 key Excel programming techniques, including:
- Assigning digital signatures to macros
- Setting properties for a project
- Assigning values to a variable
- Changing the properties of an object
- Formatting a numeric expression
- Processing a runtime error
- Saving worksheets to another file
- Displaying a built-in dialog box
- Creating custom Ribbon tabs
- Building and debugging add-ins Extra Apply It
- "Apply It" and "Extra" sidebars highlight useful tips
- High-resolution screen shots demonstrate each task
- Succinct explanations walk you through step by step
- Two-page lessons break big topics into bite-sized modules

Microsoft Office Excel 2007: Top 100 Simplified Tips & Tricks(Office 2007 100个提示与技巧)

2008-06-14 03:05:33

Microsoft Office Excel 2007: Top 100 Simplified Tips & Tricks (c) by
Wiley

The type of the release is: eBook
In the PDF format with ISBN: 0470126744 and Pub Date: July 23, 2007
The size of the release is: 06 disks x 5.00mb
And released on: 06/03/2008

You already know Excel 2007. Now you'd like to go beyond with shortcuts,
tricks, and tips that let you work smarter and faster. And because you
learn more easily when someone shows you how, this is the book for you.
Inside, you'll find clear, illustrated instructions for 100 tasks that
reveal cool secrets, teach timesaving tricks, and explain great tips
guaranteedto make you more productive with Excel 2007.

* Minimal text and maximum illustrations
* Task-oriented, step-by-step approach
* Navigational aids connect instructions to illustrations
* Self-contained, two-page lessons
* Uniform layout makes it easy to read less, learn more How easy is
it?
* Look for these symbols marking the difficulty of each task.
* Demonstrates a new spin on a common task
* Introduces a new skill or a new task
* Combines multiple skills requiring in-depth knowledge
* Requires extensive skill and may involve other technologies

Microsoft Exchange Server 2003 Deployment and Migration

2008-05-20 17:01:14

Editorial Reviews

Review
"Clearly the topic of migration and deployment is in Kieran's sweet spot. The entire topic is like a fastball floating right down the middle for him because he absolutely hits a home run in this book. He doesn't just talk about what different components are involved with migration and deployment, he describes how everything works and why you might take different approaches in your deployment. It's right on the money!" Donald Livengood,
Senior Solution Architect (MCSE, MVP, HP Certified Architect), Hewlett-Packard Company

"In his new book, Kieran outlines clear, concise, and crisp guidelines for migration and deployment of Exchange messaging systems. Armed with this generally hard to find knowledge, you'll be prepared for most Exchange 2003 implementation projects. His principles have been well used in the past-not least for the implementation of a 350,000 user Exchange system in my own organization." Roy Beattie, Messaging and Integration Director, NI Schools C2k Project

"Kieran has been working with us since 1999, originally on the AstraZeneca merger work and more recently on our Exchange 2003 project. This book demonstrates Kierans expertise in deployment and migration and is particularly strong on Directory Synchronization, which is a fundamental component of a migration from Exchange 5.5 to 2003. Youll get quite the level of detail that you need, presented in a format that is easily digestible in this work." -- Dave Cook, Global Messaging Architect, Astra Zeneca Healthcare

Product Description
Microsoft? Exchange Server 2003 Deployment and Migration describes everything that you need to know about designing, planning, and implementing an Exchange 2003 environment. The book discusses the requisite infrastructure requirements of Windows 2000 and Windows 2003. Furthermore, this book covers, in detail, the tools and techniques that messaging system planners and administrators will require in order to establish a functioning interoperability environment between Exchange 2003 and previous versions of Exchange including Exchange 5.5 and Exchange 2000. Since Microsoft will drop support for Exchange 5.5 in 2004, users will have to migrate to Exchange 2003. Additionally the book describes various deployment topologies and environments to cater for a multitude of different organizational requirements.

* Details for consultants and system administrators to migrate from older versions of Exchange 5.5 and Exchange 2000
* Critical information on integration with Outlook 2003 and Windows 2003
* Based on actual implementations of both beta and final release versions of Exchange 2003 in larger enterprise environments

Contents
Foreword xiii
Preface xv
What is This Book about? xvi
Intended Audience xvii
Acknowledgments xix
1 Exchange 2003 Deployment Fundamentals 1
1.1 Introduction 1
1.2 Windows 2000/Windows 2003 Refresher 2
1.3 Exchange 2003 and Its Relationship to the Forest 5
1.4 The Importance of Domain Controllers and Global Catalog Servers 6
1.5 Choosing an Appropriate Domain Model 17
1.6 Universal Security Groups and Windows Domain Mixed-Mode Membership 19
1.7 Token Augmentation 19
1.8 Exchange 2003 Installation Requirements 20
1.9 Exchange System Manager on Windows XP 24
1.10 Exchange 2003 and Internet Information Services 6.0 25
1.11 Exchange 2003 Installation Improvements 26
1.12 Preparing and Planning for Deployment 28
1.13 DCDiag and NetDiag Utilities 29
1.14 Preparing Windows 2003 Domains for Exchange 2003 31
1.15 Installing Exchange 2000 36
1.16 Summary 37
2 Active Directory Connector Synchronization 39
2.1 Introduction 39
2.2 Active Directory Connector Core Technology Description 40
2.3 Connection Agreements 45
2.4 Active Directory Connector Schema Modifications 50
2.5 Determining Which Directory Objects to Synchronize 52
2.6 Active Directory Connector Block Searching 53
2.7 How the Active Directory Connector Uses the Active Directory 54
2.8 Mailbox-enabled and Mail-enabled Objects 55
2.9 Object Class Mapping from Exchange 5.5 to the Active Directory 55
2.10 Object Class Mapping from the Active Directory to Exchange 5.5 58
2.11 Synchronizing Hidden Objects 60
2.12 Dealing with Hidden Distribution List Membership 60
2.13 Object Deletion 61
2.14 Connection Agreements and Authentication 62
2.15 Controlling the Synchronization Schedule 65
2.16 Connection Agreement Advanced Parameters 67
2.17 Exchange 5.5 Mailboxes and Multiple Windows NT Accounts 71
2.18 Mailbox Delegate Access 72
2.19 Troubleshooting Active Directory Connector Synchronization Problems 74
2.20 The New Exchange 2003 Active Directory Connector Features 77
2.21 Summary 78
3 Advanced Active Directory Connector Configuration 79
3.1 Introduction 79
3.2 Default Object-Matching Behavior 80
3.3 How the Active Directory Connector Uses LDAP 81
3.4 Using a Customized LDAP Search Filter 82
3.5 Understanding LDAP Search Filters 82
3.6 Setting an LDAP Search Filter on a Connection Agreement 83
3.7 Default Active Directory Connector Object-Matching Behavior 84
3.8 Using Custom Object-Matching Rules on the Active Directory Connector 87
3.9 The NTDSNoMatch Utility 92
3.10 Summarizing Object-Matching Behavior 93
3.11 Introduction to Attribute Mapping 94
3.12 Default Attribute Mapping Behavior 94
3.13 Moving Beyond the Schema Mapping GUI 95
3.14 Active Directory Distinguished Name Mapping with the Exchange 2000
Active Directory Connector 102
3.15 Distinguished Name Mapping with the Exchange 2003 Active
Directory Connector 104
3.16 Exchange 5.5 and LDAP Names 104
3.17 Attribute Mapping Rule Syntax 105
3.18 Summary 107
4 The Site Replication Service 109
4.1 Introduction 109
4.2 Positioning the Site Replication Service and the Active Directory Connector 109
4.3 Components that Comprise the Site Replication Service 110
4.4 The Site Replication Service in Intrasite Replication Operation 111
4.5 The Site Replication Service in Intersite Replication Operation 114
4.6 What Takes Place during a Bridgehead Server Upgrade? 116
4.7 Site Replication Service Management 117
4.8 Site Replication Service Preference 119
4.9 Summary 120
5 Public Folder Interoperability and Migration 123
5.1 Introduction 123
5.2 Public Folder Connection Agreements 123
5.3 Configuring Public Folder Connection Agreements 125
5.4 Public Folder Permissions 127
5.5 Exchange 5.5 and Exchange 2003 Public Folder Replication 128
5.6 Permission Handling during Mixed-Version Replication 130
5.7 Dealing with Zombie Users 132
5.8 Exchange 5.5 Distribution Lists and Access Control Lists 134
5.9 Public Folder Deployment Guidelines 135
5.10 Planning and Understanding Public Folder Topologies 136
5.11 Reintroducing Public Folder Affinity 137
5.12 Getting Ready to Migrate Public Folders 139
5.13 Moving User and System Public Folder Content 140
5.14 Using the Public Folder Migration Tool 142
5.15 Summary 143
6 Deployment and Interoperability Guidelines for the Active
Directory Connector 145
6.1 Introduction 145
6.2 Why Native-Mode Windows 2000 or Windows 2003 Domains Are Best 145
6.3 Scenarios that Require Multiple Connection Agreements 147
6.4 Container Hierarchy Mapping 149
6.5 Moving Synchronized Objects between Containers 150
6.6 Using Multiple Active Directory Connectors 151
6.7 Exchange 5.5 Back-Replication 152
6.8 Connection Agreement Deployment Models 154
6.9 Deploying Active Directory Connectors 163
6.10 Network Impact from Active Directory Connector Synchronization 165
6.11 Summary 167
7 Moving from Exchange 5.5 to Exchange 2003 169
7.1 Introduction 169
7.2 Exchange 5.5 Migration Fundamentals 169
7.3 Making a Clean Break from Exchange 5.5 171
7.4 Exchange 5.5 Migration Terminology Refresher 172
7.5 The Importance of sID History During Exchange 5.5 Migration 173
7.6 Exchange 5.5, Windows Migrations, and the ClonePrincipal Toolkit 174
7.7 Requirements for Writeable Access to sIDHistory 175
7.8 Running Exchange 5.5 on Windows 2000 Servers 176
7.9 Exchange 5.5 to Exchange 2003 Migration Approaches 177
7.10 Active Directory Account Domain Cleanup Wizard 200
7.11 Summary 210
8 Moving from Exchange 2000 to Exchange 2003 211
8.1 Introduction 211
8.2 Exchange 2000 to Exchange 2003 Migration Approaches 211
8.3 Mixed Exchange 5.5/Exchange 2000 migrations to Exchange 2003 216
8.4 The Exchange 2003 Move Mailbox Wizard 217
8.5 Summary 227
9 Interorganization Migrations 229
9.1 Introduction 229
9.2 Deciding on an Interorganization Migration Approach 229
9.3 Using the Exchange Server Migration Wizard 230
9.4 Partial Organization Migrations 235
9.5 Third-Party Tool Approach to Interorganization Migration 241
9.6 Summary 262
10 Deploying Exchange for External Access 265
10.1 Introduction 265
10.2 Using Exchange 2003 Front-End Servers in the DMZ 265
10.3 Exchange, DSAccess, and Firewalls 267
10.4 Should You Allow RPCs across Your DMZ? 269
10.5 Generalized Internal-Facing Firewall Requirements 270
10.6 Outlook Web Access Security Issues 271
10.7 Secure Architectural Alternative 272
10.8 Tunneling and Bridging 274
10.9 Putting Components into Practice 274
10.10 Using Microsoft ISA Server with OWA 275
10.11 Using a Hardware-Based SSL/TLS Proxy Server with OWA 278
10.12 Back-End Encryption 279
10.13 Understanding OWA, Authentication, Front-End Servers, and Redirection 281
10.14 Implementing Outlook RPC over HTTP 288
10.15 Summary 299
A Lists of Events Generated by the Active Directory Connector 301
B Connection Agreement Attributes 353
C Active Directory Connector Registry Keys 363
Index 365

Microsoft Office2000 VBA Fundamentals

2008-05-20 16:27:03

Introduction
Creating documents, building databases, and writing e-mail are just some of the things you can do with Microsoft Office 2000. But Office 2000 also gives you a way to do these and other tasks, as well as extend built-in functionality, through Microsoft Visual Basic programming. This book shows you how to develop the Visual Basic code that will let your Visual Basic programs automate tasks, tie content together, extend existing functionality, and develop new functionality for Office applications through COM add-ins. You'll learn how to take features beyond their original design in order to meet the needs of your customers or your company.

Microsoft Office 2000 Visual Basic for Applications Fundamentals is organized by task rather than by application. For example, the task of retrieving the current selection in the Microsoft Word, Microsoft Excel, Microsoft PowerPoint, and Microsoft Outlook applications is discussed in one place. The same goes for saving Word, Excel, or PowerPoint documents. Whether you need to develop code that accomplishes a task in any single application or in all of them, you will understand the similarities and differences among the applications. The side-by-side comparisons and code samples give you a way of learning how to write code to accomplish the same task in several Office applications.

Contents

Acknowledgments xi
Introduction xiii

Part 1 Learning Microsoft Visual Basic for Applications
Ch1.Microsoft Office/Visual Basic for Applications Overview 3
Ch2.The Fundamentals of Writing Visual Basic Code 39
Ch3.Creating Custom Dialog Boxes 65

Part 2 Managing Documents and Files and Manipulating Document Content
Ch4.Creating and Managing Files and Documents 107
Ch5.Managing Documents with Events 153
Ch6.Inserting and Manipulating Content 183

Part 3 Working Across Applications
Ch7.Communicating Across Microsoft Office 233
Ch8.Developing an Integrated Office Solution 257

Part 4 Working with Active Window Content
Ch9.Retrieving and Setting Active Content 289
Ch10.Handling Window and Content Interaction Events 317

Part 5 Customizing the User interface
Ch11.Creating Menus and Toolbars 357
Ch12.Working with the Office Assistant 397

Part 6 Developing COM Add-Ins for Office
Ch13.Developing COM Add-Ins 425
Ch14.Inside COM Add-Ins 457

Index 495