| 00 Introduction |
| 1 |
0001 Welcome |
|
2.60 MB |
|
|
| 2 |
0002 Using the exercise files |
|
513.82 KB |
|
|
| 01 Creating and Pivoting PivotTables |
| 3 |
0101 Introducing PivotTables |
|
3.72 MB |
|
|
| 4 |
0102 Formatting data for use in a PivotTable |
|
4.05 MB |
|
|
| 5 |
0103 Creating a PivotTable |
|
3.82 MB |
|
|
| 6 |
0104 Pivoting a PivotTable |
|
3.25 MB |
|
|
| 7 |
0105 Configuring a PivotTable |
|
3.22 MB |
|
|
| 8 |
0106 Connecting to an external data source |
|
3.19 MB |
|
|
| 9 |
0107 Connecting to an Access database |
|
1.97 MB |
|
|
| 10 |
0108 Consolidating data from multiple sources |
|
4.01 MB |
|
|
| 11 |
0109 Updating and refreshing PivotTable data sources |
|
4.17 MB |
|
|
| 12 |
0110 Managing PivotTables |
|
3.14 MB |
|
|
| 02 Summarizing PivotTable Data |
| 13 |
0201 Adding, removing, and positioning subtotals and grand totals |
|
3.14 MB |
|
|
| 14 |
0202 Changing the PivotTable data field summary operation |
|
4.06 MB |
|
|
| 15 |
0203 Summarizing more than one data field |
|
2.85 MB |
|
|
| 16 |
0204 Creating a calculated field |
|
2.18 MB |
|
|
| 17 |
0205 Grouping PivotTable fields |
|
2.61 MB |
|
|
| 18 |
0206 Using PivotTable data in a formula |
|
4.14 MB |
|
|
| 19 |
0207 Drilling down to the underlying data |
|
1.46 MB |
|
|
| 03 Sorting and Filtering PivotTable Data |
| 20 |
0301 Sorting PivotTable data |
|
1.71 MB |
|
|
| 21 |
0302 Creating a custom sort order |
|
3.28 MB |
|
|
| 22 |
0303 Filtering a PivotTable field by selection |
|
2.66 MB |
|
|
| 23 |
0304 Filtering a PivotTable by rule |
|
2.45 MB |
|
|
| 24 |
0305 Filtering a PivotTable using a search filter |
|
2.66 MB |
|
|
| 25 |
0306 Filtering a PivotTable using slicers |
|
3.51 MB |
|
|
| 26 |
0307 Formatting slicers |
|
3.22 MB |
|
|
| 27 |
0308 Filtering a PivotTable with report filter fields |
|
4.17 MB |
|
|
| 28 |
0309 Clearing and reapplying PivotTable filters |
|
1.23 MB |
|
|
| 04 Formatting PivotTables |
| 29 |
0401 Applying a PivotTable style |
|
4.62 MB |
|
|
| 30 |
0402 Creating a PivotTable style |
|
4.46 MB |
|
|
| 31 |
0403 Changing the PivotTable layout |
|
2.84 MB |
|
|
| 32 |
0404 Changing the data field number format |
|
1.69 MB |
|
|
| 05 Applying Conditional Formatting to PivotTables |
| 33 |
0501 Highlighting cells by applying a rule |
|
2.48 MB |
|
|
| 34 |
0502 Highlighting the top or bottom values in a PivotTable |
|
3.00 MB |
|
|
| 35 |
0503 Formatting PivotTable cells using data bars |
|
3.43 MB |
|
|
| 36 |
0504 Formatting PivotTable cells using color scales |
|
3.34 MB |
|
|
| 37 |
0505 Formatting PivotTable cells using icon sets |
|
2.38 MB |
|
|
| 38 |
0506 Editing conditional formatting rules |
|
2.08 MB |
|
|
| 39 |
0507 Controlling how multiple rules are applied |
|
2.98 MB |
|
|
| 40 |
0508 Deleting a conditional formatting rule |
|
1.88 MB |
|
|
| 06 Creating and Manipulating PivotCharts |
| 41 |
0601 Creating a PivotChart |
|
3.06 MB |
|
|
| 42 |
0602 Pivoting a PivotChart |
|
2.67 MB |
|
|
| 43 |
0603 Filtering a PivotChart |
|
2.97 MB |
|
|
| 44 |
0604 Formatting a PivotChart |
|
3.33 MB |
|
|
| 45 |
0605 Changing a PivotChart's layout |
|
2.55 MB |
|
|
| 46 |
0606 Changing a PivotChart's chart type |
|
4.09 MB |
|
|
| 47 |
0607 Adding a trendline to a PivotChart |
|
2.18 MB |
|
|
| 07 Printing PivotTables and PivotCharts |
| 48 |
0701 Printing a PivotTable |
|
3.71 MB |
|
|
| 49 |
0702 Printing each item on its own page |
|
3.08 MB |
|
|
| 50 |
0703 Printing a PivotChart |
|
1.62 MB |
|
|
| 08 Manipulating PivotTables Using Macros |
| 51 |
0801 Recording and reviewing a macro |
|
3.82 MB |
|
|
| 52 |
0802 Running a macro |
|
5.46 MB |
|
|
| 53 |
0803 Creating a simple PivotTable presentation kit |
|
2.97 MB |
|
|
| 09 Getting Started with PowerPivot |
| 54 |
0901 Introducing PowerPivot |
|
2.01 MB |
|
|
| 55 |
0902 Downloading and installing PowerPivot |
|
2.84 MB |
|
|
| 56 |
0903 Importing PowerPivot data |
|
2.90 MB |
|
|
| 57 |
0904 Managing table columns |
|
3.84 MB |
|
|
| 58 |
0905 Adding tables to a PowerPivot model |
|
2.29 MB |
|
|
| 59 |
0906 Creating relationships between tables |
|
4.10 MB |
|
|
| 10 Working with DAX Expressions |
| 60 |
1001 Introducing the DAX language |
|
2.67 MB |
|
|
| 61 |
1002 Using DAX operators |
|
3.85 MB |
|
|
| 62 |
1003 Surveying DAX functions |
|
3.10 MB |
|
|
| 63 |
1004 Adding calculated columns and measures |
|
3.61 MB |
|
|
| 64 |
1005 Using aggregate functions |
|
3.80 MB |
|
|
| 65 |
1006 Using filters in aggregate functions |
|
4.36 MB |
|
|
| 11 Conclusion |
| 66 |
1101 Additional resources |
|
679.81 KB |
|
|
| 12 ZZZ - فایلهای تمرینی |
| 67 |
Ex_Files_Ex2010_Pivot |
|
161.88 MB |
|
|
