589689.xyz

[] Excel for Mac 2011 Essential Training

  • 收录时间:2018-02-25 06:17:58
  • 文件大小:477MB
  • 下载次数:22
  • 最近下载:2021-01-03 23:06:43
  • 磁力链接:
立即下载 复制链接

文件列表

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