Available in:

OnDemand Course

Excel® - Mastering Advanced Functions

Master some of Excel's® most advanced functions that give you tremendous capabilities to tackle a myriad of statistical, mathematical and financial challenges.

How do I compare the items in these two lists and see which are missing? How do I look up a value in list ONE and pick up a related value from list TWO? How do I avoid my lookup formula displaying an ugly error when it can't find a match? What's the difference between VLOOKUP and INDEX-MATCH? I've heard of VLOOKUP but what's HLOOKUP? How can I automatically count items that match a criteria? These are just a few of the questions I get asked on a regular basis. You will get the answers to these questions (and more) with this topic dedicated to mastering some of Excel's® advanced functions.

87 minutes
Course Exam
Certificate of Completion

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

Add to Wishlist

More Program Information

Why Lorman?

Over 36 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.


How to Construct and Use the VLOOKUP Function

True and False - the 4th Parameter Demystified

Tables - the Key to Future-Proofing VLOOKUP

How to Construct and Use the HLOOKUP Function

How to Avoid #NA

The IF Function

The COUNTIF and COUNTIFS Functions

The SUMIF and SUMIFS Functions

The IFERROR Function

Purchase Options

Add to Wishlist

More Program Information

Why Lorman?

Over 36 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.


OnDemand Course

This course was last revised on January 13, 2020.

Call 1-866-352-9540 for further credit information.

  • 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
  • All education that aligns with the CAP Body of Knowledge can be used toward recertification. Lorman Education Services believes this course does align and should be counted toward recertification. Please visit IAAP's certification webpage to review recertification details and requirements. https://www.iaap-hq.org/page/CAP_Recertification. Course Length: 1.5.

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

Purchase Options

Add to Wishlist

More Program Information

Why Lorman?

Over 36 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.


Mike Thomas

Mike Thomas


  • UK-based IT trainer with a career spanning 30+ years
  • Has delivered thousands of courses and produced hundreds of written and video-based tutorials
  • Subject matter expert in a range of technologies with a primary focus and passion for Microsoft Office (especially Excel) on both the Windows and Mac platforms and Power BI
  • A fellow of The Learning and Performance Institute and has worked with and for many global and UK-based companies and organizations across a diverse range of industries, including healthcare, pharmaceutical, and public sector
  • Designs and develops Microsoft Office®-based solutions that automate key business tasks and processes
Purchase Options

Add to Wishlist

More Program Information

Why Lorman?

Over 36 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!

  • OnDemand Courses
  • Live Webinars
  • MP3 Downloads
  • Course Manuals
  • Executive Reports
  • White Papers and Articles

Additional benefits include:

  • State Specific Credit Tracker
  • All-Access Pass Course Concierge

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: 406820
Published 2020
Purchase Options

Available in Multiple Formats

Purchase this course and learn on your schedule!