种子简介

种子名称： Lynda - Excel 2016 Advanced Formulas and Functions
文件类型： 视频
文件数目： 79个文件
文件大小： 1.02 GB
收录时间： 2016-11-14 11:38
已经下载： 3次
资源热度： 203
最近下载： 2024-6-18 05:22

下载BT种子文件

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

磁力链接下载

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

喜欢这个种子的人也喜欢

种子包含的文件

Lynda - Excel 2016 Advanced Formulas and Functions.torrent

Using the ISERR, ISERROR, IFERROR, and ISNA error-checking functions-463375.mp423.32MB

Tabulating data from multiple sheets-463302.mp422.59MB

Using Auditing tools-463295.mp422.4MB

Understanding Excel date and time capabilities in formulas-463345.mp422.36MB

Using the powerful AGGREGATE function to bypass errors and hidden data-463342.mp421.06MB

Finding approximate matches with VLOOKUP and HLOOKUP-463317.mp420.92MB

Using INDIRECT with Data Validation for two-tiered pick list scenarios-463363.mp420.54MB

AND, OR, and NOT functions with IF-463314.mp420.38MB

Preventing double counting-463328.mp418.3MB

Locating and extracting data with the FIND, SEARCH, and MID functions-463365.mp417.79MB

Counting unique entries in a range with an array formula-463355.mp417.01MB

Tabulating data using multiple criteria-463327.mp416.94MB

Using array formulas and the MATCH function for complex lookups-463359.mp416.56MB

Displaying and highlighting formulas-463294.mp416.37MB

Using VLOOKUP with large tables-463320.mp416.3MB

Using autocalculate in the status bar-463310.mp416.29MB

Absolute and relative references-463308.mp416.02MB

Converting formulas to values with a drag-463298.mp415.93MB

Using the SWITCH function for formula-embedded selection-480582.mp415.55MB

Formulas tab for locating functions-463305.mp415.52MB

Counting working days with the NETWORKDAYS function-463349.mp415.52MB

Finding exact matches with VLOOKUP-463318.mp415.33MB

Exploring practical uses for the RAND and RANDBETWEEN functions-463340.mp415.23MB

Using the TODAY and NOW functions for dynamic date and time entry-463347.mp415.15MB

Using the CONCAT and TEXTJOIN to combine data from different cells-480584.mp415.06MB

Finding the remainder with MOD and using MOD with conditional formatting-463339.mp414.94MB

Tabulating date differences with the DATEDIF function-463351.mp414.93MB

Using mixed references in formulas-463309.mp414.92MB

Hierarchy of operations in formulas-463304.mp414.87MB

Using the TRIM function to remove unwanted spaces in a cell-463367.mp414.84MB

Tabulating blank cells with the COUNTBLANK function-463333.mp414.8MB

Extending formula capabilities with array formulas-463354.mp414.7MB

Using ampersands and CONCATENATE to combine data from different cells-463368.mp414.66MB

Extending the capabilities of AutoSum-463307.mp414.57MB

Enhancing readability with range names-463301.mp414.42MB

Working with the ROUND, ROUNDUP, and ROUNDDOWN functions-463336.mp414.42MB

Getting data from remote cells with the OFFSET function-463361.mp414.34MB

Flipping row and column orientation with TRANSPOSE-463357.mp414.2MB

Adjusting character content with the REPLACE and SUBSTITUTE functions-463370.mp414.16MB

Tabulating data using a single criterion-463326.mp414.13MB

Insert Function for learning about unfamiliar functions-463306.mp413.66MB

Calculating end-of-month and future and past dates with EDATE and EOMONTH-463352.mp413.02MB

Using MAXIFS and MINIFS-480583.mp412.8MB

Using MATCH and INDEX functions together-463324.mp412.65MB

Ranking data without sorting with RANK and RANK.EQ-463331.mp412.61MB

Identifying the day of the week with the WEEKDAY function-463348.mp412.59MB

Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER-463374.mp411.8MB

Using entire row and column references-463296.mp411.74MB

Using the DATE, YEAR, MONTH, DAY, TIME, HOUR, MINUTE, and SECOND functions-463346.mp411.67MB

Nesting lookup functions-463319.mp411.55MB

Looking up information with VLOOKUP and HLOOKUP-463316.mp411.44MB

Using the utility text functions - TEXT, REPT, and LEN-463371.mp411.34MB

Adjusting alphabetic case with the UPPER, LOWER, and PROPER functions-463369.mp411.27MB

Using the INT and TRUNC functions to extract integer data-463338.mp411.08MB

Expanding nested IF statements-463313.mp411.05MB

Determining a completion date with the WORKDAY function-463350.mp410.95MB

Determining frequency distributions with the FREQUENCY function-463356.mp410.53MB

Extracting information with the CELL and INFO functions-463373.mp410.4MB

Debugging formulas with the F9 key-463300.mp410.31MB

Extracting specific data with the LEFT and RIGHT functions-463366.mp49.61MB

Building analysis via regression techniques with TREND and GROWTH-463358.mp49.61MB

Locating data with the MATCH function-463322.mp49.55MB

IF logical tests-463312.mp49.53MB

Using COUNT, COUNTA, and the status bar-463334.mp49.5MB

Copying column formulas instantly-463297.mp49.27MB

Using the ROMAN and ARABIC functions to display different number systems-463343.mp49.2MB

Updating values without formulas-463299.mp49.18MB

Returning references with the INDIRECT function-463362.mp48.53MB

Converting a value between measurement systems with CONVERT-463341.mp48.37MB

Tracking and highlighting formula cells with the ISFORMULA function-463376.mp48.36MB

Retrieving information by location-463323.mp48.17MB

Using IFS for multiple conditions-480581.mp47.96MB

Working with MROUND, CEILING, and FLOOR for specialized rounding-463337.mp47.57MB

Finding the middle value with MEDIAN and most common value with MODE-463330.mp47.12MB

Finding table-like information within a function using the CHOOSE function-463321.mp46.59MB

Welcome-463291.mp46.52MB

Finding the largest and smallest values with the LARGE and SMALL functions-463332.mp44.83MB

Next steps-463378.mp41.93MB

Using the exercise files-463292.mp41.39MB