| 01. Introduction | |||
| 01_01-Welcome.mp4 | 7.8 MB | ||
| 01_02-Using the exercise files.mp4 | 1.54 MB | ||
| 02. Getting Started with Excel 2013 | |||
| 02_01-What is Excel used for.mp4 | 5.28 MB | ||
| 02_02-Using the menu system.mp4 | 12.32 MB | ||
| 02_03-The Quick Access Toolbar.mp4 | 13.68 MB | ||
| 02_04-The structure of a worksheet or workbook.mp4 | 8.19 MB | ||
| 02_05-Using the Formula bar.mp4 | 3.33 MB | ||
| 02_06-Using the Status bar.mp4 | 7.12 MB | ||
| 02_07-Navigation and mouse pointers.mp4 | 6.19 MB | ||
| 02_08-Shortcut menus and the Mini toolbar.mp4 | 6.9 MB | ||
| 02_09-Using the builtin help.mp4 | 6.68 MB | ||
| 02_10-Creating new files.mp4 | 6.3 MB | ||
| 03. Entering Data | |||
| 03_01-Exploring data entry and editing techniques.mp4 | 7.19 MB | ||
| 03_02-Entering data with AutoFill.mp4 | 6.93 MB | ||
| 03_03-Working with dates and times.mp4 | 5.39 MB | ||
| 03_04-Using Undo and Redo.mp4 | 8.08 MB | ||
| 03_05-Adding comments.mp4 | 4.89 MB | ||
| 03_06-Using Save or Save As.mp4 | 6.59 MB | ||
| 04. Creating Formulas and Functions | |||
| 04_01-Creating simple formulas Totals and averages.mp4 | 9.02 MB | ||
| 04_02-Copying a formula for adjacent cells.mp4 | 5.05 MB | ||
| 04_03-Calculating yeartodate profits.mp4 | 5.51 MB | ||
| 04_04-Creating a percentageincrease formula.mp4 | 7.23 MB | ||
| 04_05-Working with relative, absolute, and mixed references.mp4 | 8.41 MB | ||
| 04_06-Using SUM and AVERAGE.mp4 | 6.86 MB | ||
| 04_07-Using other common functions.mp4 | 16.56 MB | ||
| 05. Formatting | |||
| 05_01-Exploring font styles and effects.mp4 | 9.66 MB | ||
| 05_02-Adjusting row heights and column widths.mp4 | 7.72 MB | ||
| 05_03-Working with alignment and Wrap Text.mp4 | 8.42 MB | ||
| 05_04-Designing borders.mp4 | 8.51 MB | ||
| 05_05-Exploring numeric and special formatting.mp4 | 17.17 MB | ||
| 05_06-Formatting numbers and dates.mp4 | 11.53 MB | ||
| 05_07-Conditional formatting.mp4 | 11.02 MB | ||
| 05_08-Creating and using tables.mp4 | 30.23 MB | ||
| 05_09-Inserting shapes, arrows, and other visual features.mp4 | 16.69 MB | ||
| 06. Adjusting Worksheet Layout and Data | |||
| 06_01-Inserting and deleting rows and columns.mp4 | 13.72 MB | ||
| 06_02-Hiding and unhiding rows and columns.mp4 | 11.01 MB | ||
| 06_03-Moving, copying, and inserting data.mp4 | 15.26 MB | ||
| 06_04-Finding and replacing data.mp4 | 17.06 MB | ||
| 07. Printing | |||
| 07_01-Exploring the Page Layout tab and view.mp4 | 24.86 MB | ||
| 07_02-Previewing page breaks.mp4 | 19.45 MB | ||
| 07_03-Working with Page Setup and printing controls.mp4 | 14.91 MB | ||
| 08. Introduction to Charting | |||
| 08_01-Creating charts.mp4 | 10.37 MB | ||
| 08_02-Exploring chart types.mp4 | 18.52 MB | ||
| 08_03-Formatting charts.mp4 | 12.96 MB | ||
| 08_04-Working with axes labels gridlines and other chart elements.mp4 | 11.06 MB | ||
| 08_05-Creating incell charts with sparklines.mp4 | 16.42 MB | ||
| 09. Adjusting Worksheet Views | |||
| 09_01-Freezing and unfreezing panes.mp4 | 10.94 MB | ||
| 09_02-Splitting screens horizontally and vertically.mp4 | 16.62 MB | ||
| 09_03-Showing necessary information with the Outlining feature.mp4 | 18.25 MB | ||
| 10. Multiple Worksheets and Workbooks | |||
| 10_01-Displaying multiple worksheets and workbooks.mp4 | 10.08 MB | ||
| 10_02-Renaming, inserting, and deleting sheets.mp4 | 5.26 MB | ||
| 10_03-Moving, copying, and grouping sheets.mp4 | 6.88 MB | ||
| 10_04-Using formulas to link worksheets and workbooks.mp4 | 12.19 MB | ||
| 10_05-Locating and maintaining links.mp4 | 14.17 MB | ||
| 11. IF, VLOOKUP, and Power Functions | |||
| 11_01-Using IF functions and relational operators.mp4 | 7.6 MB | ||
| 11_02-Getting approximate table data with the VLOOKUP function.mp4 | 15.18 MB | ||
| 11_03-Getting exact table data with the VLOOKUP function.mp4 | 12.1 MB | ||
| 11_04-Using the COUNTIF family of functions.mp4 | 12.25 MB | ||
| 12. Security and Sharing | |||
| 12_01-Unlocking cells and protecting worksheets.mp4 | 18.38 MB | ||
| 12_02-Protecting workbooks.mp4 | 6.33 MB | ||
| 12_03-Assigning passwords to workbooks.mp4 | 10.59 MB | ||
| 12_04-Sharing workbooks.mp4 | 9.48 MB | ||
| 12_05-Tracking changes.mp4 | 10.3 MB | ||
| 13. Database Features | |||
| 13_01-Sorting data.mp4 | 19.3 MB | ||
| 13_02-Inserting subtotals in a sorted list.mp4 | 36.28 MB | ||
| 13_03-Using filters.mp4 | 16.16 MB | ||
| 13_04-Splitting data into multiple columns.mp4 | 12.7 MB | ||
| 13_05-Removing duplicate records.mp4 | 7.65 MB | ||
| 14. PivotTables | |||
| 14_01-Creating PivotTables.mp4 | 21.36 MB | ||
| 14_02-Manipulating PivotTable data.mp4 | 21.7 MB | ||
| 14_03-Grouping by date and time.mp4 | 14.15 MB | ||
| 14_04-Grouping by other factors.mp4 | 5.17 MB | ||
| 14_05-Using slicers to clarify and manipulate fields.mp4 | 8.67 MB | ||
| 14_06-Using PivotCharts.mp4 | 10.21 MB | ||
| 15. Data Analysis Tools | |||
| 15_01-Using Goal Seek.mp4 | 12.08 MB | ||
| 15_02-Using Solver.mp4 | 13.68 MB | ||
| 15_03-Using Scenario Manager.mp4 | 16.37 MB | ||
| 15_04-Using Data Tables.mp4 | 11.68 MB | ||
| 16. Introduction to Macros | |||
| 16_01-Definition and examples.mp4 | 18.94 MB | ||
| 16_02-Creating a simple macro.mp4 | 18.04 MB | ||
| 16_03-Running a macro.mp4 | 25.09 MB | ||
| 17. Conclusion | |||
| 17_01-Next steps.mp4 | 1.16 MB | ||
| Exercice Files | |||
| Ex_Files_Office365_Excel_EssT.zip | 1.76 KB | ||
| ▲ 83 total files | |||
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
\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
| 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