Recorded Version: Unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Excel has over 450 functions - a potent set of power tools that simplifies certain kinds of formulas and gives you a huge number of computational possibilities. Many Excel functions provide extended analytical capabilities and open the door to more efficient use of Excel.
This session gives you perspective on what functions are available and explains (with extensive examples) how to use many of them, including: the IF function (with AND and OR), the powerful lookup functions -VLOOKUP, MATCH, and their important and more robust replacements - XLOOKUP and XMATCH. Examples of selected Date, Statistical, Financial, Mathematical and TEXT functions will also be presented, as well as some of the new dynamic array functions - UNIQUE, SORT, and FILTER.
Dennis Taylor has worked extensively with Microsoft Excel since the mid-1990s. He's traveled the United States and Canada presenting seminars and classes to help attendees unlock the full potential of Excel.
Accomplishments: Dennis has authored and presented nearly 700 webinars on various Excel topics in the past 11 years. He has also produced numerous Excel courses on video, CD, and DVD and has taught more than 500 seminars and over 5,000 classes on the subject. Dennis is the author/presenter of over 200 hours of online Excel courses available at LinkedIn Learning. Dennis also authored Teach Yourself Microsoft Office 2000 and coauthored five other titles in this field.
He's taught for numerous corporations, government agencies and colleges and universities, including: Northrop-Grumman, Raytheon, Levi Strauss, Chevron, BP, IBM, Apple, Driscoll's, Amgen, AT&T, Qwest, Anheuser-Busch, Starz-Encore, University of Phoenix, University of Colorado, US Department of Labor, Bureau of Land Management, Great-West Life Insurance, Texaco, Lexmark, Time-Warner, Environmental Protection Agency, National Seminars, and the Cities of Denver, Boulder, Longmont, and Westminster, CO.