Show navigation

Live Webinar

90-minute live streaming program
  • July 10
  • 1:00 - 2:30 pm EST

Also available as:

Audio & Reference Manual

Advanced Microsoft® Excel® Formulas and Functions

July 10

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

Who Can Benefit from Advanced Excel® Functions Training?

Virtually any professional Excel® user can benefit from a more robust understanding of its more advanced formulas and features. Microsoft® Excel® is designed to be user-friendly for a casual user, but there are more than 450 features to master. A more advanced professional may benefit from learning the program’s more advanced formulas.

Professionals who can benefit from advanced Microsoft® Excel® functions training include:

  • Mathematicians, researchers and scientists
  • Academic professionals
  • Administrative assistants
  • Financial professionals
  • Paralegals, attorneys and other legal professionals
  • Office professionals
  • Aviation and aerospace professionals
  • IT and tech professionals
  • Managers, supervisors, CFOs, presidents and vice presidents
  • Professionals in the construction and architectural industries
  • Engineers

Microsoft® Excel® is a diverse program used in almost any environment where numbers and data are collated, so any professional can benefit from a more in-depth understanding of its features.

If you have struggled to understand how to use Microsoft® Excel® in your field, have had issues with making the program work in your professional context or are simply unsure of all the features it offers, training can help you. If you use advanced features of Microsoft® Excel® every day as part of your work, but it has been some time since you have had formal training, additional training can help you become familiar with data validation, macros and other features, especially newer features. Updating your Microsoft® Excel® training means you gain confidence in using Microsoft® Excel® and its most current version.

If you are starting your career or seeking career advancement, Microsoft® Excel® training can help you master the advanced features you may need to embrace new work opportunities. With an understanding of advanced Microsoft® Excel® features, you may be able to seek qualifications for a new position or prove your readiness for new responsibility. If you are mid-career or have achieved a significant level of advancement, Microsoft® Excel® training in advanced formulas and features helps you move forward with more efficiency.

What Is Advanced Excel® Training?

Microsoft® Excel® training for advanced users helps uncover the features you may not realize are part of the program, and helps you to become more confident in using the features. With advanced Microsoft® Excel® training, you will learn about quick cell values changes, 3-D formulas and power functions. If you have ever wondered how to highlight formula worksheet cells or display formulas or how to more efficiently create multiple cell formulas, training can help you.

Advanced Microsoft® Excel® training lets you troubleshoot issues you may have, lets you become more confident with the program and may help you discover ways Microsoft® Excel® can help you perform tasks you thought you had to take care of on your own. Training can further help you automate rote tasks associated with advanced formulas and features. It lets you find and use debugging tools, as well as other resources to assist you.

Microsoft® Excel® training for advanced users helps you understand the IF, INDEX, MATCH, CONVERT and VLOOKUP functions and use them in more complex ways. You can use spreadsheets and Microsoft® Excel® in scientific and academic contexts, where the demands on the software might be greater. If you are an advanced user and routinely use long formulas, training can help you condense them significantly, helping you manage your spreadsheets and information more effectively.

Advanced Microsoft® Excel® training lets you use power of array formulas and helps you understand how to count unique entries in a range. It further allows you to use specialized array functions, such as FREQUENCY, TRANSPOSE, TREND and GROWTH, as part of your work. If you need to change data using text functions such as SUBSTITUTE or REPLACE, training helps you to understand how to make the features work for you. If you need to use special formatting, training can help you use special displays, conditional formatting and the MOD function. If you’ve ever wondered how to readjust formula references, training can help you with the INDIRECT function.

These and other training subjects help you turn Microsoft® Excel® into a powerful professional resource you can use to manage large amounts of information, calculate and analyze complex data and prepare information reports. No matter why you use Microsoft® Excel®, training can help you use this program in a more advanced, professional capacity.

Why Lorman Education Services?

If you need advanced Microsoft® Excel® training for your position or for professional development, Lorman Education Services can provide flexible, robust training solutions designed for professionals like you. More than 1.4 million professionals have already entrusted Lorman Education Services for their training needs, and for 30 years Lorman Education Services has been providing training solutions for advanced professionals across industries.

Lorman Education Services understands your training needs are demanding. Your busy schedule may prevent you from obtaining the in-person classroom training available to you. Lorman Education Services offers flexible solutions designed around the way you work. Lorman Education Services training is available in a variety of formats, so you can access advanced Microsoft® Excel® training from any mobile device or computer at work, at home or in the field. Study when you have the time or when you need to learn about advanced Microsoft® Excel® features and put your training to work right away, without wading through hours of irrelevant course material. Return to training as needed, until you master the program functions.

Advanced Microsoft® Excel® training from Lorman Education Services is developed by an industry leader with years of experience teaching more than 300 seminars and training courses. You are learning from the best, ensuring you have the information you need to make a measurable difference in your professional life. Training is updated regularly, so you will have the training relevant for the most current versions of Microsoft® Excel®.

Advanced Microsoft® Excel® from Lorman Education Services is designed by professionals for professionals. The training is designed to offer work-specific help, so every minute you invest in training will reward you with actionable information and practical tips you can start implementing right away. The goal with the training is to help you in your work environment every day, and the training is designed to be relevant and applicable for you.

If you are looking for advanced Microsoft® Excel® training, sign up for an All-Access Pass with Lorman Education Services. You will gain access to thousands of training materials for one full year — at one budget-friendly cost. You will be able to train as little or as much as you like, whenever you have time. You will be able to find out how Excel® can work with other programs and will train in other programs, too. With thousands of professionally developed training solutions, Lorman Education Services can be your partner in professional development as you seek new opportunities. Lorman Education Services also offers in-person training and custom training solutions, if you prefer.

Purchase Options
Can't Attend?

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.


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 Formulas
Power Functions
  • Extended Uses of the IF and VLOOKUP Function
  • Using the MATCH and INDEX Functions for More Complex 2-Way Lookups
Scientific Applications of the CONVERT Function
Understanding 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, GROWTH
Manipulate Data at the Character Level With REPLACE, SUBSTITUTE and Other Text Functions
Use the MOD Function With Conditional Formatting Techniques for Special Displays
Readjust Formula References With the INDIRECT Function
Purchase Options
Can't Attend?

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.


Live Webinar Registration

  • AIPB 1.5
  • This program is acceptable for 1.5 CPEC(s) towards the CB designation through the American Institute of Professional Bookkeepers (AIPB).
  • ASAP PACE 0.1
  • This course is pre-approved through the American Society of Administrative Professionals (ASAP) for 0.1 CEU(s) towards your PACE Recertification.
  • IAAP 1.5
  • This course has been preapproved by the International Association of Administrative professionals for 1.5 recertification point(s).
  • CPE 1.8 including Computer Science 1.8
  • Lorman Education Services is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its web site: For more information regarding administrative policies such as complaint and refund, please contact our offices at 866-352-9539. CPE Credit: Maximum Credit Hours: 1.8 each session (based on a 50 minute credit hour). You must attend at least 50 minutes to obtain credit. Field of Study: Computer Science for 1.8 hours. Prerequisite: basic knowledge of business financials. Level of Knowledge: Intermediate. Teaching Method: Seminar/Lecture. Advance Preparation: None. Delivery Method: Group Internet Based. Please refer to the information in this brochure for outline, course content and objectives. Upon completion of this course, you will receive a certificate of attendance. Final approval of a course for CPE credit belongs with each state's regulatory board. Please note: In order to receive CPE credit for this course you MUST use the streaming audio option, as well as enable and complete the required progress checks.
  • Lorman Business Center, Inc. is a registered provider for CPA CPE through the State Education Department of New York, Sponsor number: 000640. The following course will carry the subject area of Specialized Knowledge and Applications for 1.5 hours.

Audio & Reference Manual

This program does NOT qualify, nor meet the National Standard for NASBA accreditation.

Who should attend?

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

Purchase Options
Can't Attend?

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.


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 U.S. and Canada
  • Presented more than 700 Excel® webinars and is the author or co-author of six books on spreadsheet software
Purchase Options
Can't Attend?

More Program Information

Why Lorman?

Over 32 years and 1.4 million customers worth of experience providing continuing education. Our passion is providing you world-class training to help you succeed in business and as a professional.

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

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.

Product ID: 405874
Published 2018, 2019
Purchase Options

Register today before this event fills.

Can’t attend? Order an Audio & Reference Manual from this event.