Lynda - Excel 2016 Advanced Formulas and Functions

🎬

Using the ISERR, ISERROR, IFERROR, and ISNA error-checking functions-463375.mp4

23.32 MB

🎬

Tabulating data from multiple sheets-463302.mp4

22.59 MB

🎬

Using Auditing tools-463295.mp4

22.4 MB

🎬

Understanding Excel date and time capabilities in formulas-463345.mp4

22.36 MB

🎬

Using the powerful AGGREGATE function to bypass errors and hidden data-463342.mp4

21.06 MB

🎬

Finding approximate matches with VLOOKUP and HLOOKUP-463317.mp4

20.92 MB

🎬

Using INDIRECT with Data Validation for two-tiered pick list scenarios-463363.mp4

20.54 MB

🎬

AND, OR, and NOT functions with IF-463314.mp4

20.38 MB

🎬

Preventing double counting-463328.mp4

18.3 MB

🎬

Locating and extracting data with the FIND, SEARCH, and MID functions-463365.mp4

17.79 MB

🎬

Counting unique entries in a range with an array formula-463355.mp4

17.01 MB

🎬

Tabulating data using multiple criteria-463327.mp4

16.94 MB

🎬

Using array formulas and the MATCH function for complex lookups-463359.mp4

16.56 MB

🎬

Displaying and highlighting formulas-463294.mp4

16.37 MB

🎬

Using VLOOKUP with large tables-463320.mp4

16.3 MB

🎬

Using autocalculate in the status bar-463310.mp4

16.29 MB

🎬

Absolute and relative references-463308.mp4

16.02 MB

🎬

Converting formulas to values with a drag-463298.mp4

15.93 MB

🎬

Using the SWITCH function for formula-embedded selection-480582.mp4

15.55 MB

🎬

Formulas tab for locating functions-463305.mp4

15.52 MB

🎬

Counting working days with the NETWORKDAYS function-463349.mp4

15.52 MB

🎬

Finding exact matches with VLOOKUP-463318.mp4

15.33 MB

🎬

Exploring practical uses for the RAND and RANDBETWEEN functions-463340.mp4

15.23 MB

🎬

Using the TODAY and NOW functions for dynamic date and time entry-463347.mp4

15.15 MB

🎬

Using the CONCAT and TEXTJOIN to combine data from different cells-480584.mp4

15.06 MB

🎬

Finding the remainder with MOD and using MOD with conditional formatting-463339.mp4

14.94 MB

🎬

Tabulating date differences with the DATEDIF function-463351.mp4

14.93 MB

🎬

Using mixed references in formulas-463309.mp4

14.92 MB

🎬

Hierarchy of operations in formulas-463304.mp4

14.87 MB

🎬

Using the TRIM function to remove unwanted spaces in a cell-463367.mp4

14.84 MB

🎬

Tabulating blank cells with the COUNTBLANK function-463333.mp4

14.8 MB

🎬

Extending formula capabilities with array formulas-463354.mp4

14.7 MB

🎬

Using ampersands and CONCATENATE to combine data from different cells-463368.mp4

14.66 MB

🎬

Extending the capabilities of AutoSum-463307.mp4

14.57 MB

🎬

Enhancing readability with range names-463301.mp4

14.42 MB

🎬

Working with the ROUND, ROUNDUP, and ROUNDDOWN functions-463336.mp4

14.42 MB

🎬

Getting data from remote cells with the OFFSET function-463361.mp4

14.34 MB

🎬

Flipping row and column orientation with TRANSPOSE-463357.mp4

14.2 MB

🎬

Adjusting character content with the REPLACE and SUBSTITUTE functions-463370.mp4

14.16 MB

🎬

Tabulating data using a single criterion-463326.mp4

14.13 MB

🎬

Insert Function for learning about unfamiliar functions-463306.mp4

13.66 MB

🎬

Calculating end-of-month and future and past dates with EDATE and EOMONTH-463352.mp4

13.02 MB

🎬

Using MAXIFS and MINIFS-480583.mp4

12.8 MB

🎬

Using MATCH and INDEX functions together-463324.mp4

12.65 MB

🎬

Ranking data without sorting with RANK and RANK.EQ-463331.mp4

12.61 MB

🎬

Identifying the day of the week with the WEEKDAY function-463348.mp4

12.59 MB

🎬

Using ISBLANK, ISODD, ISEVEN, ISTEXT, ISNONTEXT, and ISNUMBER-463374.mp4

11.8 MB

🎬

Using entire row and column references-463296.mp4

11.74 MB

🎬

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

11.67 MB

🎬

Nesting lookup functions-463319.mp4

11.55 MB

🎬

Looking up information with VLOOKUP and HLOOKUP-463316.mp4

11.44 MB

🎬

Using the utility text functions - TEXT, REPT, and LEN-463371.mp4

11.34 MB

🎬

Adjusting alphabetic case with the UPPER, LOWER, and PROPER functions-463369.mp4

11.27 MB

🎬

Using the INT and TRUNC functions to extract integer data-463338.mp4

11.08 MB

🎬

Expanding nested IF statements-463313.mp4

11.05 MB

🎬

Determining a completion date with the WORKDAY function-463350.mp4

10.95 MB

🎬

Determining frequency distributions with the FREQUENCY function-463356.mp4

10.53 MB

🎬

Extracting information with the CELL and INFO functions-463373.mp4

10.4 MB

🎬

Debugging formulas with the F9 key-463300.mp4

10.31 MB

🎬

Extracting specific data with the LEFT and RIGHT functions-463366.mp4

9.61 MB

🎬

Building analysis via regression techniques with TREND and GROWTH-463358.mp4

9.61 MB

🎬

Locating data with the MATCH function-463322.mp4

9.55 MB

🎬

IF logical tests-463312.mp4

9.53 MB

🎬

Using COUNT, COUNTA, and the status bar-463334.mp4

9.5 MB

🎬

Copying column formulas instantly-463297.mp4

9.27 MB

🎬

Using the ROMAN and ARABIC functions to display different number systems-463343.mp4

9.2 MB

🎬

Updating values without formulas-463299.mp4

9.18 MB

🎬

Returning references with the INDIRECT function-463362.mp4

8.53 MB

🎬

Converting a value between measurement systems with CONVERT-463341.mp4

8.37 MB

🎬

Tracking and highlighting formula cells with the ISFORMULA function-463376.mp4

8.36 MB

🎬

Retrieving information by location-463323.mp4

8.17 MB

🎬

Using IFS for multiple conditions-480581.mp4

7.96 MB

🎬

Working with MROUND, CEILING, and FLOOR for specialized rounding-463337.mp4

7.57 MB

🎬

Finding the middle value with MEDIAN and most common value with MODE-463330.mp4

7.12 MB

🎬

Finding table-like information within a function using the CHOOSE function-463321.mp4

6.59 MB

🎬

Welcome-463291.mp4

6.52 MB

🎬

Finding the largest and smallest values with the LARGE and SMALL functions-463332.mp4

4.83 MB

🎬

Next steps-463378.mp4

1.93 MB

🎬

Using the exercise files-463292.mp4

1.39 MB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch03/03-IF Function.xlsx

579.88 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch02/02-Tools.xlsx

443.93 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch05/05-COUNTIF-SUMIF.xlsx

329.09 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch01/01-TipsShortcuts.xlsx

270.22 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch04/04-LookupFunctions.xlsx

242 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch06/06-Stat.xlsx

132.4 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch09/09-Array.xlsx

129.13 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch07/07-Math.xlsx

67.85 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch08/08-Date.xlsx

64.54 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch11/11-Text.xlsx

30.54 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch10/10-Reference.xlsx

29.43 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch01/01-Sales by State.xlsx

17.87 KB

📄

Ex_Files_Excel2016_AdvancedFormulas/Exercise Files/Ch12/12-Information.xlsx

17.5 KB

Resource Detail

Disclaimer