Lynda - Excel 2016 Essential Training

  • Seeders：1
  • Leechers：18
  • Completed：85
  • File size：1.55 GB
  • Date：2020-07-25
Magnet CopyDownload Torrent

Files

  • 01. Introduction01_01-Welcome.mp4(4.72 MB)
  • 01. Introduction01_02-Using the exercise files.mp4(1.52 MB)
  • 02. Getting Started with Excel02_01-What is Excel used for.mp4(8.55 MB)
  • 02. Getting Started with Excel02_02-Using the menu system.mp4(15.82 MB)
  • 02. Getting Started with Excel02_03-Using the Quick Access Toolbar.mp4(18.70 MB)
  • 02. Getting Started with Excel02_04-Understanding workbooks and worksheets.mp4(12.01 MB)
  • 02. Getting Started with Excel02_05-Using the Formula bar.mp4(3.87 MB)
  • 02. Getting Started with Excel02_06-Using the Status bar.mp4(19.37 MB)
  • 02. Getting Started with Excel02_07-Using navigation tools.mp4(10.17 MB)
  • 02. Getting Started with Excel02_08-Using shortcut menus and the Mini toolbar.mp4(13.92 MB)
  • 02. Getting Started with Excel02_09-Creating new workbooks.mp4(8.71 MB)
  • 02. Getting Started with Excel02_10-Using Excel Help.mp4(22.50 MB)
  • 03. Entering Data03_01-Exploring data entry and editing techniques.mp4(8.18 MB)
  • 03. Entering Data03_02-Entering data with AutoFill.mp4(9.71 MB)
  • 03. Entering Data03_03-Working with dates and times.mp4(9.91 MB)
  • 03. Entering Data03_04-Using Undo and Redo.mp4(9.75 MB)
  • 03. Entering Data03_05-Adding comments.mp4(5.64 MB)
  • 03. Entering Data03_06-Using Save or Save As.mp4(10.11 MB)
  • 04. Creating Formulas and Functions04_01-Creating simple formulas.mp4(16.97 MB)
  • 04. Creating Formulas and Functions04_02-Copying a formula into adjacent cells.mp4(9.16 MB)
  • 04. Creating Formulas and Functions04_03-Calculating yeartodate totals.mp4(9.23 MB)
  • 04. Creating Formulas and Functions04_04-Creating a percentagechange formula.mp4(18.29 MB)
  • 04. Creating Formulas and Functions04_05-Working with relative absolute and mixed references.mp4(15.28 MB)
  • 04. Creating Formulas and Functions04_06-Using SUM and AVERAGE.mp4(13.23 MB)
  • 04. Creating Formulas and Functions04_07-Using other common functions.mp4(23.16 MB)
  • 05. Formatting05_01-Exploring font styles and effects.mp4(10.04 MB)
  • 05. Formatting05_02-Adjusting row heights and column widths.mp4(16.36 MB)
  • 05. Formatting05_03-Working with alignment and Wrap Text.mp4(18.62 MB)
  • 05. Formatting05_04-Designing borders.mp4(8.47 MB)
  • 05. Formatting05_05-Exploring numeric and special formatting.mp4(24.90 MB)
  • 05. Formatting05_06-Formatting numbers and dates.mp4(21.29 MB)
  • 05. Formatting05_07-Using conditional formatting.mp4(28.15 MB)
  • 05. Formatting05_08-Creating and using tables.mp4(40.29 MB)
  • 05. Formatting05_09-Inserting shapes arrows and other visual features.mp4(29.72 MB)
  • 06. Adjusting Worksheet Layout and Data06_01-Inserting and deleting rows and columns.mp4(25.22 MB)
  • 06. Adjusting Worksheet Layout and Data06_02-Hiding and unhiding rows and columns.mp4(18.57 MB)
  • 06. Adjusting Worksheet Layout and Data06_03-Moving copying and inserting data.mp4(18.22 MB)
  • 06. Adjusting Worksheet Layout and Data06_04-Finding and replacing data.mp4(19.07 MB)
  • 07. Printing07_01-Exploring the Page Layout tab and Page Layout view.mp4(28.79 MB)
  • 07. Printing07_02-Previewing page breaks.mp4(24.58 MB)
  • 07. Printing07_03-Working with Page Setup and printing controls.mp4(28.27 MB)
  • 08. Printing08_01-Creating charts.mp4(18.42 MB)
  • 08. Printing08_02-Exploring chart types.mp4(25.82 MB)
  • 08. Printing08_03-Formatting charts.mp4(20.64 MB)
  • 08. Printing08_04-Working with axes titles and other chart elements.mp4(17.52 MB)
  • 08. Printing08_05-Creating incell charts with sparklines.mp4(19.63 MB)
  • 09. Adjusting Worksheet Views09_01-Freezing and unfreezing panes.mp4(26.23 MB)
  • 09. Adjusting Worksheet Views09_02-Splitting screens horizontally and vertically.mp4(25.41 MB)
  • 09. Adjusting Worksheet Views09_03-Collapsing and expanding data views with outlining.mp4(21.72 MB)
  • 10. Multiple Worksheets and Workbooks10_01-Displaying multiple worksheets and workbooks.mp4(31.70 MB)
  • 10. Multiple Worksheets and Workbooks10_02-Renaming inserting and deleting sheets.mp4(11.27 MB)
  • 10. Multiple Worksheets and Workbooks10_03-Moving copying and grouping sheets.mp4(15.61 MB)
  • 10. Multiple Worksheets and Workbooks10_04-Using formulas to link worksheets and workbooks.mp4(20.55 MB)
  • 10. Multiple Worksheets and Workbooks10_05-Locating and maintaining links.mp4(18.62 MB)
  • 11. IF VLOOKUP and Power Functions11_01-Using IF functions and relational operators.mp4(13.43 MB)
  • 11. IF VLOOKUP and Power Functions11_02-Getting approximate table data with the VLOOKUP function.mp4(17.82 MB)
  • 11. IF VLOOKUP and Power Functions11_03-Getting exact table data with the VLOOKUP function.mp4(25.07 MB)
  • 11. IF VLOOKUP and Power Functions11_04-Using the COUNTIF family of functions.mp4(15.47 MB)
  • 12. Security and Sharing12_01-Unlocking cells and protecting worksheets.mp4(24.21 MB)
  • 12. Security and Sharing12_02-Protecting workbooks.mp4(16.82 MB)
  • 12. Security and Sharing12_03-Assigning passwords to workbooks.mp4(7.73 MB)
  • 12. Security and Sharing12_04-Sharing workbooks.mp4(12.37 MB)
  • 12. Security and Sharing12_05-Tracking changes.mp4(15.75 MB)
  • 13. Data Management Features13_01-Sorting data.mp4(38.79 MB)
  • 13. Data Management Features13_02-Inserting subtotals in a sorted list.mp4(42.80 MB)
  • 13. Data Management Features13_03-Using filters.mp4(23.89 MB)
  • 13. Data Management Features13_04-Splitting data into multiple columns.mp4(25.80 MB)
  • 13. Data Management Features13_05-Splitting and combining columnar data with Flash Fill.mp4(21.32 MB)
  • 13. Data Management Features13_06-Removing duplicate records.mp4(9.18 MB)
  • 13. Data Management Features13_07-Using validation tools.mp4(26.74 MB)
  • 14. Data Analysis Tools14_01-Using Goal Seek.mp4(18.94 MB)
  • 14. Data Analysis Tools14_02-Using Solver.mp4(18.87 MB)
  • 14. Data Analysis Tools14_03-Using Scenario Manager.mp4(22.30 MB)
  • 14. Data Analysis Tools14_04-Using data tables.mp4(16.98 MB)
  • 15. PivotTables15_01-Creating PivotTables.mp4(36.63 MB)
  • 15. PivotTables15_02-Manipulating PivotTable data.mp4(29.29 MB)
  • 15. PivotTables15_03-Grouping by date and time.mp4(36.40 MB)
  • 15. PivotTables15_04-Grouping by other factors.mp4(12.46 MB)
  • 15. PivotTables15_05-Using slicers to clarify and manipulate fields.mp4(19.37 MB)
  • 15. PivotTables15_06-Using PivotCharts.mp4(13.10 MB)
  • 16. Introduction to Macros16_01-Exploring the need for macros.mp4(19.37 MB)
  • 16. Introduction to Macros16_02-Creating a simple macro.mp4(32.69 MB)
  • 16. Introduction to Macros16_03-Running a macro.mp4(34.42 MB)
  • 17. Conclusion17_01-Goodbye.mp4(2.00 MB)
  • Ex_Files_Excel_2016_EssT.zip(3.69 MB)

Favorites