Microsoft Excel Advanced Excel Formulas Functions | F720A26B131B34F571E0C01B1E06F24284AC86D5

Microsoft Excel Advanced Excel Formulas Functions

Name	Microsoft Excel - Advanced Excel Formulas & Functions	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	2.9 GB
Total Files	313
Last Seen	2025-07-18 23:37
Hash	F720A26B131B34F571E0C01B1E06F24284AC86D5

/.../05 Lookup & Reference Functions/
051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).mp4	180.9 MB
051 DEMO_ Building Dashboards with XLOOKUP (Office 365 Only).en.srt	26.6 KB
049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.en.srt	26.5 KB
042 Fixing Errors with IFERROR & VLOOKUP.en.srt	23.8 KB
052 Selecting List Items with CHOOSE.en.srt	19.0 KB
054 Combining OFFSET with COUNTA to Create a Flexible Range.en.srt	16.0 KB
055 PRO TIP_ Using OFFSET to Create Interactive Charts.en.srt	14.2 KB
047 Combining INDEX & MATCH to Dynamically Search Ranges.en.srt	9.0 KB
043 VLOOKUP Reference Array Options.en.srt	8.5 KB
041 Joining Data with VLOOKUP.en.srt	8.4 KB
040 Introduction to VLOOKUP_HLOOKUP.en.srt	8.2 KB
044 Approximate Match Lookups.en.srt	7.3 KB
048 Combining MATCH & VLOOKUP for More Flexible Lookups.en.srt	6.9 KB
050 SNEAK PEEK_ XLOOKUP (Office 365 Only).en.srt	6.8 KB
037 Introduction.en.srt	2.0 KB
056 HOMEWORK_ Excel Lookup & Reference Functions.en.srt	5.2 KB
038 Working with Named Ranges.en.srt	4.9 KB
039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.en.srt	4.1 KB
046 Matching Text & Values with MATCH.en.srt	3.6 KB
053 Defining Ranges with OFFSET.en.srt	3.3 KB
045 Navigating Cell Ranges with INDEX.en.srt	3.3 KB
041 Joining Data with VLOOKUP.mp4	85.8 MB
052 Selecting List Items with CHOOSE.mp4	84.1 MB
040 Introduction to VLOOKUP_HLOOKUP.mp4	54.3 MB
044 Approximate Match Lookups.mp4	48.7 MB
043 VLOOKUP Reference Array Options.mp4	42.1 MB
055 PRO TIP_ Using OFFSET to Create Interactive Charts.mp4	31.8 MB
048 Combining MATCH & VLOOKUP for More Flexible Lookups.mp4	27.9 MB
047 Combining INDEX & MATCH to Dynamically Search Ranges.mp4	24.9 MB
050 SNEAK PEEK_ XLOOKUP (Office 365 Only).mp4	20.8 MB
049 TROUBLESHOOTING_ VLOOKUP with Duplicate Keys.mp4	19.4 MB
042 Fixing Errors with IFERROR & VLOOKUP.mp4	15.9 MB
038 Working with Named Ranges.mp4	11.9 MB
039 Counting Rows & Columns with ROW_ROWS & COLUMN_COLUMNS.mp4	10.0 MB
046 Matching Text & Values with MATCH.mp4	9.7 MB
054 Combining OFFSET with COUNTA to Create a Flexible Range.mp4	8.1 MB
037 Introduction.mp4	7.6 MB
053 Defining Ranges with OFFSET.mp4	7.2 MB
045 Navigating Cell Ranges with INDEX.mp4	6.4 MB
056 HOMEWORK_ Excel Lookup & Reference Functions.mp4	3.0 MB
/
TutsNode.com.txt	0.1 KB
[TGx]Downloaded from torrentgalaxy.to .txt	0.6 KB
/.../01 Getting Started/
001 Course Structure & Outline.en.srt	2.2 KB
003 Excel-Homework-Workbooks.zip	141.8 KB
003 DOWNLOAD_ Course Resources.html	2.2 KB
004 Setting Expectations.en.srt	5.6 KB
002 READ ME_ Important Notes for New Students.html	5.4 KB
001 Course Structure & Outline.mp4	30.0 MB
004 Setting Expectations.mp4	25.7 MB
003 Excel-Demo-Workbooks-COMPLETE.zip	10.3 MB
003 Excel-Demo-Workbooks.zip	5.6 MB
003 Excel-Formulas-Functions.pdf	2.6 MB
/.../09 Array Formulas/
097 Creating a _MAX IF_ Array Formula with Multiple Criteria.en.srt	33.8 KB
098 Converting Boolean Values Using the Double Unary (_--_).en.srt	17.9 KB
099 HOMEWORK_ Excel Array Functions.en.srt	11.6 KB
089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.en.srt	8.6 KB
092 Restructuring Data with TRANSPOSE.en.srt	6.3 KB
091 Defining & Referencing Named Array Constants.en.srt	5.7 KB
087 Rules of Excel Array Functions.en.srt	4.9 KB
090 Using Array Constants in Formulas.en.srt	4.9 KB
096 Creating a _MAX IF_ Array Formula.en.srt	4.4 KB
094 Returning the Largest Values in a Range.en.srt	3.9 KB
088 Pros & Cons of Array Functions.en.srt	3.5 KB
093 Linking Data Between Sheets (Array vs. Non-Array Comparison).en.srt	3.4 KB
086 READ ME_ Array Formulas are Changing!.html	2.8 KB
085 Introduction.en.srt	2.5 KB
095 Counting Characters Across Cells.en.srt	2.5 KB
097 Creating a _MAX IF_ Array Formula with Multiple Criteria.mp4	21.1 MB
092 Restructuring Data with TRANSPOSE.mp4	14.2 MB
089 Defining Vertical, Horizontal, and 2-Dimensional Arrays.mp4	13.3 MB
098 Converting Boolean Values Using the Double Unary (_--_).mp4	12.9 MB
094 Returning the Largest Values in a Range.mp4	11.3 MB
091 Defining & Referencing Named Array Constants.mp4	10.4 MB
096 Creating a _MAX IF_ Array Formula.mp4	9.7 MB
093 Linking Data Between Sheets (Array vs. Non-Array Comparison).mp4	9.5 MB
087 Rules of Excel Array Functions.mp4	9.2 MB
090 Using Array Constants in Formulas.mp4	7.4 MB
099 HOMEWORK_ Excel Array Functions.mp4	7.4 MB
085 Introduction.mp4	7.3 MB
095 Counting Characters Across Cells.mp4	5.8 MB
088 Pros & Cons of Array Functions.mp4	5.4 MB
/.../04 Common Excel Statistical Functions/
035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.en.srt	23.2 KB
034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.en.srt	11.4 KB
033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.en.srt	10.9 KB
028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.en.srt	8.8 KB
027 Basic Excel Statistical Functions.en.srt	7.7 KB
031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.en.srt	7.2 KB
026 Introduction.en.srt	1.6 KB
029 Randomization with RAND() & RANDBETWEEN.en.srt	3.0 KB
032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.en.srt	6.6 KB
030 Row-Level Calculation with SUMPRODUCT.en.srt	5.6 KB
036 HOMEWORK_ Excel Stats Functions.en.srt	1.2 KB
035 PRO TIP_ Data Profiling with COUNT & SUMPRODUCT.mp4	99.9 MB
034 DEMO_ Counting Duplicates with COUNTIF & SUMPRODUCT.mp4	76.7 MB
028 Extracting Values with SMALL_LARGE & RANK_PERCENTRANK.mp4	56.9 MB
031 DEMO_ Calculating Shipping Costs with SUMPRODUCT.mp4	32.8 MB
033 DEMO_ Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4	24.7 MB
027 Basic Excel Statistical Functions.mp4	15.5 MB
032 Conditional Aggregation with COUNTIFS, SUMIFS & AVERAGEIFS.mp4	14.8 MB
030 Row-Level Calculation with SUMPRODUCT.mp4	11.1 MB
026 Introduction.mp4	6.6 MB
029 Randomization with RAND() & RANDBETWEEN.mp4	6.6 MB
036 HOMEWORK_ Excel Stats Functions.mp4	1.9 MB
/.../02 Excel Formulas 101/
005 Introduction_ Excel Formulas 101.en.srt	3.0 KB
006 Excel Formula Syntax.en.srt	16.9 KB
012 Saving Time with Function Shortcuts.en.srt	14.8 KB
009 Formula Auditing_ Trace Precedents & Dependents.en.srt	14.7 KB
008 Common Excel Error Types.en.srt	13.2 KB
007 Writing Efficient Formulas with Fixed & Relative References.en.srt	12.6 KB
010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).en.srt	11.7 KB
014 BONUS_ Mac Shortcuts.html	1.2 KB
011 Navigating Excel Worksheets with Ctrl Shortcuts.en.srt	10.6 KB
015 PRO TIP_ Creating Drop-Down Menus with Data Validation.en.srt	9.4 KB
017 HOMEWORK_ Excel Formulas 101.en.srt	0.8 KB
016 Congrats, You're a Developer!.en.srt	7.3 KB
013 Accessing Tools with Alt Key Tips.en.srt	6.2 KB
006 Excel Formula Syntax.mp4	120.0 MB
012 Saving Time with Function Shortcuts.mp4	108.7 MB
011 Navigating Excel Worksheets with Ctrl Shortcuts.mp4	93.7 MB
009 Formula Auditing_ Trace Precedents & Dependents.mp4	84.3 MB
008 Common Excel Error Types.mp4	56.0 MB
010 Formula Auditing_ Evaluate Formula & Error Checking (PC Only).mp4	55.7 MB
007 Writing Efficient Formulas with Fixed & Relative References.mp4	53.1 MB
013 Accessing Tools with Alt Key Tips.mp4	51.5 MB
015 PRO TIP_ Creating Drop-Down Menus with Data Validation.mp4	46.2 MB
016 Congrats, You're a Developer!.mp4	35.5 MB
005 Introduction_ Excel Formulas 101.mp4	6.5 MB
017 HOMEWORK_ Excel Formulas 101.mp4	4.9 MB
/.../07 Date & Time Functions/
076 DEMO_ Building a Simple Budget Pacing Tool.en.srt	15.7 KB
074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.en.srt	9.5 KB
072 Calculating the Month Start or End with EOMONTH.en.srt	9.1 KB
068 Understanding Excel Date Syntax with DATEVALUE.en.srt	6.6 KB
075 Calculating Differences Between Dates with DATEDIF (Legacy Function).en.srt	5.9 KB
069 Formatting Dates & Filling Date Series.en.srt	5.1 KB
071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.en.srt	4.2 KB
070 Creating Real-Time Functions with TODAY & NOW.en.srt	3.5 KB
077 HOMEWORK_ Excel Date & Time Functions.en.srt	3.4 KB
073 Calculating % of Year with YEARFRAC.en.srt	3.3 KB
067 Introduction.en.srt	3.2 KB
074 Defining Time Periods with WEEKDAY, WORKDAY & NETWORKDAYS.mp4	58.0 MB
076 DEMO_ Building a Simple Budget Pacing Tool.mp4	27.4 MB
068 Understanding Excel Date Syntax with DATEVALUE.mp4	14.6 MB
072 Calculating the Month Start or End with EOMONTH.mp4	13.7 MB
067 Introduction.mp4	11.4 MB
075 Calculating Differences Between Dates with DATEDIF (Legacy Function).mp4	10.6 MB
069 Formatting Dates & Filling Date Series.mp4	9.1 MB
071 Extracting Time Periods with YEAR, MONTH, DAY, HOUR, MINUTE & SECOND.mp4	8.3 MB
073 Calculating % of Year with YEARFRAC.mp4	6.0 MB
070 Creating Real-Time Functions with TODAY & NOW.mp4	5.7 MB
077 HOMEWORK_ Excel Date & Time Functions.mp4	1.4 MB
/.../10 Extra Bonus Functions/
101 Creating Custom References with INDIRECT.en.srt	14.6 KB
104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).en.srt	13.1 KB
103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).en.srt	10.1 KB
102 Linking to Worksheet Locations with HYPERLINK.en.srt	8.2 KB
100 Introduction.en.srt	2.4 KB
104 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 2).mp4	96.7 MB
103 Real-Time Weather Conditions with WEBSERVICE & FILTERXML (Part 1).mp4	75.3 MB
101 Creating Custom References with INDIRECT.mp4	31.6 MB
102 Linking to Worksheet Locations with HYPERLINK.mp4	14.9 MB
100 Introduction.mp4	9.1 MB
/.../06 Text Functions/
065 Replacing Text with SUBSTITUTE.en.srt	12.2 KB
064 Combining RIGHT, LEN, and SEARCH.en.srt	8.1 KB
063 Categorizing Data with IF(ISNUMBER(SEARCH)).en.srt	7.7 KB
062 Searching Text String with SEARCH & FIND.en.srt	7.2 KB
061 Converting Text to Values with TEXT & VALUE.en.srt	5.7 KB
066 HOMEWORK_ Excel Text Functions.en.srt	5.5 KB
060 Extracting Strings with LEFT, MID, RIGHT & LEN.en.srt	4.8 KB
058 Capitalization with UPPER, LOWER, PROPER & TRIM.en.srt	4.8 KB
059 Combining Text with CONCATENATE (&).en.srt	4.6 KB
057 Introduction.en.srt	1.5 KB
061 Converting Text to Values with TEXT & VALUE.mp4	58.1 MB
064 Combining RIGHT, LEN, and SEARCH.mp4	43.9 MB
063 Categorizing Data with IF(ISNUMBER(SEARCH)).mp4	35.2 MB
062 Searching Text String with SEARCH & FIND.mp4	32.6 MB
059 Combining Text with CONCATENATE (&).mp4	24.8 MB
058 Capitalization with UPPER, LOWER, PROPER & TRIM.mp4	22.2 MB
060 Extracting Strings with LEFT, MID, RIGHT & LEN.mp4	17.8 MB
065 Replacing Text with SUBSTITUTE.mp4	10.3 MB
057 Introduction.mp4	4.2 MB
066 HOMEWORK_ Excel Text Functions.mp4	2.7 MB
/.../03 Conditional Statements & Logical Operators/
021 Adding Conditional AND_OR Operators.en.srt	11.6 KB
018 Introduction.en.srt	1.9 KB
020 Nesting Multiple IF Statements.en.srt	7.1 KB
019 Anatomy of the IF Statement.en.srt	5.8 KB
023 Fixing Errors with IFERROR.en.srt	5.8 KB
024 Common IS Statements.en.srt	5.3 KB
022 Using NOT & ____ Conditionals.en.srt	4.5 KB
025 HOMEWORK_ Excel Logical Operators.en.srt	4.2 KB
021 Adding Conditional AND_OR Operators.mp4	29.6 MB
024 Common IS Statements.mp4	21.9 MB
023 Fixing Errors with IFERROR.mp4	21.1 MB
019 Anatomy of the IF Statement.mp4	17.7 MB
020 Nesting Multiple IF Statements.mp4	16.8 MB
022 Using NOT & ____ Conditionals.mp4	11.9 MB
018 Introduction.mp4	6.5 MB
025 HOMEWORK_ Excel Logical Operators.mp4	1.9 MB
/.../08 Formula-Based Formatting/
084 HOMEWORK_ Excel Formula-Based Formatting.en.srt	2.9 KB
083 Formatting Cells Using Text Functions & Logical Operators.en.srt	7.0 KB
079 Creating, Editing & Managing Formula-Based Rules.en.srt	6.9 KB
082 Formatting Cells Using Stats Functions.en.srt	6.7 KB
080 Highlighting Rows Using the MOD Function.en.srt	5.6 KB
081 Formatting Based on the Value of Another Cell.en.srt	4.9 KB
078 Introduction.en.srt	2.2 KB
082 Formatting Cells Using Stats Functions.mp4	25.5 MB
083 Formatting Cells Using Text Functions & Logical Operators.mp4	21.6 MB
080 Highlighting Rows Using the MOD Function.mp4	15.7 MB
079 Creating, Editing & Managing Formula-Based Rules.mp4	12.7 MB
081 Formatting Based on the Value of Another Cell.mp4	10.5 MB
078 Introduction.mp4	9.6 MB
084 HOMEWORK_ Excel Formula-Based Formatting.mp4	1.8 MB
/.../11 Wrapping Up/
105 BONUS LECTURE_ More from Maven Analytics.html	6.7 KB
/.pad/
0	625.8 KB
1	617.4 KB
2	341.7 KB
3	730.4 KB
4	767.8 KB
5	682.8 KB
6	173.4 KB
7	644.1 KB
8	791.5 KB
9	914.0 KB
10	226.6 KB
11	649.4 KB
12	761.3 KB
13	776.5 KB
14	614.6 KB
15	921.4 KB
16	233.0 KB
17	327.6 KB
18	897.3 KB
19	620.8 KB
20	1.0 MB
21	133.2 KB
22	876.0 KB
23	123.2 KB
24	406.4 KB
25	768.2 KB
26	989.2 KB
27	733.8 KB
28	877.3 KB
29	403.7 KB
30	826.7 KB
31	374.8 KB
32	945.8 KB
33	522.4 KB
34	761.5 KB
35	297.7 KB
36	384.0 KB
37	426.6 KB
38	870.5 KB
39	78.9 KB
40	454.3 KB
41	909.3 KB
42	963.4 KB
43	138.4 KB
44	522.8 KB
45	66.2 KB
46	147.8 KB
47	1.0 MB
48	849.0 KB
49	56.2 KB
50	265.2 KB
51	873.8 KB
52	906.6 KB
53	40.0 KB
54	459.9 KB
55	970.8 KB
56	299.6 KB
57	776.6 KB
58	980.5 KB
59	668.0 KB
60	718.4 KB
61	92.7 KB
62	234.5 KB
63	425.3 KB
64	935.8 KB
65	988.4 KB
66	40.6 KB
67	155.4 KB
68	225.4 KB
69	470.1 KB
70	820.1 KB
71	821.6 KB
72	838.7 KB
73	991.8 KB
74	220.7 KB
75	349.7 KB
76	373.6 KB
77	123.3 KB
78	244.9 KB
79	811.6 KB
80	938.6 KB
81	964.9 KB
82	43.0 KB
83	95.0 KB
84	719.9 KB
85	727.7 KB
86	796.1 KB
87	828.5 KB
88	892.4 KB
89	253.0 KB
90	521.3 KB
91	624.9 KB
92	705.4 KB
93	841.7 KB
94	332.2 KB
95	1.0 MB
96	181.4 KB
97	474.9 KB
98	564.9 KB
99	172.6 KB
100	186.4 KB
101	283.1 KB
Total files 313