Download Lynda - Office 365 Essential Training: Excel Torrent

Torrent Contents Size: 1.56 GB

Lynda - Office 365 Essential Training: Excel

▼ show more 108 files

01. Introduction

	01_01-Welcome.mp4	MP4	8.05 MB
	01_02-Using the exercise files.mp4	MP4	1.53 MB

02. Getting Started with Excel

02_01-What is Excel used for.mp4	MP4	8.56 MB
02_02-Using the menu system.mp4	MP4	15.78 MB
02_03-Using the Quick Access Toolbar.mp4	MP4	18.68 MB
02_04-Understanding workbooks and worksheets.mp4	MP4	11.99 MB
02_05-Using the Formula bar.mp4	MP4	3.87 MB
02_06-Using the Status bar.mp4	MP4	19.4 MB
02_07-Using navigation tools.mp4	MP4	10.15 MB
02_08-Using shortcut menus and the Mini toolbar.mp4	MP4	13.91 MB
02_09-Creating new workbooks.mp4	MP4	8.7 MB
02_10-Using Excel Help.mp4	MP4	22.52 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.72 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.09 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.18 MB
04_03-Calculating yeartodate totals.mp4	MP4	9.24 MB
04_04-Creating a percentagechange formula.mp4	MP4	18.25 MB
04_05-Working with relative, absolute, and mixed references.mp4	MP4	15.27 MB
04_06-Using SUM and AVERAGE.mp4	MP4	13.24 MB
04_07-Using other common functions.mp4	MP4	23.14 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.37 MB
05_03-Working with alignment and Wrap Text.mp4	MP4	18.65 MB
05_04-Designing borders.mp4	MP4	8.45 MB
05_05-Exploring numeric and special formatting.mp4	MP4	24.89 MB
05_06-Formatting numbers and dates.mp4	MP4	21.3 MB
05_07-Using conditional formatting.mp4	MP4	28.14 MB
05_08-Creating and using tables.mp4	MP4	40.28 MB
05_09-Inserting shapes, arrows, and other visual features.mp4	MP4	29.74 MB

06. Adjusting Worksheet Layout and Data

06_01-Inserting and deleting rows and columns.mp4	MP4	25.24 MB
06_02-Hiding and unhiding rows and columns.mp4	MP4	18.61 MB
06_03-Moving, copying, and inserting data.mp4	MP4	18.23 MB
06_04-Finding and replacing data.mp4	MP4	19.08 MB

07. Printing

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

08. Printing

08_01-Creating charts.mp4	MP4	18.43 MB
08_02-Exploring chart types.mp4	MP4	25.82 MB
08_03-Formatting charts.mp4	MP4	20.65 MB
08_04-Working with axes, titles, and other chart elements.mp4	MP4	17.54 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.27 MB
09_02-Splitting screens horizontally and vertically.mp4	MP4	25.42 MB
09_03-Collapsing and expanding data views with outlining.mp4	MP4	21.82 MB

10. Multiple Worksheets and Workbooks

10_01-Displaying multiple worksheets and workbooks.mp4	MP4	31.69 MB
10_02-Renaming, inserting, and deleting sheets.mp4	MP4	11.26 MB
10_03-Moving, copying, and grouping sheets.mp4	MP4	15.57 MB
10_04-Using formulas to link worksheets and workbooks.mp4	MP4	20.55 MB
10_05-Locating and maintaining links.mp4	MP4	18.61 MB

11. IF, VLOOKUP, and Power Functions

11_01-Using IF functions and relational operators.mp4	MP4	13.41 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.09 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.2 MB
12_02-Protecting workbooks.mp4	MP4	16.81 MB
12_03-Assigning passwords to workbooks.mp4	MP4	7.72 MB
12_04-Sharing workbooks.mp4	MP4	12.34 MB
12_05-Tracking changes.mp4	MP4	15.75 MB

13. Data Management Features

13_01-Sorting data.mp4	MP4	38.76 MB
13_02-Inserting subtotals in a sorted list.mp4	MP4	42.64 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.33 MB
13_06-Removing duplicate records.mp4	MP4	9.19 MB
13_07-Using validation tools.mp4	MP4	26.73 MB

14. Data Analysis Tools

14_01-Using Goal Seek.mp4	MP4	18.91 MB
14_02-Using Solver.mp4	MP4	18.88 MB
14_03-Using Scenario Manager.mp4	MP4	22.28 MB
14_04-Using data tables.mp4	MP4	16.98 MB

15. PivotTables

15_01-Creating PivotTables.mp4	MP4	36.59 MB
15_02-Manipulating PivotTable data.mp4	MP4	29.27 MB
15_03-Grouping by date and time.mp4	MP4	36.37 MB
15_04-Grouping by other factors.mp4	MP4	12.45 MB
15_05-Using slicers to clarify and manipulate fields.mp4	MP4	19.36 MB
15_06-Using PivotCharts.mp4	MP4	13.08 MB

16. Introduction to Macros

16_01-Exploring the need for macros.mp4	MP4	19.36 MB
16_02-Creating a simple macro.mp4	MP4	32.7 MB
16_03-Running a macro.mp4	MP4	34.42 MB

17. Conclusion

17_01-Goodbye.mp4

MP4

1.78 MB

Exercice Files

Ex_Files_Office365_Excel_EssT.zip

ZIP

3.69 MB

Ex_Files_exname

Exercise Files

Ch01

01 - Examples.xlsx	XLSX	287.38 KB
01 - Getting Started.xlsx	XLSX	69.05 KB
~$01 - Getting Started.xlsx	XLSX	165 B

Ch02

02 - Entering Data.xlsx

XLSX

12.04 KB

Ch03

03 - Creating Formulas and Functions.xlsx

XLSX

17.32 KB

Ch04

04 - Formatting.xlsx	XLSX	127.51 KB
Bamboo_Slicker_with logo_YELLOW_101817957.jpg	JPG	49.11 KB
No_Obstacles_logo_transparent.jpg	JPG	51.69 KB
Twenty Second Sneakers_with logo_91548475.jpg	JPG	61.13 KB

Ch05

05 - Layout.xlsx

XLSX

167.31 KB

Ch06

06 - Printing.xlsx

XLSX

189.01 KB

Ch07

07 - Charting.xlsx

XLSX

32.57 KB

Ch08

	08 - Worksheet Views.xlsx	XLSX	187.99 KB
	~$08 - Worksheet Views.xlsx	XLSX	165 B

Ch09

09 - 01 - EmployeeTable.xlsx	XLSX	210.3 KB
09 - 01 - Home Product Line.xlsx	XLSX	50.83 KB
09 - 01 - RegionalSales.xlsx	XLSX	19.38 KB
09 - 02 - RegionalSales.xlsx	XLSX	34.81 KB
09 - 03 - RegionalSales.xlsx	XLSX	18.67 KB
09 - 04 - EmployeeTable.xlsx	XLSX	238.79 KB
09 - 04 - RegionalSales.xlsx	XLSX	19.02 KB
09 - 05 - EmployeeTable.xlsx	XLSX	208.73 KB
09 - 05 - RegionalSales.xlsx	XLSX	22.87 KB

Ch10

10 - IF VLOOKUP COUNTIF.xlsx

XLSX

166.83 KB

Ch11

11 - Security&Sharing.xlsx	XLSX	132.57 KB
11 - TrackingChanges.xlsx	XLSX	131.48 KB
11 - Workbook before Sharing.xlsx	XLSX	28.62 KB
11-TrackingChanges.xlsx	XLSX	131.48 KB

Ch12

12 - Data Management Features.xlsx	XLSX	297.3 KB
12 - DatabaseFeatures.xlsx	XLSX	300.91 KB
~$12 - Data Management Features.xlsx	XLSX	165 B

Ch13

13 - DataAnalysis.xlsx	XLSX	101.19 KB
13 - PivotTables.xlsx	XLSX	166.2 KB
14 - PivotTables.xlsx	XLSX	166.2 KB

Ch14

	14 - DataAnalysis.xlsx	XLSX	121.34 KB
	14 - PivotTables.xlsx	XLSX	167.38 KB

Ch15

	15 - Macros.xlsx	XLSX	118.58 KB
	~$15 - Macros.xlsx	XLSX	165 B

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 Essential Training: Excel

Torrent Contents Size: 1.56 GB

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