Search
Search
Close this search box.
All   >   Excel – Power Functions

Excel – Power Functions

Learn to use 10 Excel functions recommended by the experts

$30 USD

Suggested price per user, ask about bundle discounts

Learn to use 10 Excel functions recommended by the experts

 

Ask any Excel expert to name their favorite Excel functions, and you’ll receive a variety of suggestions. Some you’ll recognize, others you won’t. This course examines 10 of the functions more commonly listed by the experts and removes the mystery of how and why to use them. With over 450 functions available in Excel, odds are you’re not getting the full power of Excel in your workbooks. This course steps you through functions that can increase your productivity and simplify your spreadsheets.

 

How do I know if this course is for me?

  • Do you work with dates? Learn how to generate anniversary dates, renewal dates, and end-of-month dates.
  • Do you need to locate values within a large array of data? Explore options that allow you to locate data anywhere within the database without the VLOOKUP limitation of looking in the leftmost column.
  • Do you create rolling averages? Learn which functions help you calculate them.
  • Once you explore these functions, your spreadsheets will never be the same.

 

High-quality HD content in the “Uniquely Engaging™” Bigger Brains Teacher-Learner style!

Course Contents:

# Lesson Length
1 Function Criteria and Syntax 6:04
2 DATEDIF 4:45
3 EDATE and EOMONTH 7:34
4 CONVERT 4:32
5 INDEX and MATCH 6:31
6 INDEX MATCH MATCH 5:48
7 OFFSET and COUNTA 6:29
8 SUMPRODUCT 6:12

$30 USD

Suggested price per user, ask about bundle discounts

Related Course Recommendations

Excel – Creating Dashboards

Excel – Intro to Power Pivot

Excel – Data Analysis with Pivot Tables

Bigger Brains Course Catalog and Pricing

Fill out the information below to receive a download link for our latest course catalog.

Get More Information

Looking for eLearning content or other training solutions for your company? Let us know how we can help!