|
|
Adjusting character content with REPLACE and SUBSTITUTE-135802.mp4
|
MP4
|
11.14 MB
|
|
|
Adjusting the case within cells with PROPER, UPPER, and LOWER-135801.mp4
|
MP4
|
8.07 MB
|
|
|
Auditing tools-135729.mp4
|
MP4
|
14.55 MB
|
|
|
Building analysis via regression techniques with TREND and GROWTH-135790.mp4
|
MP4
|
10.71 MB
|
|
|
Calculating end-of-month and future_past dates with EDATE and EOMONTH-135783.mp4
|
MP4
|
10.93 MB
|
|
|
Converting a value between measurement systems with CONVERT-135773.mp4
|
MP4
|
6.55 MB
|
|
|
Converting formulas to values with a simple drag-135732.mp4
|
MP4
|
8.29 MB
|
|
|
Converting text entries into dates and times with DATEVALUE and TIMEVALUE-135784.mp4
|
MP4
|
9.09 MB
|
|
|
Copying column formulas instantly-135731.mp4
|
MP4
|
10.63 MB
|
|
|
Counting unique entries in a range with an array formula-135787.mp4
|
MP4
|
14.95 MB
|
|
|
Counting working days with NETWORKDAYS-135780.mp4
|
MP4
|
8 MB
|
|
|
Creating 3D formulas to gather data from multiple sheets-135736.mp4
|
MP4
|
8.87 MB
|
|
|
Creating and expanding the use of nested IF statements-135746.mp4
|
MP4
|
7.56 MB
|
|
|
Determining a completion date with WORKDAY-135781.mp4
|
MP4
|
6.58 MB
|
|
|
Determining frequency distributions with FREQUENCY-135788.mp4
|
MP4
|
8.65 MB
|
|
|
Displaying and highlighting formulas-135728.mp4
|
MP4
|
13.47 MB
|
|
|
Enhancing readability with range names-135735.mp4
|
MP4
|
14.1 MB
|
|
|
Ex_Files_EX2013_AdvForm
|
|
Exercise Files
|
|
Ch01
|
|
|
Ch02
|
|
|
Ch03
|
|
|
Ch04
|
|
|
Ch05
|
|
|
Ch06
|
|
|
Ch07
|
|
|
Ch08
|
|
|
Ch09
|
|
|
Ch10
|
|
|
Ch11
|
|
|
Ch12
|
|
|
|
|
Exploring IF logical tests and using relational operators-135745.mp4
|
MP4
|
6.89 MB
|
|
|
Extending formula capabilities with arrays-135786.mp4
|
MP4
|
25.36 MB
|
|
|
Extracting information with the CELL and INFO functions-135805.mp4
|
MP4
|
10.02 MB
|
|
|
Extracting specific data with LEFT and RIGHT-135798.mp4
|
MP4
|
5.9 MB
|
|
|
Finding approximate matches with VLOOKUP-135750.mp4
|
MP4
|
17.33 MB
|
|
|
Finding exact matches with VLOOKUP-135751.mp4
|
MP4
|
9.15 MB
|
|
|
Finding table-like information within a function with CHOOSE-135754.mp4
|
MP4
|
5.99 MB
|
|
|
Finding the largest and smallest values with LARGE and SMALL-135764.mp4
|
MP4
|
4.44 MB
|
|
|
Finding the middle value with MEDIAN-135762.mp4
|
MP4
|
6.89 MB
|
|
|
Finding the remainder with MOD and using MOD with conditional formatting-135771.mp4
|
MP4
|
10.86 MB
|
|
|
Flipping row_column orientation with TRANSPOSE-135789.mp4
|
MP4
|
7.82 MB
|
|
|
Getting data from remote cells with OFFSET-135793.mp4
|
MP4
|
11.48 MB
|
|
|
Goodbye-135810.mp4
|
MP4
|
780.37 KB
|
|
|
Identifying the day of the week with WEEKDAY-135779.mp4
|
MP4
|
9.51 MB
|
|
|
Locating and extracting data with FIND, SEARCH, and MID-135797.mp4
|
MP4
|
9.96 MB
|
|
|
Locating data with MATCH-135755.mp4
|
MP4
|
9.08 MB
|
|
|
Looking up information with VLOOKUP and HLOOKUP-135749.mp4
|
MP4
|
12.2 MB
|
|
|
Nesting lookup functions-135752.mp4
|
MP4
|
9.66 MB
|
|
|
Practical uses for the random number functions RAND and RANDBETWEEN-135772.mp4
|
MP4
|
15.04 MB
|
|
|
Ranking data without sorting with RANK-135763.mp4
|
MP4
|
12.48 MB
|
|
|
Removing extra spaces with TRIM and removing hidden characters with CLEAN-135799.mp4
|
MP4
|
9.42 MB
|
|
|
Retrieving information by location with INDEX-135756.mp4
|
MP4
|
5.92 MB
|
|
|
Returning references with INDIRECT-135794.mp4
|
MP4
|
8.5 MB
|
|
|
Simplifying debugging formulas-135734.mp4
|
MP4
|
10.04 MB
|
|
|
Tabulating blank cells with COUNTBLANK-135765.mp4
|
MP4
|
16.65 MB
|
|
|
Tabulating date differences with DATEDIF-135782.mp4
|
MP4
|
11.55 MB
|
|
|
Tabulating information using a single criterion with COUNTIF, SUMIF, and AVERAGEIF-135759.mp4
|
MP4
|
12.19 MB
|
|
|
Tabulating information using multiple criteria with COUNTIFS, SUMIFS, and AVERAGEIFS-135760.mp4
|
MP4
|
10.78 MB
|
|
|
Understanding Excel date_time capabilities in formulas-135777.mp4
|
MP4
|
16.48 MB
|
|
|
Understanding the hierarchy of operations in Excel formulas-135738.mp4
|
MP4
|
5.43 MB
|
|
|
Updating values without formulas-135733.mp4
|
MP4
|
5.65 MB
|
|
|
Using COUNT, COUNTA, and the status bar-135766.mp4
|
MP4
|
7.17 MB
|
|
|
Using INDIRECT with data validation for two-tiered pick list scenarios-135795.mp4
|
MP4
|
18.74 MB
|
|
|
Using ISBLANK, ISODD, ISEVEN, ISTEXT, and ISNUMBER-135806.mp4
|
MP4
|
10.1 MB
|
|
|
Using MATCH and INDEX together-135757.mp4
|
MP4
|
17.28 MB
|
|
|
Using TODAY and NOW functions for dynamic date_time entry-135778.mp4
|
MP4
|
6.77 MB
|
|
|
Using VLOOKUP with large tables-135753.mp4
|
MP4
|
8.61 MB
|
|
|
Using absolute and relative references in formulas-135742.mp4
|
MP4
|
6.47 MB
|
|
|
Using ampersands and CONCATENATE to combine data from different cells-135800.mp4
|
MP4
|
11.16 MB
|
|
|
Using and extending AutoSum button capabilities-135741.mp4
|
MP4
|
12.29 MB
|
|
|
Using array formula techniques with the MATCH function for complex lookups-135791.mp4
|
MP4
|
8.98 MB
|
|
|
Using entire row_column references-135730.mp4
|
MP4
|
11.02 MB
|
|
|
Using error-checking functions ISERR, ISERROR, IFERROR, ISNA, and IFNA-135807.mp4
|
MP4
|
12.58 MB
|
|
|
Using mixed references in formulas-135743.mp4
|
MP4
|
7.7 MB
|
|
|
Using other utility text functions - LEN, REPT, VALUE, TEXT-135803.mp4
|
MP4
|
12.72 MB
|
|
|
Using the AND and OR functions with IF to create compound logical tests-135747.mp4
|
MP4
|
13.36 MB
|
|
|
Using the Formulas tab on the Ribbon for locating functions-135739.mp4
|
MP4
|
6.86 MB
|
|
|
Using the INT and TRUNC functions to extract integer data-135770.mp4
|
MP4
|
6.16 MB
|
|
|
Using the ISFORMULA function with conditional formatting-135808.mp4
|
MP4
|
5.11 MB
|
|
|
Using the Insert Function button for guidance with unfamiliar functions-135740.mp4
|
MP4
|
7.9 MB
|
|
|
Using the ROMAN and ARABIC functions to display different numeral systems-135775.mp4
|
MP4
|
5.86 MB
|
|
|
Using the exercise files-135726.mp4
|
MP4
|
1.73 MB
|
|
|
Using the powerful AGGREGATE function to bypass errors and hidden data-135774.mp4
|
MP4
|
13.45 MB
|
|
|
Welcome-135725.mp4
|
MP4
|
5.89 MB
|
|
|
Working with MROUND, CEILING, and FLOOR for specialized rounding-135769.mp4
|
MP4
|
9.76 MB
|
|
|
Working with ROUND, ROUNDUP, and ROUNDDOWN-135768.mp4
|
MP4
|
11.48 MB
|
![Excel 2013 Tutorials Advanced Formulas and Functions [2013, ENG]](/static/img/no-torrent-image.png "Excel 2013 Tutorials Advanced Formulas and Functions [2013, ENG]")
