Advanced Functions of Excel Formulas: Part 2

In this part two of our Excel Formulas video series, you will learn how to further build and troubleshoot formulas and master advanced functions in Microsoft Excel. Whether you are a beginner or an experienced user looking to build up your Excel skills, this video will show you how to use array formulas, subtotal formulas, date and time functions, concatenate vs. flash fill, index and match versus VLookup, variations of the Round Function, and using Table References in formulas.

For more information on Microsoft Excel training, visit

via Global Knowledge

About The Author
- Global Knowledge is the worldwide leader in IT and business training. We deliver via training centers, private facilities, and the Internet, enabling our customers to choose when, where, and how they want to receive training programs and learning services. Our more than 1,200 courses span foundational and specialized training and certifications. Founded in 1995, Global Knowledge employs more than 1,300 people worldwide and is headquartered in Cary, N.C., with Canadian headquarters in Toronto, and EMEA headquarters in London.

Tell us what you think...