Lynda Office 365 Excel Essential Training | ED92C13F1251E85FBA96ACD4D334E52EA34229B5

Lynda Office 365 Excel Essential Training

Name	Lynda - Office 365: Excel Essential Training	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.0 GB
Total Files	83
Hash	ED92C13F1251E85FBA96ACD4D334E52EA34229B5

/13. Database Features/
13_02-Inserting subtotals in a sorted list.mp4	38.0 MB
13_01-Sorting data.mp4	20.2 MB
13_03-Using filters.mp4	16.9 MB
13_04-Splitting data into multiple columns.mp4	13.3 MB
13_05-Removing duplicate records.mp4	8.0 MB
/05. Formatting/
05_08-Creating and using tables.mp4	31.7 MB
05_05-Exploring numeric and special formatting.mp4	18.0 MB
05_09-Inserting shapes, arrows, and other visual features.mp4	17.5 MB
05_06-Formatting numbers and dates.mp4	12.1 MB
05_07-Conditional formatting.mp4	11.6 MB
05_01-Exploring font styles and effects.mp4	10.1 MB
05_04-Designing borders.mp4	8.9 MB
05_03-Working with alignment and Wrap Text.mp4	8.8 MB
05_02-Adjusting row heights and column widths.mp4	8.1 MB
/16. Introduction to Macros/
16_03-Running a macro.mp4	26.3 MB
16_01-Definition and examples.mp4	19.9 MB
16_02-Creating a simple macro.mp4	18.9 MB
/07. Printing/
07_01-Exploring the Page Layout tab and view.mp4	26.1 MB
07_02-Previewing page breaks.mp4	20.4 MB
07_03-Working with Page Setup and printing controls.mp4	15.6 MB
/14. PivotTables/
14_02-Manipulating PivotTable data.mp4	22.8 MB
14_01-Creating PivotTables.mp4	22.4 MB
14_03-Grouping by date and time.mp4	14.8 MB
14_06-Using PivotCharts.mp4	10.7 MB
14_05-Using slicers to clarify and manipulate fields.mp4	9.1 MB
14_04-Grouping by other factors.mp4	5.4 MB
/08. Introduction to Charting/
08_02-Exploring chart types.mp4	19.4 MB
08_05-Creating incell charts with sparklines.mp4	17.2 MB
08_03-Formatting charts.mp4	13.6 MB
08_04-Working with axes labels gridlines and other chart elements.mp4	11.6 MB
08_01-Creating charts.mp4	10.9 MB
/12. Security and Sharing/
12_01-Unlocking cells and protecting worksheets.mp4	19.3 MB
12_03-Assigning passwords to workbooks.mp4	11.1 MB
12_05-Tracking changes.mp4	10.8 MB
12_04-Sharing workbooks.mp4	9.9 MB
12_02-Protecting workbooks.mp4	6.6 MB
/09. Adjusting Worksheet Views/
09_03-Showing necessary information with the Outlining feature.mp4	19.1 MB
09_02-Splitting screens horizontally and vertically.mp4	17.4 MB
09_01-Freezing and unfreezing panes.mp4	11.5 MB
/06. Adjusting Worksheet Layout and Data/
06_04-Finding and replacing data.mp4	17.9 MB
06_03-Moving, copying, and inserting data.mp4	16.0 MB
06_01-Inserting and deleting rows and columns.mp4	14.4 MB
06_02-Hiding and unhiding rows and columns.mp4	11.5 MB
/04. Creating Formulas and Functions/
04_07-Using other common functions.mp4	17.4 MB
04_01-Creating simple formulas Totals and averages.mp4	9.5 MB
04_05-Working with relative, absolute, and mixed references.mp4	8.8 MB
04_04-Creating a percentageincrease formula.mp4	7.6 MB
04_06-Using SUM and AVERAGE.mp4	7.2 MB
04_03-Calculating yeartodate profits.mp4	5.8 MB
04_02-Copying a formula for adjacent cells.mp4	5.3 MB
/15. Data Analysis Tools/
15_03-Using Scenario Manager.mp4	17.2 MB
15_02-Using Solver.mp4	14.3 MB
15_01-Using Goal Seek.mp4	12.7 MB
15_04-Using Data Tables.mp4	12.2 MB
/11. IF, VLOOKUP, and Power Functions/
11_02-Getting approximate table data with the VLOOKUP function.mp4	15.9 MB
11_04-Using the COUNTIF family of functions.mp4	12.8 MB
11_03-Getting exact table data with the VLOOKUP function.mp4	12.7 MB
11_01-Using IF functions and relational operators.mp4	8.0 MB
/10. Multiple Worksheets and Workbooks/
10_05-Locating and maintaining links.mp4	14.9 MB
10_04-Using formulas to link worksheets and workbooks.mp4	12.8 MB
10_01-Displaying multiple worksheets and workbooks.mp4	10.6 MB
10_03-Moving, copying, and grouping sheets.mp4	7.2 MB
10_02-Renaming, inserting, and deleting sheets.mp4	5.5 MB
/02. Getting Started with Excel 2013/
02_03-The Quick Access Toolbar.mp4	14.3 MB
02_02-Using the menu system.mp4	12.9 MB
02_04-The structure of a worksheet or workbook.mp4	8.6 MB
02_06-Using the Status bar.mp4	7.5 MB
02_08-Shortcut menus and the Mini toolbar.mp4	7.2 MB
02_09-Using the builtin help.mp4	7.0 MB
02_10-Creating new files.mp4	6.6 MB
02_07-Navigation and mouse pointers.mp4	6.5 MB
02_01-What is Excel used for.mp4	5.5 MB
02_05-Using the Formula bar.mp4	3.5 MB
/03. Entering Data/
03_04-Using Undo and Redo.mp4	8.5 MB
03_01-Exploring data entry and editing techniques.mp4	7.5 MB
03_02-Entering data with AutoFill.mp4	7.3 MB
03_06-Using Save or Save As.mp4	6.9 MB
03_03-Working with dates and times.mp4	5.6 MB
03_05-Adding comments.mp4	5.1 MB
/01. Introduction/
01_01-Welcome.mp4	8.2 MB
01_02-Using the exercise files.mp4	1.6 MB
/17. Conclusion/
17_01-Next steps.mp4	1.2 MB
/Exercice Files/
Ex_Files_Office365_Excel_EssT.zip	1.8 KB
Total files 83