Lynda Excel 2016 Essential Training | 36FEA24E2ED42CE29C3D7B3645BCAFA54748C949

Lynda Excel 2016 Essential Training

Name	Lynda - Excel 2016 Essential Training	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	1.7 GB
Total Files	85
Hash	36FEA24E2ED42CE29C3D7B3645BCAFA54748C949

/01. Introduction/
01_01-Welcome.mp4	4.9 MB
01_02-Using the exercise files.mp4	1.6 MB
/02. Getting Started with Excel/
02_01-What is Excel used for.mp4	9.0 MB
02_02-Using the menu system.mp4	16.6 MB
02_03-Using the Quick Access Toolbar.mp4	19.6 MB
02_04-Understanding workbooks and worksheets.mp4	12.6 MB
02_05-Using the Formula bar.mp4	4.1 MB
02_06-Using the Status bar.mp4	20.3 MB
02_07-Using navigation tools.mp4	10.7 MB
02_08-Using shortcut menus and the Mini toolbar.mp4	14.6 MB
02_09-Creating new workbooks.mp4	9.1 MB
02_10-Using Excel Help.mp4	23.6 MB
/03. Entering Data/
03_01-Exploring data entry and editing techniques.mp4	8.6 MB
03_02-Entering data with AutoFill.mp4	10.2 MB
03_03-Working with dates and times.mp4	10.4 MB
03_04-Using Undo and Redo.mp4	10.2 MB
03_05-Adding comments.mp4	5.9 MB
03_06-Using Save or Save As.mp4	10.6 MB
/04. Creating Formulas and Functions/
04_01-Creating simple formulas.mp4	17.8 MB
04_02-Copying a formula into adjacent cells.mp4	9.6 MB
04_03-Calculating yeartodate totals.mp4	9.7 MB
04_04-Creating a percentagechange formula.mp4	19.2 MB
04_05-Working with relative, absolute, and mixed references.mp4	16.0 MB
04_06-Using SUM and AVERAGE.mp4	13.9 MB
04_07-Using other common functions.mp4	24.3 MB
/05. Formatting/
05_01-Exploring font styles and effects.mp4	10.5 MB
05_02-Adjusting row heights and column widths.mp4	17.2 MB
05_03-Working with alignment and Wrap Text.mp4	19.5 MB
05_04-Designing borders.mp4	8.9 MB
05_05-Exploring numeric and special formatting.mp4	26.1 MB
05_06-Formatting numbers and dates.mp4	22.3 MB
05_07-Using conditional formatting.mp4	29.5 MB
05_08-Creating and using tables.mp4	42.2 MB
05_09-Inserting shapes, arrows, and other visual features.mp4	31.2 MB
/06. Adjusting Worksheet Layout and Data/
06_01-Inserting and deleting rows and columns.mp4	26.4 MB
06_02-Hiding and unhiding rows and columns.mp4	19.5 MB
06_03-Moving, copying, and inserting data.mp4	19.1 MB
06_04-Finding and replacing data.mp4	20.0 MB
/07. Printing/
07_01-Exploring the Page Layout tab and Page Layout view.mp4	30.2 MB
07_02-Previewing page breaks.mp4	25.8 MB
07_03-Working with Page Setup and printing controls.mp4	29.6 MB
/08. Printing/
08_01-Creating charts.mp4	19.3 MB
08_02-Exploring chart types.mp4	27.1 MB
08_03-Formatting charts.mp4	21.6 MB
08_04-Working with axes, titles, and other chart elements.mp4	18.4 MB
08_05-Creating incell charts with sparklines.mp4	20.6 MB
/09. Adjusting Worksheet Views/
09_01-Freezing and unfreezing panes.mp4	27.5 MB
09_02-Splitting screens horizontally and vertically.mp4	26.6 MB
09_03-Collapsing and expanding data views with outlining.mp4	22.8 MB
/10. Multiple Worksheets and Workbooks/
10_01-Displaying multiple worksheets and workbooks.mp4	33.2 MB
10_02-Renaming, inserting, and deleting sheets.mp4	11.8 MB
10_03-Moving, copying, and grouping sheets.mp4	16.4 MB
10_04-Using formulas to link worksheets and workbooks.mp4	21.5 MB
10_05-Locating and maintaining links.mp4	19.5 MB
/11. IF, VLOOKUP, and Power Functions/
11_01-Using IF functions and relational operators.mp4	14.1 MB
11_02-Getting approximate table data with the VLOOKUP function.mp4	18.7 MB
11_03-Getting exact table data with the VLOOKUP function.mp4	26.3 MB
11_04-Using the COUNTIF family of functions.mp4	16.2 MB
/12. Security and Sharing/
12_01-Unlocking cells and protecting worksheets.mp4	25.4 MB
12_02-Protecting workbooks.mp4	17.6 MB
12_03-Assigning passwords to workbooks.mp4	8.1 MB
12_04-Sharing workbooks.mp4	13.0 MB
12_05-Tracking changes.mp4	16.5 MB
/13. Data Management Features/
13_01-Sorting data.mp4	40.7 MB
13_02-Inserting subtotals in a sorted list.mp4	44.9 MB
13_03-Using filters.mp4	25.1 MB
13_04-Splitting data into multiple columns.mp4	27.1 MB
13_05-Splitting and combining columnar data with Flash Fill.mp4	22.4 MB
13_06-Removing duplicate records.mp4	9.6 MB
13_07-Using validation tools.mp4	28.0 MB
/14. Data Analysis Tools/
14_01-Using Goal Seek.mp4	19.9 MB
14_02-Using Solver.mp4	19.8 MB
14_03-Using Scenario Manager.mp4	23.4 MB
14_04-Using data tables.mp4	17.8 MB
/15. PivotTables/
15_01-Creating PivotTables.mp4	38.4 MB
15_02-Manipulating PivotTable data.mp4	30.7 MB
15_03-Grouping by date and time.mp4	38.2 MB
15_04-Grouping by other factors.mp4	13.1 MB
15_05-Using slicers to clarify and manipulate fields.mp4	20.3 MB
15_06-Using PivotCharts.mp4	13.7 MB
/16. Introduction to Macros/
16_01-Exploring the need for macros.mp4	20.3 MB
16_02-Creating a simple macro.mp4	34.3 MB
16_03-Running a macro.mp4	36.1 MB
/17. Conclusion/
17_01-Goodbye.mp4	2.1 MB
/
Ex_Files_Excel_2016_EssT.zip	3.9 MB
Total files 85