Lynda - Excel 2011 for the Mac: Mastering Formulas and Functions with Dennis Taylor

seeders: 1

leechers: 0

Download torrent

Added on January 9, 2015 by webcentarain Other > Tutorials
Torrent verified.

Main

add to bookmarks

Lynda - Excel 2011 for the Mac: Mastering Formulas and Functions with Dennis Taylor (Size: 859.58 MB)

		063 Extending formula capabilities with arrays.mp4	22.5 MB
		048 Understanding Excel date-time capabilities in formulas.mp4	20.05 MB
		017 Creating 3D formulas to gather data from multiple sheets.mp4	18.69 MB
		068 Using array formula techniques with the MATCH function for complex lookups.mp4	17.99 MB
		044 Using the random-number functions RAND and RANDBETWEEN.mp4	17.89 MB
		016 Enhancing readability with range names.mp4	17.6 MB
		020 Using the AND and OR functions with IF to create compound logical tests.mp4	17.52 MB
		029 Using MATCH and INDEX together.mp4	17.36 MB
		056 Locating and extracting data with FIND, SEARCH, and MID.mp4	16.56 MB
		046 Using the powerful AGGREGATE function to bypass errors and hidden data.mp4	16.25 MB
		035 Tabulating based on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mp4	16.12 MB
		061 Adjusting character content with REPLACE and SUBSTITUTE.mp4	16.05 MB
		036 Tabulating based on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mp4	15.74 MB
		040 Working with ROUND, ROUNDUP, and ROUNDDOWN.mp4	15.65 MB
		074 Using error-checking functions ISERR, ISERROR, IFERROR, and ISNA.mp4	15.65 MB
		007 Using the Reference button on the Formulas tab for locating functions.mp4	15.62 MB
		004 Using and extending AutoSum button capabilities.mp4	15.24 MB
		062 Using other utility text functions - LEN, REPT, VALUE, TEXT.mp4	15.23 MB
		071 Using INDIRECT with data validation for two-tiered pick-list scenarios.mp4	14.97 MB
		022 Finding approximate matches with VLOOKUP.mp4	14.7 MB
		072 Extracting information with the CELL and INFO functions.mp4	14.67 MB
		010 Tracking cell dependencies and locating formula sources.mp4	14.14 MB
		058 Removing extra spaces with TRIM.mp4	13.52 MB
		012 Copying column formulas instantly.mp4	13.5 MB
		023 Finding exact matches with VLOOKUP.mp4	13.49 MB
		064 Counting unique entries in a range with an array formula.mp4	13.23 MB
		043 Finding the remainder with MOD, and using MOD with conditional formatting.mp4	12.9 MB
		037 Calculating payments with PMT.mp4	12.58 MB
		053 Tabulating date differences with DATEDIF.mp4	12.3 MB
		009 Displaying and highlighting formulas.mp4	12.3 MB
		09-Date.xlsx	643.47 KB
		03-IF Function.xlsx	597.32 KB
		Lookup Functions.xlsx	342.96 KB
		01-Tools.xlsx	486.26 KB
		04-Lookup Functions.xlsx	361.99 KB
		02-TipsShortcuts.xlsx	299.24 KB
		02-RegionalSales.xlsx	38.61 KB
		11-Array.xlsx	164.89 KB
		06-PowerFunctions.xlsx	152.75 KB
		05-Stat.xlsx	124.96 KB
		08-Math.xlsx	70.66 KB
		10-Text.xlsx	21.58 KB
		12-Reference.xlsx	21.54 KB
		07-FinancialFunctions.xlsx	16.41 KB
		13-Information.xlsx	14.95 KB

Description

Lynda - Excel 2011 for the Mac: Mastering Formulas and Functions with Dennis Taylor

Subjects: Business, Spreadsheets, IT, Business Intelligence,
Software: Excel Office

6h 13m Advanced Dec 10, 2014 | Uploaded in Jan 9, 2015 via Webcentara

Conquer some of the most daunting features in Microsoft Excel once and for all. In this version of his popular course, designed specifically for Excel for Mac users, author Dennis Taylor demystifies some of the most challenging of the 300+ formulas and functions in Excel, and shows how to put them to their best use. Dennis covers key shortcuts, the IF and LOOKUP functions for search and data retrieval, the statistical and math functions, and the date, time, and text functions that make formatting easier. He also covers combining functions to extend their power. These practical examples transition effortlessly to real-world scenarios.
Topics include:
• Using absolute, relative, and mixed references
• Using the Formula Builder
• Converting formulas to values
• Creating 3D formulas to gather data from multiple sheets
• Creating and expanding the use of nested IF statements
• Looking up information with VLOOKUP, MATCH, and INDEX
• Using the power functions: COUNTIF, SUMIF, and AVERAGEIF
• Analyzing data with the statistical functions
• Calculating payment
• Performing basic math
• Determining dates and times
• Editing text with functions
• Analyzing data with arrays

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\

Sharing Widget

Download torrent

859.58 MB

seeders:1

leechers:0

Lynda - Excel 2011 for the Mac: Mastering Formulas and Functions with Dennis Taylor