買這商品的人也買了...
-
$2,030$1,929 -
$880$695 -
$550$468 -
$550$435 -
$1,600$1,520 -
$2,010$1,910 -
$600$480 -
$480$379 -
$590$460 -
$1,860$1,767 -
$720$569 -
$1,920$1,824 -
$980$774 -
$450$351 -
$490$387 -
$620$490 -
$480$379 -
$380$323 -
$680$578 -
$650$514 -
$520$411 -
$520$411 -
$680$537 -
$750$593 -
$650$514
相關主題
商品描述
Description
“In this day and age of ‘too much information and not enough time,’ the ability to get to the bottom line quickly and in a concise method is what excels companies to the top of their industry. The techniques in this book will allow you to do things you only dreamt of.”
—Jerry Kohl, president of Brighton Collectibles
Develop your Excel macro programming skills using VBA instantly with proven techniques
Automate Reports
Handle Errors
Master Pivot Tables
Produce Charts
Build User-Defined Functions
Migrate to Excel 2007
Query Web Data
Build Dialog Boxes
Use Data Visualizations
Automate Word
You are an expert in Excel, but the macro recorder doesn’t work and you can’t make heads or tails out of the recorded code. If this is you, buy this book. Macros that you record today might work today but not tomorrow. Recorded macros might handle a dataset with 14 records but not one with 12 or 16 records. These are all common problems with the macro recorder that unfortunately cause too many Excel gurus to turn away from writing macros. This book shows you why the macro recorder fails and the steps needed to convert recorded code into code that will work every day with every dataset. The book assumes that you know Excel well, but there is no need for prior programming experience. This book describes everything you could conceivably need to know to automate reports and design applications in Excel VBA. Whether you want to automate reports for your office or design full-blown applications for others, this book is for you.
Learn VBA syntax as easy-to-understand English Automate Excel’s power tools: Pivot Tables, Charts, Advanced Filters Save hours per week by automating redundant tasks Create applications built on top of Excel with custom dialog boxes Automatically produce hundreds of Excel reports in seconds Understand how changes in Excel 2007 impact your VBA macros
Table of Contents
Introduction 1
1 Unleash the Power of Excel with VBA 7
2 This Sounds Like BASIC, So Why Doesn’t It Look Familiar? 29
3 Referring to Ranges 61
4 User-Defined Functions 75
5 Looping and Flow Control 101
6 R1C1-Style Formulas 121
7 What’s New in Excel 2007 and What's Changed 135
8 Create and Manipulate Names in VBA 143
9 Event Programming 155
10 UserForms--An Introduction 177
11 Creating Charts 197
12 Data Mining with Advanced Filter 249
13 Using VBA to Create Pivot Tables 281
14 Excel Power 337
15 Data Visualizations and Conditional Formatting 373
16 Reading from and Writing to the Web 393
17 XML in Excel 2007 413
18 Automating Word 421
19 Arrays 441
20 Text File Processing 449
21 Using Access as a Back End to Enhance Multi-User Access to Data 461
22 Creating Classes, Records, and Collections 477
23 Advanced UserForm Techniques 493
24 Windows Application Programming Interface (API) 517
25 Handling Errors 529
26 Customizing the Ribbon to Run Macros 543
27 Creating Add-Ins 569
Index 577
商品描述(中文翻譯)
**描述**
“在這個‘資訊過多而時間不足’的時代,快速且簡潔地達到結論的能力是使公司在其行業中脫穎而出的關鍵。本書中的技術將使您能夠實現您曾經夢想過的事情。”
—Jerry Kohl,Brighton Collectibles總裁
立即使用經過驗證的技術來發展您的Excel宏程式設計技能
自動化報告
處理錯誤
掌握樞紐分析表
生成圖表
建立自定義函數
遷移到Excel 2007
查詢網頁數據
建立對話框
使用數據可視化
自動化Word
您是Excel的專家,但宏錄製器無法正常工作,您無法理解錄製的代碼。如果您是這樣的人,請購買本書。您今天錄製的宏可能今天有效,但明天卻不一定。錄製的宏可能能處理14條記錄的數據集,但無法處理12條或16條記錄的數據集。這些都是宏錄製器的常見問題,不幸的是,這使得太多Excel專家放棄編寫宏。本書向您展示了為什麼宏錄製器會失敗,以及將錄製的代碼轉換為能夠每天在每個數據集上運行的代碼所需的步驟。本書假設您對Excel非常熟悉,但不需要有先前的程式設計經驗。本書描述了您可能需要知道的所有內容,以自動化報告和設計Excel VBA應用程序。無論您是想為辦公室自動化報告,還是為他人設計完整的應用程序,本書都適合您。
- 以易於理解的英語學習VBA語法
- 自動化Excel的強大工具:樞紐分析表、圖表、高級篩選
- 通過自動化重複性任務每週節省數小時
- 創建基於Excel的應用程序,並使用自定義對話框
- 在幾秒鐘內自動生成數百個Excel報告
- 理解Excel 2007中的變更如何影響您的VBA宏
**目錄**
引言 1
1 釋放Excel與VBA的力量 7
2 這聽起來像BASIC,為什麼看起來不熟悉? 29
3 引用範圍 61
4 自定義函數 75
5 循環與流程控制 101
6 R1C1風格公式 121
7 Excel 2007中的新功能及變更 135
8 在VBA中創建和操作名稱 143
9 事件編程 155
10 用戶表單——簡介 177
11 創建圖表 197
12 使用高級篩選進行數據挖掘 249
13 使用VBA創建樞紐分析表 281
14 Excel的力量 337
15 數據可視化和條件格式化 373
16 從網絡讀取和寫入 393
17 Excel 2007中的XML 413
18 自動化Word 421
19 陣列 441
20 文本文件處理 449
21 使用Access作為後端以增強多用戶數據訪問 461
22 創建類、記錄和集合 477
23 高級用戶表單技術 493
24 Windows應用程序編程接口(API) 517
25 處理錯誤 529
26 自定義功能區以運行宏 543
27 創建附加元件 569
索引 577