Show navigation

Available in:

Audio & Reference Manual

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.

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

More Program Information

Why Lorman?

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

Agenda

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

More Program Information

Why Lorman?

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

Credits

Audio & Reference Manual

No credit available.

Purchase Options

More Program Information

Why Lorman?

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

Faculty

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 500 Excel® webinars and is the author or co-author of six books on spreadsheet software
Purchase Options

More Program Information

Why Lorman?

Over 30 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
$699/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: 400461
Published 2017
Purchase Options

Available in Multiple Formats

Purchase this course and learn on your schedule!