| 01. Introduction | |||
| 01_01-Welcome.mp4 | 4.72 MB | ||
| 01_02-Using the exercise files.mp4 | 1.52 MB | ||
| 02. Getting Started with Excel | |||
| 02_01-What is Excel used for.mp4 | 8.55 MB | ||
| 02_02-Using the menu system.mp4 | 15.82 MB | ||
| 02_03-Using the Quick Access Toolbar.mp4 | 18.7 MB | ||
| 02_04-Understanding workbooks and worksheets.mp4 | 12.01 MB | ||
| 02_05-Using the Formula bar.mp4 | 3.87 MB | ||
| 02_06-Using the Status bar.mp4 | 19.37 MB | ||
| 02_07-Using navigation tools.mp4 | 10.17 MB | ||
| 02_08-Using shortcut menus and the Mini toolbar.mp4 | 13.92 MB | ||
| 02_09-Creating new workbooks.mp4 | 8.71 MB | ||
| 02_10-Using Excel Help.mp4 | 22.5 MB | ||
| 03. Entering Data | |||
| 03_01-Exploring data entry and editing techniques.mp4 | 8.18 MB | ||
| 03_02-Entering data with AutoFill.mp4 | 9.71 MB | ||
| 03_03-Working with dates and times.mp4 | 9.91 MB | ||
| 03_04-Using Undo and Redo.mp4 | 9.75 MB | ||
| 03_05-Adding comments.mp4 | 5.64 MB | ||
| 03_06-Using Save or Save As.mp4 | 10.11 MB | ||
| 04. Creating Formulas and Functions | |||
| 04_01-Creating simple formulas.mp4 | 16.97 MB | ||
| 04_02-Copying a formula into adjacent cells.mp4 | 9.16 MB | ||
| 04_03-Calculating yeartodate totals.mp4 | 9.23 MB | ||
| 04_04-Creating a percentagechange formula.mp4 | 18.29 MB | ||
| 04_05-Working with relative, absolute, and mixed references.mp4 | 15.28 MB | ||
| 04_06-Using SUM and AVERAGE.mp4 | 13.23 MB | ||
| 04_07-Using other common functions.mp4 | 23.16 MB | ||
| 05. Formatting | |||
| 05_01-Exploring font styles and effects.mp4 | 10.04 MB | ||
| 05_02-Adjusting row heights and column widths.mp4 | 16.36 MB | ||
| 05_03-Working with alignment and Wrap Text.mp4 | 18.62 MB | ||
| 05_04-Designing borders.mp4 | 8.47 MB | ||
| 05_05-Exploring numeric and special formatting.mp4 | 24.9 MB | ||
| 05_06-Formatting numbers and dates.mp4 | 21.29 MB | ||
| 05_07-Using conditional formatting.mp4 | 28.15 MB | ||
| 05_08-Creating and using tables.mp4 | 40.29 MB | ||
| 05_09-Inserting shapes, arrows, and other visual features.mp4 | 29.72 MB | ||
| 06. Adjusting Worksheet Layout and Data | |||
| 06_01-Inserting and deleting rows and columns.mp4 | 25.22 MB | ||
| 06_02-Hiding and unhiding rows and columns.mp4 | 18.57 MB | ||
| 06_03-Moving, copying, and inserting data.mp4 | 18.22 MB | ||
| 06_04-Finding and replacing data.mp4 | 19.07 MB | ||
| 07. Printing | |||
| 07_01-Exploring the Page Layout tab and Page Layout view.mp4 | 28.79 MB | ||
| 07_02-Previewing page breaks.mp4 | 24.58 MB | ||
| 07_03-Working with Page Setup and printing controls.mp4 | 28.27 MB | ||
| 08. Printing | |||
| 08_01-Creating charts.mp4 | 18.42 MB | ||
| 08_02-Exploring chart types.mp4 | 25.82 MB | ||
| 08_03-Formatting charts.mp4 | 20.64 MB | ||
| 08_04-Working with axes, titles, and other chart elements.mp4 | 17.52 MB | ||
| 08_05-Creating incell charts with sparklines.mp4 | 19.63 MB | ||
| 09. Adjusting Worksheet Views | |||
| 09_01-Freezing and unfreezing panes.mp4 | 26.23 MB | ||
| 09_02-Splitting screens horizontally and vertically.mp4 | 25.41 MB | ||
| 09_03-Collapsing and expanding data views with outlining.mp4 | 21.72 MB | ||
| 10. Multiple Worksheets and Workbooks | |||
| 10_01-Displaying multiple worksheets and workbooks.mp4 | 31.7 MB | ||
| 10_02-Renaming, inserting, and deleting sheets.mp4 | 11.27 MB | ||
| 10_03-Moving, copying, and grouping sheets.mp4 | 15.61 MB | ||
| 10_04-Using formulas to link worksheets and workbooks.mp4 | 20.55 MB | ||
| 10_05-Locating and maintaining links.mp4 | 18.62 MB | ||
| 11. IF, VLOOKUP, and Power Functions | |||
| 11_01-Using IF functions and relational operators.mp4 | 13.43 MB | ||
| 11_02-Getting approximate table data with the VLOOKUP function.mp4 | 17.82 MB | ||
| 11_03-Getting exact table data with the VLOOKUP function.mp4 | 25.07 MB | ||
| 11_04-Using the COUNTIF family of functions.mp4 | 15.47 MB | ||
| 12. Security and Sharing | |||
| 12_01-Unlocking cells and protecting worksheets.mp4 | 24.21 MB | ||
| 12_02-Protecting workbooks.mp4 | 16.82 MB | ||
| 12_03-Assigning passwords to workbooks.mp4 | 7.73 MB | ||
| 12_04-Sharing workbooks.mp4 | 12.37 MB | ||
| 12_05-Tracking changes.mp4 | 15.75 MB | ||
| 13. Data Management Features | |||
| 13_01-Sorting data.mp4 | 38.79 MB | ||
| 13_02-Inserting subtotals in a sorted list.mp4 | 42.8 MB | ||
| 13_03-Using filters.mp4 | 23.89 MB | ||
| 13_04-Splitting data into multiple columns.mp4 | 25.8 MB | ||
| 13_05-Splitting and combining columnar data with Flash Fill.mp4 | 21.32 MB | ||
| 13_06-Removing duplicate records.mp4 | 9.18 MB | ||
| 13_07-Using validation tools.mp4 | 26.74 MB | ||
| 14. Data Analysis Tools | |||
| 14_01-Using Goal Seek.mp4 | 18.94 MB | ||
| 14_02-Using Solver.mp4 | 18.87 MB | ||
| 14_03-Using Scenario Manager.mp4 | 22.3 MB | ||
| 14_04-Using data tables.mp4 | 16.98 MB | ||
| 15. PivotTables | |||
| 15_01-Creating PivotTables.mp4 | 36.63 MB | ||
| 15_02-Manipulating PivotTable data.mp4 | 29.29 MB | ||
| 15_03-Grouping by date and time.mp4 | 36.4 MB | ||
| 15_04-Grouping by other factors.mp4 | 12.46 MB | ||
| 15_05-Using slicers to clarify and manipulate fields.mp4 | 19.37 MB | ||
| 15_06-Using PivotCharts.mp4 | 13.1 MB | ||
| 16. Introduction to Macros | |||
| 16_01-Exploring the need for macros.mp4 | 19.37 MB | ||
| 16_02-Creating a simple macro.mp4 | 32.69 MB | ||
| 16_03-Running a macro.mp4 | 34.42 MB | ||
| 17. Conclusion | |||
| 17_01-Goodbye.mp4 | 2 MB | ||
| ▲ 84 total files | |||
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
//////////////////////////////////////////////////////
| torrent name | size | uploader | age | seed | leech |
|---|---|---|---|---|---|
|
[ CourseWikia ] Lynda - Excel for the Web Tips and Tricks (Office 365 - Microsoft 365) Posted by
freecoursewb in Other
|
185.6 MB | freecoursewb | 5 years | 0 | 0 |
|
[ DevCourseWeb ] Lynda - Excel - Setting Up a Database (Office 365 - Microsoft 365) Posted by
freecoursewb in Other
|
207.9 MB | freecoursewb | 5 years | 0 | 0 |
| 215.36 MB | tutsnode | 5 years | 12 | 1 | |
|
[ DevCourseWeb ] Lynda - Word Essential Training (Office 365 - Microsoft 365) Posted by
freecoursewb in Other
|
466.3 MB | freecoursewb | 5 years | 0 | 1 |
|
[ FreeCourseWeb ] Lynda - PowerPoint Essential Training (Office 365 - Microsoft 365) Posted by
freecoursewb in Other
|
1.2 GB | freecoursewb | 5 years | 0 | 1 |
All Comments