​Package Includes
★ Total 101 Video Lectures
​★ 14 Hour content
​★ English Language
​★ Lifetime Access

Microsoft Excel - Advanced Excel Formulas & Functions quantity

Total 101 Video Lectures:-

1. Excel Formulas 101

1. Introduction.mp4

1. Introduction.vtt

1.1 Excel For Analysts Formulas 101.pdf

1.2 Section 2 Fixed Relative References.xlsx

2. The Formula Library & Auditing Tools.mp4

2. The Formula Library & Auditing Tools.vtt

3. DEMO Evaluate Formula (not available for mac).mp4

3. DEMO Evaluate Formula (not available for mac).vtt

4. Basic Formula Syntax.mp4

4. Basic Formula Syntax.vtt

5. Fixed, Relative, & Mixed References.mp4

5. Fixed, Relative, & Mixed References.vtt

6. Common Errors & the IFERROR statement.mp4

6. Common Errors & the IFERROR statement.vtt

7. Function, CTRL & ALT Shortcuts.mp4

7. Function, CTRL & ALT Shortcuts.vtt

8. BONUS Shortcuts for Mac Users.mp4

8. BONUS Shortcuts for Mac Users.vtt

8.1 Mac_Shortcuts.pdf.pdf

9. Creating Custom Data Validation Rules.mp4

9. Creating Custom Data Validation Rules.vtt

10. Fixed vs. Volatile Functions.mp4

10. Fixed vs. Volatile Functions.vtt

11. HOMEWORK Formulas 101.mp4

2. Conditional Statements & Logical Operators

1. Introduction.mp4

1. Introduction.vtt

1.1 Section 3 Logical Operators.xlsx

1.2 Excel For Analysts Logical Operators.pdf

2. Anatomy of the IF Statement.mp4

2. Anatomy of the IF Statement.vtt

3. Nested IF Statements.mp4

3. Nested IF Statements.vtt

4. ANDOR Operators.mp4

4. ANDOR Operators.vtt

5. NOT vs. .mp4

5. NOT vs. .vtt

6. Fixing Errors with IFERROR.mp4

6. Fixing Errors with IFERROR.vtt

7. Common IS Statements.mp4

7. Common IS Statements.vtt

8. HOMEWORK Logical Operators.mp4

8. HOMEWORK Logical Operators.vtt

3. Statistical Functions

1. Introduction.mp4

1. Introduction.vtt

1.1 Excel For Analysts Statistical Functions.pdf.pdf

1.2 Section4_Statistical_Functions.xlsx.xlsx

2. Basic Statistical Functions.mp4

2. Basic Statistical Functions.vtt

3. SMALL LARGE & RANKPERCENTRANK.mp4

3. SMALL LARGE & RANK PERCENTRANK.vtt

4. RAND() & RANDBETWEEN.mp4

4. RAND() & RANDBETWEEN.vtt

5. The SUMPRODUCT Function.mp4

5. The SUMPRODUCT Function.vtt

6. NEW SUMPRODUCT Demo.mp4

6. NEW SUMPRODUCT Demo.vtt

7. COUNTIFSSUMIFSAVERAGEIFS.mp4

7. COUNTIFS SUMIFS AVERAGEIFS.vtt

8. PROJECT SHOWCASE Building a Basic Dashboard with COUNTIFS & SUMIFS.mp4

8. PROJECT SHOWCASE Building a Basic Dashboard with COUNTIFS & SUMIFS.vtt

9. NEW Combining COUNTIF & SUMPRODUCT.mp4

9. NEW Combining COUNTIF & SUMPRODUCT.vtt

10. HOMEWORK Statistical Functions.mp4

10. HOMEWORK Statistical Functions.vtt

4. LookupReference Functions

1. Introduction.mp4

1. Introduction.vtt

1.1 Section_5_Lookup_Reference.xlsx.xlsx

1.2 Excel For Analysts Lookup Reference Functions.pdf.pdf

2. Working with Named Arrays.mp4

2. Working with Named Arrays.vtt

3. ROW ROWS & COLUMNCOLUMNS.mp4

3. ROW ROWS & COLUMNS COLUMNS.vtt

4. VLOOKUPHLOOKUP.mp4

4. VLOOKUP HLOOKUP.vtt

5. Joining Data with VLOOKUP.mp4

5. Joining Data with VLOOKUP.vtt

6. Fixing Errors with IFERROR & VLOOKUP.mp4

6. Fixing Errors with IFERROR & VLOOKUP.vtt

7. VLOOKUP Reference Array Options.mp4

7. VLOOKUP Reference Array Options.vtt

8. NEW Fuzzy Match Lookups.mp4

8. NEW Fuzzy Match Lookups.vtt

9. The INDEX Function.mp4

9. The INDEX Function.vtt

10. The MATCH Function.mp4

10. The MATCH Function.vtt

11. Using INDEX & MATCH together.mp4

11. Using INDEX & MATCH together.vtt

12. Combining MATCH with VLOOKUP.mp4

12. Combining MATCH with VLOOKUP.vtt

13. UPDATE VLOOKUP Correction.mp4

13. UPDATE VLOOKUP Correction.vtt

14. The OFFSET Function.mp4

14. The OFFSET Function.vtt

15. Combining OFFSET with COUNTA to return a variable list.mp4

15. Combining OFFSET with COUNTA to return a variable list.vtt

16. PROJECT SHOWCASE Using OFFSET to create a dynamic scrolling chart.mp4

16. PROJECT SHOWCASE Using OFFSET to create a dynamic scrolling chart.vtt

17. HOMEWORK LookupReference Functions.mp4

5. Text Functions

1. Introduction.mp4

1. Introduction.vtt

1.1 Section 6 Text Functions.xlsx

1.2 Excel For Analysts Text Functions.pdf

2. UPPERLOWERPROPER & TRIM.mp4

2. UPPERLOWERPROPER & TRIM.vtt

3. The CONCATENATE Function (&).mp4

3. The CONCATENATE Function (&).vtt

4. LEFT MID RIGHT & LEN.mp4

4. LEFT MID RIGHT & LEN.vtt

5. TEXTVALUE.mp4

5. TEXT VALUE.vtt

6. SEARCHFIND.mp4

6. SEARCHFIND.vtt

7. Categorizing Data with IF(ISNUMBER(SEARCH)).mp4

7. Categorizing Data with IF(ISNUMBER(SEARCH)).vtt

8. Combining RIGHT, LEN, and SEARCH.mp4

8. Combining RIGHT, LEN, and SEARCH.vtt

9. BONUS The SUBSTITUTE Function.mp4

9. BONUS The SUBSTITUTE Function.vtt

10. HOMEWORK Text Functions.mp4

10. HOMEWORK Text Functions.vtt

6. Date & Time Functions

1. Introduction.mp4

1. Introduction.vtt

1.1 Section 7 Date Time Functions.xlsx

1.2 Excel For Analysts Date Time Functions.pdf.pdf

2. DATEVALUE Your New BFF.mp4

2. DATEVALUE Your New BFF.vtt

3. Date Formatting & Fill Series.mp4

3. Date Formatting & Fill Series.vtt

4. TODAY()NOW().mp4

4. TODAY()NOW().vtt

5. YEAR MONTH DAY & HOURMINUTESECOND.mp4

5. YEAR MONTH DAY & HOUR MINUTE SECOND.vtt

6. The EOMONTH Function.mp4

6. The EOMONTH Function.vtt

7. The YEARFRAC Function.mp4

7. The YEARFRAC Function.vtt

8. WEEKDAY, WORKDAY & NETWORKDAYS.mp4

8. WEEKDAY, WORKDAY & NETWORKDAYS.vtt

9. The DATEDIF Function.mp4

9. The DATEDIF Function.vtt

10. PROJECT SHOWCASE Designing a Sample Budget Pacing Tool.mp4

10. PROJECT SHOWCASE Designing a Sample Budget Pacing Tool.vtt

11. HOMEWORK Date & Time Functions.mp4

11. HOMEWORK Date & Time Functions.vtt

7. Formula-Based Formatting

1. Introduction.mp4

1. Introduction.vtt

1.1 Section8_Formula_Formatting.xlsx.xlsx

1.2 Excel For Analysts Formula Formatting.pdf

2. Creating, Editing & Managing Formula-Based Rules.mp4

2. Creating, Editing & Managing Formula-Based Rules.vtt

3. Highlighting Every Other Row Using the MOD function.mp4

3. Highlighting Every Other Row Using the MOD function.vtt

4. Formatting Cells Based on the Value of Another Cell.mp4

4. Formatting Cells Based on the Value of Another Cell.vtt

5. Formatting Cells Using Statistical Functions.mp4

5. Formatting Cells Using Statistical Functions.vtt

6. Formatting Cells Using Text Functions & Logical Operators.mp4

6. Formatting Cells Using Text Functions & Logical Operators.vtt

7. HOMEWORK Formula-Based Formatting.mp4

7. HOMEWORK Formula-Based Formatting.vtt

8. Array Formulas

1. Introduction.mp4

1. Introduction.vtt

1.1 Section 9 Array Formulas.xlsx

1.2 Excel For Analysts Array Formulas.pdf

2. Rules of Array Functions.mp4

2. Rules of Array Functions.vtt

3. Pros & Cons of Array Functions.mp4

3. Pros & Cons of Array Functions.vtt

4. Vertical, Horizontal, and 2-Dimensional Array Constants.mp4

4. Vertical, Horizontal, and 2-Dimensional Array Constants.vtt

5. Using Array Constants in Formulas.mp4

5. Using Array Constants in Formulas.vtt

6. Named Array Constants.mp4

6. Named Array Constants.vtt

7. The Transpose Function.mp4

7. The Transpose Function.vtt

8. Linking Data Between Sheets Array vs. Non-Array Comparison.mp4

8. Linking Data Between Sheets Array vs. Non-Array Comparison.vtt

9. Returning the X Largest Values in a Range.mp4

9. Returning the X Largest Values in a Range.vtt

10. Counting Characters Across Cells.mp4

10. Counting Characters Across Cells.vtt

11. Creating a MAX IF Array Formula.mp4

11. Creating a MAX IF Array Formula.vtt

12. BONUS MAX IF with Multiple Criteria.mp4

12. BONUS MAX IF with Multiple Criteria.vtt

13. BONUS Using the Double Unary Operator (--).mp4

13. BONUS Using the Double Unary Operator (--).vtt

14. HOMEWORK Array Functions.mp4

14. HOMEWORK Array Functions.vtt

9. Badass Bonus Functions

1. Introduction.mp4

1. Introduction.vtt

1.1 Section10_Bonus_Functions.xlsx.xlsx

1.2 Excel For Analysts Bonus Functions.pdf

2. The INDIRECT Function.mp4

2. The INDIRECT Function.vtt

3. HYPERLINK as Awesome as it Sounds.mp4

3. HYPERLINK as Awesome as it Sounds.vtt

4. Tapping into Real-Time Data with WEB SERVICE & FILTERXML.mp4

4. Tapping into Real-Time Data with WEB SERVICE & FILTERXML.vtt

5. NEW Open Weather Map WEB SERVICE Demo.mp4

5. NEW Open Weather Map WEB SERVICE Demo.vtt

✦ COURSE DESCRIPTION

Microsoft Excel – Advanced Excel Formulas & Functions

It’s time to show Excel who’s boss. Whether you’re starting from square one or aspiring to become an absolute Excel power user, you’ve come to the right place.

This course will give you a deep understanding of the advanced Excel formulas and functions that transform Excel from a basic spreadsheet program into a dynamic and powerful analytics tool.

While most Excel courses focus on simply what each formula does, I teach through hands-on, contextual examples designed to showcase why these formulas are awesome and how they can be applied in a number of ways.

I will not train you to regurgitate functions and formula syntax; I will teach you how to THINK like Excel.

By the end of the course you’ll be writing robust, elegant formulas from scratch, allowing you to:

✦ Easily build dynamic tools & Excel dashboards to filter, display and analyze your data
✦ Create your own formula-based Excel formatting rules
✦ Join datasets from multiple sources with XLOOKUP, INDEX & MATCH functions
✦ Manipulate dates, times, text, and arrays
✦ Automate tedious and time-consuming tasks using cell formulas and functions in Excel (no VBA required!)
✦ Pull real-time data from APIs directly into Excel (weather, stock quotes, directions, etc.)

We’ll dive into a broad range of Excel formulas & functions, including:

✦ Lookup/Reference functions
✦ Statistical functions
✦ Formula-based formatting
✦ Date & Time functions
✦ Logical operators
✦ Dynamic Array formulas
✦ Text functions
✦ INDIRECT & HYPERLINK

✦ Web scraping with WEBSERVICE & FILTERXML

WHO THIS COURSE IS FOR

✦ Excel users who want to learn how to write advanced formulas from scratch

✦ Anyone hoping to expand their analytics skill set, work efficiently with data, and take their career to a new level

✦ Students looking for an engaging, hands-on, and highly interactive approach to Excel analytics training

✦ Excel users looking to build powerful analytical thinking and business intelligence skills

Enroll this powerful skill building course… Right Now!