种子简介

种子名称： Lynda - Excel 2013 Tutorials Advanced Formulas and Functions
文件类型：
文件数目： 73个文件
文件大小： 727.02 MB
收录时间： 2016-2-9 07:05
已经下载： 3次
资源热度： 140
最近下载： 2024-11-11 02:53

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:B9DC779BF99D7E58104A6C8AE0123A0B5CBD5D56&dn=Lynda - Excel 2013 Tutorials Advanced Formulas and Functions 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Lynda - Excel 2013 Tutorials Advanced Formulas and Functions.torrent

Extending formula capabilities with arrays-135786.mp425.36MB

Using INDIRECT with data validation for two-tiered pick list scenarios-135795.mp418.74MB

Finding approximate matches with VLOOKUP-135750.mp417.33MB

Using MATCH and INDEX together-135757.mp417.28MB

Tabulating blank cells with COUNTBLANK-135765.mp416.65MB

Understanding Excel date_time capabilities in formulas-135777.mp416.48MB

Practical uses for the random number functions RAND and RANDBETWEEN-135772.mp415.04MB

Counting unique entries in a range with an array formula-135787.mp414.95MB

Auditing tools-135729.mp414.55MB

Enhancing readability with range names-135735.mp414.1MB

Displaying and highlighting formulas-135728.mp413.47MB

Using the powerful AGGREGATE function to bypass errors and hidden data-135774.mp413.45MB

Using the AND and OR functions with IF to create compound logical tests-135747.mp413.36MB

Using other utility text functions - LEN, REPT, VALUE, TEXT-135803.mp412.72MB

Using error-checking functions ISERR, ISERROR, IFERROR, ISNA, and IFNA-135807.mp412.58MB

Ranking data without sorting with RANK-135763.mp412.48MB

Using and extending AutoSum button capabilities-135741.mp412.29MB

Looking up information with VLOOKUP and HLOOKUP-135749.mp412.2MB

Tabulating information using a single criterion with COUNTIF, SUMIF, and AVERAGEIF-135759.mp412.19MB

Tabulating date differences with DATEDIF-135782.mp411.55MB

Getting data from remote cells with OFFSET-135793.mp411.48MB

Working with ROUND, ROUNDUP, and ROUNDDOWN-135768.mp411.48MB

Using ampersands and CONCATENATE to combine data from different cells-135800.mp411.16MB

Adjusting character content with REPLACE and SUBSTITUTE-135802.mp411.14MB

Using entire row_column references-135730.mp411.02MB

Calculating end-of-month and future_past dates with EDATE and EOMONTH-135783.mp410.93MB

Finding the remainder with MOD and using MOD with conditional formatting-135771.mp410.86MB

Tabulating information using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS-135760.mp410.78MB

Building analysis via regression techniques with TREND and GROWTH-135790.mp410.71MB

Copying column formulas instantly-135731.mp410.63MB

Using ISBLANK, ISODD, ISEVEN, ISTEXT, and ISNUMBER-135806.mp410.1MB

Simplifying debugging formulas-135734.mp410.04MB

Extracting information with the CELL and INFO functions-135805.mp410.02MB

Locating and extracting data with FIND, SEARCH, and MID-135797.mp49.96MB

Working with MROUND, CEILING, and FLOOR for specialized rounding-135769.mp49.76MB

Nesting lookup functions-135752.mp49.66MB

Identifying the day of the week with WEEKDAY-135779.mp49.51MB

Removing extra spaces with TRIM and removing hidden characters with CLEAN-135799.mp49.42MB

Finding exact matches with VLOOKUP-135751.mp49.15MB

Converting text entries into dates and times with DATEVALUE and TIMEVALUE-135784.mp49.09MB

Locating data with MATCH-135755.mp49.08MB

Using array formula techniques with the MATCH function for complex lookups-135791.mp48.98MB

Creating 3D formulas to gather data from multiple sheets-135736.mp48.87MB

Determining frequency distributions with FREQUENCY-135788.mp48.65MB

Using VLOOKUP with large tables-135753.mp48.61MB

Returning references with INDIRECT-135794.mp48.5MB

Converting formulas to values with a simple drag-135732.mp48.29MB

Adjusting the case within cells with PROPER, UPPER, and LOWER-135801.mp48.07MB

Counting working days with NETWORKDAYS-135780.mp48MB

Using the Insert Function button for guidance with unfamiliar functions-135740.mp47.9MB

Flipping row_column orientation with TRANSPOSE-135789.mp47.82MB

Using mixed references in formulas-135743.mp47.7MB

Creating and expanding the use of nested IF statements-135746.mp47.56MB

Using COUNT, COUNTA, and the status bar-135766.mp47.17MB

Finding the middle value with MEDIAN-135762.mp46.89MB

Exploring IF logical tests and using relational operators-135745.mp46.89MB

Using the Formulas tab on the Ribbon for locating functions-135739.mp46.86MB

Using TODAY and NOW functions for dynamic date_time entry-135778.mp46.77MB

Determining a completion date with WORKDAY-135781.mp46.58MB

Converting a value between measurement systems with CONVERT-135773.mp46.55MB

Using absolute and relative references in formulas-135742.mp46.47MB

Using the INT and TRUNC functions to extract integer data-135770.mp46.16MB

Finding table-like information within a function with CHOOSE-135754.mp45.99MB

Retrieving information by location with INDEX-135756.mp45.92MB

Extracting specific data with LEFT and RIGHT-135798.mp45.9MB

Welcome-135725.mp45.89MB

Using the ROMAN and ARABIC functions to display different numeral systems-135775.mp45.86MB

Updating values without formulas-135733.mp45.65MB

Understanding the hierarchy of operations in Excel formulas-135738.mp45.43MB

Using the ISFORMULA function with conditional formatting-135808.mp45.11MB

Finding the largest and smallest values with LARGE and SMALL-135764.mp44.44MB

Using the exercise files-135726.mp41.73MB

Goodbye-135810.mp4780.37KB