Lynda - Office 2016 Essential Training - Excel 2016

seeders: 0 leechers: 1 updated: 1 year ago
Added 10 years ago by External VIP Uploader 2boweb in Other
Downloaded 46 times.
thepiratebay.org
Lynda - Office 2016 Essential Training - Excel 2016

Torrent Contents Size: 1.55 GB

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

Description

Related Torrents

Location

Trackers

Tracker name
udp://tracker.coppersurfer.tk:6969/announce
udp://9.rarbg.me:2850/announce
udp://9.rarbg.to:2920/announce
udp://tracker.opentrackr.org:1337
udp://tracker.leechers-paradise.org:6969/announce
Torrent hash: