< Excel Functions Mastery Course

42 casts | 5:05:41 for the total course

created by Mammoth Interactive INC

• 1. Intro to the Course
  • Excel Functions | Intro to the Course | 1.1

  • Excel Functions | Intro of the Instructor | 1.2

  • Excel Functions | Course Requirements | 1.3

  • Excel Functions | How to Get Excel | 1.4

• 2. Excel Logic and Lookup Functions Projects

  • Excel Functions | Section Learnings | 2.1

  • Excel Functions | Create An If() Function | 2.2

  • Excel Functions | Nest And() And/Or Or() Functions Within Reference Functions

  • Excel Functions | Work With Choose(), Vlookup(), Index(), And Match() Functions | 2.4

  • Excel Functions | Create A Vlookup() Function | 2.5

  • Excel Functions | Section Summary | 2.6

• 3. Excel Math and Finance Functions Projects

  • Excel Functions | Section Learnings | 3.1

  • Excel Functions | Aggregate Data Using Both The Sum And Subtotal Function | 3.2

  • Excel Functions | Calculate Minimums, Maximums, and Averages From Data Sets | 3.3

  • Excel Functions | Use the Forecast Function to Forecast Numbers Along a Trend | 3.4

  • Excel Functions | Generate a Net Present Value Using a Formula | 3.5

  • Excel Functions | Section Summary | 3.6

• 4. Excel Date and Time Functions Projects

  • Excel Functions | Section Learnings | 4.1

  • Excel Functions | Work With Excel's Date Manipulation Functions | 4.2

  • Excel Functions | Build a Holiday Date Calculator | 4.3

  • Excel Functions | Section Summary | 4.4

• 5. Excel Text and Information Functions Projects

  • Excel Functions | Section Learnings | 5.1

  • Excel Functions | Split Textual Data Apart | 5.2

  • Excel Functions | Manipulate Textual Data | 5.3

  • Excel Functions | Replace Portions of Textual Data | 5.4

  • Excel Functions | Put Textual Data Back Together With Formulae | 5.5

  • Excel Functions | Work With Key Informational Functions For Evaluating And Responding Correctly to Errors in Routine Excel Calculations | 5.6

  • Excel Functions | Use the Hyperlink Function to Build Navigational Menus Inside an Excel Worksheet | 5.7

  • Excel Functions | Section Summary | 5.8

• 6. Excel Lists

  • Excel Functions | Section Learnings | 6.1

  • Excel Functions | How to Filter Items in a List | 6.2

  • Excel Functions | Sorting List Without Messing up the Data | 6.3

  • Excel Functions | How to Freeze Rows or Columns | 6.4

  • Excel Functions | Remove Duplicates From a List | 6.5

  • Excel Functions | Section Summary | 6.6

• 7. Other Excel Useful Functions

  • Excel Functions | Section learnings | 7.1

  • Excel Functions | COUNT, COUNTA and COUNTIF Functions | 7.2

  • Excel Functions | Create a Drop Down List | 7.3

  • Excel Functions | Work With ISNUMBER and SEARCH Functions Within Text Functions | 7.4

  • Excel Functions | Format Row Based on a Cell Value | 7.5

  • Excel Functions | Create An Invoice Template in Excel | 7.6

  • Excel Functions | Section Summary | 7.7

• 8. Course Summary

  • Excel Functions | Course Summary and Next Steps | 8.1