My Shopping Cart
There are no items in your shopping cart.

Advanced Excel Formulas and Functions at Your Fingertips

Presented by: Dennis Taylor
(*) Single User Price. For multiple users please call 1-800-223-8720
Pre Recorded Audio Conference
60 minutes
  •  Tue, February 2, 2010
Event Description

Even if you've used Excel for years, you still probably don't take advantage of all of its power, flexibility and scope of functions. You need insider information to master this potent tool's advanced formulas and functions — and that help is here! Professional tips and secrets offered by our Excel expert Dennis Taylor will take your creativity and analysis skills to the next level!


To increase your Excel productivity and make advanced Excel do the work for you with functions and formulas at your fingertips!

At the end of the conference you'll be able to:

  • Use Text functions to quickly clean up and restructure downloaded data
  • Examine and categorize date by date and time measures
  • Use a function to look up data from a list in another workbook
  • Use the special-purpose array functions and formulas
  • And more Excel techniques to make your day easier

Conference Outline:

  • How to use the Function Wizard to quickly get a function's information and see functions listed by category.
  • How to use selected Text functions to extract and manipulate character and numerical data for sorting and analytical purposes.
  • How to build 3-D formulas to tabulate data totals from multiple worksheets.
  • How to harness the power gained from using multiple functions in a nested fashion.
  • How and when to use the advanced capabilities of array functions and formulas to perform frequency distribution, calculate unique entries in a list and extend the capabilities of the IF function far beyond standard usage.
About Our Speaker(s)

Dennis Taylor | Microsoft Excel SpeakerDennis Taylor
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info

We Also Recommend
Recommend this event to a colleague
  • Your Name:
  • Your E-mail:
  • Colleague's Name:
  • Colleague's E-mail:
    Event Title: Advanced Excel Formulas and Functions at Your Fingertips
    Presenter(s): Dennis Taylor

Our Accreditation Partners Protection Status