Lynda - Office 2016 Essential Training - Excel 2016
- Type:
- Other > Other
- Files:
- 84
- Size:
- 1.55 GiB (1658976544 Bytes)
- Tag(s):
- Office Office 365 Access Power Point Excel Word One Point Outlook Publisher
- Uploaded:
- 2015-11-05 03:26:48 GMT
- By:
-
2boweb
- Seeders:
- 2
- Leechers:
- 0
- Comments
- 3
- Info Hash: 44BFC6507A49E0A1835BC841744308F06C9F9C3E
(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Office 2016 Essential Training - Excel 2016 This Course will be good to the Best for DL within 30 days after has been post, after that it might not be good DL already, please do me favour to continue seeding to keep this torrent alive. 8h 40m Beginner Sep 22, 2015 | Uploaded in Nov 5, 2015 by 2boweb Subjects: Business Education + Elearning Software: Excel Office Author: Dennis Taylor Start mastering Excel, the world's most popular and powerful spreadsheet program, with Excel expert Dennis Taylor. Learn how to best enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data and cells, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and automating tasks with macros. Topics include: • Working with the Excel interface • Entering data • Creating formulas and functions • Formatting rows, columns, cells, and data • Working with alignment and text wrap • Adjusting rows and columns • Finding and replacing data • Printing and sharing worksheets • Creating charts and PivotTables • Inserting and deleting sheets • Using power functions such as IF and VLOOKUP • Password-protecting worksheets and workbooks • Sorting data • Analyzing data with Goal Seek and Solver • Creating and running macros //////////////////////////////////////////////////////
| 13. Data Management Features/13_02-Inserting subtotals in a sorted list.mp4 | 42.8 MiB |
| 05. Formatting/05_08-Creating and using tables.mp4 | 40.29 MiB |
| 13. Data Management Features/13_01-Sorting data.mp4 | 38.79 MiB |
| 15. PivotTables/15_01-Creating PivotTables.mp4 | 36.63 MiB |
| 15. PivotTables/15_03-Grouping by date and time.mp4 | 36.4 MiB |
| 16. Introduction to Macros/16_03-Running a macro.mp4 | 34.42 MiB |
| 16. Introduction to Macros/16_02-Creating a simple macro.mp4 | 32.69 MiB |
| 10. Multiple Worksheets and Workbooks/10_01-Displaying multiple worksheets and workbooks.mp4 | 31.7 MiB |
| 05. Formatting/05_09-Inserting shapes, arrows, and other visual features.mp4 | 29.72 MiB |
| 15. PivotTables/15_02-Manipulating PivotTable data.mp4 | 29.29 MiB |
| 07. Printing/07_01-Exploring the Page Layout tab and Page Layout view.mp4 | 28.79 MiB |
| 07. Printing/07_03-Working with Page Setup and printing controls.mp4 | 28.27 MiB |
| 05. Formatting/05_07-Using conditional formatting.mp4 | 28.15 MiB |
| 13. Data Management Features/13_07-Using validation tools.mp4 | 26.74 MiB |
| 09. Adjusting Worksheet Views/09_01-Freezing and unfreezing panes.mp4 | 26.23 MiB |
| 08. Printing/08_02-Exploring chart types.mp4 | 25.82 MiB |
| 13. Data Management Features/13_04-Splitting data into multiple columns.mp4 | 25.8 MiB |
| 09. Adjusting Worksheet Views/09_02-Splitting screens horizontally and vertically.mp4 | 25.41 MiB |
| 06. Adjusting Worksheet Layout and Data/06_01-Inserting and deleting rows and columns.mp4 | 25.22 MiB |
| 11. IF, VLOOKUP, and Power Functions/11_03-Getting exact table data with the VLOOKUP function.mp4 | 25.07 MiB |
| 05. Formatting/05_05-Exploring numeric and special formatting.mp4 | 24.9 MiB |
| 07. Printing/07_02-Previewing page breaks.mp4 | 24.58 MiB |
| 12. Security and Sharing/12_01-Unlocking cells and protecting worksheets.mp4 | 24.21 MiB |
| 13. Data Management Features/13_03-Using filters.mp4 | 23.89 MiB |
| 04. Creating Formulas and Functions/04_07-Using other common functions.mp4 | 23.16 MiB |
| 02. Getting Started with Excel/02_10-Using Excel Help.mp4 | 22.5 MiB |
| 14. Data Analysis Tools/14_03-Using Scenario Manager.mp4 | 22.3 MiB |
| 09. Adjusting Worksheet Views/09_03-Collapsing and expanding data views with outlining.mp4 | 21.72 MiB |
| 13. Data Management Features/13_05-Splitting and combining columnar data with Flash Fill.mp4 | 21.32 MiB |
| 05. Formatting/05_06-Formatting numbers and dates.mp4 | 21.29 MiB |
| 08. Printing/08_03-Formatting charts.mp4 | 20.64 MiB |
| 10. Multiple Worksheets and Workbooks/10_04-Using formulas to link worksheets and workbooks.mp4 | 20.55 MiB |
| 08. Printing/08_05-Creating incell charts with sparklines.mp4 | 19.63 MiB |
| 15. PivotTables/15_05-Using slicers to clarify and manipulate fields.mp4 | 19.37 MiB |
| 02. Getting Started with Excel/02_06-Using the Status bar.mp4 | 19.37 MiB |
| 16. Introduction to Macros/16_01-Exploring the need for macros.mp4 | 19.37 MiB |
| 06. Adjusting Worksheet Layout and Data/06_04-Finding and replacing data.mp4 | 19.07 MiB |
| 14. Data Analysis Tools/14_01-Using Goal Seek.mp4 | 18.94 MiB |
| 14. Data Analysis Tools/14_02-Using Solver.mp4 | 18.87 MiB |
| 02. Getting Started with Excel/02_03-Using the Quick Access Toolbar.mp4 | 18.7 MiB |
| 05. Formatting/05_03-Working with alignment and Wrap Text.mp4 | 18.62 MiB |
| 10. Multiple Worksheets and Workbooks/10_05-Locating and maintaining links.mp4 | 18.62 MiB |
| 06. Adjusting Worksheet Layout and Data/06_02-Hiding and unhiding rows and columns.mp4 | 18.57 MiB |
| 08. Printing/08_01-Creating charts.mp4 | 18.42 MiB |
| 04. Creating Formulas and Functions/04_04-Creating a percentagechange formula.mp4 | 18.29 MiB |
| 06. Adjusting Worksheet Layout and Data/06_03-Moving, copying, and inserting data.mp4 | 18.22 MiB |
| 11. IF, VLOOKUP, and Power Functions/11_02-Getting approximate table data with the VLOOKUP function.mp4 | 17.82 MiB |
| 08. Printing/08_04-Working with axes, titles, and other chart elements.mp4 | 17.52 MiB |
| 14. Data Analysis Tools/14_04-Using data tables.mp4 | 16.98 MiB |
| 04. Creating Formulas and Functions/04_01-Creating simple formulas.mp4 | 16.97 MiB |
| 12. Security and Sharing/12_02-Protecting workbooks.mp4 | 16.82 MiB |
| 05. Formatting/05_02-Adjusting row heights and column widths.mp4 | 16.36 MiB |
| 02. Getting Started with Excel/02_02-Using the menu system.mp4 | 15.82 MiB |
| 12. Security and Sharing/12_05-Tracking changes.mp4 | 15.75 MiB |
| 10. Multiple Worksheets and Workbooks/10_03-Moving, copying, and grouping sheets.mp4 | 15.61 MiB |
| 11. IF, VLOOKUP, and Power Functions/11_04-Using the COUNTIF family of functions.mp4 | 15.47 MiB |
| 04. Creating Formulas and Functions/04_05-Working with relative, absolute, and mixed references.mp4 | 15.28 MiB |
| 02. Getting Started with Excel/02_08-Using shortcut menus and the Mini toolbar.mp4 | 13.92 MiB |
| 11. IF, VLOOKUP, and Power Functions/11_01-Using IF functions and relational operators.mp4 | 13.43 MiB |
| 04. Creating Formulas and Functions/04_06-Using SUM and AVERAGE.mp4 | 13.23 MiB |
| 15. PivotTables/15_06-Using PivotCharts.mp4 | 13.1 MiB |
| 15. PivotTables/15_04-Grouping by other factors.mp4 | 12.46 MiB |
| 12. Security and Sharing/12_04-Sharing workbooks.mp4 | 12.37 MiB |
| 02. Getting Started with Excel/02_04-Understanding workbooks and worksheets.mp4 | 12.01 MiB |
| 10. Multiple Worksheets and Workbooks/10_02-Renaming, inserting, and deleting sheets.mp4 | 11.27 MiB |
| 02. Getting Started with Excel/02_07-Using navigation tools.mp4 | 10.17 MiB |
| 03. Entering Data/03_06-Using Save or Save As.mp4 | 10.11 MiB |
| 05. Formatting/05_01-Exploring font styles and effects.mp4 | 10.04 MiB |
| 03. Entering Data/03_03-Working with dates and times.mp4 | 9.91 MiB |
| 03. Entering Data/03_04-Using Undo and Redo.mp4 | 9.75 MiB |
| 03. Entering Data/03_02-Entering data with AutoFill.mp4 | 9.71 MiB |
| 04. Creating Formulas and Functions/04_03-Calculating yeartodate totals.mp4 | 9.23 MiB |
| 13. Data Management Features/13_06-Removing duplicate records.mp4 | 9.18 MiB |
| 04. Creating Formulas and Functions/04_02-Copying a formula into adjacent cells.mp4 | 9.16 MiB |
| 02. Getting Started with Excel/02_09-Creating new workbooks.mp4 | 8.71 MiB |
| 02. Getting Started with Excel/02_01-What is Excel used for.mp4 | 8.55 MiB |
| 05. Formatting/05_04-Designing borders.mp4 | 8.47 MiB |
| 03. Entering Data/03_01-Exploring data entry and editing techniques.mp4 | 8.18 MiB |
| 12. Security and Sharing/12_03-Assigning passwords to workbooks.mp4 | 7.73 MiB |
| 03. Entering Data/03_05-Adding comments.mp4 | 5.64 MiB |
| 01. Introduction/01_01-Welcome.mp4 | 4.72 MiB |
| 02. Getting Started with Excel/02_05-Using the Formula bar.mp4 | 3.87 MiB |
| 17. Conclusion/17_01-Goodbye.mp4 | 2 MiB |
| 01. Introduction/01_02-Using the exercise files.mp4 | 1.52 MiB |
Comments