| 01. Introduction |
| 1 |
01_01-Welcome |
|
4.72 MB |
|
|
| 2 |
01_02-Using the exercise files |
|
1.52 MB |
|
|
| 02. Getting Started with Excel |
| 3 |
02_01-What is Excel used for |
|
8.55 MB |
|
|
| 4 |
02_02-Using the menu system |
|
15.82 MB |
|
|
| 5 |
02_03-Using the Quick Access Toolbar |
|
18.70 MB |
|
|
| 6 |
02_04-Understanding workbooks and worksheets |
|
12.01 MB |
|
|
| 7 |
02_05-Using the Formula bar |
|
3.87 MB |
|
|
| 8 |
02_06-Using the Status bar |
|
19.37 MB |
|
|
| 9 |
02_07-Using navigation tools |
|
10.17 MB |
|
|
| 10 |
02_08-Using shortcut menus and the Mini toolbar |
|
13.92 MB |
|
|
| 11 |
02_09-Creating new workbooks |
|
8.71 MB |
|
|
| 12 |
02_10-Using Excel Help |
|
22.50 MB |
|
|
| 03. Entering Data |
| 13 |
03_01-Exploring data entry and editing techniques |
|
8.18 MB |
|
|
| 14 |
03_02-Entering data with AutoFill |
|
9.71 MB |
|
|
| 15 |
03_03-Working with dates and times |
|
9.91 MB |
|
|
| 16 |
03_04-Using Undo and Redo |
|
9.75 MB |
|
|
| 17 |
03_05-Adding comments |
|
5.64 MB |
|
|
| 18 |
03_06-Using Save or Save As |
|
10.11 MB |
|
|
| 04. Creating Formulas and Functions |
| 19 |
04_01-Creating simple formulas |
|
16.97 MB |
|
|
| 20 |
04_02-Copying a formula into adjacent cells |
|
9.16 MB |
|
|
| 21 |
04_03-Calculating yeartodate totals |
|
9.23 MB |
|
|
| 22 |
04_04-Creating a percentagechange formula |
|
18.29 MB |
|
|
| 23 |
04_05-Working with relative, absolute, and mixed references |
|
15.28 MB |
|
|
| 24 |
04_06-Using SUM and AVERAGE |
|
13.23 MB |
|
|
| 25 |
04_07-Using other common functions |
|
23.16 MB |
|
|
| 05. Formatting |
| 26 |
05_01-Exploring font styles and effects |
|
10.04 MB |
|
|
| 27 |
05_02-Adjusting row heights and column widths |
|
16.36 MB |
|
|
| 28 |
05_03-Working with alignment and Wrap Text |
|
18.62 MB |
|
|
| 29 |
05_04-Designing borders |
|
8.47 MB |
|
|
| 30 |
05_05-Exploring numeric and special formatting |
|
24.90 MB |
|
|
| 31 |
05_06-Formatting numbers and dates |
|
21.29 MB |
|
|
| 32 |
05_07-Using conditional formatting |
|
28.15 MB |
|
|
| 33 |
05_08-Creating and using tables |
|
40.29 MB |
|
|
| 34 |
05_09-Inserting shapes, arrows, and other visual features |
|
29.72 MB |
|
|
| 06. Adjusting Worksheet Layout and Data |
| 35 |
06_01-Inserting and deleting rows and columns |
|
25.22 MB |
|
|
| 36 |
06_02-Hiding and unhiding rows and columns |
|
18.57 MB |
|
|
| 37 |
06_03-Moving, copying, and inserting data |
|
18.22 MB |
|
|
| 38 |
06_04-Finding and replacing data |
|
19.07 MB |
|
|
| 07. Printing |
| 39 |
07_01-Exploring the Page Layout tab and Page Layout view |
|
28.79 MB |
|
|
| 40 |
07_02-Previewing page breaks |
|
24.58 MB |
|
|
| 41 |
07_03-Working with Page Setup and printing controls |
|
28.27 MB |
|
|
| 08. Printing |
| 42 |
08_01-Creating charts |
|
18.42 MB |
|
|
| 43 |
08_02-Exploring chart types |
|
25.82 MB |
|
|
| 44 |
08_03-Formatting charts |
|
20.64 MB |
|
|
| 45 |
08_04-Working with axes, titles, and other chart elements |
|
17.52 MB |
|
|
| 46 |
08_05-Creating incell charts with sparklines |
|
19.63 MB |
|
|
| 09. Adjusting Worksheet Views |
| 47 |
09_01-Freezing and unfreezing panes |
|
26.23 MB |
|
|
| 48 |
09_02-Splitting screens horizontally and vertically |
|
25.41 MB |
|
|
| 49 |
09_03-Collapsing and expanding data views with outlining |
|
21.72 MB |
|
|
| 10. Multiple Worksheets and Workbooks |
| 50 |
10_01-Displaying multiple worksheets and workbooks |
|
31.70 MB |
|
|
| 51 |
10_02-Renaming, inserting, and deleting sheets |
|
11.27 MB |
|
|
| 52 |
10_03-Moving, copying, and grouping sheets |
|
15.61 MB |
|
|
| 53 |
10_04-Using formulas to link worksheets and workbooks |
|
20.55 MB |
|
|
| 54 |
10_05-Locating and maintaining links |
|
18.62 MB |
|
|
| 11. IF, VLOOKUP, and Power Functions |
| 55 |
11_01-Using IF functions and relational operators |
|
13.43 MB |
|
|
| 56 |
11_02-Getting approximate table data with the VLOOKUP function |
|
17.82 MB |
|
|
| 57 |
11_03-Getting exact table data with the VLOOKUP function |
|
25.07 MB |
|
|
| 58 |
11_04-Using the COUNTIF family of functions |
|
15.47 MB |
|
|
| 12. Security and Sharing |
| 59 |
12_01-Unlocking cells and protecting worksheets |
|
24.21 MB |
|
|
| 60 |
12_02-Protecting workbooks |
|
16.82 MB |
|
|
| 61 |
12_03-Assigning passwords to workbooks |
|
7.73 MB |
|
|
| 62 |
12_04-Sharing workbooks |
|
12.37 MB |
|
|
| 63 |
12_05-Tracking changes |
|
15.75 MB |
|
|
| 13. Data Management Features |
| 64 |
13_01-Sorting data |
|
38.79 MB |
|
|
| 65 |
13_02-Inserting subtotals in a sorted list |
|
42.80 MB |
|
|
| 66 |
13_03-Using filters |
|
23.89 MB |
|
|
| 67 |
13_04-Splitting data into multiple columns |
|
25.80 MB |
|
|
| 68 |
13_05-Splitting and combining columnar data with Flash Fill |
|
21.32 MB |
|
|
| 69 |
13_06-Removing duplicate records |
|
9.18 MB |
|
|
| 70 |
13_07-Using validation tools |
|
26.74 MB |
|
|
| 14. Data Analysis Tools |
| 71 |
14_01-Using Goal Seek |
|
18.94 MB |
|
|
| 72 |
14_02-Using Solver |
|
18.87 MB |
|
|
| 73 |
14_03-Using Scenario Manager |
|
22.30 MB |
|
|
| 74 |
14_04-Using data tables |
|
16.98 MB |
|
|
| 15. PivotTables |
| 75 |
15_01-Creating PivotTables |
|
36.63 MB |
|
|
| 76 |
15_02-Manipulating PivotTable data |
|
29.29 MB |
|
|
| 77 |
15_03-Grouping by date and time |
|
36.40 MB |
|
|
| 78 |
15_04-Grouping by other factors |
|
12.46 MB |
|
|
| 79 |
15_05-Using slicers to clarify and manipulate fields |
|
19.37 MB |
|
|
| 80 |
15_06-Using PivotCharts |
|
13.10 MB |
|
|
| 16. Introduction to Macros |
| 81 |
16_01-Exploring the need for macros |
|
19.37 MB |
|
|
| 82 |
16_02-Creating a simple macro |
|
32.69 MB |
|
|
| 83 |
16_03-Running a macro |
|
34.42 MB |
|
|
| 17. Conclusion |
| 84 |
17_01-Goodbye |
|
2.00 MB |
|
|
| 18. ZZZ - فایلهای تمرینی |
| 85 |
Ex_Files_Excel_2016_EssT |
|
3.69 MB |
|
|
