tailieunhanh - Excel 2007 pivot and macro

tài liệu Excel 2007 pivot and macro dành cho sinh viên học sinh muốn tham thêm về công nghệ thông tin | Excel 2007 Pivot Tables Macros CALIFORNIA STATE UNIVERSITY SACRAMENTO WORKSHOP Overview 1 Prerequisites 1 Objectives 1 WHAT IS A PIVOT Sample Example 2 PivotTable Terminology 3 Creating a PivotTable 4 Layout of the PivotTable 5 Pivoting a PivotTable 6 Refreshing a PivotTable 7 Grouping and Ungrouping Data 7 Grouping Numeric Items 8 Grouping Items in Date or Time Ranges 8 Removing Groups 9 Creating a PivotChart 9 EXERCISE 1 11 WHAT IS A MACRO .12 Creating a Macro 15 Run a Macro Without Using Keyboard Shortcuts 17 The VBA Environment 17 Editing a Macro 19 Writing your own Macro using the VB Editor 20 EXERCISE 2 .

TỪ KHÓA LIÊN QUAN