|
Please note that this page does not hosts or makes available any of the listed filenames. You
cannot download any of those files from here.
|
| [CourseClub.NET].url |
123B |
| [FCS Forum].url |
133B |
| [FreeCourseSite.com].url |
127B |
| 1.1 Excel For Analysts Bonus Functions.pdf |
189.10KB |
| 1.1 Excel For Analysts Date Time Functions.pdf.pdf |
443.98KB |
| 1.1 Excel For Analysts Logical Operators.pdf |
368.46KB |
| 1.1 Excel For Analysts Statistical Functions.pdf.pdf |
261.45KB |
| 1.1 Excel For Analysts Text Functions.pdf |
337.16KB |
| 1.1 Section_5_Lookup_Reference.xlsx.xlsx |
799.25KB |
| 1.1 Section 2 Fixed Relative References.xlsx |
8.23KB |
| 1.1 Section8_Formula_Formatting.xlsx.xlsx |
13.37KB |
| 1.1 Section 9 Array Formulas.xlsx |
9.28KB |
| 1.2 Excel For Analysts Array Formulas.pdf |
352.47KB |
| 1.2 Excel For Analysts Formula Formatting.pdf |
181.71KB |
| 1.2 Excel For Analysts Formulas 101.pdf |
553.49KB |
| 1.2 Excel For Analysts Lookup Reference Functions.pdf.pdf |
407.02KB |
| 1.2 Section10_Bonus_Functions.xlsx.xlsx |
1.65MB |
| 1.2 Section 3 Logical Operators.xlsx |
65.31KB |
| 1.2 Section4_Statistical_Functions.xlsx.xlsx |
146.29KB |
| 1.2 Section 6 Text Functions.xlsx |
64.32KB |
| 1.2 Section 7 Date Time Functions.xlsx |
19.36KB |
| 1. Conclusion & Next Steps.mp4 |
678.25KB |
| 1. Conclusion & Next Steps.vtt |
1.11KB |
| 1. Course Structure & Outline.mp4 |
12.32MB |
| 1. Course Structure & Outline.vtt |
5.72KB |
| 1. Introduction.mp4 |
2.60MB |
| 1. Introduction.mp4 |
2.31MB |
| 1. Introduction.mp4 |
2.48MB |
| 1. Introduction.mp4 |
1.82MB |
| 1. Introduction.mp4 |
2.13MB |
| 1. Introduction.mp4 |
1.18MB |
| 1. Introduction.mp4 |
3.26MB |
| 1. Introduction.mp4 |
2.80MB |
| 1. Introduction.mp4 |
2.03MB |
| 1. Introduction.vtt |
2.21KB |
| 1. Introduction.vtt |
1.58KB |
| 1. Introduction.vtt |
1.80KB |
| 1. Introduction.vtt |
1.52KB |
| 1. Introduction.vtt |
1.76KB |
| 1. Introduction.vtt |
1.38KB |
| 1. Introduction.vtt |
2.84KB |
| 1. Introduction.vtt |
1.99KB |
| 1. Introduction.vtt |
1.98KB |
| 10. Counting Characters Across Cells.mp4 |
5.51MB |
| 10. Counting Characters Across Cells.vtt |
2.10KB |
| 10. Fixed vs. Volatile Functions.mp4 |
7.51MB |
| 10. Fixed vs. Volatile Functions.vtt |
3.97KB |
| 10. PROJECT SHOWCASE Designing a Sample Budget Pacing Tool.mp4 |
26.10MB |
| 10. PROJECT SHOWCASE Designing a Sample Budget Pacing Tool.vtt |
13.33KB |
| 10. Statistical Functions.html |
124B |
| 10. Text Functions.html |
124B |
| 10. The MATCH Function.mp4 |
9.23MB |
| 10. The MATCH Function.vtt |
3.06KB |
| 11. Creating a MAX IF Array Formula.mp4 |
9.22MB |
| 11. Creating a MAX IF Array Formula.vtt |
3.71KB |
| 11. DateTime Functions.html |
124B |
| 11. Formulas 101.html |
124B |
| 11. HOMEWORK Statistical Functions.mp4 |
1.56MB |
| 11. HOMEWORK Statistical Functions.vtt |
992B |
| 11. HOMEWORK Text Functions.mp4 |
2.28MB |
| 11. HOMEWORK Text Functions.vtt |
5.07KB |
| 11. Using INDEX & MATCH together.mp4 |
23.72MB |
| 11. Using INDEX & MATCH together.vtt |
7.63KB |
| 12. BONUS MAX IF with Multiple Criteria.mp4 |
17.45MB |
| 12. BONUS MAX IF with Multiple Criteria.vtt |
30.99KB |
| 12. Combining MATCH with VLOOKUP.mp4 |
26.65MB |
| 12. Combining MATCH with VLOOKUP.vtt |
5.83KB |
| 12. HOMEWORK Date & Time Functions.mp4 |
1.21MB |
| 12. HOMEWORK Date & Time Functions.vtt |
3.15KB |
| 12. HOMEWORK Formulas 101.mp4 |
1.81MB |
| 12. HOMEWORK Formulas 101.vtt |
4.40KB |
| 13. BONUS Using the Double Unary Operator (--).mp4 |
10.57MB |
| 13. BONUS Using the Double Unary Operator (--).vtt |
16.46KB |
| 13. UPDATE VLOOKUP Correction.mp4 |
14.84MB |
| 13. UPDATE VLOOKUP Correction.vtt |
24.25KB |
| 14. Array Formulas.html |
124B |
| 14. The OFFSET Function.mp4 |
6.92MB |
| 14. The OFFSET Function.vtt |
2.84KB |
| 15. Combining OFFSET with COUNTA to return a variable list.mp4 |
6.99MB |
| 15. Combining OFFSET with COUNTA to return a variable list.vtt |
14.73KB |
| 15. HOMEWORK Array Functions.mp4 |
5.89MB |
| 15. HOMEWORK Array Functions.vtt |
10.61KB |
| 16. PROJECT SHOWCASE Using OFFSET to create a dynamic scrolling chart.mp4 |
30.30MB |
| 16. PROJECT SHOWCASE Using OFFSET to create a dynamic scrolling chart.vtt |
12.00KB |
| 17. LookupReference Functions.html |
124B |
| 18. HOMEWORK LookupReference Functions.mp4 |
2.48MB |
| 18. HOMEWORK LookupReference Functions.vtt |
4.72KB |
| 2. Anatomy of the IF Statement.mp4 |
16.86MB |
| 2. Anatomy of the IF Statement.vtt |
4.89KB |
| 2. Basic Statistical Functions.mp4 |
14.75MB |
| 2. Basic Statistical Functions.vtt |
6.44KB |
| 2. Bonus Lecture More from Excel Maven.html |
2.51KB |
| 2. Creating, Editing & Managing Formula-Based Rules.mp4 |
12.07MB |
| 2. Creating, Editing & Managing Formula-Based Rules.vtt |
5.93KB |
| 2. DATEVALUE Your New BFF.mp4 |
13.96MB |
| 2. DATEVALUE Your New BFF.vtt |
5.66KB |
| 2. Important Notes for New Students.html |
3.76KB |
| 2. Rules of Array Functions.mp4 |
8.79MB |
| 2. Rules of Array Functions.vtt |
4.14KB |
| 2. The Formula Library & Auditing Tools.mp4 |
12.30MB |
| 2. The Formula Library & Auditing Tools.vtt |
5.89KB |
| 2. The INDIRECT Function.mp4 |
30.17MB |
| 2. The INDIRECT Function.vtt |
12.40KB |
| 2. UPPERLOWERPROPER & TRIM.mp4 |
21.17MB |
| 2. UPPERLOWERPROPER & TRIM.vtt |
4.08KB |
| 2. Working with Named Arrays.mp4 |
11.31MB |
| 2. Working with Named Arrays.vtt |
4.17KB |
| 3.1 Excel_Homework_Exercises_ANSWERS.xlsx.xlsx |
85.82KB |
| 3.2 Excel_Homework_Exercises.xlsx.xlsx |
67.81KB |
| 3. BONUS Extra Homework Exercises.mp4 |
5.64MB |
| 3. BONUS Extra Homework Exercises.vtt |
2.52KB |
| 3. Date Formatting & Fill Series.mp4 |
8.65MB |
| 3. Date Formatting & Fill Series.vtt |
4.40KB |
| 3. DEMO Evaluate Formula (not available for mac).mp4 |
4.16MB |
| 3. DEMO Evaluate Formula (not available for mac).vtt |
7.40KB |
| 3. Highlighting Every Other Row Using the MOD function.mp4 |
14.96MB |
| 3. Highlighting Every Other Row Using the MOD function.vtt |
4.73KB |
| 3. HYPERLINK as Awesome as it Sounds.mp4 |
14.17MB |
| 3. HYPERLINK as Awesome as it Sounds.vtt |
6.95KB |
| 3. Nested IF Statements.mp4 |
16.04MB |
| 3. Nested IF Statements.vtt |
5.97KB |
| 3. Pros & Cons of Array Functions.mp4 |
5.20MB |
| 3. Pros & Cons of Array Functions.vtt |
3.00KB |
| 3. ROWROWS & COLUMNCOLUMNS.mp4 |
9.55MB |
| 3. ROWROWS & COLUMNCOLUMNS.vtt |
8B |
| 3. SMALLLARGE & RANKPERCENTRANK.mp4 |
21.05MB |
| 3. SMALLLARGE & RANKPERCENTRANK.vtt |
7.40KB |
| 3. The CONCATENATE Function (&).mp4 |
23.63MB |
| 3. The CONCATENATE Function (&).vtt |
3.93KB |
| 4. ANDOR Operators.mp4 |
28.21MB |
| 4. ANDOR Operators.vtt |
9.86KB |
| 4. Basic Formula Syntax.mp4 |
7.84MB |
| 4. Basic Formula Syntax.vtt |
4.14KB |
| 4. Formatting Cells Based on the Value of Another Cell.mp4 |
10.07MB |
| 4. Formatting Cells Based on the Value of Another Cell.vtt |
4.13KB |
| 4. LEFTMIDRIGHT & LEN.mp4 |
16.94MB |
| 4. LEFTMIDRIGHT & LEN.vtt |
8B |
| 4. RAND() & RANDBETWEEN.mp4 |
6.32MB |
| 4. RAND() & RANDBETWEEN.vtt |
2.53KB |
| 4. Tapping into Real-Time Data with WEBSERVICE & FILTERXML.mp4 |
71.78MB |
| 4. Tapping into Real-Time Data with WEBSERVICE & FILTERXML.vtt |
8.89KB |
| 4. TODAY()NOW().mp4 |
5.40MB |
| 4. TODAY()NOW().vtt |
2.97KB |
| 4. Vertical, Horizontal, and 2-Dimensional Array Constants.mp4 |
12.71MB |
| 4. Vertical, Horizontal, and 2-Dimensional Array Constants.vtt |
7.30KB |
| 4. VLOOKUPHLOOKUP.mp4 |
21.22MB |
| 4. VLOOKUPHLOOKUP.vtt |
7.23KB |
| 5. Fixed, Relative, & Mixed References.mp4 |
14.76MB |
| 5. Fixed, Relative, & Mixed References.vtt |
5.71KB |
| 5. Formatting Cells Using Statistical Functions.mp4 |
24.27MB |
| 5. Formatting Cells Using Statistical Functions.vtt |
5.74KB |
| 5. Joining Data with VLOOKUP.mp4 |
37.77MB |
| 5. Joining Data with VLOOKUP.vtt |
7.38KB |
| 5. NEW Open Weather Map WEBSERVICE Demo.mp4 |
92.27MB |
| 5. NEW Open Weather Map WEBSERVICE Demo.vtt |
11.56KB |
| 5. NOT vs. .mp4 |
11.37MB |
| 5. NOT vs. .vtt |
3.80KB |
| 5. TEXTVALUE.mp4 |
55.38MB |
| 5. TEXTVALUE.vtt |
4.90KB |
| 5. The SUMPRODUCT Function.mp4 |
10.59MB |
| 5. The SUMPRODUCT Function.vtt |
4.72KB |
| 5. Using Array Constants in Formulas.mp4 |
7.11MB |
| 5. Using Array Constants in Formulas.vtt |
4.21KB |
| 5. YEARMONTHDAY & HOURMINUTESECOND.mp4 |
7.88MB |
| 5. YEARMONTHDAY & HOURMINUTESECOND.vtt |
3.60KB |
| 6. Bonus Functions.html |
124B |
| 6. Common Errors & the IFERROR statement.mp4 |
19.07MB |
| 6. Common Errors & the IFERROR statement.vtt |
9.61KB |
| 6. Fixing Errors with IFERROR.mp4 |
20.08MB |
| 6. Fixing Errors with IFERROR.vtt |
4.87KB |
| 6. Fixing Errors with IFERROR & VLOOKUP.mp4 |
15.20MB |
| 6. Fixing Errors with IFERROR & VLOOKUP.vtt |
21.81KB |
| 6. Formatting Cells Using Text Functions & Logical Operators.mp4 |
20.57MB |
| 6. Formatting Cells Using Text Functions & Logical Operators.vtt |
5.91KB |
| 6. Named Array Constants.mp4 |
9.96MB |
| 6. Named Array Constants.vtt |
4.88KB |
| 6. NEW SUMPRODUCT Demo.mp4 |
31.27MB |
| 6. NEW SUMPRODUCT Demo.vtt |
6.32KB |
| 6. SEARCHFIND.mp4 |
31.06MB |
| 6. SEARCHFIND.vtt |
6.13KB |
| 6. The EOMONTH Function.mp4 |
13.07MB |
| 6. The EOMONTH Function.vtt |
7.75KB |
| 7. Categorizing Data with IF(ISNUMBER(SEARCH)).mp4 |
33.61MB |
| 7. Categorizing Data with IF(ISNUMBER(SEARCH)).vtt |
6.56KB |
| 7. Common IS Statements.mp4 |
20.92MB |
| 7. Common IS Statements.vtt |
4.51KB |
| 7. COUNTIFSSUMIFSAVERAGEIFS.mp4 |
14.15MB |
| 7. COUNTIFSSUMIFSAVERAGEIFS.vtt |
5.65KB |
| 7. Formula-Based Formatting.html |
124B |
| 7. Function, CTRL & ALT Shortcuts.mp4 |
19.04MB |
| 7. Function, CTRL & ALT Shortcuts.vtt |
7.54KB |
| 7. The Transpose Function.mp4 |
13.56MB |
| 7. The Transpose Function.vtt |
5.32KB |
| 7. The YEARFRAC Function.mp4 |
5.76MB |
| 7. The YEARFRAC Function.vtt |
2.82KB |
| 7. VLOOKUP Reference Array Options.mp4 |
40.16MB |
| 7. VLOOKUP Reference Array Options.vtt |
7.23KB |
| 8.1 Mac_Shortcuts.pdf.pdf |
37.94KB |
| 8. BONUS Shortcuts for Mac Users.mp4 |
7.86MB |
| 8. BONUS Shortcuts for Mac Users.vtt |
2.63KB |
| 8. Combining RIGHT, LEN, and SEARCH.mp4 |
41.87MB |
| 8. Combining RIGHT, LEN, and SEARCH.vtt |
6.83KB |
| 8. HOMEWORK Formula-Based Formatting.mp4 |
1.53MB |
| 8. HOMEWORK Formula-Based Formatting.vtt |
2.65KB |
| 8. Linking Data Between Sheets Array vs. Non-Array Comparison.mp4 |
9.05MB |
| 8. Linking Data Between Sheets Array vs. Non-Array Comparison.vtt |
2.94KB |
| 8. Logical Operators.html |
124B |
| 8. NEW Fuzzy Match Lookups.mp4 |
46.42MB |
| 8. NEW Fuzzy Match Lookups.vtt |
6.52KB |
| 8. PROJECT SHOWCASE Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4 |
23.60MB |
| 8. PROJECT SHOWCASE Building a Basic Dashboard with COUNTIFS & SUMIFS.vtt |
9.23KB |
| 8. WEEKDAY, WORKDAY & NETWORKDAYS.mp4 |
19.09MB |
| 8. WEEKDAY, WORKDAY & NETWORKDAYS.vtt |
8.23KB |
| 9. BONUS The SUBSTITUTE Function.mp4 |
8.00MB |
| 9. BONUS The SUBSTITUTE Function.vtt |
11.20KB |
| 9. Creating Custom Data Validation Rules.mp4 |
9.17MB |
| 9. Creating Custom Data Validation Rules.vtt |
3.97KB |
| 9. HOMEWORK Logical Operators.mp4 |
1.70MB |
| 9. HOMEWORK Logical Operators.vtt |
3.88KB |
| 9. NEW Combining COUNTIF & SUMPRODUCT.mp4 |
73.14MB |
| 9. NEW Combining COUNTIF & SUMPRODUCT.vtt |
9.85KB |
| 9. Returning the X Largest Values in a Range.mp4 |
10.78MB |
| 9. Returning the X Largest Values in a Range.vtt |
3.32KB |
| 9. The DATEDIF Function.mp4 |
10.12MB |
| 9. The DATEDIF Function.vtt |
5.08KB |
| 9. The INDEX Function.mp4 |
6.16MB |
| 9. The INDEX Function.vtt |
2.72KB |