Show navigation

Video

  • 94 minutes

Advanced Microsoft® Excel® Formulas and Functions

 

Even if you are comfortable with building formulas and functions in Excel®, you may be missing out on some often overlooked powerful functions and special capabilities.

There's no question that Excel's® 450+ functions give you tremendous capabilities to tackle a myriad of statistical, mathematical and financial challenges, not to mention functions that extract valuable date information and let you manipulate text at the character level. But few of us have the time to explore functions (and of course you don't need to know them all). This topic gives you exposure to those overlooked functions and gives you new and powerful tools, such as array formulas, that will make your usage of Excel® even more powerful and efficient. Receive valuable tips that you may have picked up in the previous program, mastering Excel® formulas and functions, such as quick formula copying methods, creative use of the Ctrl to create formulas/function in multiple locations simultaneously and a host of others. Specific functions that will be covered include MATCH, INDEX, CONVERT, AGGREGATE, FREQUENCY, DATEDIF, INDIRECT, LEN, MOD, TREND, GROWTH, REPLACE, SUBSTITUTE, and extended uses of the IF and VLOOKUP functions.
Runtime: 93 minutes
View Video

More Program Information

Agenda

View Video

More Program Information

Faculty

Dennis Taylor

Dennis Taylor

Taylor Associates

  • Founder of Taylor Associates
  • More than 20 years of experience working with Excel®
  • Taught thousands of classes and seminars throughout the United States and Canada
  • Presented more than 700 Excel® webinars and is the author or co-author of six books on spreadsheet software
View Video

More Program Information

All of your training, right here at Lorman.

Pay once and get a full year of unlimited training in any format, any time!

  • Live Webinars
  • OnDemand Webinars
  • MP3 Downloads
  • Course Manuals
  • Audio Recordings*
  • Executive Reports
  • White Papers and Articles
  • Sponsored Live Webinars

Additional benefits include:

  • State Specific Credit Tracker
  • Members Only Newsletter
  • All-Access Pass Course Concierge

* For audio recordings you only pay shipping

Questions? Call 877-296-2169 to speak with a real person.

Sign Up Today
With This Course

Access to all training products for one year
$699/year

Unlimited Lorman Training

With the All-Access Pass there is no guessing what you will need for your yearly training budget. $699 will cover all of your training needs for an entire year!

Easy Registrations

Once you purchase your All-Access Pass you will never be any further than one-click away from attending any Lorman training course.

Invest in Yourself

You haven't gotten to where you are professionally by luck alone; it's taken a lot of hard work and training. Invest in yourself with the All-Access Pass.