Advanced Microsoft® Excel® Formulas and Functions

Lorman Education Services
Training overview
Professional Course
1.5 hours

Course description

Advanced Microsoft® Excel® Formulas and Functions

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.

Learning Objectives

  • You will be able to review powerful Date and Text functions.
  • You will be able to discuss the power of Array Formulas.
  • You will be able to identify nested uses of VLOOKUP, MATCH, and Array formula techniques.
  • You will be able to explain how to readjust formula references with the INDIRECT function.

  • Want to find out more?

    Who should attend?

    This live webinar is designed for business owners and managers, supervisors, associates, administrative professionals, analysts, controllers, bookkeepers and accountants.

    Training content

    • Overview and Review of Power Tools for Handling Formulas and Functions
    • Quick Cell Values Changes Without Formulas
    • Displaying Formulas and Highlighting Worksheet Formula Cells
    • Multiple Cell Formula Creation With the Ctrl Key
    • Debugging Tools and 3-D FormulasPower Functions
    • Extended Uses of the IF and VLOOKUP Function
    • Using the MATCH and INDEX Functions for More Complex 2-Way LookupsScientific Applications of the CONVERT FunctionUnderstanding and Using the Power of Array Formulas
    • Counting Unique Entries in a Range
    • Condense Long Formulas by as Much as 90%Use Specialized Array Functions – FREQUENCY, TRANSPOSE, TREND, GROWTHManipulate Data at the Character Level With REPLACE, SUBSTITUTE and Other Text FunctionsUse the MOD Function With Conditional Formatting Techniques for Special DisplaysReadjust Formula References With the INDIRECT Function


    The cost of this Advanced Microsoft® Excel® Formulas and Functions live webinar is $199 per participant.

    About Lorman Education Services

    Lorman Education Services

    Lorman Education Services - Live and On-Demand Webinars

    With more than 27 years spent educating over 1.4 million professionals, Lorman has the experience and expert instructors you need to stay ahead no matter the position or profession. Search from the many courses listed here or contact the customer...

    Read more and show all training delivered by this supplier

    Request info

    Fill out your details to find out more about Advanced Microsoft® Excel® Formulas and Functions.

      Contact the provider

      Get more information

      Register your interest

    Contact info

    Lorman Education Services

    Lorman Education Services
    2510 Alpine Road
    54702 Eau Claire Wisconsin

    Request Information

    Have a question about this course? Fill out this form and the provider will get in touch with you shortly

    View again
    Supplier Directory
    Join our Supplier Directory to:
    - Gain Traffic
    - Get Noticed
    - Showcase Your Services
    - Free Listing Available