00 Introduction |
1 |
0001 Welcome |
|
3.69 MB |
|
|
2 |
0002 Using the exercise files |
|
487.81 KB |
|
|
01 Getting Started with Excel |
3 |
0101 Exploring the Excel 2011 window |
|
3.58 MB |
|
|
4 |
0102 Introducing the Ribbon for Mac |
|
4.25 MB |
|
|
5 |
0103 Customizing the Ribbon |
|
3.81 MB |
|
|
6 |
0104 Setting program preferences |
|
3.04 MB |
|
|
7 |
0105 Getting help in Excel |
|
4.70 MB |
|
|
02 Managing Workbooks |
8 |
0201 Opening creating and saving workbooks |
|
4.71 MB |
|
|
9 |
0202 Setting workbook properties |
|
3.60 MB |
|
|
10 |
0203 Creating and modifying workbook templates |
|
3.59 MB |
|
|
11 |
0204 Managing workbooks across multiple versions of Excel |
|
5.92 MB |
|
|
03 Managing Worksheets Cells and Cell Data |
12 |
0301 Selecting cells and groups of cells |
|
4.17 MB |
|
|
13 |
0302 Copying and pasting cell data |
|
2.24 MB |
|
|
14 |
0303 Entering data using AutoFill and other techniques |
|
3.50 MB |
|
|
15 |
0304 Entering data using AutoFill and other techniques |
|
4.54 MB |
|
|
16 |
0305 Creating an Excel table |
|
3.94 MB |
|
|
17 |
0306 Locating and changing data using Find and Replace |
|
3.92 MB |
|
|
18 |
0307 Restricting input using validation rules |
|
3.59 MB |
|
|
19 |
0308 Using lists to limit data entered into a cell |
|
2.01 MB |
|
|
20 |
0309 Sorting worksheet data |
|
2.48 MB |
|
|
21 |
0310 Creating a custom sort order |
|
3.22 MB |
|
|
22 |
0311 Filtering worksheet data |
|
3.16 MB |
|
|
23 |
0312 Inserting moving and deleting cells and cell ranges |
|
3.05 MB |
|
|
24 |
0313 Splitting and freezing rows and columns |
|
3.60 MB |
|
|
25 |
0314 Managing worksheets |
|
6.73 MB |
|
|
26 |
0315 Creating editing and deleting headers and footers |
|
4.11 MB |
|
|
04 Summarizing Data Using Formulas and Functions |
27 |
0401 Introducing Excel formulas and functions |
|
2.79 MB |
|
|
28 |
0402 Adding a formula to a cell |
|
3.16 MB |
|
|
29 |
0403 Introducing arithmetic operators |
|
3.29 MB |
|
|
30 |
0404 Using absolute and relative cell references |
|
5.41 MB |
|
|
31 |
0405 Controlling how Excel copies and pastes formulas |
|
4.68 MB |
|
|
32 |
0406 Referring to Excel table data in formulas |
|
1.76 MB |
|
|
33 |
0407 Creating an AutoSum formula |
|
2.80 MB |
|
|
34 |
0408 Summarizing data on the status bar |
|
1.89 MB |
|
|
35 |
0409 Joining text in cells with concatenation |
|
2.98 MB |
|
|
36 |
0410 Summarizing data using an IF function |
|
4.70 MB |
|
|
37 |
0411 Summarizing data using SUMIF and other conditional functions |
|
4.41 MB |
|
|
38 |
0412 Creating formulas to count cells |
|
2.00 MB |
|
|
39 |
0413 Rounding cell values up and down |
|
3.61 MB |
|
|
40 |
0414 Finding data using VLOOKUP and HLOOKUP |
|
4.93 MB |
|
|
41 |
0415 Auditing formulas by identifying precedents and dependents |
|
2.68 MB |
|
|
42 |
0416 Managing Excel formula error indicators |
|
5.41 MB |
|
|
43 |
0417 Managing scenarios |
|
3.76 MB |
|
|
44 |
0418 Performing Goal Seek analysis |
|
2.42 MB |
|
|
05 Formatting Worksheet Elements |
45 |
0501 Applying fonts background colors and borders |
|
5.53 MB |
|
|
46 |
0502 Applying number and date formats to cells |
|
5.45 MB |
|
|
47 |
0503 Managing text alignment |
|
3.08 MB |
|
|
48 |
0504 Copying cell formats |
|
3.27 MB |
|
|
49 |
0505 Managing cell styles |
|
2.89 MB |
|
|
50 |
0506 Managing Office themes |
|
4.17 MB |
|
|
51 |
0507 Creating rule-based conditional formats |
|
3.21 MB |
|
|
52 |
0508 Defining Top 10 conditional formats |
|
3.27 MB |
|
|
53 |
0509 Defining data bar color scale and icon set conditional formats |
|
5.44 MB |
|
|
54 |
0510 Editing ordering and deleting conditional formats |
|
3.22 MB |
|
|
06 Working with Charts |
55 |
0601 Creating bar and column charts |
|
4.65 MB |
|
|
56 |
0602 Creating pie charts |
|
2.03 MB |
|
|
57 |
0603 Creating line charts |
|
3.98 MB |
|
|
58 |
0604 Creating XY scatter charts |
|
1.38 MB |
|
|
59 |
0605 Creating stock charts |
|
3.29 MB |
|
|
60 |
0606 Changing chart types and layouts |
|
1.83 MB |
|
|
61 |
0607 Changing the appearance of a chart |
|
3.68 MB |
|
|
62 |
0608 Managing chart axes and numbering |
|
2.33 MB |
|
|
63 |
0609 Adding trendlines to charts |
|
3.42 MB |
|
|
64 |
0610 Creating sparkline charts |
|
3.85 MB |
|
|
07 Working with External Data |
65 |
0701 Importing data from comma separated value CSV or text files |
|
3.69 MB |
|
|
66 |
0702 Connecting to an external data source |
|
1.92 MB |
|
|
67 |
0703 Using hyperlinks |
|
5.67 MB |
|
|
68 |
0704 Including an Excel workbook in another Office document |
|
2.61 MB |
|
|
69 |
0705 Linking to an Excel chart from another Office program |
|
2.41 MB |
|
|
08 Working with Objects |
70 |
0801 Creating and formatting shapes |
|
2.57 MB |
|
|
71 |
0802 Adding and adjusting images |
|
5.44 MB |
|
|
72 |
0803 Cropping compressing and removing image backgrounds |
|
4.34 MB |
|
|
73 |
0804 Creating SmartArt graphics |
|
4.00 MB |
|
|
74 |
0805 Creating WordArt |
|
2.10 MB |
|
|
75 |
0806 Aligning and layering objects |
|
4.63 MB |
|
|
09 Exploring PivotTable Reports |
76 |
0901 Exploring PivotTable Reports |
|
3.51 MB |
|
|
77 |
0902 Creating a PivotTable report |
|
3.82 MB |
|
|
78 |
0903 Pivoting a PivotTable report |
|
3.38 MB |
|
|
79 |
0904 Managing subtotals and grand totals |
|
2.96 MB |
|
|
80 |
0905 Summarizing more than one data field |
|
1.38 MB |
|
|
81 |
0906 Changing the data field summary operation |
|
2.24 MB |
|
|
82 |
0907 Changing the data field number format |
|
1.98 MB |
|
|
83 |
0908 Filtering a PivotTable report |
|
2.32 MB |
|
|
84 |
0909 Applying a PivotTable style |
|
2.39 MB |
|
|
85 |
0910 Creating and editing styles |
|
2.70 MB |
|
|
10 Reviewing and Sharing Your Spreadsheets |
86 |
1001 Checking spelling |
|
2.81 MB |
|
|
87 |
1002 Setting AutoCorrect and automatic Replace options |
|
3.17 MB |
|
|
88 |
1003 Managing workbook comments |
|
2.90 MB |
|
|
89 |
1004 Tracking and reviewing changes |
|
5.48 MB |
|
|
90 |
1005 Printing a worksheet or workbook |
|
3.87 MB |
|
|
91 |
1006 Setting and removing print areas |
|
2.20 MB |
|
|
92 |
1007 Exporting to other formats |
|
1.42 MB |
|
|
93 |
1008 Protecting a workbook |
|
2.01 MB |
|
|
11 Automating Workbooks Using Macros |
94 |
1101 Running an existing macro |
|
3.98 MB |
|
|
95 |
1102 Recording a macro |
|
3.15 MB |
|
|
96 |
1103 Recording a macro using relative references |
|
6.09 MB |
|
|
97 |
1104 Renaming viewing and deleting macros |
|
2.35 MB |
|
|
98 |
1105 Adding comments to a macro |
|
2.06 MB |
|
|
99 |
1106 Turning off screen updating in a macro |
|
2.50 MB |
|
|
12 Conclusion |
100 |
1201 Additional resources |
|
676.37 KB |
|
|
13. ZZZ - فایلهای تمرینی |
101 |
Ex_Files_Ex2011_Mac_EssT |
|
9.56 MB |
|
|