Group Attendees: Any number of participants
Recorded Version: Unlimited viewing for 6 months ( Access information will be emailed 24 hours after the completion of live webinar)
Excel’s 500+ functions represent a potent set of power tools that simplifies many different kinds of formulas and gives you a huge number of computational possibilities.Some of the more important Excel functions are those categorized as Lookup and Reference functions. In addition to the widely used VLOOKUP function (and its companion HLOOKUP), significant functions like MATCH, INDEX, SWITCH, and CHOOSE are also needed at different times to retrieve data from lists and tables. Two newer functions - XLOOKUP and XMATCH - provide powerful new capabilities and ease of use and can ultimately replace the use of VLOOKUP, HLOOKUP, and MATCH functions. Newer lookup functions include CHOOSEROWS,CHOOSECOLS, TAKE, and DROP - additional tools to get to the data you need quickly and efficiently. This session presents in-depth coverage of all these functions, as well as providing attendees with the perspective they need to understand the scope and depth of these important Excel features.
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.