Lynda.com Excel 2010 Advanced Formulas and Functions

seeders: 14
leechers: 17
Added on February 17, 2015 by VIP-Naruin Other > Tutorials
Torrent verified.



Lynda.com Excel 2010 Advanced Formulas and Functions (Size: 623.67 MB)
 0001 Welcome.mov11.44 MB
 0002 Using the exercise files.mov837.85 KB
 0106 Displaying and highlighting formulas.mov21.76 MB
 0101 Using the entire row column references.mov14.73 MB
 0108 Enhancing readability with range names.mov12.74 MB
 0104 Creating 3D formulas to gather data from multiple sheets.mov10.05 MB
 0102 Copying column formulas instantly.mov9.92 MB
 0107 Simplifying debugging formulas.mov8.43 MB
 0103 Converting formulas to values with a simple drag.mov5.98 MB
 0105 Updating values without formulas.mov5.49 MB
 0201 Reviewing function basics.mov29.06 MB
 0204 Using mixed references.mov10.8 MB
 0202 Using and extending AutoSum.mov10.33 MB
 0203 Using absolute and relative references.mov8.99 MB
 0303 Using the AND, OR, and NOT functions with IF to create compound logical tests.mov12.97 MB
 0301 Exploring IF logical tests and using relational operators.mov7.97 MB
 0302 Creating and expanding the use of nested IF statements.mov7.29 MB
 0408 Using MATCH and INDEX together.mov13.84 MB
 0402 Finding approximate matches with VLOOKUP.mov13.74 MB
 0404 Nesting LOOKUP functions.mov12.92 MB
 0406 Locating data with MATCH.mov10.45 MB
 0401 Looking up information with VLOOKUP and HLOOKUP.mov10.21 MB
 0407 Retrieving information by location with INDEX.mov9.63 MB
 0403 Finding exact matches with VLOOKUP.mov7.83 MB
 0405 Finding table-like information within a function with CHOOSE.mov6.29 MB
 0502 Tabulating information on multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS.mov15 MB
 0501 Tabulating information on a single criterion with COUNTIF, SUMIF, and AVERAGEIF.mov8.84 MB
 0602 Ranking data without sorting with RANK.mov10.72 MB
 0604 Tabulating blank cells with COUNTBLANK.mov8.6 MB
 0601 Finding the middle value with MEDIAN.mov3.36 MB
 0603 Finding the magnitude data with LARGE and SMALL.mov3.24 MB
 0701 Understanding Excel date time capabilities in formulas.mov13.05 MB
 0702 Identifying the day of the week with WEEKDAY.mov12.02 MB
 0705 Tabulating date time differences with DATEDIF.mov8.53 MB
 0703 Counting working days with NETWORKDAYS.mov5.26 MB
 0704 Determining a completion date with WORKDAY.mov4.27 MB
 0801 Working with rounding functions.mov15.45 MB
 0803 Building random number generators with RAND and RANDBETWEEN.mov11.36 MB
 0805 Using the powerful new AGGREGATE function to bypass errors and hidden data.mov10.8 MB
 0802 Finding the remainder with MOD and using MOD with conditional formatting.mov10.39 MB
 0804 Converting a value between measurement systems with CONVERT.mov7.87 MB
 0901 Extending formula capabilities with arrays.mov17.68 MB
 0902 Counting unique entries in a range with an array formula.mov11.49 MB
 0906 Combining multiple functions in arrays.mov9.03 MB
 0904 Flipping row column orientation with TRANSPOSE.mov8.95 MB
 0905 Building analysis via regression techniques with TREND and GROWTH.mov8.54 MB
 0903 Determining frequency distributions with FREQUENCY.mov6.05 MB
 1006 Adjusting character content with REPLACE and SUBSTITUTE.mov11.31 MB
 1001 Locating and extracting data with FIND and MID.mov10.99 MB
 1003 Removing excess spaces with TRIM.mov10.36 MB
 1007 Reviewing additional text functions.mov10.34 MB
 1005 Adjusting case within cells with PROPER, UPPER, and LOWER.mov9.43 MB
 1004 Using CONCATENATE with functions.mov7.29 MB
 1002 Extracting specific data with LEFT and RIGHT.mov5.82 MB
 1101 Calculating payments with PMT.mov7.86 MB
 1103 Determining total amount of future payments with PV.mov7.65 MB
 1102 Finding future values with FV.mov6.28 MB
 1202 Using error-checking functions ISERR, ISERROR, IFERROR.mov12.78 MB
 1201 Working with the IS information functions.mov8.16 MB
 1302 Returning references with INDIRECT.mov20.26 MB
 1301 Getting data from remote cells with OFFSET.mov7.66 MB
 1401 Final thoughts.mov2.37 MB
 Ch 1 Tips.xlsx199.41 KB
 Ch 9 Array.xlsx165.26 KB
 Ch 6 Stat.xlsx107.26 KB
 Ch 4 LOOKUP.xlsx103.82 KB
 Ch 8 Math.xlsx70.88 KB
 Ch 2 Functions.xlsx64.78 KB
 Ch 5 Power.xlsx60.97 KB
 Ch 7 Date.xlsx44.79 KB
 Ch 3 IF.xlsx42.92 KB
 Ch 13 Reference.xlsx25.85 KB

Description

5h 5m Advanced Dec 03, 2010

In Excel 2010: Advanced Formulas and Functions, author Dennis Taylor demystifies formulas and some of the most challenging of the nearly 400 functions in Excel and shows how to put them to their best use. The course reviews the building-block functions, along with a few critical keyboard shortcuts that will speed up working with Excel data. It also covers how to perform advanced searching and data retrieval with LOOKUP functions, tabulate data with counting, statistical, and math functions, reformat data with text functions, and work with financial data using advanced formulas. Exercise files accompany the course.
Topics include:

Referencing, copying, updating, and converting formulas
Using the logical functions and creating compound logic tests
Searching for and matching data based on specific criteria
Reconfiguring cell data using text functions
Calculating dates, times, and days of the week
Analyzing mathematical and financial data
Using the power functions, COUNTIFS, SUMIFS, and AVERAGEIFS
Working with rounding functions
Returning cell references

Software:
Excel
Author:
Dennis Taylor

Source Page


Related Torrents

torrent name size seed leech

Sharing Widget


Download torrent
623.67 MB
seeders:14
leechers:17
Lynda.com Excel 2010 Advanced Formulas and Functions