Lynda - Office 365 Excel Essential Training Updated 09 2015
- 收录时间:2018-03-03 02:53:42
- 文件大小:2GB
- 下载次数:234
- 最近下载:2021-01-13 08:24:41
- 磁力链接:
-
文件列表
- 13. Data Management Features/13_02-Inserting subtotals in a sorted list.mp4 43MB
- 05. Formatting/05_08-Creating and using tables.mp4 40MB
- 13. Data Management Features/13_01-Sorting data.mp4 39MB
- 15. PivotTables/15_01-Creating PivotTables.mp4 37MB
- 15. PivotTables/15_03-Grouping by date and time.mp4 36MB
- 16. Introduction to Macros/16_03-Running a macro.mp4 34MB
- 16. Introduction to Macros/16_02-Creating a simple macro.mp4 33MB
- 10. Multiple Worksheets and Workbooks/10_01-Displaying multiple worksheets and workbooks.mp4 32MB
- 05. Formatting/05_09-Inserting shapes, arrows, and other visual features.mp4 30MB
- 15. PivotTables/15_02-Manipulating PivotTable data.mp4 29MB
- 07. Printing/07_01-Exploring the Page Layout tab and Page Layout view.mp4 29MB
- 07. Printing/07_03-Working with Page Setup and printing controls.mp4 28MB
- 05. Formatting/05_07-Using conditional formatting.mp4 28MB
- 13. Data Management Features/13_07-Using validation tools.mp4 27MB
- 09. Adjusting Worksheet Views/09_01-Freezing and unfreezing panes.mp4 26MB
- 08. Printing/08_02-Exploring chart types.mp4 26MB
- 13. Data Management Features/13_04-Splitting data into multiple columns.mp4 26MB
- 09. Adjusting Worksheet Views/09_02-Splitting screens horizontally and vertically.mp4 25MB
- 06. Adjusting Worksheet Layout and Data/06_01-Inserting and deleting rows and columns.mp4 25MB
- 11. IF, VLOOKUP, and Power Functions/11_03-Getting exact table data with the VLOOKUP function.mp4 25MB
- 05. Formatting/05_05-Exploring numeric and special formatting.mp4 25MB
- 07. Printing/07_02-Previewing page breaks.mp4 25MB
- 12. Security and Sharing/12_01-Unlocking cells and protecting worksheets.mp4 24MB
- 13. Data Management Features/13_03-Using filters.mp4 24MB
- 04. Creating Formulas and Functions/04_07-Using other common functions.mp4 23MB
- 02. Getting Started with Excel/02_10-Using Excel Help.mp4 23MB
- 14. Data Analysis Tools/14_03-Using Scenario Manager.mp4 22MB
- 09. Adjusting Worksheet Views/09_03-Collapsing and expanding data views with outlining.mp4 22MB
- 13. Data Management Features/13_05-Splitting and combining columnar data with Flash Fill.mp4 21MB
- 05. Formatting/05_06-Formatting numbers and dates.mp4 21MB
- 08. Printing/08_03-Formatting charts.mp4 21MB
- 10. Multiple Worksheets and Workbooks/10_04-Using formulas to link worksheets and workbooks.mp4 21MB
- 08. Printing/08_05-Creating incell charts with sparklines.mp4 20MB
- 02. Getting Started with Excel/02_06-Using the Status bar.mp4 19MB
- 16. Introduction to Macros/16_01-Exploring the need for macros.mp4 19MB
- 15. PivotTables/15_05-Using slicers to clarify and manipulate fields.mp4 19MB
- 06. Adjusting Worksheet Layout and Data/06_04-Finding and replacing data.mp4 19MB
- 14. Data Analysis Tools/14_01-Using Goal Seek.mp4 19MB
- 14. Data Analysis Tools/14_02-Using Solver.mp4 19MB
- 02. Getting Started with Excel/02_03-Using the Quick Access Toolbar.mp4 19MB
- 05. Formatting/05_03-Working with alignment and Wrap Text.mp4 19MB
- 06. Adjusting Worksheet Layout and Data/06_02-Hiding and unhiding rows and columns.mp4 19MB
- 10. Multiple Worksheets and Workbooks/10_05-Locating and maintaining links.mp4 19MB
- 08. Printing/08_01-Creating charts.mp4 18MB
- 04. Creating Formulas and Functions/04_04-Creating a percentagechange formula.mp4 18MB
- 06. Adjusting Worksheet Layout and Data/06_03-Moving, copying, and inserting data.mp4 18MB
- 11. IF, VLOOKUP, and Power Functions/11_02-Getting approximate table data with the VLOOKUP function.mp4 18MB
- 08. Printing/08_04-Working with axes, titles, and other chart elements.mp4 18MB
- 14. Data Analysis Tools/14_04-Using data tables.mp4 17MB
- 04. Creating Formulas and Functions/04_01-Creating simple formulas.mp4 17MB
- 12. Security and Sharing/12_02-Protecting workbooks.mp4 17MB
- 05. Formatting/05_02-Adjusting row heights and column widths.mp4 16MB
- 02. Getting Started with Excel/02_02-Using the menu system.mp4 16MB
- 12. Security and Sharing/12_05-Tracking changes.mp4 16MB
- 10. Multiple Worksheets and Workbooks/10_03-Moving, copying, and grouping sheets.mp4 16MB
- 11. IF, VLOOKUP, and Power Functions/11_04-Using the COUNTIF family of functions.mp4 15MB
- 04. Creating Formulas and Functions/04_05-Working with relative, absolute, and mixed references.mp4 15MB
- 02. Getting Started with Excel/02_08-Using shortcut menus and the Mini toolbar.mp4 14MB
- 11. IF, VLOOKUP, and Power Functions/11_01-Using IF functions and relational operators.mp4 13MB
- 04. Creating Formulas and Functions/04_06-Using SUM and AVERAGE.mp4 13MB
- 15. PivotTables/15_06-Using PivotCharts.mp4 13MB
- 15. PivotTables/15_04-Grouping by other factors.mp4 12MB
- 12. Security and Sharing/12_04-Sharing workbooks.mp4 12MB
- 02. Getting Started with Excel/02_04-Understanding workbooks and worksheets.mp4 12MB
- 10. Multiple Worksheets and Workbooks/10_02-Renaming, inserting, and deleting sheets.mp4 11MB
- 02. Getting Started with Excel/02_07-Using navigation tools.mp4 10MB
- 03. Entering Data/03_06-Using Save or Save As.mp4 10MB
- 05. Formatting/05_01-Exploring font styles and effects.mp4 10MB
- 03. Entering Data/03_03-Working with dates and times.mp4 10MB
- 03. Entering Data/03_04-Using Undo and Redo.mp4 10MB
- 03. Entering Data/03_02-Entering data with AutoFill.mp4 10MB
- 04. Creating Formulas and Functions/04_03-Calculating yeartodate totals.mp4 9MB
- 13. Data Management Features/13_06-Removing duplicate records.mp4 9MB
- 04. Creating Formulas and Functions/04_02-Copying a formula into adjacent cells.mp4 9MB
- 02. Getting Started with Excel/02_09-Creating new workbooks.mp4 9MB
- 02. Getting Started with Excel/02_01-What is Excel used for.mp4 9MB
- 05. Formatting/05_04-Designing borders.mp4 8MB
- 03. Entering Data/03_01-Exploring data entry and editing techniques.mp4 8MB
- 01. Introduction/01_01-Welcome.mp4 8MB
- 12. Security and Sharing/12_03-Assigning passwords to workbooks.mp4 8MB
- 03. Entering Data/03_05-Adding comments.mp4 6MB
- 02. Getting Started with Excel/02_05-Using the Formula bar.mp4 4MB
- Exercice Files/Ex_Files_Office365_Excel_EssT.zip 4MB
- 17. Conclusion/17_01-Goodbye.mp4 2MB
- 01. Introduction/01_02-Using the exercise files.mp4 2MB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch12/12 - DatabaseFeatures.xlsx 301KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch12/12 - Data Management Features.xlsx 297KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch01/01 - Examples.xlsx 287KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch09/09 - 04 - EmployeeTable.xlsx 239KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch09/09 - 01 - EmployeeTable.xlsx 210KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch09/09 - 05 - EmployeeTable.xlsx 209KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch06/06 - Printing.xlsx 189KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch08/08 - Worksheet Views.xlsx 188KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch14/14 - PivotTables.xlsx 167KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch05/05 - Layout.xlsx 167KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch10/10 - IF VLOOKUP COUNTIF.xlsx 167KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch13/13 - PivotTables.xlsx 166KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch13/14 - PivotTables.xlsx 166KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch11/11 - Security&Sharing.xlsx 133KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch11/11 - TrackingChanges.xlsx 131KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch11/11-TrackingChanges.xlsx 131KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch04/04 - Formatting.xlsx 128KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch14/14 - DataAnalysis.xlsx 121KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch15/15 - Macros.xlsx 119KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch13/13 - DataAnalysis.xlsx 101KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch01/01 - Getting Started.xlsx 69KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch04/Twenty Second Sneakers_with logo_91548475.jpg 61KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch04/No_Obstacles_logo_transparent.jpg 52KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch09/09 - 01 - Home Product Line.xlsx 51KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch04/Bamboo_Slicker_with logo_YELLOW_101817957.jpg 49KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch09/09 - 02 - RegionalSales.xlsx 35KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch07/07 - Charting.xlsx 33KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch11/11 - Workbook before Sharing.xlsx 29KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch09/09 - 05 - RegionalSales.xlsx 23KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch09/09 - 01 - RegionalSales.xlsx 19KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch09/09 - 04 - RegionalSales.xlsx 19KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch09/09 - 03 - RegionalSales.xlsx 19KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch03/03 - Creating Formulas and Functions.xlsx 17KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch02/02 - Entering Data.xlsx 12KB
- Exercice Files/Ex_Files_exname/Exercise Files/Ch12/~$12 - Data Management Features.xlsx 165B
- Exercice Files/Ex_Files_exname/Exercise Files/Ch15/~$15 - Macros.xlsx 165B
- Exercice Files/Ex_Files_exname/Exercise Files/Ch01/~$01 - Getting Started.xlsx 165B
- Exercice Files/Ex_Files_exname/Exercise Files/Ch08/~$08 - Worksheet Views.xlsx 165B