Lynda - Office 365: Excel Essential Training with Dennis Taylor
- Type:
- Other > Other
- Files:
- 83
- Size:
- 976.6 MiB (1024039079 Bytes)
- Tag(s):
- Business Education + Elearning Excel Office 365
- Uploaded:
- 2015-02-20 12:06:59 GMT
- By:
-
2boweb
- Seeders:
- 1
- Leechers:
- 0
- Comments
- 0
- Info Hash: ED92C13F1251E85FBA96ACD4D334E52EA34229B5
(Problems with magnets links are fixed by upgrading your torrent client!)
Lynda - Office 365: Excel Essential Training with Dennis Taylor Subjects: Business, Education + Elearning, Software: Excel, Office 365, 6h 32m Feb 09, 2015 | Uploaded in Feb 20, 2015 Via Webcentara Learn how to start entering your data and building organized workbooks in Excel 2013, the version that Office 365 subscribers use. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, 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 task automation with macros. Topics include: • Working with dates and times • Creating simple formulas • Formatting fonts, row and column sizes, borders, and more • Inserting shapes, arrows, and other graphics • Adding and deleting rows and columns • Hiding data • Moving, copying, and pasting • Sorting and filtering data • Printing worksheets • Securing workbooks • Tracking changes \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
| 13. Database Features/13_02-Inserting subtotals in a sorted list.mp4 | 36.28 MiB |
| 05. Formatting/05_08-Creating and using tables.mp4 | 30.23 MiB |
| 16. Introduction to Macros/16_03-Running a macro.mp4 | 25.09 MiB |
| 07. Printing/07_01-Exploring the Page Layout tab and view.mp4 | 24.86 MiB |
| 14. PivotTables/14_02-Manipulating PivotTable data.mp4 | 21.7 MiB |
| 14. PivotTables/14_01-Creating PivotTables.mp4 | 21.36 MiB |
| 07. Printing/07_02-Previewing page breaks.mp4 | 19.45 MiB |
| 13. Database Features/13_01-Sorting data.mp4 | 19.3 MiB |
| 16. Introduction to Macros/16_01-Definition and examples.mp4 | 18.94 MiB |
| 08. Introduction to Charting/08_02-Exploring chart types.mp4 | 18.52 MiB |
| 12. Security and Sharing/12_01-Unlocking cells and protecting worksheets.mp4 | 18.38 MiB |
| 09. Adjusting Worksheet Views/09_03-Showing necessary information with the Outlining feature.mp4 | 18.25 MiB |
| 16. Introduction to Macros/16_02-Creating a simple macro.mp4 | 18.04 MiB |
| 05. Formatting/05_05-Exploring numeric and special formatting.mp4 | 17.17 MiB |
| 06. Adjusting Worksheet Layout and Data/06_04-Finding and replacing data.mp4 | 17.06 MiB |
| 05. Formatting/05_09-Inserting shapes, arrows, and other visual features.mp4 | 16.69 MiB |
| 09. Adjusting Worksheet Views/09_02-Splitting screens horizontally and vertically.mp4 | 16.62 MiB |
| 04. Creating Formulas and Functions/04_07-Using other common functions.mp4 | 16.56 MiB |
| 08. Introduction to Charting/08_05-Creating incell charts with sparklines.mp4 | 16.42 MiB |
| 15. Data Analysis Tools/15_03-Using Scenario Manager.mp4 | 16.37 MiB |
| 13. Database Features/13_03-Using filters.mp4 | 16.16 MiB |
| 06. Adjusting Worksheet Layout and Data/06_03-Moving, copying, and inserting data.mp4 | 15.26 MiB |
| 11. IF, VLOOKUP, and Power Functions/11_02-Getting approximate table data with the VLOOKUP function.mp4 | 15.18 MiB |
| 07. Printing/07_03-Working with Page Setup and printing controls.mp4 | 14.91 MiB |
| 10. Multiple Worksheets and Workbooks/10_05-Locating and maintaining links.mp4 | 14.17 MiB |
| 14. PivotTables/14_03-Grouping by date and time.mp4 | 14.15 MiB |
| 06. Adjusting Worksheet Layout and Data/06_01-Inserting and deleting rows and columns.mp4 | 13.72 MiB |
| 02. Getting Started with Excel 2013/02_03-The Quick Access Toolbar.mp4 | 13.68 MiB |
| 15. Data Analysis Tools/15_02-Using Solver.mp4 | 13.68 MiB |
| 08. Introduction to Charting/08_03-Formatting charts.mp4 | 12.96 MiB |
| 13. Database Features/13_04-Splitting data into multiple columns.mp4 | 12.7 MiB |
| 02. Getting Started with Excel 2013/02_02-Using the menu system.mp4 | 12.32 MiB |
| 11. IF, VLOOKUP, and Power Functions/11_04-Using the COUNTIF family of functions.mp4 | 12.25 MiB |
| 10. Multiple Worksheets and Workbooks/10_04-Using formulas to link worksheets and workbooks.mp4 | 12.19 MiB |
| 11. IF, VLOOKUP, and Power Functions/11_03-Getting exact table data with the VLOOKUP function.mp4 | 12.1 MiB |
| 15. Data Analysis Tools/15_01-Using Goal Seek.mp4 | 12.08 MiB |
| 15. Data Analysis Tools/15_04-Using Data Tables.mp4 | 11.68 MiB |
| 05. Formatting/05_06-Formatting numbers and dates.mp4 | 11.53 MiB |
| 08. Introduction to Charting/08_04-Working with axes labels gridlines and other chart elements.mp4 | 11.06 MiB |
| 05. Formatting/05_07-Conditional formatting.mp4 | 11.02 MiB |
| 06. Adjusting Worksheet Layout and Data/06_02-Hiding and unhiding rows and columns.mp4 | 11.01 MiB |
| 09. Adjusting Worksheet Views/09_01-Freezing and unfreezing panes.mp4 | 10.94 MiB |
| 12. Security and Sharing/12_03-Assigning passwords to workbooks.mp4 | 10.59 MiB |
| 08. Introduction to Charting/08_01-Creating charts.mp4 | 10.37 MiB |
| 12. Security and Sharing/12_05-Tracking changes.mp4 | 10.3 MiB |
| 14. PivotTables/14_06-Using PivotCharts.mp4 | 10.21 MiB |
| 10. Multiple Worksheets and Workbooks/10_01-Displaying multiple worksheets and workbooks.mp4 | 10.08 MiB |
| 05. Formatting/05_01-Exploring font styles and effects.mp4 | 9.66 MiB |
| 12. Security and Sharing/12_04-Sharing workbooks.mp4 | 9.48 MiB |
| 04. Creating Formulas and Functions/04_01-Creating simple formulas Totals and averages.mp4 | 9.02 MiB |
| 14. PivotTables/14_05-Using slicers to clarify and manipulate fields.mp4 | 8.67 MiB |
| 05. Formatting/05_04-Designing borders.mp4 | 8.51 MiB |
| 05. Formatting/05_03-Working with alignment and Wrap Text.mp4 | 8.42 MiB |
| 04. Creating Formulas and Functions/04_05-Working with relative, absolute, and mixed references.mp4 | 8.41 MiB |
| 02. Getting Started with Excel 2013/02_04-The structure of a worksheet or workbook.mp4 | 8.19 MiB |
| 03. Entering Data/03_04-Using Undo and Redo.mp4 | 8.08 MiB |
| 01. Introduction/01_01-Welcome.mp4 | 7.8 MiB |
| 05. Formatting/05_02-Adjusting row heights and column widths.mp4 | 7.72 MiB |
| 13. Database Features/13_05-Removing duplicate records.mp4 | 7.65 MiB |
| 11. IF, VLOOKUP, and Power Functions/11_01-Using IF functions and relational operators.mp4 | 7.6 MiB |
| 04. Creating Formulas and Functions/04_04-Creating a percentageincrease formula.mp4 | 7.23 MiB |
| 03. Entering Data/03_01-Exploring data entry and editing techniques.mp4 | 7.19 MiB |
| 02. Getting Started with Excel 2013/02_06-Using the Status bar.mp4 | 7.12 MiB |
| 03. Entering Data/03_02-Entering data with AutoFill.mp4 | 6.93 MiB |
| 02. Getting Started with Excel 2013/02_08-Shortcut menus and the Mini toolbar.mp4 | 6.9 MiB |
| 10. Multiple Worksheets and Workbooks/10_03-Moving, copying, and grouping sheets.mp4 | 6.88 MiB |
| 04. Creating Formulas and Functions/04_06-Using SUM and AVERAGE.mp4 | 6.86 MiB |
| 02. Getting Started with Excel 2013/02_09-Using the builtin help.mp4 | 6.68 MiB |
| 03. Entering Data/03_06-Using Save or Save As.mp4 | 6.59 MiB |
| 12. Security and Sharing/12_02-Protecting workbooks.mp4 | 6.33 MiB |
| 02. Getting Started with Excel 2013/02_10-Creating new files.mp4 | 6.3 MiB |
| 02. Getting Started with Excel 2013/02_07-Navigation and mouse pointers.mp4 | 6.19 MiB |
| 04. Creating Formulas and Functions/04_03-Calculating yeartodate profits.mp4 | 5.51 MiB |
| 03. Entering Data/03_03-Working with dates and times.mp4 | 5.39 MiB |
| 02. Getting Started with Excel 2013/02_01-What is Excel used for.mp4 | 5.28 MiB |
| 10. Multiple Worksheets and Workbooks/10_02-Renaming, inserting, and deleting sheets.mp4 | 5.26 MiB |
| 14. PivotTables/14_04-Grouping by other factors.mp4 | 5.17 MiB |
| 04. Creating Formulas and Functions/04_02-Copying a formula for adjacent cells.mp4 | 5.05 MiB |
| 03. Entering Data/03_05-Adding comments.mp4 | 4.89 MiB |
| 02. Getting Started with Excel 2013/02_05-Using the Formula bar.mp4 | 3.33 MiB |
| 01. Introduction/01_02-Using the exercise files.mp4 | 1.54 MiB |
| 17. Conclusion/17_01-Next steps.mp4 | 1.16 MiB |
| Exercice Files/Ex_Files_Office365_Excel_EssT.zip | 1.76 KiB |
