Available in:

OnDemand Course
MP3 Download

Advanced Microsoft® Excel® Formulas and Functions

Demystify the concept of functions in Excel®, empowering you to harness the full potential of this powerful spreadsheet software.

Functions in Excel® are pre-defined formulas that perform specific calculations or actions on data. They serve as building blocks for creating dynamic and efficient formulas to manipulate and analyze your data. With hundreds of built-in functions available, Excel® offers a wide range of capabilities to handle various types of data and tasks. Excel® contains over 500 functions. Strip away the ones nobody uses. Discount the ones that have a specialized use case, and you're left with a core set of functions that all Excel® users should know, regardless of their job function, industry, or business sector. This presentation covers some of Excel's most popular productivity-boosting functions. By the end of the session, you will have a solid foundation in Excel® functions, enabling you to leverage their power to perform complex calculations, automate tasks, and analyze data effectively. This training is categorized as intermediate. It is aimed at users who want to learn about the commonly-used worksheet functions in Excel®. Although the training will be delivered using the latest version of Excel®, this training is relevant for users of all versions of Excel®. (Please note that several of the functions, UNIQUE, SORT, and FILTER, are only available to Office 365® subscribers and users of Excel® 2021.)

64 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 37 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.


Functions Covered

  • IF: Automate Data Entry...If This Condition Is True, Enter This Value Into a Cell, Else Enter That Value Into a Cell
  • COUNTIFS: Count How Many Times a Particular Value (Date, Number, Text) Appears Within a Range (e.g., How Many Times Was Customer X a Late Payer?)
  • SUMIFS: Add Up a Set of Numbers That Match Criteria (e.g., What Was the Total Number of Hours Worked on Project 123)
  • FILTER: Quickly Generate a Dynamic List of Filtered Items
  • SUBTOTAL: Storing List-Based Data in a Table Is Best Practice, but What If You Need to Generate a Total, Count, or Average From Filtered Data in the Table?
  • LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN, and More: These Popular Functions Allow You to Easily Manipulate Text in Your Worksheets
  • WORKDAY, EOMONTH, NETWORKDAYS: These Popular Functions Allow You to Easily Manipulate Dates in Your Worksheets
Purchase Options

Add to Wishlist

More Program Information

Why Lorman?

Over 37 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 September 19, 2023.

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

  • AIPB 1.0
  • This program is acceptable for 1.0 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.25
  • 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.25.

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

MP3 Download

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

Purchase Options

Add to Wishlist

More Program Information

Why Lorman?

Over 37 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 over 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
  • Has worked with, and for many global and UK-based companies, and organizations across a diverse range of industries which include healthcare, pharmaceutical, and the 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 37 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

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: 410712
Published 2023
Purchase Options

Available in Multiple Formats

Purchase this course and learn on your schedule!