This training will cover the new intermediate features of Microsoft Excel. Participants will learn about advanced functions, solving formula errors, and about how to apply absolute and relative cell references. In addition, they will learn to link cells between multiple worksheets, sort and filter data, and use goal seek. Find out about creating pivot tables and charts. Participants will learn how to apply advanced chart features and use SmartArt and objects. Each participant will receive a manual and completion certificate.