<br /><br /><p><br></p><p>英文版的excel advanced report development，如果有需要可以载下来研究一下，书还是很不错的推荐</p><br><p>Excel® Advanced Report Development</p><p>Timothy Zapawa</p><p><br></p><p>Acknowledgments xv</p><p>Introduction xvi</p><p>Part I Report Initiation and Source Data 1</p><p>Chapter 1 Taking a First Look at Excel’s Reporting Tools 3</p><p>Why Use Excel for Reports? 3</p><p>PivotTable Reports 6</p><p>PivotChart Reports 9</p><p>Spreadsheet Reports 10</p><p>Parameter Queries 13</p><p>Web Queries 14</p><p>Related Office Components 15</p><p>Microsoft MapPoint 16</p><p>Microsoft FrontPage 17</p><p>Microsoft Access 18</p><p>Chapter Review 18</p><p>Chapter 2 Getting Started with PivotTables 19</p><p>PivotTable Data Organization 19</p><p>Creating Your First PivotTable 22</p><p>Modifying the PivotTable 27</p><p>Removing a Field from a PivotTable 27</p><p>Changing the Summary Type 28</p><p>Refreshing Report Data 31</p><p>Drilling Down on Report Data 34</p><p>Basic Components and Terminology 36</p><p>PivotTable Areas 37</p><p>PivotTable Toolbar 42</p><p></p><p>PivotTable Field List 43</p><p>Terminology 45</p><p>Trying It Out in the Real World 45</p><p>Getting Down to Business 46</p><p>Reviewing What You Did 49</p><p>Chapter Review 49</p><p>Chapter 3 Understanding and Accessing Source Data 51</p><p>Characteristics of a Data Source 52</p><p>Types of Data Sources 52</p><p>Data Source Locations 53</p><p>Authenticating to a Data Source 53</p><p>Importing Text Files 53</p><p>Delimited Files 54</p><p>Fixed-Width Files 59</p><p>Creating Data Source Name Files 64</p><p>Creating a Data Source for a Text File 65</p><p>Setting the Directory 67</p><p>Defining the File Format 68</p><p>Supporting Files of Text File DSNs 72</p><p>Creating a Data Source for an SQL Database 75</p><p>Authenticating to the Database 77</p><p>Supporting Files of Database DSNs 81</p><p>Creating a Data Source for an OLAP Cube 82</p><p>Accessing the OLAP Cube 85</p><p>Supporting Files of OLAP Cube DSNs 87</p><p>Viewing the DSN File for an OLAP Cube 88</p><p>Trying It Out in the Real World 88</p><p>Getting Down to Business 89</p><p>Reviewing What You Did 93</p><p>Chapter Review 93</p><p>Chapter 4 Using the Query Wizard 93</p><p>Overview of the Query Wizard 93</p><p>Starting the Wizard 95</p><p>Selecting Objects 96</p><p>Using Table Options for Object Selection 97</p><p>Choosing Fields 99</p><p>Filtering Data 101</p><p>Using the Wizard to Filter Data 102</p><p>Applying Multiple Filters 104</p><p>Mathematical Operators 104</p><p>String Operators 105</p><p>Viewing and Changing Filter Conditions 106</p><p>Sorting Data 106</p><p>Finishing Up 107</p><p>Saving the Query 108</p><p>Viewing a Saved Query 109</p><p></p><p></p><p>Opening a Saved Query 111</p><p>Editing with Microsoft Query 112</p><p>Trying It Out in the Real World 113</p><p>Getting Down to Business 113</p><p>Reviewing What You Did 115</p><p>Chapter Review 116</p><p>Chapter 5 Getting Started with Microsoft Query 117</p><p>Introducing the Microsoft Query Program 118</p><p>Starting Microsoft Query 119</p><p>With New Reports 119</p><p>With Existing Reports 121</p><p>Understanding the Basics 122</p><p>Getting to Know the Environment 123</p><p>Customizing the Environment 131</p><p>Working in the Environment 138</p><p>Trying It Out in the Real World 141</p><p>Getting Down to Business 141</p><p>Reviewing What You Did 143</p><p>Chapter Review 143</p><p>Chapter 6 Working with SQL in Microsoft Query 145</p><p>Managing the SQL Query 145</p><p>Before You Begin 146</p><p>Working in the Select Part of an SQL Query 147</p><p>Working in the Where and Having Parts 156</p><p>Working in the Order By Part 165</p><p>Managing Table Joins 166</p><p>Before You Begin 167</p><p>Understanding Joins and Join Types 170</p><p>Executing SQL Commands 178</p><p>Managing Tables 179</p><p>Understanding How Microsoft Query Uses SQL 180</p><p>Automatic Query Modification 181</p><p>Hiding an SQL Query 182</p><p>Use Brackets instead of Single Quotes 182</p><p>Criteria Incorrectly Put into the Having Clause 184</p><p>Stored Procedures with Input Parameters 184</p><p>Inserting a Stored Procedure 184</p><p>Using Parameters 185</p><p>Accessing Multiple Databases in a Single Session 188</p><p>Multiple Databases on a Single Server 188</p><p>Multiple Databases on Different Servers 189</p><p>Trying It Out in the Real World 191</p><p>Getting Down to Business 191</p><p>Reviewing What You Did 193</p><p>Chapter Review 194</p><p>................</p><p><br></p><p></p><p><br></p><p></p>