Download lynda.com - Excel 2010: Advanced Formulas and Functions [ENG, 2010] Torrent

Torrent Contents Size: 623.67 MB

lynda.com - Excel 2010: Advanced Formulas and Functions [ENG, 2010]

▼ show more 60 files

00 Introduction

	0001 Welcome.mov	MOV	11.44 MB
	0002 Using the exercise files.mov	MOV	837.85 KB

01 Formula and Function Tips and Shortcuts

0101 Using the entire row column references.mov	MOV	14.73 MB
0102 Copying column formulas instantly.mov	MOV	9.92 MB
0103 Converting formulas to values with a simple drag.mov	MOV	5.98 MB
0104 Creating 3D formulas to gather data from multiple sheets.mov	MOV	10.05 MB
0105 Updating values without formulas.mov	MOV	5.49 MB
0106 Displaying and highlighting formulas.mov	MOV	21.76 MB
0107 Simplifying debugging formulas.mov	MOV	8.43 MB
0108 Enhancing readability with range names.mov	MOV	12.74 MB

02 Formula and Function Tools

0201 Reviewing function basics.mov	MOV	29.06 MB
0202 Using and extending AutoSum.mov	MOV	10.33 MB
0203 Using absolute and relative references.mov	MOV	8.99 MB
0204 Using mixed references.mov	MOV	10.8 MB

03 IF and Related Functions

0301 Exploring IF logical tests and using relational operators.mov	MOV	7.97 MB
0302 Creating and expanding the use of nested IF statements.mov	MOV	7.29 MB
0303 Using the AND, OR, and NOT functions with IF to create compound logical tests.mov	MOV	12.97 MB

04 Lookup and Reference Function

0401 Looking up information with VLOOKUP and HLOOKUP.mov	MOV	10.21 MB
0402 Finding approximate matches with VLOOKUP.mov	MOV	13.74 MB
0403 Finding exact matches with VLOOKUP.mov	MOV	7.83 MB
0404 Nesting LOOKUP functions.mov	MOV	12.92 MB
0405 Finding table-like information within a function with CHOOSE.mov	MOV	6.29 MB
0406 Locating data with MATCH.mov	MOV	10.45 MB
0407 Retrieving information by location with INDEX.mov	MOV	9.63 MB
0408 Using MATCH and INDEX together.mov	MOV	13.84 MB

05 Power Functions

	0501 Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov	MOV	8.84 MB
	0502 Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov	MOV	15 MB

06 Statistical Functions

0601 Finding the middle value with MEDIAN.mov	MOV	3.36 MB
0602 Ranking data without sorting with RANK.mov	MOV	10.72 MB
0603 Finding the magnitude data with LARGE and SMALL.mov	MOV	3.24 MB
0604 Tabulating blank cells with COUNTBLANK.mov	MOV	8.6 MB

07 Data Functions

0701 Understanding Excel date time capabilities in formulas.mov	MOV	13.05 MB
0702 Identifying the day of the week with WEEKDAY.mov	MOV	12.02 MB
0703 Counting working days with NETWORKDAYS.mov	MOV	5.26 MB
0704 Determining a completion date with WORKDAY.mov	MOV	4.27 MB
0705 Tabulating date time differences with DATEDIF.mov	MOV	8.53 MB

08 Math Functions

0801 Working with rounding functions.mov	MOV	15.45 MB
0802 Finding the remainder with MOD and using MOD with conditional formatting.mov	MOV	10.39 MB
0803 Building random number generators with RAND and RANDBETWEEN.mov	MOV	11.36 MB
0804 Converting a value between measurement systems with CONVERT.mov	MOV	7.87 MB
0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.mov	MOV	10.8 MB

09 Array Formulas and Functions

0901 Extending formula capabilities with arrays.mov	MOV	17.68 MB
0902 Counting unique entries in a range with an array formula.mov	MOV	11.49 MB
0903 Determining frequency distributions with FREQUENCY.mov	MOV	6.05 MB
0904 Flipping row column orientation with TRANSPOSE.mov	MOV	8.95 MB
0905 Building analysis via regression techniques with TREND and GROWTH.mov	MOV	8.54 MB
0906 Combining multiple functions in arrays.mov	MOV	9.03 MB

10 Text Functions

1001 Locating and extracting data with FIND and MID.mov	MOV	10.99 MB
1002 Extracting specific data with LEFT and RIGHT.mov	MOV	5.82 MB
1003 Removing excess spaces with TRIM.mov	MOV	10.36 MB
1004 Using CONCATENATE with functions.mov	MOV	7.29 MB
1005 Adjusting case within cells with PROPER, UPPER, and LOWER.mov	MOV	9.43 MB
1006 Adjusting character content with REPLACE and SUBSTITUTE.mov	MOV	11.31 MB
1007 Reviewing additional text functions.mov	MOV	10.34 MB

11 Financial Functions

1101 Calculating payments with PMT.mov	MOV	7.86 MB
1102 Finding future values with FV.mov	MOV	6.28 MB
1103 Determining total amount of future payments with PV.mov	MOV	7.65 MB

12 Information Functions

	1201 Working with the IS information functions.mov	MOV	8.16 MB
	1202 Using error-checking functions ISERR, ISERROR, IFERROR.mov	MOV	12.78 MB

13 Reference Functions

	1301 Getting data from remote cells with OFFSET.mov	MOV	7.66 MB
	1302 Returning references with INDIRECT.mov	MOV	20.26 MB

14 Conclusion

1401 Final thoughts.mov

MOV

2.37 MB

Exercise Files

Ch 1 Tips.xlsx	XLSX	199.41 KB
Ch 10 Text.xlsx	XLSX	21.36 KB
Ch 11 Financial.xlsx	XLSX	12.66 KB
Ch 12 Information.xlsx	XLSX	14.75 KB
Ch 13 Reference.xlsx	XLSX	25.85 KB
Ch 2 Functions.xlsx	XLSX	64.78 KB
Ch 3 IF.xlsx	XLSX	42.92 KB
Ch 4 LOOKUP.xlsx	XLSX	103.82 KB
Ch 5 Power.xlsx	XLSX	60.97 KB
Ch 6 Stat.xlsx	XLSX	107.26 KB
Ch 7 Date.xlsx	XLSX	44.79 KB
Ch 8 Math.xlsx	XLSX	70.88 KB
Ch 9 Array.xlsx	XLSX	165.26 KB

Description

Show full description

Related Torrents

TORRENT NAME	SIZE	FILES	AGE	SEED	LEECH	SOURCE
[Lynda.com].Laravel 9.0 Essential Training.(2022).[MP4] Posted by Midiablooo in Other Posted in Other 0 496.73 MB 3 years ago Midiablooo	Size 496.73 MB	Files 90	Age 3 years ago	Seeds 0	Leechs 0	Source
[TutorialPace] Lynda.com - CorelDRAW Essential Training - [TP] Posted by TutorialPace in Other Posted in Other 0 1 GB 6 years ago TutorialPace	Size 1 GB	Files 54	Age 6 years ago	Seeds 0	Leechs 1	Source
[Lynda.com] - Foundations of Programming : Fundamentals (2011) [WebDL mov 540p EN] Posted by Hrund in Other Posted in Other 0 1.07 GB 6 years ago Hrund	Size 1.07 GB	Files 162	Age 6 years ago	Seeds 0	Leechs 0	Source
[Lynda.com] - Foundations of Programming : Web Security (2014) [WebDL MP4 720p EN ] Posted by Imadiano in Other Posted in Other 6 299.07 MB 6 years ago Imadiano	Size 299.07 MB	Files 51	Age 6 years ago	Seeds 6	Leechs 0	Source
[Lynda.com] - Foundations of Programming : Databases (2015) [WebDL - WMV En] Posted by Hrund in Other Posted in Other 0 916.21 MB 6 years ago Hrund	Size 916.21 MB	Files 40	Age 6 years ago	Seeds 0	Leechs 0	Source

lynda.com - Excel 2010: Advanced Formulas and Functions [ENG, 2010]

Torrent Contents Size: 623.67 MB

Description

Related Torrents

Location

Trackers

Latest News

Latest Searches

Sites In Our Index

Popular Tags

Tracker name
http://bt2.t-ru.org/ann?magnet
http://bt2.t-ru.org/ann
http://bt3.t-ru.org/ann
http://bt4.t-ru.org/ann
udp://tracker.opentrackr.org:1337
udp://open.stealth.si:80/announce
udp://tracker.torrent.eu.org:451/announce
udp://exodus.desync.com:6969
udp://open.demonii.com:1337/announce
udp://tracker.coppersurfer.tk:6969
udp://p4p.arenabg.com:1337
udp://tracker.internetwarriors.net:1337