Filename Size Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/1. Getting Started/1. Course Structure & Outline.vtt 5.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/1. Getting Started/2. Important Notes for New Students.html 3.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/1. Getting Started/3. BONUS Extra Homework Exercises.vtt 2.5 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/10. Badass Bonus Functions/1. Introduction.vtt 2.2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/10. Badass Bonus Functions/3. HYPERLINK as Awesome as it Sounds.vtt 6.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/10. Badass Bonus Functions/4. Tapping into Real-Time Data with WEBSERVICE & FILTERXML.vtt 8.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/10. Badass Bonus Functions/6. Bonus Functions.html 124 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/11. Wrapping Up/1. Conclusion & Next Steps.vtt 1.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/11. Wrapping Up/2. Bonus Lecture More from Excel Maven.html 2.5 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/1. Introduction.vtt 1.6 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/1.1 Section 2 Fixed Relative References.xlsx 8.2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/10. Fixed vs. Volatile Functions.vtt 4 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/11. Formulas 101.html 124 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/12. HOMEWORK Formulas 101.vtt 4.4 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/2. The Formula Library & Auditing Tools.vtt 5.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/3. DEMO Evaluate Formula (not available for mac).vtt 7.4 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/4. Basic Formula Syntax.vtt 4.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/5. Fixed, Relative, & Mixed References.vtt 5.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/6. Common Errors & the IFERROR statement.vtt 9.6 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/7. Function, CTRL & ALT Shortcuts.vtt 7.5 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/8. BONUS Shortcuts for Mac Users.vtt 2.6 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/2. Excel Formulas 101/9. Creating Custom Data Validation Rules.vtt 4 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/3. Conditional Statements & Logical Operators/1. Introduction.vtt 1.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/3. Conditional Statements & Logical Operators/2. Anatomy of the IF Statement.vtt 4.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/3. Conditional Statements & Logical Operators/3. Nested IF Statements.vtt 6 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/3. Conditional Statements & Logical Operators/4. ANDOR Operators.vtt 9.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/3. Conditional Statements & Logical Operators/5. NOT vs. .vtt 3.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/3. Conditional Statements & Logical Operators/6. Fixing Errors with IFERROR.vtt 4.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/3. Conditional Statements & Logical Operators/7. Common IS Statements.vtt 4.5 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/3. Conditional Statements & Logical Operators/8. Logical Operators.html 124 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/3. Conditional Statements & Logical Operators/9. HOMEWORK Logical Operators.vtt 3.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/1. Introduction.vtt 1.5 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/10. Statistical Functions.html 124 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/11. HOMEWORK Statistical Functions.vtt 992 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/2. Basic Statistical Functions.vtt 6.4 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/3. SMALLLARGE & RANKPERCENTRANK.vtt 7.4 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/4. RAND() & RANDBETWEEN.vtt 2.5 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/5. The SUMPRODUCT Function.vtt 4.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/6. NEW SUMPRODUCT Demo.vtt 6.3 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/7. COUNTIFSSUMIFSAVERAGEIFS.vtt 5.6 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/8. PROJECT SHOWCASE Building a Basic Dashboard with COUNTIFS & SUMIFS.vtt 9.2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/4. Statistical Functions/9. NEW Combining COUNTIF & SUMPRODUCT.vtt 9.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/1. Introduction.vtt 1.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/10. The MATCH Function.vtt 3.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/11. Using INDEX & MATCH together.vtt 7.6 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/12. Combining MATCH with VLOOKUP.vtt 5.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/14. The OFFSET Function.vtt 2.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/17. LookupReference Functions.html 124 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/18. HOMEWORK LookupReference Functions.vtt 4.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/2. Working with Named Arrays.vtt 4.2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/3. ROWROWS & COLUMNCOLUMNS.vtt 8 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/4. VLOOKUPHLOOKUP.vtt 7.2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/5. Joining Data with VLOOKUP.vtt 7.4 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/7. VLOOKUP Reference Array Options.vtt 7.2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/8. NEW Fuzzy Match Lookups.vtt 6.5 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/5. LookupReference Functions/9. The INDEX Function.vtt 2.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/1. Introduction.vtt 1.4 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/10. Text Functions.html 124 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/11. HOMEWORK Text Functions.vtt 5.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/2. UPPERLOWERPROPER & TRIM.vtt 4.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/3. The CONCATENATE Function (&).vtt 3.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/4. LEFTMIDRIGHT & LEN.vtt 8 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/5. TEXTVALUE.vtt 4.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/6. SEARCHFIND.vtt 6.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/7. Categorizing Data with IF(ISNUMBER(SEARCH)).vtt 6.6 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/6. Text Functions/8. Combining RIGHT, LEN, and SEARCH.vtt 6.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/1. Introduction.vtt 2.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/11. DateTime Functions.html 124 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/12. HOMEWORK Date & Time Functions.vtt 3.2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/2. DATEVALUE Your New BFF.vtt 5.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/3. Date Formatting & Fill Series.vtt 4.4 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/4. TODAY()NOW().vtt 3 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/5. YEARMONTHDAY & HOURMINUTESECOND.vtt 3.6 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/6. The EOMONTH Function.vtt 7.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/7. The YEARFRAC Function.vtt 2.8 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/8. WEEKDAY, WORKDAY & NETWORKDAYS.vtt 8.2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/7. Date & Time Functions/9. The DATEDIF Function.vtt 5.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/8. Formula-Based Formatting/1. Introduction.vtt 2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/8. Formula-Based Formatting/2. Creating, Editing & Managing Formula-Based Rules.vtt 5.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/8. Formula-Based Formatting/3. Highlighting Every Other Row Using the MOD function.vtt 4.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/8. Formula-Based Formatting/4. Formatting Cells Based on the Value of Another Cell.vtt 4.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/8. Formula-Based Formatting/5. Formatting Cells Using Statistical Functions.vtt 5.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/8. Formula-Based Formatting/6. Formatting Cells Using Text Functions & Logical Operators.vtt 5.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/8. Formula-Based Formatting/7. Formula-Based Formatting.html 124 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/8. Formula-Based Formatting/8. HOMEWORK Formula-Based Formatting.vtt 2.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/1. Introduction.vtt 2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/1.1 Section 9 Array Formulas.xlsx 9.3 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/10. Counting Characters Across Cells.vtt 2.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/11. Creating a MAX IF Array Formula.vtt 3.7 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/14. Array Formulas.html 124 B Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/15. HOMEWORK Array Functions.vtt 10.6 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/2. Rules of Array Functions.vtt 4.1 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/3. Pros & Cons of Array Functions.vtt 3 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/4. Vertical, Horizontal, and 2-Dimensional Array Constants.vtt 7.3 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/5. Using Array Constants in Formulas.vtt 4.2 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/6. Named Array Constants.vtt 4.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/7. The Transpose Function.vtt 5.3 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/8. Linking Data Between Sheets Array vs. Non-Array Comparison.vtt 2.9 KB Udemy-Microsoft.Excel-Advanced.Excel.Formulas.&.Functions/9. Array Formulas/9. Returning the X Largest Values in a Range.vtt 3.3 KB
No related downloads found.