Excel 2010: Advanced

Get more out of Excel 2010 by learning how to use advanced functions and features to help you efficiently calculate, organize and analyze your data. The course begins by teaching you more advanced formulas, including financial, logical, text and lookup functions. Then, you’ll discover how to apply and manage conditional formats and use a new feature to Excel 2010 called Sparklines. You’ll learn how to manipulate your data by filtering and sorting and using PivotTables and PivotCharts. Lastly, you’ll learn how to analyze data using tools such as Scenario Manager and Goal Seek, and discover how to import and export data using different sources.
This course includes useful step-by-step instruction and engaging visuals to build your knowledge and skills in working with Excel 2010.
This course aligns with the CAP Body of Knowledge and should be approved for 3 recertification points under the Operational Functions content area. Email info@intellezy.com with proof of completion of the course to obtain your certificate.