Download Lynda - Office 365: Excel Essential Training with Dennis Taylor Torrent

Torrent Contents Size: 976.6 MB

Lynda - Office 365: Excel Essential Training with Dennis Taylor

▼ show more 68 files

01. Introduction

	01_01-Welcome.mp4	MP4	7.8 MB
	01_02-Using the exercise files.mp4	MP4	1.54 MB

02. Getting Started with Excel 2013

02_01-What is Excel used for.mp4	MP4	5.28 MB
02_02-Using the menu system.mp4	MP4	12.32 MB
02_03-The Quick Access Toolbar.mp4	MP4	13.68 MB
02_04-The structure of a worksheet or workbook.mp4	MP4	8.19 MB
02_05-Using the Formula bar.mp4	MP4	3.33 MB
02_06-Using the Status bar.mp4	MP4	7.12 MB
02_07-Navigation and mouse pointers.mp4	MP4	6.19 MB
02_08-Shortcut menus and the Mini toolbar.mp4	MP4	6.9 MB
02_09-Using the builtin help.mp4	MP4	6.68 MB
02_10-Creating new files.mp4	MP4	6.3 MB

03. Entering Data

03_01-Exploring data entry and editing techniques.mp4	MP4	7.19 MB
03_02-Entering data with AutoFill.mp4	MP4	6.93 MB
03_03-Working with dates and times.mp4	MP4	5.39 MB
03_04-Using Undo and Redo.mp4	MP4	8.08 MB
03_05-Adding comments.mp4	MP4	4.89 MB
03_06-Using Save or Save As.mp4	MP4	6.59 MB

04. Creating Formulas and Functions

04_01-Creating simple formulas Totals and averages.mp4	MP4	9.02 MB
04_02-Copying a formula for adjacent cells.mp4	MP4	5.05 MB
04_03-Calculating yeartodate profits.mp4	MP4	5.51 MB
04_04-Creating a percentageincrease formula.mp4	MP4	7.23 MB
04_05-Working with relative, absolute, and mixed references.mp4	MP4	8.41 MB
04_06-Using SUM and AVERAGE.mp4	MP4	6.86 MB
04_07-Using other common functions.mp4	MP4	16.56 MB

05. Formatting

05_01-Exploring font styles and effects.mp4	MP4	9.66 MB
05_02-Adjusting row heights and column widths.mp4	MP4	7.72 MB
05_03-Working with alignment and Wrap Text.mp4	MP4	8.42 MB
05_04-Designing borders.mp4	MP4	8.51 MB
05_05-Exploring numeric and special formatting.mp4	MP4	17.17 MB
05_06-Formatting numbers and dates.mp4	MP4	11.53 MB
05_07-Conditional formatting.mp4	MP4	11.02 MB
05_08-Creating and using tables.mp4	MP4	30.23 MB
05_09-Inserting shapes, arrows, and other visual features.mp4	MP4	16.69 MB

06. Adjusting Worksheet Layout and Data

06_01-Inserting and deleting rows and columns.mp4	MP4	13.72 MB
06_02-Hiding and unhiding rows and columns.mp4	MP4	11.01 MB
06_03-Moving, copying, and inserting data.mp4	MP4	15.26 MB
06_04-Finding and replacing data.mp4	MP4	17.06 MB

07. Printing

07_01-Exploring the Page Layout tab and view.mp4	MP4	24.86 MB
07_02-Previewing page breaks.mp4	MP4	19.45 MB
07_03-Working with Page Setup and printing controls.mp4	MP4	14.91 MB

08. Introduction to Charting

08_01-Creating charts.mp4	MP4	10.37 MB
08_02-Exploring chart types.mp4	MP4	18.52 MB
08_03-Formatting charts.mp4	MP4	12.96 MB
08_04-Working with axes labels gridlines and other chart elements.mp4	MP4	11.06 MB
08_05-Creating incell charts with sparklines.mp4	MP4	16.42 MB

09. Adjusting Worksheet Views

09_01-Freezing and unfreezing panes.mp4	MP4	10.94 MB
09_02-Splitting screens horizontally and vertically.mp4	MP4	16.62 MB
09_03-Showing necessary information with the Outlining feature.mp4	MP4	18.25 MB

10. Multiple Worksheets and Workbooks

10_01-Displaying multiple worksheets and workbooks.mp4	MP4	10.08 MB
10_02-Renaming, inserting, and deleting sheets.mp4	MP4	5.26 MB
10_03-Moving, copying, and grouping sheets.mp4	MP4	6.88 MB
10_04-Using formulas to link worksheets and workbooks.mp4	MP4	12.19 MB
10_05-Locating and maintaining links.mp4	MP4	14.17 MB

11. IF, VLOOKUP, and Power Functions

11_01-Using IF functions and relational operators.mp4	MP4	7.6 MB
11_02-Getting approximate table data with the VLOOKUP function.mp4	MP4	15.18 MB
11_03-Getting exact table data with the VLOOKUP function.mp4	MP4	12.1 MB
11_04-Using the COUNTIF family of functions.mp4	MP4	12.25 MB

12. Security and Sharing

12_01-Unlocking cells and protecting worksheets.mp4	MP4	18.38 MB
12_02-Protecting workbooks.mp4	MP4	6.33 MB
12_03-Assigning passwords to workbooks.mp4	MP4	10.59 MB
12_04-Sharing workbooks.mp4	MP4	9.48 MB
12_05-Tracking changes.mp4	MP4	10.3 MB

13. Database Features

13_01-Sorting data.mp4	MP4	19.3 MB
13_02-Inserting subtotals in a sorted list.mp4	MP4	36.28 MB
13_03-Using filters.mp4	MP4	16.16 MB
13_04-Splitting data into multiple columns.mp4	MP4	12.7 MB
13_05-Removing duplicate records.mp4	MP4	7.65 MB

14. PivotTables

14_01-Creating PivotTables.mp4	MP4	21.36 MB
14_02-Manipulating PivotTable data.mp4	MP4	21.7 MB
14_03-Grouping by date and time.mp4	MP4	14.15 MB
14_04-Grouping by other factors.mp4	MP4	5.17 MB
14_05-Using slicers to clarify and manipulate fields.mp4	MP4	8.67 MB
14_06-Using PivotCharts.mp4	MP4	10.21 MB

15. Data Analysis Tools

15_01-Using Goal Seek.mp4	MP4	12.08 MB
15_02-Using Solver.mp4	MP4	13.68 MB
15_03-Using Scenario Manager.mp4	MP4	16.37 MB
15_04-Using Data Tables.mp4	MP4	11.68 MB

16. Introduction to Macros

16_01-Definition and examples.mp4	MP4	18.94 MB
16_02-Creating a simple macro.mp4	MP4	18.04 MB
16_03-Running a macro.mp4	MP4	25.09 MB

17. Conclusion

17_01-Next steps.mp4

MP4

1.16 MB

Exercice Files

Ex_Files_Office365_Excel_EssT.zip

ZIP

1.76 KB

Description

									Show full description
								

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
[ DevCourseWeb ] Lynda - Excel - Setting Up a Database (Office 365 - Microsoft 365) Posted by freecoursewb in Other Posted in Other 0 207.9 MB 5 years ago freecoursewb	Size 207.9 MB	Files 1	Age 5 years ago	Seeds 0	Leechs 0	Source
Lynda - Excel: Setting Up a Database (Office 365/Microsoft 365) Posted by tutsnode in Other Posted in Other 12 215.36 MB 5 years ago tutsnode	Size 215.36 MB	Files 36	Age 5 years ago	Seeds 12	Leechs 1	Source
[ DevCourseWeb ] Lynda - Word Essential Training (Office 365 - Microsoft 365) Posted by freecoursewb in Other Posted in Other 0 466.3 MB 5 years ago freecoursewb	Size 466.3 MB	Files 1	Age 5 years ago	Seeds 0	Leechs 1	Source
[ FreeCourseWeb ] Lynda - PowerPoint Essential Training (Office 365 - Microsoft 365) Posted by freecoursewb in Other Posted in Other 0 1.2 GB 5 years ago freecoursewb	Size 1.2 GB	Files 1	Age 5 years ago	Seeds 0	Leechs 1	Source
[ DevCourseWeb ] Lynda - Note-Taking Tips for Microsoft Office 365 Posted by freecoursewb in Other Posted in Other 0 169.6 MB 5 years ago freecoursewb	Size 169.6 MB	Files 1	Age 5 years ago	Seeds 0	Leechs 0	Source

Lynda - Office 365: Excel Essential Training with Dennis Taylor

Torrent Contents Size: 976.6 MB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

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